Retail Inventory Dashboard from Google Sheets — Free

The point-of-sale system in a small shop is confident about exactly one thing: what got scanned at the register. Ask it how many sea salt candles are on the floor versus boxed up in the back, and it shrugs. That number lives somewhere else — usually a Google Sheet the owner updates after close, walking the aisles with a phone in one hand.

And the sheet, honestly, does a lot. It remembers which supplier the enamel pins come from, when the last delivery arrived, and roughly when to reorder — "roughly" because most independent retailers set reorder points by feel. You know the ceramics move fast in November and the greeting cards crawl in January, so you buy on instinct, and once a year the physical count reveals what walked out the door unscanned.

Retail inventory platforms will happily replace all of this for around $325 a month, plus an onboarding project and a new workflow for every employee. Or you can keep the sheet you trust and put a free AI-built dashboard on top of it — the approach from our general inventory dashboard guide, tuned here for a physical store.

Step 1: Start With Your Stock Sheet

No restructuring required. A typical shop sheet — one row per SKU — looks something like this:

If you also track seasonal buys or a second location on other tabs, leave them where they are. Every tab becomes data the dashboard can read.

Step 2: Grab a Free Love Spreadsheets Account

Head to lovespreadsheets.com and register — no card required. The free tier handles the entire build and keeps the dashboard running; you'd only pay later for staff logins or hosting it on your store's own domain.

Step 3: Describe the Shop, Not the Software

Select the Dashboard template. If your register runs on a system with an API — Square and Shopify POS both offer keys — you can connect it so sales-side numbers flow in live alongside the sheet. Then write out what you actually want to see, in shopkeeper terms:

"We're a gift shop with a sales floor and a backroom. This sheet tracks both counts per SKU plus reorder points and suppliers. Show me total stock per product, floor and backroom separately, and highlight anything at or below its reorder point, grouped by category."

Then request the piece that saves you the nightly aisle-walk:

"Include a chatbot for stock questions — things like 'what's below reorder point in accessories?' or 'when did we last get a candle delivery?'"

Three more asks that earn their keep in retail:

• Reorder alert emails the moment a SKU dips under its threshold, so the November bestseller never sells to zero on a Saturday
• A nightly snapshot written to a trend tab — over months, the gap between deliveries, sales, and counts is your first real shrinkage signal
• Per-category views, so the person who buys jewelry sees jewelry and nothing else

The AI refines your description, may fire back a clarifying question, and the build finishes in roughly 15–20 minutes.

Step 4: One Screen Behind the Counter

The result is a URL you can leave open on the counter iPad: live counts per SKU, floor versus backroom, a red list of everything under its reorder point, and last-delivery dates next to each supplier. When a customer asks "do you have this in the back?", the answer is a glance — or a typed question to the chatbot — instead of a jog to the storeroom.

Why Shop Owners Keep the Sheet

Closing-time habits survive. The after-hours count you already do keeps feeding the same sheet; the dashboard simply reads it live, along with any connected POS.

Reorder points become policy, not memory. Instead of one person's gut carrying forty supplier relationships, thresholds sit in a column and the alerts fire whether or not the owner is on shift.

Shrinkage gets a paper trail. With daily snapshots accumulating in a tab, you can see which categories bleed stock between counts — long before the annual inventory delivers the bad news in one lump.

Common Questions from Retailers

Can it cover two store locations? Yes — keep a location column or a tab per store, and ask for combined totals plus a per-location view.

Does the POS have to connect? No. Plenty of shops run the dashboard off the sheet alone and add the register feed later.

Will seasonal items clutter it year-round? Ask for filters — a "current season" view is just another instruction in plain English.

Build Yours

Take the stock sheet that already runs your shop to lovespreadsheets.com, pick the Dashboard template, and explain your floor-and-backroom reality in a paragraph. Twenty minutes later, "is there more in the back?" stops being a question anyone has to walk to answer.