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

  • 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

Related Resources