Transformation Configuration Setup
This pages provides instructions on what transform code should be added to a script manifest file to transform Salesforce Commerce Cloud (SFCC) data into the Unified Order Schema (UOS)
Was this helpful?
This pages provides instructions on what transform code should be added to a script manifest file to transform Salesforce Commerce Cloud (SFCC) data into the Unified Order Schema (UOS)
Was this helpful?
Was this helpful?
The Daasity transformation code maps data from the Salesforce Commerce Cloud (SFCC) schema into the Unified Order Schema (UOS) for all sales channels
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.
This code is dependent on the following integration being installed:
Salesforce Commerce Cloud
This code block is dependent on the following upstream code blocks being implemented:
To enable the data transformation from the Salesforce Commerce Cloud schema into UOS, the following code must be run in a workflow:
uos_salesforce_commerce_cloud:
integrations:
- salesforce_commerce
scripts:
- "github://platform-sql-shared/scripts/pro/0500_uos/sfcc/0586_UOS_BAS_sfcc_customers.sql"
- "github://platform-sql-shared/scripts/pro/0500_uos/sfcc/0587_UOS_BAS_sfcc_products.sql"
- "github://platform-sql-shared/scripts/pro/0500_uos/sfcc/0588_UOS_BAS_sfcc_product_variants.sql"
- "github://platform-sql-shared/scripts/pro/0500_uos/sfcc/0589_UOS_BAS_sfcc_orders.sql"
- "github://platform-sql-shared/scripts/pro/0500_uos/sfcc/0590_UOS_BAS_sfcc_order_line_items.sql"
- "github://platform-sql-shared/scripts/pro/0500_uos/sfcc/0591_UOS_BAS_sfcc_order_discount_codes.sql"
- "github://platform-sql-shared/scripts/pro/0500_uos/sfcc/0592_UOS_BAS_sfcc_order_payments.sql"
- "github://platform-sql-shared/scripts/pro/0500_uos/sfcc/0593_UOS_BAS_sfcc_transactions.sql"
- "github://platform-sql-shared/scripts/pro/0500_uos/sfcc/0594_UOS_BAS_sfcc_refunds.sql"
- "github://platform-sql-shared/scripts/pro/0500_uos/sfcc/0596_UOS_BAS_sfcc_fulfillments.sql"
- "github://platform-sql-shared/scripts/pro/0500_uos/sfcc/0597_UOS_BAS_sfcc_order_item_fulfillments.sql"
- "github://platform-sql-shared/scripts/pro/0500_uos/sfcc/0599_UOS_BAS_sfcc_current_inventory_levels.sql"
Code to populate the UOS tables: