How do you know the total number of each product that you’ve sold each month on Shopify?

4

Yes, the best way to do it is with a Shopify app. I actually don’t know why Shopify don’t just enable to export a report, it is such an essential feature.

There’s an app to integrate Quickbooks if you use that for your accounts.

4

If you want to get the reports from Shopify then you’ll probably need to upgrade your plan.
I actually think that an app is the preferable solution. There are apps for Quickbooks and Xero integration. I personally use Quickbooks, their app syncs orders to my accounting system and pulls the data from my accounting system.

4

Agree that you’d better using an app.

4

You can also download a CSV from Shopify:
Orders –> all orders –> orders by date.

Then you’ll receive a CSV file with all your sales. There are spreadsheets which automate the translation of the CSV file into a readable Excel file. I use this spreadsheet:
https://www.etsy.com/listing/744666358