E-Commerce & Inventory Tracker Pro — Excel Template | Stock + Sales + P&L + Alerts

Complete inventory and sales tracking system for online sellers. Manage 15+ products across Shopify, Amazon and Etsy. Auto low stock alerts, monthly P&L, product performance rankings and supplier tracker. Excel & Google Sheets.

📦 E-COMMERCE & INVENTORY TRACKER PRO

Built for Shopify, Amazon, Etsy and eBay sellers who want 
to run their store with data — not guesswork.

Know your margins. Know your stock levels. Know exactly 
which products make the most profit. All in one Excel file.

───────────────────────────────────────
📦 10 COMPLETE SHEETS INCLUDED
───────────────────────────────────────

📊 Dashboard
Portfolio overview — revenue, top products, low stock 
count and channel breakdown. All data auto from other sheets.

📦 Inventory
Your full product catalogue. Enter SKU, product name, 
category, cost price, sell price, current stock and 
minimum stock. Margin %, stock value and status 
calculate automatically.

💰 Sales Tracker
Record every sale — channel, SKU, quantity and price. 
Revenue, gross profit and margin % calculate automatically. 
Track Shopify, Amazon, Etsy, eBay, Direct or Other.

📈 Revenue & Profit (P&L)
Monthly income statement for all 12 months. Gross revenue, 
returns, product cost, shipping, platform fees, operating 
expenses and net profit. Net margin % auto-calculated.

🛒 Orders Register
Customer order log with status tracking. Processing, 
Shipped, Delivered, Cancelled and Refunded — 
colour-coded dropdown.

🔄 Stock Movements
Complete inventory history. Log every stock in, sale, 
return, adjustment, write-off and transfer. Net stock 
value change auto-calculated.

🏆 Product Performance
All products ranked by total revenue. Gross profit, margin % 
and performance rating (Star, Performing, Review, No Sales) 
for every SKU.

👥 Supplier Tracker
5 suppliers with email, phone, lead time, minimum order, 
payment terms and A/B/C rating. Know who to call and 
when stock arrives.

📉 Low Stock Alerts
Automatic reorder warnings. Low Stock (red), Warning (amber), 
OK (green) — set your minimum stock and alerts update 
instantly. Reorder quantity shown per product.

📖 Instructions
Built-in guide — SKU system, margin targets, reorder 
formula, channel tracking tips.

───────────────────────────────────────
⚡ KEY FEATURES
───────────────────────────────────────

- 185 auto-calculating formulas — enter data, rest is auto
- Low stock alerts — automatic, colour-coded, no setup needed
- Gross margin auto-calculated for every product and every sale
- Monthly P&L — revenue, COGS, platform fees, net profit
- Product performance rankings — know your best sellers
- 3 sales channels tracked (add more with ease)
- 5 supplier contacts with lead times and payment terms
- Stock movement history — full audit trail
- Works for any currency
- Google Sheets compatible

───────────────────────────────────────
👤 PERFECT FOR
───────────────────────────────────────

- Shopify store owners wanting margin clarity
- Amazon FBM sellers tracking stock and fees
- Etsy sellers with 10–50 products
- eBay sellers managing multiple SKUs
- Anyone replacing expensive inventory software

───────────────────────────────────────
🖥️ COMPATIBILITY
───────────────────────────────────────

✓ Microsoft Excel 2016 / 2019 / 2021 / 365
✓ Google Sheets
✓ Mac and Windows
✓ Works offline

───────────────────────────────────────
📦 WHAT YOU GET
───────────────────────────────────────

- 1 × Ecommerce_Inventory_Tracker_Pro.xlsx
- 1 × Ecom_Tracker_User_Guide.pdf (12-page guide)
- Instant download after payment
- Free updates — all improvements included forever

Replace $360–$1,200/year in inventory app subscriptions.
Pay once. Own forever.