All things Shopify and commerce
Hi,
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.
Hi @newworldkitchen,
Kritesh here from Better Reports team.
Our app - Better Reports can help! In fact, we work with many meal prep merchants like yourself.
You can create a report that shows the sales by product (excluding returns) over the last 7 days aggregated by orders (you can exclude cancelled or archived orders), so that you have an accurate quantity totals.
You can also schedule this report to run at a regular cadence (say weekly) and be sent to your email or Google Sheets so it helps automate your production workflow as well.
Let me know if you want to try it and I'll be happy to set this up for you.
Disclaimer: I am part of the Better Reports support team.
Hi KBetterReports,
I appreciate the response, but it looks like your service costs roughly $20/month to do this, and I'd rather not add to my bills to get this one basic function I need. I'm just baffled that this isn't a default function of Shopify. Why would anyone want to see sales numbers from cancelled orders in their total sales reports? Why would variants in cancelled orders be counted as part of the total number of variants sold? I can't see any reason the default function shouldn't be to exclude cancelled orders. If people want to see cancelled orders added into the totals on their reports, why not just give them a filter to do so? Can someone from Shopify please answer these questions?
I'm having the same problem. Canceled orders are showing up in my sales reports and it's ridiculous that a canceled order is not excluded automatically.
I've read some solutions about enabling a filter in the reports but it seems like this feature is only available in the advance or higher plan )Basic shopify plan does not have this).
It's kind of frustrating that every time I generate a report and I need to manually remove the cancelled orders from the total revenue, even looking at other options other than shopify due to this.
Hi @Rags
Claudia here from the Better Reports support team.
Better Reports can definitely help with this as we can easily exclude canceled orders from any sales report with the use of a single filter, which is available to all Shopify plans.
In addition to our custom report capabilities, we have more than 60 built-in reports that cover your most common reporting needs including sales, current inventory, refunds, payouts, and more. Our reports can even be scheduled to send at a set frequency to your email or Google Drive!
I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.
What do you think?
Portrait of Stephen positioned next to an image of planet Earth, with the Stephen's World ...
By JasonH Mar 18, 2024Digital marketers and app developers have tracked activity in apps and websites for yea...
By Ollie Mar 13, 2024February was an exciting month with Shopify Editions, informative webinars, and more! F...
By JasonH Mar 7, 2024