This document explains how Conjura standardises store and channel fields across different ecommerce platforms, ERPs, and order management systems.

Different systems represent stores and channels in very different ways. Conjura normalises these so that reporting remains comparable.

Conjura Field definitions

Field	Description
Store Name	Name of the store or channel.
Store Type	The underlying system or integration type (e.g. Shopify, Amazon, POS).
Store Category	High-level classification such as Ecommerce, Marketplace, or POS.
Store URL	Primary web domain associated with the store, where available.
Sales Platform	Clean, user-facing platform name used in reporting.
New Sales Channel	Final reporting label combining platform and store name.
Sales Channel Category	Broad commercial category (e.g. DTC, Marketplace, POS, Other).

eCommerce

Shopify

Store Name: From name field in Shopify shop data
Store Type: Shopify
Store Category: Ecommerce
Store URL: From domain field
Sales Platform: Shopify
New Sales Channel: Shopify:, {Store Name}
Sales Channel Category: DTC

BigCommerce

Store Name: From name field in BigCommerce store data
Store Type: Bigcommerce
Store Category: Ecommerce
Store URL: From domain field
Sales Platform: Bigcommerce
New Sales Channel: Bigcommerce:, {Store Name}
Sales Channel Category: DTC

OMS and ERP

For ERP and OMS platforms, store and channel concepts are not always first-class. Conjura derives these fields where possible and aligns them to linked ecommerce or marketplace stores when available.

Brightpearl

Store Key: From channelId field in channel data
Store Name: From name field in channel data (defaults to Brightpearl Store if null)
Store Type: From providerCode field in in channel data.
Store Category: Derived from providerCode
Store URL: Linked ecommerce store domain, if available
Sales Platform: Generated from providerCode in integrationDetail, will show Other if not added to covered by Conjura's mappings.
New Sales Channel: Same as sales_platform (defaults to Brightpearl if null)
Sales Channel Brand Name: From name field in channel_brand table.
Sales Channel Category: DTC

Linnworks

Store Name: From SubSource field in order data (Linnworks Store if empty/null)
Store Type: Derived from Source field in order data
Store Category: Generated from cleaned channel_type
Store URL: From linked ecommerce store if available
Sales Platform: Derived from Source and SubSource fields in an order's GeneralInfo data. Will default to source if not within macro
New Sales Channel: Same as Sales Platform.
Sales Channel Category: Derived from new_sales_channel.

Cin7

Store Key: From sourcechannel field in order data (or else taken with linked ecommerce/marketplace store keys if available)
Store Name: From sourcechannel field (defaults to Cin7 Store if null, else taken with linked ecommerce/marketplace store keys if available)
Store Type: Derived from sourcechannel field using custom Conjura logic.
Store Category: Derived from sourcechannel field using custom Conjura logic.
Store URL: Missing
Sales Platform: Generated from sourcechannel field using custom Conjura logic and will show sourcechannel uncleaned if not captured within it.
New Sales Channel: Same as sales_platform (coalesced with ecommerce/marketplace channels)
Sales Channel Category: Other

Linnworks Frequently Asked Questions

Brightpearl Frequently Asked Questions

Brightpearl & Linnworks Product Fields

TikTok Shop Frequently Asked Questions

WooCommerce Frequently Asked Questions

Channel Field Mappings