Skip to content

1 or 2 credits, some free · 1 credit is about $1

pocketshelf

Online Shop Inventory Tracker

An inventory and reorder tracker for an online shop: a Dashboard with 3 charts, Products, Stock In and Sales. XLSX with a blank copy.

ForSmall business

Dashboard tab: Stock value $893, Low stock 1, Out of stock 1, Units sold 144; doughnut chart of Stock value by category ($); bar chart of Stock value by category ($); column chart of Units sold by...Products tab: columns SKU, Product, Category, Unit cost ($), Unit price ($), Reorder at, Opening stock, Received (auto), Sold (auto), On hand (auto), Stock value (auto) ($), Status (auto); 6...Settings tab: Currency symbol, Symbol position, Start month, Year and more.Sales tab: columns Date, SKU, Quantity, Product (auto), Revenue (auto) ($), Month (auto), Year (auto); 15 sample rows.

DashboardPreviews of the Dashboard, Products, Settings and Sales tabs with sample data, drawn from the file. Fonts and chart styling can differ in Excel, Numbers and Google Sheets.

View full size (opens image)

What's inside

Format
XLSX, CSV
Contents
6 tabs · 3 charts
Version
1.1 · Updated 7 Oct 2026
Licence
Commercial What this means
Checked
Checked before it ships
  • online-shop-inventory-tracker.xlsxXLSX · 111 KB
  • online-shop-inventory-tracker-blank.xlsxXLSX · 109 KB
  • online-shop-inventory-tracker.csvCSV · 465 B
  • LICENSE.txtadded to every download

About this item

An inventory and reorder tracker for an online shop. It has 6 tabs: Start Here, Dashboard, Products, Stock In, Sales, Settings. The Dashboard with 3 charts shows the value of the stock you hold ($893 in the sample data), how many products are Low or Out, and units sold in the month you pick, with a doughnut of stock value by category and units sold for every month. Type each delivery on Stock In and each sale on Sales; on hand is calculated for every product and its status says Low, Out or OK in words, never colour alone. Reorder points are yours to set. You get two files: one with sample data so you can see it working, and a blank copy with the same formulas. Nothing is password-locked. Made for Excel (XLSX).

Reviews

No reviews yet.

You might also grab