Workflow · Stock and products · Opening soon
Best sellers by month
Turn your Shopify Orders export into a monthly product ranking. See the top 10 products by units and revenue for each month.
Someone typed
“rank the top selling products by units and revenue each month”
The agent read it as
Rank the top selling products by units and revenue each month in Shopify Orders export, showing the top 10.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
Shopify Orders export
CSV export · 29 rows
Step
Rank products each month
Step 1
Result
Monthly Product Rankings
28 rows
Schedule
Runs when you say
Proposed
- FileShopify Orders exportCSV export · 29 rows
- StepRank products each monthStep 1
- ResultMonthly Product Rankings28 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 28 rows came out.
- Download Shopify Orders export sample (29 rows)Shopify admin: Orders > Export > Current page / All orders > CSV with line items
What you get back
The result of that run, the rows to look at first.
Monthly Product RankingsSample data28 rows
| Product | Month | Units | Revenue (USD) | Units rank | Revenue rank |
|---|---|---|---|---|---|
| Spark Pen | 2026-11-01 | 16 | 96 | 1 | 4 |
| Field Notebook | 2026-11-01 | 11 | 132 | 2 | 2 |
| Aurora Bottle 750ml | 2026-11-01 | 9 | 216 | 3 | 1 |
| Cedar Cap | 2026-11-01 | 6 | 120 | 4 | 3 |
| Trail Mug 12oz | 2026-11-01 | 4 | 72 | 5 | 6 |
| Summit Tote | 2026-11-01 | 3 | 96 | 6 | 4 |
| Northstar Tee | 2026-11-01 | 2 | 56 | 7 | 7 |
| Spark Pen | 2026-10-01 | 14 | 84 | 1 | 5 |
| Summit Tote | 2026-10-01 | 8 | 256 | 2 | 1 |
| Trail Mug 12oz | 2026-10-01 | 7 | 126 | 3 | 3 |
| Northstar Tee | 2026-10-01 | 6 | 168 | 4 | 2 |
| Field Notebook | 2026-10-01 | 5 | 60 | 5 | 7 |
How do you rank the top selling products by month?
Upload your Shopify Orders export, then group orders by month and rank products by units sold and revenue. The result shows the top 10 products for each month.
How it works
How to use the Monthly Product Rankings workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Monthly Product Rankings: questions
Which export should you use?
Use the Shopify Orders export. It should include order dates, product names, units, and revenue fields so the workflow can rank products by month.
What happens to rows that do not match?
Rows that do not have the needed fields, or that do not fit the rule, are left out of the ranking. The workflow uses the rows that match the month and product columns you provide.
How do you change the rules in words?
Edit the instruction to change the time period, ranking measure, or output size. For example, you can ask for top products by units only, by revenue only, or for the top 20 instead of the top 10.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Find the few products that make most of your sales, what sells together, and the stock that sits too long.
- Pareto (ABC) analysisEvery item ranked by its total, with its share, the running share and an A, B or C classSee the workflow Template
- Inventory turnover by SKURank Shopify SKUs by inventory turnover ratio using product, order, and inventory exports from the last 12 months.See the workflow Built by the agent
- Market basket analysisEvery pair of products bought together, with support, confidence and liftSee the workflow Template
- Inventory turnover and days on handEach product's turnover and days of stock on hand, month by monthSee the workflow Template
- Demand forecast by SKUForecast next month’s demand for each SKU from your Shopify order line export using recent monthly averages and trend.See the workflow Built by the agent
- Economic order quantityCalculate economic order quantity for each item from a NetSuite item cost and demand export.See the workflow Built by the agent