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
Orders & Costs
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.
Other internal order types or transfers are excluded to ensure clean reporting across both sales and procurement functions.
How much order data does Conjura pull?
Conjura pulls order data going back 3 years from initial sign up.
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.
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.
How do we determine Shipping Revenue, Shipping COGS and Shipping Tax?
These are pulled from the line items whose account code matches your Shipping on Sales nominal code, as per here. This is then allocated across the rest of the line items on the order.
Why are my shipping only orders missing?
In Conjura we don’t treat shipping as its own "sale" - we take out the shipping lineitem and spread the shipping costs across the "real" products on an order.
When an order is shipping-only, there’s nothing for it to attach to on our side, and it won’t show up in the dashboard.
I want to see the SKUs in my sales orders that are allocated / partially allocated
You can use the Units Allocated field in the Product Table dashboard to answer this. This shows, for each given sales order, how many units of each items is marked as reserved.
Note: This data is only available going forward from data of sign up.
How do we determine Discount amounts?
As per Brightpearl documentation - there are various methods of discounting available.
Conjura currently handles order item discounts; where a percentage discounts in entered directly on the order row.
Order discounts, which are line items with a negative price, are currently not handled. The will be pulled via the line items whose account code matches your Sales Discount nominal code.
For orders downloaded from Shopify or BigCommerce, the total of the discount is pre-applied proportionally to the price of the line items. Therefore, we have no view of the discount amounts, as per those eCommerce platform. Pulling these amounts directly from sales platform is on Conjura's roadmap.
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.
Product Reporting
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 - A product's Product Category is determined by it's Reporting Category within Brightpearl. We also pull Reporting Subcategory as Product Subcategory.
Other product attributes like Product Season & Supplier are also brought through.
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.
Stores & Channels
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.
Other Common Questions
Where does Conjura pull Sales Agent data from?
The comes from the Assigned to field from the Sales Orders' Header section in Brightpearl. This represent the staff member who owns this order.
How often does the data sync from Brightpearl?
Data synchronization occurs daily.
Can I view historical stock data?
Yes, we maintain historical stock levels from Brightpearl.