Production planning turns "what will sell" into "what to make, when, with what". For a Shopify maker, the inputs are Shopify's sales rate and stock (from the Inventory sold daily and Inventory remaining reports), the orders already waiting (negative stock or unfulfilled orders), wholesale orders, and anything coming up like a market or a holiday. The output is a weekly list of batches, checked against ingredients, packaging and the hours you have. Shopify supplies the demand side; the rest has to be worked out beside it.
The short version
- Demand: days of stock left per product, plus orders waiting, plus wholesale.
- Batches: which products drop below their reorder point this week, in batch sizes.
- Materials: does each batch have its ingredients and packaging, or do they need ordering?
- Capacity: do the batches fit in the week's hours and equipment?
- Schedule: which day each batch runs.
A weekly routine
Monday morning, 30 minutes.
- Open Inventory remaining per product. List products under 14 days of stock.
- Add products with negative stock (made to order or preorders) and wholesale orders due.
- For each, choose a batch size: a full recipe, or a half batch for slow sellers.
- Multiply each batch by its recipe; total the ingredients and packaging.
- Compare with what's on the shelf. Order anything short, now, with its lead time in mind.
- Fit batches into days by equipment and hours.
A made-up example
Hāmākua Hot Sauce's Monday list:
| Product | Days left | Batch | Day |
|---|---|---|---|
| Original | 6 | 240 bottles | Tuesday |
| Garlic | 11 | 120 bottles | Wednesday |
| Mango Habanero | -18 (owed) | 120 bottles | Wednesday |
| Smoked Ghost | 45 | none |
The ingredient check: 480 bottles need 480 caps; there are 300. Caps ordered Monday arrive Wednesday afternoon, so the Garlic batch moves to Thursday and Mango runs Wednesday morning with the caps on hand. Without the check, Wednesday would have stopped halfway.
When plans change mid-week
Plans change: a wholesale order lands on Tuesday, a delivery is late, a batch fails. Re-run the same check, not the whole plan: does the change need materials you don't have, or hours you haven't got? Move the lowest-priority batch first, usually the product with the most days of stock left. Write the change on the plan, so Friday's review shows what happened and why.
Batch sizes
Make full batches of best sellers; they're cheaper per unit and the stock won't sit. Make half batches of slow sellers, even if it costs a bit more per unit, rather than filling a shelf with dead stock. Shopify dead stock covers what happens otherwise.
Capacity
A kettle, an oven, a bottling line or a person can do only so much in a day. Write down each batch's hours and equipment, and don't plan more hours than you have. Busy seasons fail at capacity before they fail at sales.
Where this stops working
Shopify gives you the demand numbers. Everything after that, recipes, ingredient checks, capacity, the schedule, happens in your head or a spreadsheet, and the spreadsheet doesn't know what was used yesterday. Shopify inventory planning and Shopify raw materials inventory cover the inputs.
How TaroStack does it
TaroStack for Shopify runs inside your Shopify admin and plans from your Shopify sales and orders: what to make, on which day, with what you have. It checks ingredients and packaging on hand and on order, uses work centers and capacity so a week's plan fits your hours, and names in plain words what will run short, arrive too late, or expire before it's used. Free for 14 days.
