Free tool
Print a blank inventory sheet, or make a count sheet from your Shopify inventory CSV. The sheet has one row for each real item, so you count a blank tee one time, even when ten listings sell it.
In Shopify admin, go to Products, then Inventory, then Export. Drop the file here. Listings with the same SKU become one row, because they sell one real item.
A plain inventory list template for a count by hand. Download it as a CSV file to open in Excel or Google Sheets, or print it.
The item name or SKU, the location or shelf, the unit, the counted number, and a note. If several listings sell one item, also list those listings, so you know which numbers to change after the count.
Yes. Download the blank sheet above as a CSV file. Excel and Google Sheets open it directly.
Because they sell one real item. You count the shelf, not the listings. Shopify keeps a separate number for each listing, so after the count, each of those listings must show what the shelf allows.
No. The sheet is made in your browser. Your file does not leave your computer.
See how many units customers can buy that you do not have, when several listings sell one item.
Open the overselling check →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 →See when to reorder, how much safety stock to keep, and how fast your stock turns.
Open the reorder calculator →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 →After a count, each listing that sells the item needs a new number. In OneShelf, you type the count one time in the base stock, and each sale on any listing takes from it. It is free for up to 3 base stocks.