Integration Specifications
This page will help you learn about how Daasity replicates data from Skubana, the limitations of the data we can extract, and where the data is stored in the Skubana schema.
Integration Overview
Seamlessly Integrate Your Products, Fulfillment Centers & Sales Channels In One Platform. Skubana is an order management platform that helps brands, merchants and 3PLs intelligently manage orders.
This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.
Integration Availability
This integration is available for:
Enterprise
Growth
API Endpoints
The Daasity Skubana extractor is built based on this Skubana API documentation. The following endpoints are used by Daasity to replicate data from Skubana:
The Orders endpoint runs each hour and all other endpoints are updated daily.
Limitation: due to the impact on Skubana, for merchants with a large number of products, the Product Stock Totals endpoint will be used in lieu of the Inventory endpoint to ensure that the API will return data in a timely manner
Entity Relationship Diagram (ERD)
Click here to view the ERD for the Daasity Skubana integration illustrating the different tables and keys to join across tables.
Skubana Schema
The Daasity Skubana extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.
FBA Inventory Levels
Endpoint: Retrieve FBA inventory
Update method: UPSERT
Table Name: [
skubana.fba_inventory_levels]
| JSON Element | Database Column |
|---|---|
asin + fnsku | key |
asin | asin |
fnSku | fnsku |
inStockSupplyQuantity | in_stock_quantity_supply |
listingSku | listing_sku |
product::fnSku | product_fnsku |
product::masterSku | product_master_sku |
product::mpn | product_mpn |
product::name | product_name |
product::productId | product_product_id |
product::productType | product_product_type |
product::upc | product_upc |
productCondition | product_condition |
totalSupplyQuantity | total_supply_quantity |
warehouse::warehouseId | warehouse_id |
Inventory Levels
Endpoint: Inventory or Product Stock Totals depending on the volume of SKUs
Update method: UPSERT
Table Name: [
skubana.inventory_levels]
NOTE: Daasity cycles through each warehouse to retrieve the inventory data
For merchants with a large volume of SKUs the Inventory endpoint is not performant as Skubana has to do calculations to determine the on hand quantity. If you have a large number of SKUs we will use the Product Stock Totals endpoint instead but populate the same table
| JSON Element | Database Column |
|---|---|
masterSKU + productId + upc | key |
inTransitQuantity | in_transit_quantity |
lockedQuantity | locked_quantity |
onHandQuantity | on_hand_quantity |
product::description | description |
product::fnSku | fnsku |
product::hazmat | hazmat |
product::masterSku | master_sku |
product::mpn | mpn |
product::name | name |
product::productId | product_id |
product::productType | product_type |
product::productWeight | product_weight |
product::upc | upc |
from API call | warehouse_id |
Listing SKU
Endpoint: Product Listing
Update method: UPSERT
Table Name: [
skubana.listing_sku]
| JSON Element | Database Column |
|---|---|
listingId | listing_id |
productId | product_id |
fnSku | fnsku |
masterSku | master_sku |
listingSku | listing_sku |
pushInventory | push_inventory_flag |
salesChannelId | sales_channel_id |
active | active |
masterSku+listingId+productId+listingSku | key |
created | created_at |
lastModified | updated_at |
Order Items
Endpoint: Orders
Update method: UPSERT
Table Name: [
skubana.order_items]
| JSON Element | Database Column |
|---|---|
orderId + orderItems::orderItemId | key |
orderItems::listingName | listing_name |
orderItems::listingSku | listing_sku |
orderId | order_id |
orderItems::orderItemId | order_item_id |
orderItems::product::fnSku | product_fnsku |
orderItems::product::masterSku | product_master_sku |
orderItems::product::mpn | product_mpn |
orderItems::product::name | product_name |
orderItems::product::productId | product_product_id |
orderItems::product::productType | product_product_type |
orderItems::product::upc | product_upc |
orderItems::quantityOrdered | quantity_ordered |
orderItems::unitPrice::amount | unit_price_amount |
orderItems::unitPrice::currency | unit_price_currency |
orderItems::tax::amount | tax_amount |
orderItems::tax::currency | tax_currency |
Orders
Endpoint: Orders
Update method: UPSERT
Table Name: [
skubana.orders]
| JSON Element | Database Column |
|---|---|
orderId | order_id |
cancelReason::details | cancel_reason_details |
cancelReasons::type | cancel_reason_type |
currency | currency |
customer::companyName | customer_company_name |
customer::emailAddresses | customer_email_addresses |
customer::name | customer_name |
discount::amount | discount_amount |
fulfillmentSource::name | fulfillment_source_name |
fulfillmentSource::warehouseId | fulfillment_source_warehouse_id |
orderDate | order_date |
orderItemTotal::amount | order_item_total_amount |
orderItemTotal::currency | order_item_total_currency |
orderNumber | order_number |
orderStatus | order_status |
orderTotal::amount | order_total_amount |
orderTotal::currency | order_total_currency |
orderType | order_type |
paymentDate | payment_date |
paymentType::name | payment_type_name |
salesChannel::name | sales_channel_name |
salesChannel::salesChannelId | sales_channel_id |
salesChannel::type | sales_channel_type |
shipCompany | ship_company |
shipEmail | ship_email |
shipAddress1 | ship_address1 |
shipAddress2 | ship_address2 |
shipCity | ship_city |
shipState | ship_state |
shipZipCode | ship_zip_code |
shipPhone | ship_phone |
shipCountry | ship_country |
shipDate | ship_date |
shipMethod::shippingProviderId | shipping_provider_id |
shipMethod::shippingServiceId | shipping_service_id |
shipment::shipmentId | shipment_id |
shippingCost::amount | shipping_cost_amount |
createdDate | created_at |
modifiedDate | updated_at |
Purchase Order Items
Endpoint: Purchase Orders
Update method: UPSERT
Table Name: [
skubana.purchase_order_items]
| JSON Element | Database Column |
|---|---|
purchaseOrderID + purchaseOrderItems::purchaseOrderItemId | key |
purchaseOrderId | purchase_order_id |
purchaseOrderItems::billedDate | billed_date |
purchaseOrderItems::billedUnitCost::amount | billed_unit_cost_amount |
purchaseOrderItems::billedUnitCost::currency | billed_unit_cost_currency |
purchaseOrderItems::deliveryDate | delivery_date |
purchaseOrderItems::discount::amount | discount_amount |
purchaseOrderItems::discount::discountType | discount_type |
purchaseOrderItems::estimatedDeliveryDate | estimated_delivery_date |
purchaseOrderItems::landedUnitCost::amount | landed_unit_cost_amount |
purchaseOrderItems::landedUnitCost::currency | landed_unit_currency |
purchaseOrderItems::memo | memo |
purchaseOrderItems::originalUnitCost::amount | original_unit_cost_amount |
purchaseOrderItems::originalUnitCost::currency | original_unit_cost_currency |
purchaseOrderItems::packaging | packaging |
purchaseOrderItems::percentageTax | percentage_tax |
purchaseOrderItems::productStockId | product_stock_id |
purchaseOrderItems::purchaseOrderItemId | purchase_order_item_id |
purchaseOrderItems::quantity | quantity |
purchaseOrderItems::referenceNumber | reference_number |
purchaseOrderItems::status | status |
purchaseOrderItems::unitOfMeasure | unit_of_measure |
purchaseOrderItems::uomUnitQuantity | uom_unit_quantity |
purchaseOrderItems::vendorProductId | vendor_product_id |
purchaseOrderItems::vendorProductMasterSku | vendor_product_master_sku |
purchaseOrderItems::vendorProductVendorSku | vendor_product_vendor_sku |
purchaseOrderItems::receivedDate | received_date |
Purchase Orders
Endpoint: Purchase Orders
Update method: UPSERT
Table Name: [
skubana.purchase_orders]
| JSON Element | Database Column |
|---|---|
vendorId | vendor_id |
vendorConfirmedOnDate | vendor_confirmed_on_date |
vendorConfirmByDate | vendor_confirm_by_date |
type | type |
status | status |
shippingCost::amount | shipping_cost_amount |
shippingCost::currency | shipping_cost_currency |
purchaseOrderTemplateId | purchase_order_template_id |
purchaseOrderId | purchase_order_id |
paymentTerm::active | payment_term_active |
paymentTerm::description | payment_term_description |
paymentTerm::vendorPaymentTermId | payment_term_id |
number | number |
internalNotes | internal_notes |
incortermShippingRuleId | incoterm_shipping_rule_id |
incotermShippingRule | incoterm_shipping_rule |
format | format |
dropshipOrderId | dropship_order_id |
destinationWarehouseId | destination_warehouse_id |
dateModified | date_modified |
dateIssued | date_issued |
dateCreated | date_created |
dateAuthorized | date_authorized |
currency | currency |
createdBy::email | created_by_email |
createdBy::name | created_by_name |
createdBy::userId | created_by_user_id |
autoUpdatesEnabled | auto_updates_enabled |
authorizer::email | authorizer_email |
authorizer::name | authorizer_name |
authorizer::userId | authorizer_user_id |
Related Orders
Endpoint: Orders
Update method: UPSERT
Table Name: [
skubana.related_orders]
| JSON Element | Database Column |
|---|---|
orderId | order_id |
relatedOrderIds | related_order_id |
Sales Channels
Endpoint: Sales Channels
Update method: UPSERT
Table Name: [
skubana.sales_channels]
| JSON Element | Database Column |
|---|---|
companyName + name + salesChannelId + type | key |
companyName | company_name |
name | name |
salesChannelId | sales_channel_id |
type | type |
Shipment Carrier Services
Endpoint: Shipment Providers
Update method: UPSERT
Table Name: [
skubana.shipment_carrier_services]
| JSON Element | Database Column |
|---|---|
shippingProviderId + shippingServices::shippingServiceId | key |
shippingProviderId | shipping_carrier_id |
shippingServices::shippingServiceId | shipping_service_id |
shippingServices::shippingCarrier | shipping_carrier |
shippingServices::serviceName | service_name |
shippingServices::serviceCode | service_code |
shippingServices::abbreviation | abbreviation |
shippingServices::international | international |
shippingServices::weightRequired | weight_required |
shippingServices::dimensionsRequired | dimensions_required |
shippingServices::halfPageLabel | half_page_label |
shippingServices::active | active |
Shipment Carriers
Endpoint: Shipment Providers
Update method: UPSERT
Table Name: [
skubana.shipment_carriers]
| JSON Element | Database Column |
|---|---|
active | active |
name | name |
shippingProviderId | shipment_carrier_id |
type | type |
Shipment Package Types
Endpoint: Shipment Providers
Update method: UPSERT
Table Name: [
skubana.shipment_package_types]
| JSON Element | Database Column |
|---|---|
shippingProviderId + packageTypes::packageTypeId | key |
shippingProviderId | shipment_carrier_id |
packageTypes::packageTypeId | package_type_id |
packageTypes::shippingCarrier | shipping_carrier |
packageTypes::packageName | package_name |
packageTypes::description | description |
packageTypes::abbreviation | abbreviation |
packageTypes::packageCode | package_code |
packageTypes::domestic | domestic |
packageTypes::international | international |
packageTypes::weightRequired | weight_required |
packageTypes::active | active |
Shipments
Endpoint: Shipments
Update method: UPSERT
Table Name: [
skubana.shipments]
| JSON Element | Database Column |
|---|---|
batchNumber | batch_number |
carrierFee::amount | carrier_fee_amount |
carrierFee::currency | carrier_fee_currency |
deliveryStatus | delivery_status |
estimatedArrival | estimated_arrival |
orderId | order_id |
orderNumber | order_number |
received | received |
rma | rma |
shipDate | ship_date |
shipMethod::packageTypeId | ship_method_package_type_id |
shipMethod::shippingCarrier | ship_method_shipping_carrier |
shipMethod::shippingProviderId | ship_method_shipping_provider_id |
shipMethod::shippingServiceId | ship_method_shipping_service_id |
shipmentId | shipment_id |
trackingNumber | tracking_number |
transactionId | transaction_id |
type | type |
warehouseId | warehouse_id |
created | created_at |
SKU Attributes
Endpoint: Products
Update method: UPSERT
Table Name: [
skubana.sku_attributes]
| JSON Element | Database Column |
|---|---|
productId + attributeGroups::attributeGroupId + attributeGroups::attributes::attributeId | key |
productId | product_id |
attributeGroups::attributeGroupId | attribute_group_id |
attributeGroups::attributes::attributeId | attribute_id |
attributeGroups::attributes::name | attribute_name |
SKU Components
Endpoint: Products
Update method: UPSERT
Table Name: [
skubana.sku_components]
| JSON Element | Database Column |
|---|---|
productId + bundledItems::bundleItemId | key |
productId | parent_product_id |
bundledItems::bundleItemId | bundle_item_id |
bundledItems::bundledProducts::fnSku | bundled_product_fnsku |
bundledItems::bundledProducts::masterSku | bundled_product_mastersku |
bundledItems::bundledProducts::mpn | bundled_product_mpn |
bundledItems::bundledProducts::name | bundled_product_name |
bundledItems::bundledProducts::productId | bundled_product_product_id |
bundledItems::bundledProducts::productType | bundled_product_product_type |
bundledItems::bundledProducts::upc | bundled_product_upc |
bundledItems::bundledProductQuantity | bundled_product_quantity |
bundledItems::product::fnSku | product_fnsku |
bundledItems::product::masterSku | product_master_sku |
bundledItems::product::mpn | product_mpn |
bundledItems::product::name | product_name |
bundledItems::product::productId | product_product_id |
bundledItems::product::productType | product_product_type |
bundledItems::product::upc | product_upc |
SKU Labels
Endpoint: Products
Update method: UPSERT
Table Name: [
skubana.sku_labels]
| JSON Element | Database Column |
|---|---|
productId + labels | key |
productId | product_id |
labels | label |
SKUs
Endpoint: Products
Update method: UPSERT
Table Name: [
skubana.skus]
| JSON Element | Database Column |
|---|---|
productId | product_id |
name | name |
active | active |
allowBackorders | allow_backorders |
brand | brand |
bundle | bundle |
height | height |
length | length |
masterSku | master_sku |
mapPrice::amount | map_price_amount |
mapPrice::currency | map_price_currency |
ounces | ounces |
pounds | pounds |
shippingCost::amount | shipping_cost_amount |
shippingCost::currency | shipping_cost_currency |
shipsInOwnBox | ships_in_own_box |
type | type |
upc | upc |
vendorCost::amount | vendor_cost_amount |
vendorCost::currency | vendor_cost_currency |
weight | weight |
width | width |
createdDate | created_at |
modifiedDate | updated_at |
Vendors
Endpoint: Vendors
Update method: UPSERT
Table Name: [
skubana.vendors]
| JSON Element | Database Column |
|---|---|
vendorId | vendor_id |
active | active |
address::address1 | address1 |
address::address2 | address2 |
address::address3 | address3 |
address::city | city |
address::country | country |
address::province | province |
address::state | state |
address::type | address_type |
address::zipCode | zipcode |
contactEmail | contact_email |
contactPhone1 | contact_phone1 |
contactPhone2 | contact_phone2 |
defaultIncotermShippingRule | default_incoterm_shipping_rule |
defaultIncotermShippingRuleId | default_incoterm_shipping_rule_id |
defaultPurchaseOrderFormat | default_purchase_order_format |
defaultPurchaseOrderFormatId | default_purchase_order_template_id |
defaultVendorPaymentTerm::active | default_vendor_payment_term_active |
defaultVendorPaymentTerm::description | default_vendor_payment_term_desc |
defaultVendorPaymentTerm::vendorPaymentTermId | default_vendor_payment_term_id |
dropshipPurchaseOrderTemplateId | dropship_purchase_order_template_id |
dropshipper | dropshipper |
fax | fax |
manufacturer | manufacturer |
percentageTax | percentage_tax |
purchaseOrderEmail | purchase_order_email |
supplier | supplier |
warehouse::name | warehouse_name |
warehouse::warehouseId | warehouse_id |
website | website |
name | name |
Warehouses
Endpoint: Warehouses
Update method: UPSERT
Table Name: [
skubana.warehouses]
| JSON Element | Database Column |
|---|---|
warehouseId | warehouse_id |
active | active |
name | name |
Last updated