What data does the Brightpearl integration extract?
The Brightpearl integration extracts comprehensive data from your ERP system, including:
Orders - All order details, line items, and transaction data
Products - Product catalog, SKUs, brands, categories, and inventory status
Channels - Sales channel configurations and marketplace integrations
Account Configuration - Your Brightpearl account settings and setup
Warehouses - Warehouse and location data
Stock Levels - Current inventory levels and goods-in notes
Brands & Categories - Product categorization and brand information
How does Conjura determine COGS (Product Costs)?
COGS is based on the item cost stored at the order line item level in Brightpearl. This represents the cost of goods at the time the order was placed.
The system automatically handles currency conversion to ensure COGS matches your reporting currency. The accuracy depends on how well your product costs are maintained in Brightpearl's inventory system.
If your costs are not properly maintained in Brightpearl or managed through third-party integrations, you may see unexpected values. In this case, you'll need to import COGS data using our Custom Data Import.
Where does Conjura pull Average Inventory Cost from?
Average Inventory Cost is derived from the unit cost information in Brightpearl's stock/inventory data. This represents the most recent unit cost per product as calculated from:
Purchase Order costs - When products are received
Sales Order costs - Historical cost information
Stock movement values - Direct inventory valuations
The system intelligently chooses the most appropriate cost source available and maintains cost history over time. This ensures your inventory valuations reflect the most accurate cost information available in your Brightpearl system.
How does Conjura report on Brightpearl products
Product reporting from Brightpearl includes comprehensive product catalog data such as:
Product Details - SKU, name, creation date, and status
Brand Information - Brand names from your Brightpearl brand master data
Category Structure - A product's category is determined by it's Reporting Subcategory within Brightpearl. This allows for the most granular category reporting possible.
How are Brightpearl product statuses handled in reporting?
Brightpearl product statuses are normalized for consistent reporting:
LIVE orders appear as ACTIVE
DISCONTINUED orders appear as DRAFT
ARCHIVED orders remain ARCHIVED
Products without status default to ACTIVE
This ensures consistent product status reporting across different data sources and ERP systems.
How does Conjura determine the Store Name?
The store name follows a priority hierarchy, with ecommerce platform names taking precedence over Brightpearl channel names:
First priority: Connected ecommerce store name (e.g., from Shopify).
Second priority: Connected marketplace store name (e.g., from Amazon).
Fallback: Brightpearl channel name.
Example:
If your Brightpearl channel is called "eCommerce Store" but your connected Shopify store is named "My First Store", the reporting will show "My First Store" as the store name.
This ensures consistency with your actual eCommerce platform naming rather than internal ERP naming. This is important as ad spend, products view and session data are all associated with your eCommerce store.
What if I want to see the original Sales Channel Name?
You can use the ERP Sales Channel field within our dashboards.
Why is a Platform marked as Unknown?
We manage our mappings manually to standardize values across different ERP systems. We don't just take the raw values from Brightpearl - we clean and standardize them so they make sense across all other systems.
Inform support@conjura.com and the team can update the mappings manually.
How does Conjura handle Brightpearl sales channel categories?
Conjura automatically categorizes your Brightpearl sales channels into standard groups:
Webstore - Direct website sales (Shopify, Magento, BigCommerce)
Marketplace - Third-party marketplaces (Amazon, eBay, Walmart)
POS - Point-of-sale systems
B2B - Business-to-business channels
Retail - Offline - Non-integrated retail channels
This standardization allows for consistent reporting across all your sales channels.
What Brightpearl order types are included in reporting?
Conjura processes the following Brightpearl order types:
Sales Orders (SO) - Regular sales transactions for revenue reporting
Sales Credits (SC) - Credit notes/refunds that are processed and linked back to original orders for accurate refund tracking
Purchase Orders (PO) - Purchase orders for procurement and inventory cost tracking
Purchase Credits (PC) - Purchase-related credits and adjustments
Other internal order types or transfers are excluded to ensure clean reporting across both sales and procurement functions.
How often does the data sync from Brightpearl?
Data synchronization occurs daily.
How are Brightpearl external references handled for ecommerce integration?
The system automatically cleans external reference fields to match them with your ecommerce orders. For example, Shopify order IDs stored in Brightpearl are cleaned (removing prefixes like 'SO' or 'SC') to ensure proper linking between your ERP and ecommerce data.
Can I view historical stock data?
Yes, we maintain historical stock levels from Brightpearl.