Transformation Configuration Setup

This pages provides instructions on what transform code should be added to a script manifest file to transform Extensiv (Skubana) data into the Unified Order Schema (UOS)

Overview

The Daasity transformation code maps data from the Extensiv (Skubana) schema into the Unified Order Schema (UOS) for all orders that are not from Shopify or Amazon as those will be inserted into UOS using the Shopify and Amazon integrations

Feature Dependencies

You must have enabled our Code Repository feature in order to both access the Daasity transformation code as well as modify a Script Manifest File enabling this code to execute

We recommend you review the Transformation Configuration section of our Help documentation to familiarize yourself with our workflow engine and script manifest files.

Script Manifest File (YML)

Upstream Transformation Dependencies

This code is dependent on the following integration being installed:

• Skubana

This code block is dependent on the following upstream code blocks being implemented:

• Initialization

Transformation Code Requirements

To enable the data transformation from the Extensiv (Skubana) schema into UOS, the following code must be run in a workflow:

  uos_skubana:
    integrations:
      - skubana
    scripts:
      - "github://platform-sql-shared/scripts/base/0500_uos/skubana/0570_UOS_BAS_SKUBANA_orders_to_update.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/skubana/0570_UOS_BAS_SKUBANA_locations.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/skubana/0572_UOS_BAS_SKUBANA_customers.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/skubana/0573_UOS_BAS_SKUBANA_products.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/skubana/0574_UOS_BAS_SKUBANA_product_variants.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/skubana/0575_UOS_BAS_SKUBANA_orders.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/skubana/0576_UOS_BAS_SKUBANA_order_line_items.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/skubana/0578_UOS_BAS_SKUBANA_order_shipping_service.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/skubana/0579_UOS_BAS_SKUBANA_order_payments.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/skubana/0581_UOS_BAS_SKUBANA_refunds.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/skubana/0582_UOS_BAS_SKUBANA_refund_line_items.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/skubana/0583_UOS_BAS_SKUBANA_fulfillments.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/skubana/0584_UOS_BAS_SKUBANA_order_item_fulfillments.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/skubana/0585_UOS_BAS_SKUBANA_current_inventory_levels.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/skubana/0587_UOS_BAS_SKUBANA_sales_report.sql"

Unified Order Schema

Order Data

Orders in Skubana that are sourced from the following Sales Channels will be excluded from the order data model as they will be sourced from Shopify and Amazon directly:

• SHOPIFY

• AMAZON

• AMAZON_AU

• AMAZON_CA

• AMAZON_DE

• AMAZON_ES

• AMAZON_FR

• AMAZON_IT

• AMAZON_MX

• AMAZON_UK

Orders in Skubana that are not from the above Sales Channels will be added into the Daasity data model as new orders and available in the Transactional Sales Report and Order Line Revenue. All related customer, product, item and fulfillment data for these orders will also be added

Inventory Data

Inventory levels for all warehouses are updated on a daily basis and available in the Current Inventory Level explore that can be accessed from the Inventory Dashboard

Fulfillment & Shipping Costs

All orders in Skubana that exist in the order data model will have the Shipping and Fulfillment Cost updated using the "Carrier Fee Amount" that can be populated in Skubana

Code to determine what orders should be inserted into UOS:

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/skubana/0570_UOS_BAS_SKUBANA_orders_to_update.sql

Code to populate the UOS tables:

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/skubana/0571_UOS_BAS_SKUBANA_locations.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/skubana/0572_UOS_BAS_SKUBANA_customers.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/skubana/0573_UOS_BAS_SKUBANA_products.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/skubana/0574_UOS_BAS_SKUBANA_product_variants.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/skubana/0575_UOS_BAS_SKUBANA_orders.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/skubana/0576_UOS_BAS_SKUBANA_order_line_items.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/skubana/0578_UOS_BAS_SKUBANA_order_shipping_service.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/skubana/0579_UOS_BAS_SKUBANA_order_payments.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/skubana/0583_UOS_BAS_SKUBANA_fulfillments.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/skubana/0584_UOS_BAS_SKUBANA_order_item_fulfillments.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/skubana/0585_UOS_BAS_SKUBANA_current_inventory_levels.sql

Code to update shipping and fulfillment costs for Shopify and Amazon FBM orders:Code to update shipping and fulfillment costs for Shopify and Amazon FBM orders:

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/skubana/0586_UOS_BAS_SKUBANA_shopify_amazon_fbm_cost_update.sql