Report for Individual Collection Items
“I want to build a report to get sales of individual products that are included in collections.”
Click on the Ordered Products report, select Report Parameters, then scroll down until you see "Breakdown Collections".
By changing Breakdown Collection to YES, you will then get a report that shows you the sales for each bottle in each collection.
A report NOT broken down by collection will not show the sales of individual products, but a report that IS broken down by collection will show the sales of each product in each collection. Thus, the report with Breakdown Collections enabled will have a larger quantity than the report without breakdown collections.
Here is an example from a report WITHOUT Breakdown Collections enabled:
Here is an example from a report WITH Breakdown Collections enabled:
The quantity will be different, but discounts, costs, and revenues will remain unchanged regardless of whether Breakdown Collections is enabled.