Purchase planner

How the purchase planner works out reorder quantities from sales, lead times and minimum stock, and turns them into a draft purchase order.

The purchase planner answers one question: what do I need to order from this supplier right now? Pick a supplier or vendor, and StockWay lists the products that will run out before a new delivery could arrive, with a suggested quantity for each. Change any quantity, then turn the plan into a draft purchase order.

Plan an order

  1. In the top bar, open Inventory and choose Purchase planner. The page is headed Purchase order planner.
  2. In Who are you ordering from?, choose a supplier or a vendor.
  3. Set any other options, then click Plan.
  4. Change any quantity in the Order column. Set a line to 0 to leave it out. The units and cost above the table update as you type.
  5. Check Receive into, then click Create draft purchase order.

The draft opens on its edit page. Unit costs come from the supplier's own prices, or else the product's cost when the order is in your store's currency. Nothing is sent until you send it yourself.

Which products are planned

  • A vendor: every product whose vendor in Shopify is that vendor.
  • A supplier whose Catalogue is By Shopify vendor: the products of its linked vendors, or of the vendor with the same name if none is linked.
  • A supplier whose Catalogue is By manual selection: only the products you added to it.

Only inventory-tracked products at active locations are planned, never bundles. Only lines that need ordering are listed, soonest to run out first (Runs out is days of stock left).

The options

OptionWhat it does
Default sales window or Last 7, 14, 30 or 60 daysHow far back sales are measured. The default is Sales velocity window (days) in Preferences (account menu): 60 days unless you change it.
Cover the lead time (auto) or Order for 15, 30, 60 or 90 daysHow far forward to buy.
Ignore what is already on orderPlans as if nothing were on its way.
Include out-of-stock itemsAdds every variant at zero stock or below with nothing on order for it, at one unit each, even if it has not sold.
LocationAll locations, or one location. With one, stock, minimums, sales and incoming stock count for that location only, and Receive into starts on it.
Only these tags / Exclude these tagsPlan only products with one of these tags, or leave out products with any of them. Separate tags with commas. Tags must match in full; capitals do not matter.

How the suggested quantity is worked out

  1. Sales rate. Units sold in the sales window, divided by its days. Cancelled orders and gift cards do not count. This is Sales/day.
  2. Days to cover. With Cover the lead time (auto): lead time + restock period + safety stock (Safety stock (days) in Preferences, 7 by default). With Order for: exactly that many days.
  3. Need. Sales rate × days to cover, minus stock, minus what is on order, rounded up and never below zero.
  4. Minimum stock. If stock plus what is on order is below the product's minimum, the quantity is raised to reach the minimum.
  5. Order rules. The quantity is raised to the product's minimum order quantity, if set, then rounded up to whole packs where the supplier sells in packs.

Example: a product sells 2 a day, the lead time is 14 days, you order every 30 days and safety stock is 7 days. That is 51 days, or 102 units. With 40 in stock and 20 on order, it suggests 42.

Stock is what is available at your active locations, or the chosen one. On order is what is still due on placed purchase orders from any supplier or vendor, plus stock in transit between your locations; drafts and archived orders do not count. ABC grades play no part.

Lead time and restock period

The planner uses the first lead time it finds:

  1. The product's own override, from the vendor's Lead Times page or the supplier's Lead & restock times page.
  2. The supplier's lead time. For a vendor, the longest among its linked suppliers, ignoring archived ones and ones set to By manual selection.
  3. The vendor's lead time.
  4. Default supplier lead time (days) in Preferences, 14 days by default.

The restock period is how often you order: the supplier's, or else the vendor's. Leave it blank to order whenever stock runs low. The Lead time column shows both, for example 14d +30d.

Minimum and maximum stock

  • Min Stock is set per location on its page under Locations, or with the Minimum Stock import on the Products page. It works as a floor, so a product that sells too slowly to measure is still reordered.
  • Reorder points from the Reorder Points import work the same way. If both are set, the larger is used.
  • With All locations, the minimums of every active location are added together.
  • Max Stock is saved but not used by the planner yet: quantities are not capped at, or topped up to, it.

The 60-day sales history

Shopify lets the app read only the last 60 days of orders, so no sales rate covers more than 60 days, even if Preferences asks for more. A product that sells a few times a year may show no sales at all: give it a Min Stock, or tick Include out-of-stock items. A shorter window shows a Measured over banner.

Planning for one location

A sale counts at a location if it was rung up there on point of sale, or is an online order shipped from there. StockWay learns where online orders ship from when you run Sync from Shopify; an order shipped from several locations counts at none. If no sales, or under 80% of the units sold, can be tied to the location, a warning banner says so: treat those quantities as a floor.

Supplier minimum orders

A plan below the supplier's or vendor's minimum order value or units shows a Below ... minimum order banner. You can still create the draft, but it cannot be placed until the minimum is met.

Exclude products

  • Archive it in Shopify. Archived products are always left out; draft products are not.
  • Tag it with a tag listed in Ignore products tagged in Preferences (stocky:ignore by default).
  • Use a report's row menu: Exclude from forecasting on the Low stock or SKU/Variant report. Include in forecasting on the SKU/Variant report undoes it.

Excluded products are also left out of the low stock, best sellers and sale items reports, and the dashboard's Low stock and Lost revenue cards.

If the plan is empty

  • Nothing to order from ... right now: every selling product has enough stock for its lead time, or is already on order.
  • None of ... sold anything: there is no sales rate to work from. Set Min Stock levels.
  • ... is not connected to any products: link the supplier to a vendor, or add products to it, on the Suppliers page.
  • Nothing matched from ... with the tags you applied: check or clear the tag boxes.

Still have a question? Email us and we will help you get set up.

ilyasstaibi1992@gmail.com