What to Reorder in Shopify Now That Stocky Is Gone

1. Set a stock target for each product

A target is how many units you want on the shelf right after a delivery lands. A simple way to set one:

• Work out how many you sell in a normal week.
• Multiply by the weeks a delivery takes to arrive, plus the weeks until you’ll next place an order.
• Add a small buffer for slow deliveries or a good week.

For weekly sales, Shopify’s inventory reports (opens in a new tab) include Inventory sold daily by product and Inventory remaining per product, which estimates how many days your current stock will last. Don’t overthink the first numbers. You can adjust a target after every order.

2. Check what you actually have

Use the Available number in Products, then Inventory, not On hand. Available leaves out units already promised to orders. If you have more than one location, only count the locations you actually restock and ship from. If a product shows a negative number, fix that first with our negative inventory guide, or the order will be wrong too.

If you already have stock on order that hasn’t arrived, take it into account so you don’t order it twice.

3. Work out how much stock to reorder

Subtract what you have from the target. If the result is zero or less, skip the product this time. If it’s positive, that’s your shortfall.

Then apply the supplier’s rules. If they have a minimum order quantity (MOQ), order at least that many. If they sell in packs or cases, round up to the next full pack.

An example: your target for a linen throw is 40 and you have 13 available, so you’re 27 short. The supplier’s minimum is 24, and 27 is already above that. They sell in cases of 12, so 27 rounds up to 3 cases, which is 36 units.

4. Place the order

Group the lines by supplier and send each one its list. If you want the order recorded in Shopify, you can create a purchase order in Shopify admin (opens in a new tab) under Products, then Purchase orders, and receive the stock against it when it arrives. Shopify fills in the supplier’s SKU and cost from earlier orders, but the quantities are still yours to decide.

Let Efficiencia do the arithmetic

The steps above work in a spreadsheet. They get tedious once you have a few dozen products and more than one supplier.

Efficiencia’s Reorder does the same calculation. It creates your suppliers from the vendor on your Shopify products, reads the last 60 days of sales, and works out a target for every product from the supplier’s lead time and the weeks of stock you keep. It takes off the stock you have and the stock already on order, rounds the rest up to the supplier’s pack size and minimum order, and groups the lines by supplier. Each line shows exactly why it chose that number. When you’re ready, send each supplier’s order as a PDF, as an email draft in your mail app, or as a CSV for a Shopify purchase order.

It’s deliberately simple. It uses sales, lead time and weeks of stock, not a forecasting model, and it leaves purchase orders, receiving and stock counts to Shopify. Looking for the wider picture? Read what Shopify covers since Stocky and what Efficiencia adds.

Efficiencia is still in development. If you’d like to try it on your store, join early access.