0980_UOS_BAS_update_sku_mapping Transformation

Target Database Table

drp_staging.uos_name_update.

Script Description and Logic

Pulls a list of skus from the BSD sku mapping sheet in your Daasity account to update the sku mapping in product variants, order line items and inventory_levels to use a master sku. A list of product names and fields to update is then created from product variants and products. The data is loaded into a staging table and used to update product data in the unified schema. The code prioritizes the sku from Shopify, then Skubana, then Amazon and lastly data from the BSD.

Source Tables Used In Script

Coming soon.

SQL Flow

To View Larger Image, Right Click and Choose Open Image In New Tab.

0980_UOS_BAS_update_sku_mapping Transformation

Calculated and Derived Fields

Coming soon.

All content © Daasity 2021. Do not copy, share or distribute.