Bundle markup

September 28, 2022


On this page

For stores that sell bundle products, sales reports offer two different views: sales at component level, or sales at bundle level.

Dropdown for selecting the view: by bundles or by components.

 

When using the option “by components separately” (this is also the default option), the detailed sales report ("Reports" > “Sales” > "Invoice rows") can sometimes contain lines labeled as “Bundle markup”:

“Bundle markup” in "Reports" > “Sales” > "Invoice rows"

 

In aggregated reports (by product group, by brand, by category), these lines get summed up as “Unclassified products”.

Example of a report by product group.

In reports with the “drill down” option, these lines appear as “- - - - -” and get summed up as “Unclassified products”.

Example of a report by product group, with drill down.

 

The sum of the “bundle markup” is a few cents, typically 0.01 or -0.01.

This is normal behavior. Erply must ensure that the total of the sales report is the same in both the “by components” view and the “by bundle” view. In some cases, the sales price of the bundle cannot be cleanly divided between components; the leftover thus gets reported as “bundle markup”.

A simple example is a bundle that costs $1.99 and contains 6 units. The selling price $1.99 cannot be cleanly divided by 6; Erply therefore registers the components as costing $0.33 each (Erply cannot assign different sales prices unit by unit). The difference of 1 cent (6 * $0.33 = $1.98) gets booked as “bundle markup”.

This is therefore an unavoidable side effect of selling bundles. Furthermore, this revenue cannot be linked to any product group or category; it will appear as a separate line. However, since the correction is always just a few cents one way or the other, this line does not usually make up a significant part of the revenue. 

Recommendations

  • To avoid seeing this line, please use the report option “Display sold bundles: as bundles”.
  • If this is not possible (component-level sales give a better overview), the “Bundle markup” / “Unclassified product” total can be filed in accounting as rounding.