
ProOnline Shop Profit & Stock Tracker
Available product — files, demo URL and secure download get mapped in EDF 0.3.
What it does
Excel system for net profit, channel fees, returns, stock and ROAS
Online Shop Profit & Stock Tracker: products with live stock, days of cover and REORDER alerts, orders with marketplace, payment and fixed fees per channel, returns and refunds, stock purchases and ad spend; Dashboard with NET PROFIT, ROAS against break-even ROAS, profit by channel and week, best products, returns by reason. A Settings sheet, dropdown lists, red/green alerts and a charted Dashboard; sample and empty versions of the same workbook; no macros.
Origin: EWDS Store (epicwebdesignstudio.com) · Roadmap window: EDF 0.2
Live demo
demo_url is mapped. See Home → Live Products for the frame.Package
Placed in the private vault layout (deploy/vault/products). Downloads stay disabled until checkout is connected.
What's included
- Online Shop Profit & Stock Tracker: products with live stock, days of cover and REORDER alerts, orders with marketplace, payment and fixed fees per channel, returns and refunds, stock purchases and ad spend; Dashboard with NET PROFIT, ROAS against break-even ROAS, profit by channel and week, best products, returns by reason
- 2 files: the workbook with fictional sample data and an empty copy, plus README and licence
- Formulas use only SUMIFS, COUNTIFS, SUMPRODUCT, INDEX/MATCH and similar: no macros, no add-ins, no XLOOKUP or dynamic arrays
FORGE DNA™
TIMEPROOF SCORE — derived from real catalog fields (stack, formats, skill, AI flag), not decoration
Compatibility & relations
Derived by the mapping engine (family · layer · tags · dependency rules). Stored in the catalog as compatibility, dependencies, relations[].
Documentation
- Quick start (planned — every product gets one)
- Customisation guide
- Deployment guide — Vercel / Cloudflare / GitHub
- epic.json / EPIC-DNA.json — machine-readable DNA shipped inside the ZIP
Version history & changelog
| VERSION | STATE | NOTES |
|---|---|---|
| v2.0.0 2026-10-03 | AVAILABLE | Current release. This package contains: Online Shop Profit & Stock Tracker: products with live stock, days of cover and REORDER alerts, orders with marketplace, payment and fixed fees per channel, returns and refunds, stock purchases and ad spend; Dashboard with NET PROFIT, ROAS against break-even ROAS, profit by channel and week, best products, returns by reason; 2 files: the workbook with fictional sample data and an empty copy, plus README and licence; Formulas use only SUMIFS, COUNTIFS, SUMPRODUCT, INDEX/MATCH and similar: no macros, no add-ins, no XLOOKUP or dynamic arrays. |
| → EDF 0.2 | Roadmap | Target window for the next stage. |
Before you buy
Tested by recalculating both files in LibreOffice: no formula errors, and the key Dashboard figures of the sample file were checked against values computed independently in Python from the same sample data. Not tested by the author in every Excel version, on Excel for the web or in Google Sheets (charts and conditional formatting import there but can look slightly different). Files are saved without pre-calculated results, so quick-look previewers may show formula cells empty until opened in a spreadsheet program. Ranges are sized for the capacities in the README; more rows need the last row copied down. All names, people and figures are fictional. A management tool, not accounting, tax or legal advice.
License
Standard (personal or commercial use in one end project or your own business) · Extended ×3 (SaaS, unlimited client projects, finished products only). Agency licence comes later.
Personal: run your own business. Commercial: use inside one client's or company's business. Extended: unlimited businesses and clients, including handing the file to your customers. No resale or redistribution of the spreadsheet itself.
Deployment
Activated by 1.0 (download) and 2.0 (one-click deploy). Download will be a 10-minute signed URL from the R2 vault — never a public /files/product.zip.
Related products


Salon, Barber & Studio Manager

Contractor Jobs, Estimates & Cash
