How to track inventory for a small shop without paying for software

Start with one spreadsheet and a few columns

Google Sheets or Excel is enough for most small shops. The mistake is usually too many columns, not too few. Every extra column is something you have to remember to update, and the ones you skip become wrong fast.

Keep one row per item, or per variant if you sell sizes or colors. If you make things to order, one row per material or component often matters more than one row per finished product.

• Item name and a short code you can type quickly
• Quantity on hand
• Reorder point: the number at which you buy or make more
• Reorder amount: how much you usually buy at once
• Supplier or where you get it
• Last counted date

Make low stock obvious without looking

A spreadsheet only helps if it tells you something when you open it. Add one column that compares quantity on hand to the reorder point, and use conditional formatting to turn the row red or yellow when it's at or below that number.

If you want it to come to you, a spreadsheet can also send an email when a cell changes, but this takes some scripting or add-ons. Many shops skip that and simply check the red rows once a week, which works fine at small volume.

Build habits that keep the numbers true

Inventory data goes wrong because of habits, not software. The best sheet in the world drifts from reality if nobody updates it when a box arrives or a sale goes out.

Pick the smallest set of habits you will really keep, and write them down where everyone who touches stock can see them.

• Update the sheet when stock arrives, not at the end of the week
• Subtract sales from one place, such as your register or online orders, on a set day
• Do a quick count of your fastest-moving items every week
• Do a full count once or twice a year and correct the sheet to match
• Give one person ownership of the sheet, even if others can edit

Free and low-cost options before you pay for anything

Beyond a plain spreadsheet, there are a few free routes. Many point-of-sale and online store platforms include basic stock counts with your plan, so check what you already have before adding another tool. Some inventory apps offer free tiers, but limits on items, users, or features change, so read their current terms before you move your data in.

A paper notebook or a clipboard by the shelf is also a legitimate system for a very small shop. If you only stock a few dozen items and one person handles all of it, a weekly count written down is better than a tool nobody opens.

• Spreadsheet: most flexible, no limits, needs discipline
• Your existing sales platform: stays in sync with sales, but often weak on materials and reorder alerts
• Free tier of an inventory app: less setup, but check limits and how easy it is to export your data
• Paper count sheet: fine for tiny catalogs

Signs the spreadsheet is no longer enough

A spreadsheet starts to strain when more than one person edits it at once, when someone overwrites a formula, or when you can't tell who changed a number. Another sign is that you want alerts, a phone-friendly screen for the stockroom, or a simple history of what moved and when.

Moving to a paid platform solves some of this, but those tools often bring features you won't use: purchase orders, multiple warehouses, barcodes, and monthly fees that scale with your catalog. If your needs are simpler than that, you may be paying for a lot of surface area.

Where a small fixed-price build fits

If your spreadsheet works but you want it to be easier and safer to use, a small custom tool can sit between a sheet and full inventory software. Our simple inventory tracker for a small shop is the closest example: a stock tracker with low-stock alerts, so you stop checking rows by eye.

This usually fits our Tool tier: $749, 5 business days, up to 5 screens, saved data, one integration such as email or Google Sheets, and two rounds of tweaks. You get a hosted link and the full source code. Hosting is included for 12 months, then $9.00 per month, or you can self-host. We send a working preview within one business day of the brief.

If you only need a single calculator or a form that emails you, the Micro tier at $249 may be enough. If you need staff logins and roles, that's the Mini-app tier at $1999. We'd tell you if a spreadsheet and a few habits would serve you better, and you can decline before work starts for a full refund.