Workflow · Stock and products · Opening soon
Amazon sales by ASIN
Turn your Amazon sales detail export into a monthly sales view by ASIN. See units, revenue, refunds and fees in one table.
Someone typed
“summarize amazon sales by ASIN and month: units, revenue, refunds and fees”
The agent read it as
Summarize Amazon sales detail by child ASIN by ASIN and month: units, revenue, refunds and fees.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
Amazon sales detail by child ASIN
CSV export · 30 rows
Step
Summarize by ASIN and month
Step 1
Result
Amazon Sales Summary
20 rows
Schedule
Runs when you say
Proposed
- FileAmazon sales detail by child ASINCSV export · 30 rows
- StepSummarize by ASIN and monthStep 1
- ResultAmazon Sales Summary20 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 20 rows came out.
- Download Amazon sales detail by child ASIN sample (30 rows)Amazon Seller Central: Business Reports > Detail Page Sales and Traffic by Child Item > Download
What you get back
The result of that run, the rows to look at first.
Amazon Sales SummarySample data20 rows
| ASIN | Month | Units | Revenue | Refunds | Fees |
|---|---|---|---|---|---|
| B0F6Z2J8LM | 2026-09-01 | 5 | 99.95 | 0 | -15 |
| B0K1N9X6PD | 2026-09-01 | 4 | 143.96 | 0 | -21.60 |
| B0M3W7Q2VA | 2026-10-01 | 3 | 56.97 | 0 | -8.55 |
| B0F6Z2J8LM | 2026-10-01 | 4 | 79.96 | 0 | -12 |
| B0K1N9X6PD | 2026-10-01 | 1 | 35.99 | 0 | -5.40 |
| B0F6Z2J8LM | 2026-11-01 | 4 | 79.96 | 0 | -12 |
| B0K1N9X6PD | 2026-11-01 | 5 | 179.95 | 0 | -27 |
| B0M3W7Q2VA | 2026-11-01 | 4 | 75.96 | 0 | -11.40 |
| B0C2K7M4QH | 2026-09-01 | 3 | 74.97 | 0 | -11.25 |
| B0D4L8N1RT | 2026-09-01 | 2 | 49.98 | 0 | -7.50 |
| B0A7P5V3HN | 2026-09-01 | 1 | 24.99 | 0 | -3.75 |
| B0T8R3C5SJ | 2026-10-01 | 5 | 149.95 | 0 | -22.50 |
How do you summarize Amazon sales by ASIN and month?
Export your sales detail file from Amazon Seller Central, then upload it to Mammoth. Mammoth groups the rows by ASIN and month and totals units, revenue, refunds and fees. You get a monthly sales by ASIN table.
How it works
How to use the Amazon Sales Summary 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.
Amazon Sales Summary: questions
What export should I use?
Use the Amazon sales detail export from Seller Central. If you have child ASIN rows, use the file that includes those rows.
What happens to rows that do not match the ASIN or month rules?
Rows that do not match stay out of the summary. You can review them in the source file and decide whether to clean the data or change the rule.
How do I change the rules?
Edit the steps in plain words, then run the workflow again. You can change the grouping fields, the date level, or which values are summed.
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