Mini-App · Ecommerce
Shopify Monthly Sales Summary and Top Products by Quantity
For Shopify store owners who want a clear month-by-month view of sales without building a spreadsheet. Upload your Shopify orders export CSV, or several monthly exports, and choose how many top products to list.
You get a monthly table of orders, subtotal, discounts, shipping, taxes, refunds and net sales with a Total row, a top products list ranked by units sold, and a bar chart of net sales by month.
Shopify orders export (CSV)
Your file stays private to you. One free try without an account; then 2 credits a run.
A real result, on the sample file
The file has 2343 line rows and 2343 unique orders. The money fields appeared only on one line row per order (blank or zero on the others); to avoid double counting, I built one row per order (first non-null value of each money field and the first Created at), then summed by the order's month (YYYY-MM). Net Sales = Total minus Refunded Amount; missing numbers were treated as 0. The top 10 products sum Lineitem quantity over line rows and count distinct orders containing each product.
| Month | Orders | Subtotal | Discount Amount | Shipping | Taxes | Total | Refunded Amount | Net Sales |
|---|---|---|---|---|---|---|---|---|
| 2025-07 | 137 | 6203 | 109.5 | 646.35 | 441.65 | 7181.5 | 101.33 | 7080.17 |
| 2025-08 | 131 | 5329 | 157.05 | 688.05 | 374.87 | 6234.87 | 257.67 | 5977.2 |
| 2025-09 | 132 | 5452 | 135 | 674.15 | 385.37 | 6376.52 | 262.82 | 6113.7 |
| 2025-10 | 153 | 6756 | 209.25 | 757.55 | 474.48 | 7778.78 | 111.37 | 7667.41 |
| 2025-11 | 220 | 9785 | 354.6 | 1056.4 | 683.48 | 11170.28 | 162.28 | 11008 |
| 2025-12 | 285 | 12420 | 397.5 | 1369.15 | 871.36 | 14263.01 | 660.29 | 13602.72 |
| 2026-01 | 131 | 5420 | 72.45 | 695 | 387.54 | 6430.09 | 370.61 | 6059.48 |
| 2026-02 | 131 | 5560 | 144 | 632.45 | 392.55 | 6441 | 143.46 | 6297.54 |
| 2026-03 | 155 | 6717 | 173.85 | 750.6 | 474.19 | 7767.94 | 589.36 | 7178.58 |
| 2026-04 | 158 | 6504 | 128.4 | 771.45 | 462.09 | 7609.14 | 302.07 | 7307.07 |
| 2026-05 | 177 | 7606 | 219.75 | 903.5 | 535.29 | 8825.04 | 187.6 | 8637.44 |
| 2026-06 | 159 | 6430 | 133.65 | 827.05 | 456.36 | 7579.76 | 242.62 | 7337.14 |
| 2026-07 | 191 | 8019 | 242.4 | 924.35 | 563.62 | 9264.57 | 222.9 | 9041.67 |
| 2026-08 | 183 | 7586 | 198.75 | 959.1 | 535.34 | 8881.69 | 181.21 | 8700.48 |
| Total | 2343 | 99787 | 2676.15 | 11655.15 | 7038.19 | 115804.19 | 3795.59 | 112008.6 |
How to use it
- 1In Shopify admin, go to Orders, choose the date range you want, and export all orders as CSV (the plain CSV file, not the summary).
- 2Check that the file has columns such as Name, Created at, Subtotal, Total, Refunded Amount, Lineitem name and Lineitem quantity. You can add several monthly exports and they will be combined.
- 3Set how many top products you want listed. The default is 10.
- 4Read the Monthly summary table: Net Sales is Total minus Refunded Amount, and the last row adds up all months. The chart shows net sales by month, and the products table ranks items by units sold.
Common questions
Which Shopify file do I need to upload?
Use the plain orders CSV from Shopify admin. Go to Orders, pick your date range, and export all orders as CSV, not the summary file. You can upload several monthly exports, and they will be combined into one report.
Which columns does the file need, and what if one is named differently?
The tool needs Name, Created at, Subtotal, Discount Amount, Shipping, Taxes, Total, Refunded Amount, Lineitem name and Lineitem quantity. These are the standard Shopify export headers. If you renamed or removed a column, change the header back to the Shopify name before uploading so the numbers land in the right place.
How is net sales calculated?
Net Sales is Total minus Refunded Amount for each month. The last row of the Monthly summary table adds up all months. The top products table ranks items by units sold and shows how many orders included each product.
Is my data private, and what does it cost?
Your orders file is used only to build your report. Each run costs 2 credits, no matter how many monthly exports you combine in that run.