Product and Inventory Code
This page provides detailed instructions on the Product and Inventory Code transform code block and what should be added to the Script Manifest file in order to execute the code
Script Manifest File (YML)
Upstream Transformation Dependencies
This code block is dependent on the following upstream code blocks being implemented:
Initialization
UOS
Transformation Code Requirements
The following code should be added to the main workflow in the appropriate position, after Returns and before Email and SMS per the Transform Code Sequence - DRP page
#--------------------------------------------------------------------------------------------------------------------
# SECTION: 6000_INVENTORY AND 6500_MERCH_PLANNING
# DEPENDENCIES:
# - Section: 0500_UOS
# REQUIRED: No
# PURPOSE: This code the DRP tables for Inventory and SKU Attributes and should be enabled once UOS is enabled
#--------------------------------------------------------------------------------------------------------------------
inventory merch planning:
scripts:
- "github://platform-sql-shared/scripts/base/6000_inventory/6010_INV_BAS_inventory_history.sql"
- "github://platform-sql-shared/scripts/base/6500_merchandising_planning/6510_PLN_BAS_sku_attributes.sql"
Inventory
Add this code to take a snapshot of the inventory levels each day to enable inventory level analysis
[
drp.inventory_level_history
]
Product
Add this code to combine product information from all the commerce platforms:
[
drp.sku_attributes
]
Was this helpful?