Buying and reordering

The Buy Sheet: what to reorder

Reorder recommendations based on sales velocity, supplier lead time and live stock on hand.

The Buy Sheet is the heart of Miko Restock: Inventory & PO. It lists every product with its sales pace, how many days of cover you have left, and a recommended order quantity, so you can see what to reorder at a glance.

Where to find it

Open Buy Sheet from the app menu. Rows are sorted by urgency: out of stock first, then running low with the least cover at the top.

How to set it up

Turning the Buy Sheet into purchase orders

  1. Tune the forecast

    In Settings → Forecasting, set the cover target, the low-stock warning and the default supplier lead time.
  2. Assign suppliers

    Assign a supplier to any product inline, right from the Buy Sheet, or from the Suppliers page.
  3. Tick the products you want to reorder

    Filter by supplier, status or search to narrow the list.
  4. Create the purchase orders

    Press the create button. If the products you selected belong to different suppliers, Miko automatically splits them into one draft purchase order per supplier, each with the recommended quantities filled in.

Options

What each column tells you

ColumnWhat it shows
On hand / IncomingCurrent available stock across your locations, and the incoming quantity Shopify holds for the product (for example stock on a Shopify transfer).
Sold 30dUnits sold over the last 30 days. Sales over 90 and 365 days are also read, so both fast movers and slow seasonal lines get a sales rate.
Days of coverHow long on-hand plus incoming stock will last at the recent sales pace. Products fall to Low when cover drops under your warning threshold, and Out at zero.
Order qtyHow many units to buy so you land back at your cover target, taking incoming stock and the supplier's lead time into account.

Tune the recommendations

SettingDefaultWhat it does
Cover target (days)45How many days of stock to aim for when an order is recommended.
Low stock warning (days of cover)14A product counts as running low when its cover drops under this.
Default supplier lead time (days)14Used when a product has no supplier, or its supplier has no lead time set.

These three numbers drive every recommendation.

Example

The sales rate uses the last 90 days, falling back to 30 days and then 365 days when a window has no sales. A product that sold 180 units in 90 days sells 2 a day. With a 45-day cover target and a 14-day lead time it needs (45 + 14) × 2 = 118 units. With 30 on hand and none incoming, the recommended order is 118 − 30 = 88. Where a supplier minimum order quantity is recorded for the product, the order is raised to that minimum.

Plan required


Related articles

Not on Shopify yet?

Start a free Shopify trial, then add Miko apps when you are ready.

Set up your store in minutes and try it with your own products. Loyalty, wholesale pricing, AI descriptions and the rest of the Miko apps install in one click once your store is live.