Use Report Center to generate a CSV that you can plug into Google Sheets to quickly analyze your sales on individual items.
Set up:
For this example, you'll need to:
have SKUs for your listings & variations.
copy this Google Sheet to your Google Account:
Step 1 - Generate a custom orders report
Visit the Custom Report tab
Choose Orders as your Report Type:
For Fields to Include, select (in this order)
- item_sku
- variation_sku
- transaction_quantity
You can also add more fields to this report. But for this example, we recommend keeping them together and in this order.
Apply a filter for the desired date range of the report:
>> Order Date
>> Between
>> {{your date range}}
Or include data from the last 90 days
Save the report to use as a template,
and generate the report.
In your reports history, download the report when finished:
Step 2 - Copy/paste report cells into Google Sheets
Open the Google Sheet you copied to your Google Drive.
Open your downloaded Report on your computer and copy all of the SKU & quantity data (three columns)
In the Google Sheet, delete the sample data in columns A, B, and C:
Click on the top-left cell of the data range (A3), and paste the data you copied earlier:
Columns F, G, and H will then display the total sold for each SKU or variation:
This is accomplished with formulas inside these cells. Feel free to modify them to fit your needs.
