Workflow · Stock and products · Opening soon
Etsy sales by listing
Turn your Etsy orders export into a monthly sales report by listing. See orders, revenue, and fees grouped by listing and month.
Someone typed
“summarize etsy sales by listing and month: orders, revenue and fees”
The agent read it as
Summarize Etsy orders export sales by listing and month: orders, revenue and fees.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
Etsy orders export
CSV export · 18 rows
Step
Summarize by listing and month
Step 1
Result
Etsy Listing Sales Summary
16 rows
Schedule
Runs when you say
Proposed
- FileEtsy orders exportCSV export · 18 rows
- StepSummarize by listing and monthStep 1
- ResultEtsy Listing Sales Summary16 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 16 rows came out.
- Download Etsy orders export sample (18 rows)Etsy Shop Manager: Orders & Shipping > Orders > Download CSV
What you get back
The result of that run, the rows to look at first.
Etsy Listing Sales SummarySample data16 rows
| Listing ID | Listing | Month | Orders | Revenue | Fees |
|---|---|---|---|---|---|
| 881200114 | Ceramic Moon Mug | 2026-09-01 | 2 | 56 | 6.36 |
| 881200221 | Handwoven Market Tote | 2026-09-01 | 1 | 64 | 7.04 |
| 881200338 | Botanical Notepad Set | 2026-09-01 | 1 | 27 | 2.97 |
| 881200221 | Handwoven Market Tote | 2026-10-01 | 1 | 32 | 3.52 |
| 881200804 | Blue Ridge Serving Bowl | 2026-10-01 | 1 | 46 | 5.06 |
| 881200338 | Botanical Notepad Set | 2026-10-01 | 1 | 36 | 3.96 |
| 881200114 | Ceramic Moon Mug | 2026-10-01 | 1 | 56 | 6.16 |
| 881200921 | Wool Felt Coaster Set | 2026-10-01 | 1 | 24 | 2.64 |
| 881200221 | Handwoven Market Tote | 2026-11-01 | 1 | 32 | 3.52 |
| 881200455 | Oak Leaf Candle Holder | 2026-10-01 | 1 | 34 | 3.57 |
| 881200579 | Minimalist Desk Clock | 2026-10-01 | 1 | 42 | 4.41 |
| 881200690 | Pressed Fern Art Print | 2026-10-01 | 1 | 36 | 3.96 |
How do you summarize Etsy sales by listing and month?
Export your Etsy orders file, then upload it to Mammoth. Mammoth groups the rows by listing and month, then totals orders, revenue, and fees.
How it works
How to use the Etsy Listing 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.
Etsy Listing Sales Summary: questions
What export should I use?
Use the Etsy orders export that includes listing, order date, revenue, and fees. If your export uses different column names, map them to the same fields.
What happens to rows that do not match?
Rows that do not have the fields needed for the grouping or totals are left out of the summary. You can review the source file and fix the missing values, then run it again.
How do I change the rules?
Edit the grouping words in the workflow, for example change the time period or the fields used for grouping. You can also rename columns or add filters before running the summary again.
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