FREE TOOL · NO SIGNUP

Scan your shelves. Get an inventory report.

Point your phone camera at UPC barcodes. We name the products, you fill in cost and retail. Export to Excel and use it for your own P&L — no account required.

What you'll download

A 3-sheet Excel file — ready to edit

How to use the file for your monthly P&L.

shop-analytics-inventory-your-shop-2026-07-27.xlsx
A
1How to use this file
2
31. Open the Inventory sheet.
42. Cost and Retail are what you entered — edit any time.
53. Ext. Cost, Ext. Retail, Profit, and Margin % recalc automatically.
64. Use this as a starting point for your monthly P&L.
7
8Want this done for you every month?
9The Shop Analytics paid audit imports your POS, ranks every SKU
10by velocity, flags dead stock at 30 / 60 / 90 days, and
11price-matches you against shops within 2 miles.
12From $249/mo — shopanalytics.ai

Scanner

Tap Start camera, then point at a UPC barcode.

Session totals

Items scanned
0 / 200
Total units
0
Total cost
$0.00
Total retail
$0.00
Potential profit
$0.00
Blended margin
0.0%
No items yet. Tap "Start camera" and scan a UPC, or use "Add product manually".

What the free tool doesn't do

This is a scan-to-spreadsheet utility. The paid Shop Analytics audit picks up where it stops.

Rank what's actually selling
Velocity, top movers, cash cows vs. cash burners.
Dead stock at 30/60/90
Flag exactly what to discount or dump.
Price-match within 2 miles
We compare your retail prices to nearby shops in real time.
POS sync
Square, Clover, Shopify — your data auto-imports.
AI memo
Plain-English memo of what to stock, push, or pull.
Co-purchase analysis
What sells with what — bundle and merchandise smarter.