This page will help you learn about how Daasity replicates data from Extensiv (Skubana), the limitations of the data we can extract, and where the data is stored in the Extensiv (Skubana) schema.
Seamlessly Integrate Your Products, Fulfillment Centers & Sales Channels In One Platform. Extensiv (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 Extensiv (Skubana) extractor is built based on this . The following endpoints are used by Daasity to replicate data from Extensiv (Skubana:)
The Orders endpoint runs each hour and all other endpoints are updated daily.
Limitation: due to the impact on Extensiv (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)
Extensiv (Skubana) Schema
The Daasity Extensiv (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
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
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