Shopify inventory report
“show every product at each shop with on hand, last 4 weeks of sales deduped, and weeks of cover; use status Agrees unless it’s duplicate sales, negative stock, or low cover”
show every product at each shop with on hand, last 4 weeks of sales deduped, and weeks of cover; use status Agrees unless it’s duplicate sales, negative stock, or low cover from Shopify inventory by location, Shopify orders, and Shopify products
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileShopify inventory by locationCSV export · 24 rows
- FileShopify productsCSV export · 8 rows
- FileShopify ordersCSV export · 18 rows
- JoinAdd product names24 of 24 paired
- StepDedupe recent salesStep 1
- JoinAdd sales totals24 of 24 paired
- StepSet statusStep 4
- ResultShop product cover24 rows · 3 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 24 rows came out, and the join paired 24 of 24 rows; the join paired 24 of 24 rows.
- Download Shopify inventory by location sample (24 rows)Shopify admin: Products > Inventory > Export
- Download Shopify products sample (8 rows)Shopify admin: Products > Export > All products CSV
- Download Shopify orders sample (18 rows)Shopify admin: Orders > Export > All orders CSV
What you get back
The result of that run, the rows to look at first.
| Shop | Product | SKU | On hand | Last 4 weeks sales | Weeks cover | Status |
|---|---|---|---|---|---|---|
| Downtown Shop | Atlas Coffee Mug | MUG-ATL-12 | 18 | 3 | 24 | Duplicate sales |
| North Yard | Atlas Coffee Mug | MUG-ATL-12 | 44 | 3 | 58.67 | Duplicate sales |
| Web Fulfillment | Atlas Coffee Mug | MUG-ATL-12 | 29 | 3 | 38.67 | Duplicate sales |
| Downtown Shop | Alpine Water Bottle 750ml | WTR-ALP-750 | 34 | 1 | 136 | Agrees |
| Downtown Shop | Cedar Notebook A5 | NOT-CED-A5 | 21 | 1 | 84 | Agrees |
| Downtown Shop | Drift Tee Heather | TEE-DRF-HM | 16 | 2 | 32 | Agrees |
| Downtown Shop | Ember Candle Jar | CAN-EMB-8 | 9 | 3 | 12 | Agrees |
| Downtown Shop | Fennel Cap Black | CAP-FEN-BLK | 12 | 3 | 16 | Agrees |
| Downtown Shop | Grove Tote Natural | TOT-GRV-NAT | 25 | 3 | 33.33 | Agrees |
| Downtown Shop | Harbor Socks Slate | SOC-HRB-SLT | 40 | 7 | 22.86 | Agrees |
| North Yard | Alpine Water Bottle 750ml | WTR-ALP-750 | 52 | 1 | 208 | Agrees |
| North Yard | Cedar Notebook A5 | NOT-CED-A5 | 31 | 1 | 124 | Agrees |
How do you build a Shopify inventory report?
Export your Shopify inventory by location, orders, and products files, then upload them to Mammoth. The workflow dedupes recent sales, adds product names, totals sales, and sets a status for each product at each location. Rows with duplicate sales, negative stock, or low cover do not stay as Agrees.
How it works
How to use the Shop product cover 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.
Shop product cover: questions
Which Shopify export should you use?
What happens to rows that do not match?
How do you change the rules?
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.
- Shopify sales by productBuild weekly Shopify sales by product from orders and refunds exports. See gross sales, discounts, refunds, net sales, and status by SKU.See the workflow Built by the agent
- Refund rate by productCalculate refund rate by product from Shopify orders and refunds exports for the last 90 days, sorted highest first.See the workflow Built by the agent
- GA4 vs Shopify revenue gapCompare daily GA4 revenue with Shopify orders, match the dates, and flag days where one side is more than 5% higher.See the workflow Built by the agent
- Shopify returns by productBuild a Shopify returns report by SKU with return reason and return rate from exported orders and returns files.See the workflow Built by the agent
- Pareto (ABC) analysisEvery item ranked by its total, with its share, the running share and an A, B or C classSee the workflow Template
- Market basket analysisEvery pair of products bought together, with support, confidence and liftSee the workflow Template