Householding Code

This page provides detailed instructions on the Householding 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 block is dependent on the following blocks being implemented:

• Initialization

• UOS

Transformation Code Requirements

The following code should be added to the main workflow in the appropriate position, after UNS and before Google Analytics per the Transform Code Sequence - DRP page

  #--------------------------------------------------------------------------------------------------------------------
  # SECTION: 2300_HOUSEHOLDING
  # DEPENDENCIES:
  #   - Section: 0500_UOS
  # REQUIRED: No
  # PURPOSE: These scripts perform householding across the different Commerce integrations using the UOS data model
  # and should be enabled when UOS is enabled
  #--------------------------------------------------------------------------------------------------------------------
  householding:
    integrations:
      - shopify
      - amazon_seller_central
      - skubana
    scripts:
      - "github://platform-sql-shared/scripts/base/2300_householding/2310_HSH_BAS_customer_order_lkp.sql"

Householding

Add this script in the appropriate section to household across different commerce integrations. This must be included in order to create a unique customer identifier that is used in the data model

Create the [uos.customer_hshld_lkp] and [uos.order_hshld_lkp] tables

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/2300_householding/2310_HSH_BAS_customer_order_lkp.sql