Inventory Tracking for Small Retail — A Plain-English Guide
Last verified: August 2026
For the gift shop, the boutique, the hardware store, the salon retail shelf, the kitchen store, the small bookstore — written in plain English, not warehouse-manager-speak. From clipboard to barcode scanner, the upgrade that pays for itself in dead stock you stop carrying.
What's inside the 25-page PDF
- Square vs. Clover vs. Lightspeed Retail — which POS handles inventory well
- Zoho Inventory, Inflow, Sortly, plus the Notion/Airtable hack for ultra-small shops
- The spreadsheet vs. software cutoff — under 50 SKUs vs. the messy middle vs. 200+
- SKUs vs. UPCs — why they're different, how to name SKUs you can find later
- Barcode scanner setup — wired vs. wireless, plus printing your own with Avery and Dymo
- Variants, bundles, and kits — when each one fits and where POSes fall down
- Receiving — POs, putaway, partial shipments, vendor variants
- Cycle counting vs. annual full count — how to count without closing the shop
- Low-stock alerts and reorder points that actually fire
- Multi-channel sync — in-store POS + Shopify + Etsy + events without overselling
- Inventory at events and markets — the pull/return/reconcile playbook
- Shrink — typical retail loss rates and how to spot patterns
- COGS and how inventory feeds QuickBooks — cost vs. retail value, periodic vs. perpetual
- Pricing, margin, and the markup math (they're different)
- Vendor relationships — terms, returns, and the awkward call
- 5 common mistakes that cost shops money
- Bill's printable monthly inventory checklist
- Plain-English glossary (SKU, UPC, COGS, ABC, lead time, etc.)
- Honest take on AI inventory — what works, what's hype
The full guide is a 25-page printable PDF with real numbers, real workflows, and Bill's recommendations for small retail in Portage County. Download it above — it's free, no email required, no signup.
Why I made this guide
Half the small shops I service in Portage County still track inventory on a clipboard or a spreadsheet that hasn't been updated since spring. They run great little stores — gift shops with packed weekends, salons with retail shelves customers actually buy from, hardware stores three generations old — and they lose real money every month to dead stock, stockouts, and shrink they never caught.
Modern inventory software runs around $30-$70 a month. The right setup takes one afternoon. After that, it's 30-45 minutes a month and the clipboard goes in the recycling. That's one of the highest-ROI tech upgrades a small shop can make.
No affiliate links. No POS-vendor kickbacks. No upsells. Just plain English from the guy who sets it up for shops on Main Street.
— Bill Davis
Want me to do the setup with you?
First call is free — 20 minutes, figure out which tool you actually need. Inventory setup visits are $99 flat per-visit — no tiers, no surprises. Scanner connected and first 100 SKUs entered together. 30-day come-back-free guarantee. Optional $39 Monthly Support Plan for unlimited phone & text help.
Would you rather I just do this for you?
No shame in it — plenty of folks would rather hand it off, and that's what I'm here for. I'll come to your home, set it up right, and make sure it's working before I leave. Flat $99 per visit — no jargon, no upsell, and every visit is 30-day come-back-free.
Not a hardware job? I can often fix it remotely for $49 — a secure screen-share, up to 2 hours, that you watch the whole time and can end whenever (included free for $39/mo Support Plan members, and it counts toward the $99 if it turns out I need to come out).