Integration: Skubana
This article will help you learn about how Daasity replicates data from Skubana, limitations to the data we can extract and where the data is stored in the Skubana schema
Key Topics
Click on the links below to take you to the section where you can learn more about this Integration
Integration Availability
This integration is available for:
- Growth (see Related Resources for more information on how Skubana works in Growth)
- Pro
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)
The embedded diagram houses the ERD for the Daasity Skubana integration illustrating the different tables and keys to join across tables. Hover over the embedded diagram to reveal controls to zoom and scroll.
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
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
NOTE: Daasity cycles through each warehouse to retrieve the inventory data
WARNING: 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
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 |
Related Resources