Report for $0.00 sales

[amber-ilove]

Hey all. 

Is there a report I can run to find sales that have been put through with 100% discount ($0.00)? 

thanks ☺️ 

[Summer]

Hey, @amber-ilove! You can refer to the Sales by discount report for this. You'll find it by going to Analytics > Reports in your admin.

If you need information on our sales reports, here's a handy guide you can utilize. Let us know if you have other questions! 

[bundler-marko]

Hi @amber-ilove,

You can use the method @Summer recommended or you can also export all orders in a CSV file and filter the final price field to see all the ones which were priced at 0.0 dollars.

Regards,

Marko

[BetterReports-C]

Hi @amber-ilove 

Claudia here from Better Reports.

Have you been able to find a solution for this with Shopify? If not, I would recommend our app Better Reports.

We can create a custom field to filter sales reports to pull items that are fully discounted in an order, or orders that are fully discounted.

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? 

[Report-Pundit]

Hi @amber-ilove,

I wanted to follow up and see if you were able to export all orders with $0.00 sales. I understand that Shopify’s reporting has some limitations, particularly when it comes to applying filters to the total sales column.

With Report Pundit, we can easily apply precise filters on the total sales column, enabling you to export only the orders where a 100% discount was applied, resulting in $0.00 sales.

If this sounds like it would be helpful, please feel free to reach out. We’d be more than happy to assist you with setting this up.

Best regards,
The Report Pundit Team