Integration Specifications

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.

Integration Overview

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 Skubana API documentation. The following endpoints are used by Daasity to replicate data from Extensiv (Skubana:)

• Company Info

• Retrieve FBA inventory

• Inventory

• Orders

• Warehouses

• Shipment Providers

• Products

• Product Listing

• Product Stock Totals

• Purchase Orders

• Sales Channels

• Shipments

• Vendors

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)

Click here to view the ERD for the Daasity Skubana integration illustrating the different tables and keys to join across tables.

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
• Inventory Levels
• Listing SKU
• Order Items
• Orders
• Purchase Order Items
• Purchase Orders
• Related Orders
• Sales Channels
• Shipment Carrier Services
• Shipment Carriers
• Shipment Package Types
• Shipments
• SKU Attributes
• SKU Components
• SKU Labels
• SKUs
• Vendors
• Warehouses

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