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]

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/6000_inventory/6010_INV_BAS_inventory_history.sql

Product

Add this code to combine product information from all the commerce platforms:

• [drp.sku_attributes]

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/6500_merchandising_planning/6510_PLN_BAS_sku_attributes.sql