Skip to content
Workflow · Stock and products · Opening soon

Open to buy by category

Export your category sales plan, inventory on hand at cost, and open purchase orders from Shopify. Mammoth matches the category keys, brings the files together, and calculates next month open to buy as planned sales plus planned end of month inventory, minus inventory on hand and on order.

Early access opens shortly. Check back soon.

Someone typed

“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”

The agent read it as

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.

  1. File
    Sales plan by category and month
    CSV export · 16 rows
  2. File
    Inventory on hand at cost by category
    CSV export · 8 rows
  3. File
    Open purchase orders by category
    CSV export · 8 rows
  4. Step
    Make plan category key
    Step 1
  5. Step
    Make inventory category key
    Step 2
  6. Step
    Make order category key
    Step 3
  7. Join
    Bring in inventory on hand
    16 of 16 paired
  8. Join
    Bring in open purchase orders
    16 of 16 paired
  9. Step
    Calculate next month open to buy
    Step 6
  10. Result
    Open to Buy by Category
    8 rows
  11. Schedule
    Runs when you say
    Proposed

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.

What you get back

The result of that run, the rows to look at first.

Open to Buy by CategorySample data8 rows
CategoryOpen to buyPlanned salesPlanned end of month inventoryInventory on handOpen purchase orders
activewear100,00091,20072,10041,20022,100
accessories43,50050,80039,50028,60018,200
dresses75,60074,10056,80033,90021,400
denim77,40086,40062,30044,70026,600
footwear57,90078,80050,10039,80031,200
knitwear59,70064,10047,20031,80019,800
outerwear105,100104,50085,40056,10028,700
tops70,50074,50053,60037,10020,500
8 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Open to Buy by Category workflow

  1. 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.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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?
Export your category sales plan, inventory on hand at cost, and open purchase orders from Shopify. Mammoth matches the category keys, brings the files together, and calculates next month open to buy as planned sales plus planned end of month inventory, minus inventory on hand and on order.
What export do I use?
Use the exported files that contain your sales plan by category and month, inventory on hand by category, and open purchase orders by category. The workflow needs the category field to match across the files.
What happens to rows that do not match?
Rows that do not match the category key do not get brought into that step’s result. You can review them and fix the category values or key rules before running it again.
How do I change the rules?
Edit the matching rules in words, such as which column is the category key and how the next month open to buy is calculated. Then rerun the workflow with the updated 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.

Early access opens shortly. Check back soon.