Free tool
Type how fast an item sells and how long your supplier takes. See the stock level at which to reorder, the safety stock to keep back, and the day to place the order.
Paste one number for each day, such as the last 30 or 60 days. Use commas, spaces, or new lines. The tool fills the average and the busiest day, and it finds how much your sales change from day to day.
The inventory turnover ratio shows how many times your stock sells and is replaced in a period. Use the same money values for all three numbers: cost, not sale price.
Multiply your average daily sales by the lead time in days. Then add your safety stock. When the on hand comes down to that number, place the order.
The simple formula is (busiest daily sales × longest lead time) − (average daily sales × usual lead time). With daily sales data, you can use Z × the standard deviation of daily sales × √(lead time) for a set service level.
Use the busiest day method if your supplier is sometimes late, or if you have little sales data. Use the service level method if your lead time is steady and you have at least 30 days of daily sales.
Divide the cost of goods sold by the average inventory value for the same period. The average is the start value plus the end value, divided by 2. A turnover of 4 in a year means that an item waits about 91 days before it sells.
Shopify shows the quantity of each variant. It does not give a reorder point. If several listings sell one item, add their sales together, and compare the reorder point with the real count of the item.
See how many units customers can buy that you do not have, when several listings sell one item.
Open the overselling check →Print a blank inventory sheet, or make a count sheet from Shopify with one row for each real item.
Open the inventory sheet →See how many bundles or kits you can make, and which part runs out first.
Open the bundle calculator →See how many decants one bottle makes, the cost of each, and your margin.
Open the decant calculator →Answer six questions. See if your store needs Shopify alone, a sync app, or a base stock.
Open the check →Download a template that imports correctly, or check your CSV file before you import it.
Open the CSV tool →Make a SKU for each variant from one pattern. See what a SKU is, and find repeated SKUs.
Open the SKU generator →When many listings sell one item, the number to watch is the shelf, not one listing. OneShelf keeps that number as one base stock, and each sale on any listing takes from it. It is free for up to 3 base stocks.