This article is specific to Conjura's Brightpearl connector only. For information on how bundles are handled for other datasources, please contact support@conjura.com.
Overview
In Brightpearl, bundles allow products to be sold together as a single package, often consisting of multiple child components. To ensure accurate tracking and reporting, we have implemented specific processes for handling data related to bundles.
Key Considerations
Revenue Allocation
Revenue for bundles is reported at the bundle parent SKU level.
Cost of Goods Sold (COGS) Calculation
For bundle parent SKUs (the overall package sold), we sum the Cost of Goods Sold (COGS) values of all child components if the parent itself has no COGS value. The COGS values are derived from the
itemCostfield associated with each line item in Brightpearl.The total COGS from the child SKUs is then assigned to the parent SKU. To prevent double-counting, the COGS value for the child SKUs is set to zero once it has been aggregated.
Units Tracking
The quantity of units sold is attributed solely to the parent SKU of the bundle. We set the quantity of child components within the bundle to zero. This ensures that sales are correctly reflected as a single unit, representing the full bundle.
Impact on Metrics: This approach may affect sell-through rates, since inventory levels are tracked against child SKUs, but only quantities sold for non-bundle purchases are considered for these child SKUs.
Considerations for other Conjura Metrics
Closing Stock: Stock remains reported at the child SKU level, even though sales are reported against the parent bundle. This helps maintain precise stock counts.
Sell-Through Rate: Since quantities for child SKUs are zeroed out within bundles, sell-through rates for individual child SKUs may appear lower. Non-bundle sales of these components will still reflect accurate quantities.
Example
Let's say we have 2 products: Product A and Product B.
Each unit of Product A and Product B costs your business $5 to manufacture. You have 15 units of each in stock at the moment.
These products can be purchased separately for $10, or as a bundle for $18.
Customer 1 buys Product A only.
Customer 2 buys Product B only.
Customer 3 buys the bundle.
These sales appear in Conjura's Product Table like this:
| Gross Revenue | Units Sold | COGS | Closing Stock |
Product A | $10 | 1 | $5 | 15 |
Product B | $10 | 1 | $5 | 15 |
Bundle (Product A + Product B) | $18 | 1 | $10 | 0 |
Customer 3's bundle purchase counts as one unit against the bundled product.
The cost of goods sold (COGS) of the bundle is calculated using the costs of the individual products.
Stock is tracked against the individual products only.