Open to buy by category
“work out open to buy by category for next month: planned sales plus planned end of month inventory, minus the inventory on hand and on order”
Work out open to buy by category for next month: planned sales plus planned end of month inventory, minus the inventory on hand and on order, using Sales plan by category and month, Inventory on hand at cost by category and Open purchase orders by category.
What the agent built
6 steps, each one an ordinary Mammoth step you can open and change.
- FileSales plan by category and monthCSV export · 16 rows
- FileInventory on hand at cost by categoryCSV export · 8 rows
- FileOpen purchase orders by categoryCSV export · 8 rows
- StepMake plan category keyStep 1
- StepMake inventory category keyStep 2
- StepMake order category keyStep 3
- JoinBring in inventory on hand16 of 16 paired
- JoinBring in open purchase orders16 of 16 paired
- StepCalculate next month open to buyStep 6
- ResultOpen to Buy by Category8 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 8 rows came out, and the join paired 16 of 16 rows; the join paired 16 of 16 rows.
- Download Sales plan by category and month sample (16 rows)Shopify: Analytics > Reports > Custom reports > Export
- Download Inventory on hand at cost by category sample (8 rows)Shopify: Products > Inventory > Export
- Download Open purchase orders by category sample (8 rows)Shopify: Orders > Purchase orders > Export
What you get back
The result of that run, the rows to look at first.
| Category | Open to buy | Planned sales | Planned end of month inventory | Inventory on hand | Open purchase orders |
|---|---|---|---|---|---|
| activewear | 100,000 | 91,200 | 72,100 | 41,200 | 22,100 |
| accessories | 43,500 | 50,800 | 39,500 | 28,600 | 18,200 |
| dresses | 75,600 | 74,100 | 56,800 | 33,900 | 21,400 |
| denim | 77,400 | 86,400 | 62,300 | 44,700 | 26,600 |
| footwear | 57,900 | 78,800 | 50,100 | 39,800 | 31,200 |
| knitwear | 59,700 | 64,100 | 47,200 | 31,800 | 19,800 |
| outerwear | 105,100 | 104,500 | 85,400 | 56,100 | 28,700 |
| tops | 70,500 | 74,500 | 53,600 | 37,100 | 20,500 |
How it works
How to use the Open to Buy by Category 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.
Open to Buy by Category: questions
How do you work out open to buy by category?
What export do I use?
What happens to rows that do not match?
How do I 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.
- 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