Hi, I created a custom field in inventory items to assign an individual article to a group of products.
I would like to run a report every month (or every quarter) that shows me all the items that have been sold during this period (including profit generated per article) and including this custom field. It may be in Manager, but would be fine for me as well if I could export this data to excel.
In this way I would be able to generate a report for the sales that will show me how every productgroup performed. (In terms of total sales and generated margin).
Example:
- Sunglasses: Total Sales 630K, Profit 200K
- Bags: Total Sales 320K, Profit 150K
- Jewelry: Total Sales 250K, Profit -90K
Total Sales: 1200K, Profit 260K