Free tool

Inventory sheet template

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.

✓ No sign-up✓ Your numbers stay in your browser✓ Print or download as CSV

Or print a blank inventory sheet

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.

How to count stock when listings share items

Questions

What should an inventory sheet include?

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.

Is there a free inventory list template for Excel?

Yes. Download the blank sheet above as a CSV file. Excel and Google Sheets open it directly.

Why does the sheet put several listings on one row?

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.

Is my file uploaded anywhere?

No. The sheet is made in your browser. Your file does not leave your computer.

Other free tools

Count once, and keep every listing correct

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.

Install on Shopify See how it works