Hello!
I am trying to get a weekly sales report that shows te total orders with a value greater than 0.
I am able to get a count of all orders, but I can’t figure out how to filter out orders with a value > 0.
The Flow looks like this
The Get Order Data looks line this
created_at:<='{{ scheduledAt }}' AND created_at:>'{{ scheduledAt | date_minus: "1 week" }} AND total_price:>0
The last part of the code does not seem to have any effect. I’m curious what’s wrong with my query.
Koen
Hi @Koennn
Claudia here from Better Reports.
Have you been able to find a solution with Shopify? If not, I would recommend our app Better Reports.
We can create a report filtered for order’s current total price > 0 showing weekly total orders with their total value.
In addition to this, Better Reports has more than 60 built-in reports available out of the box that cover many common use cases for merchants. You can schedule reports to run at set frequencies to your email or Google Drive or export the reports in CSV, Excel or PDF format.
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?