Shopify
Output Fields and Their Sources:
store_key: From id field in Shopify shop data
store_name: From name field
store_type: Hardcoded as 'shopify'
store_category: Hardcoded as 'Ecommerce'
sales_platform: Hardcoded as 'Shopify'
new_sales_channel: Constructed as concat('Shopify: ', name)
web_domain: From domain field
store_shop_url: From shop_url field
territory_key: Derived from country_code field (joined to territory dimension)
sales_channel_category: Hardcoded as 'DTC'
BigCommerce
Output Fields and Their Sources:
store_key: From id field in BigCommerce store data
store_name: From name field
store_type: Hardcoded as 'bigcommerce'
store_category: Hardcoded as 'Ecommerce'
sales_platform: Hardcoded as 'Bigcommerce'
new_sales_channel: Constructed as concat('Bigcommerce: ', name)
web_domain: From domain field
store_shop_url: From domain field
territory_key: Derived from country_code field (joined to territory dimension)
sales_channel_category: Hardcoded as 'DTC'
Additional for orders:
order_sales_platform: Derived from order_source field via mapping logic
Brightpearl
Output Fields and Their Sources:
store_key: From channelId field in channel data (or brightpearl__order_channel_id from order if channel not found)
store_name: From name field in channel data (defaults to 'Brightpearl Store' if null)
store_type: From providerCode field in integrationDetail JSON (cleaned via macro to remove 'bp' prefix)
store_category: Derived from channel_type (which is the cleaned providerCode)
sales_platform: Generated from providerCode in integrationDetail using a macro, will show other if not added to macro.
new_sales_channel: Same as sales_platform (defaults to 'Brightpearl' if null)
brand_name: From name field in channel_brand table (joined via channelBrandId)
web_domain: From linked ecommerce store if available
store_shop_url: Hardcoded as 'Missing'
territory_key: From linked ecommerce/marketplace store if available
sales_channel_category: Hardcoded as 'DTC'
Linnworks
Output Fields and Their Sources:
store_key: Constructed as concat(Source, SubSource) from order data
store_name: From SubSource field in order GeneralInfo JSON (defaults to 'linnworks Store' if empty/null)
store_type: Derived from Source field in order GeneralInfo JSON using linnworks_clean_sources macro
store_category: Generated from cleaned channel_type
sales_platform: Generated from Source and SubSource fields in order GeneralInfo JSON using a macro. Will default to sourcechannel if not within macro
new_sales_channel: Same as sales_platform
web_domain: From linked ecommerce store if available
store_shop_url: Hardcoded as 'Missing'
territory_key: From linked ecommerce/marketplace store if available
sales_channel_category: Derived from new_sales_channel
Cin7
Output Fields and Their Sources:
store_key: From sourcechannel field in order/sale data (coalesced with linked ecommerce/marketplace store keys if available)
store_name: From sourcechannel field (defaults to 'Cin7 Store' if null, coalesced with ecommerce/marketplace store names)
store_type: Derived from sourcechannel field using cin7_channel_type_generator macro
store_category: Derived from cleaned channel_type
sales_platform: Generated from sourcechannel field using a macro and will show sourcchannel uncleaned if not within it
new_sales_channel: Same as sales_platform (coalesced with ecommerce/marketplace channels)
web_domain: From linked ecommerce/marketplace store if available, otherwise 'Unknown'
store_shop_url: Hardcoded as 'Missing'
territory_key: Coalesced from linked ecommerce/marketplace store territory (defaults to 0)
sales_channel_category: Hardcoded as 'Other'