I run a meal-prep service through my Shopify account. People order meals during the week, and then pick them up on a single day at the end of the week. In order to prepare the food, it's useful for me to be able to print a report with the total number of each product variant that has been ordered over a 7-day period. However, that appears to be impossible to do, since sales from canceled orders are included in the reports. For example, the total sales number for Product A says 26, but one order was canceled, so in reality I only sold 25. I tried archiving the canceled orders, but they are still counted in the reports. Is there a way to exclude archived and/or canceled orders from reports?
Not having accurate counts on the reports means that I've had to go through each individual order and tally them by hand to ensure the correct number of meals are being made. I would hope there's a less time consuming way to handle this.