Integrations
      Back to home
      1. Help Center
      2. ELT+ | Technical User Documentation
      3. Integrations

      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