📊
No sales data loaded yet
Sign in as admin and import a sales workbook to populate the dashboard. Once imported, your data lives on the server and everyone who visits this site sees it — until you replace or remove it.
Business at a glance
Monthly Revenue — 2025 vs 2026
2025 full year · 2026 in progress
20252026
Revenue Share by Portal
Top Portals
Top Collections by Revenue
All-time, top 8
Daily Revenue
Revenue per day by order date. Filter, switch views, export.
Range
–
Metric
Channel
Collection
Type
Set size
Revenue by day
Daily breakdown
Newest first · scrolls
🔍 Order Details
Search any order, review its full ShipStation record, and verify Custom Field 2 & the portal it flows to.
Enter an Order ID above and press Search.
Year vs Year
Compare any two years month-by-month — now that 2023–2026 are synced.
Revenue by month
Month-by-month
Monthly
Revenue, orders and units by month.
Revenue by Month
2025 vs 2026
20252026
Orders by Month
Order lines
Units by Month
Quantity sold
Monthly Detail
Full detail incl. June 2026
Portal performance
Growth % is like-for-like. Revenue columns are all-time.
Revenue by Portal
All-time, ranked
Like-for-Like Growth by Portal
2026 vs 2025
Portal Detail
Click a header to sort
Collection performance
Best-selling product lines and year-over-year movement.
Top Collections by Revenue
All-time, top 12
Collection Growth (LFL)
2026 vs 2025
Collection Detail
Click a collection to see its portal breakdown
Collection × Portal — Revenue Heatmap
All-time revenue · scroll to see more
Size analysis
Revenue split by size and product type.
Revenue by Size
Top 12 sizes
By Product Type
Revenue share
Size Detail
Top 15 by revenue
📈 Collection × Size — what’s scaling
like-for-like: 2025 vs 2026 (Jan–Jun), ranked by revenue growth · click a row for the color & portal breakdown
SKU analysis
Per-SKU monthly revenue, 2025 vs 2026, with a projection and sale difference for each month.
SKU × Month
Projection & targets
Set a growth target for 2026 and track pace against it, month by month and portal by portal.
🎯 Set your 2026 growth target
Enter the % increase you want over 2025. Targets below are 2025 actuals grown by that %. Pace is measured like-for-like (Jan–Jun, where 2026 has actuals).
% over 2025
Monthly Target vs Actual — 2026
Bars = 2026 actual · line = monthly target
Month-by-Month Targets
Target = 2025 month × (1 + target%)
Portal Targets (Jan–Jun pace)
Like-for-like: 2026 actual vs 2025 grown by target%
Growth strategy
Where to lean in and where to act. All comparisons are like-for-like.
🚀 Top Growth SKUs
Biggest revenue gains (LFL)
⚠️ Declining SKUs — Action Needed
Biggest revenue drops (LFL)
Best Portals to Scale
Largest LFL revenue gains
Portals Losing Ground
Largest LFL revenue drops
Note: Inventory, Ads & Promotions, and AI Insights tabs from your original dashboard need data that isn't in this sales file (stock levels, cost, ad spend). Share those and I'll add the tabs back, powered by real numbers.
🧠 AI Strategy Advisor
Automated diagnosis of where you’re losing ground — by portal, collection, and portal×collection — with a prioritized plan to rank them back up. Like-for-like: 2025 vs 2026 (Jan–Jun).
📉 Portals losing ground
Like-for-like decline, biggest $ loss first
📉 Collections losing ground
Like-for-like decline
🎯 Biggest problem areas — Collection × Portal
The specific collection+portal combos bleeding the most revenue — fix these first
🩺 Root-cause diagnosis — why is it dropping?
reads price vs. units movement and where it fell vs. held, to rank the likely drivers — pricing, visibility, reviews, listing, competition
📜 Recommended action plan
📈 Where you’re winning — double down here
Redirect ad budget & inventory toward these
💭 How to read this
💰 Ad Spend by portal & year
Enter each portal's total ad spend and ad sales per year from your reports. Saved to the database and used in the P&L Ads column (by year) and the ROAS below.
Optional — upload a portal's raw ads report to preview its detailed metrics (browser-only, not saved). The table above is what feeds the P&L.
📤 Upload an ads report
Pick the portal, then drop the raw export (.xlsx or .csv) exactly as the platform gives it. Parsed in your browser — nothing is uploaded to a server.
📊
Drop the ads report here, or click to choose
Any columns are fine — we'll detect spend, clicks, sales, etc. where present
📋 Loaded ad reports
One report per portal. Re-uploading a portal replaces its report.
Discount tracking
Base cost vs. what you actually sold for — realized discounts across portals, collections and months.
Portal types
Tap a portal to switch · sets which base cost it uses🏪 Marketplace we pay shipping
🚚 Dropship portal pays
Discount summary — all portals
Upload a base-cost file (bottom of page) to see discounts across every portal.
📈 Month by month
Discount by collection
Upload a base-cost file (bottom of page) to see discount by collection.
Discount analysis — per SKU
Load a base-cost file (bottom of page) to calculate discounts. Sale prices come from your existing sales records.
🔍
Data inputs
📤 Base cost (one file, all SKUs)
Columns: SKU TYPE, SKU, MarketPlace, Dropship. Marketplace portals use the MarketPlace cost; dropship portals use the Dropship cost. Saved on this device once uploaded.
💳
Drop base-cost file, or click
.xlsx / .csv · SKU + MarketPlace + Dropship
📤 Current portal price
The price the portal is listing right now. File columns: an SKU / Item_code column and a price column.
🏷️
Drop current-price file, or click
.xlsx / .csv · SKU + price
📊 Profit & Loss
Gross revenue → returns → net, then commission, return commission & shipping, per portal.
📈 Profitability by Collection & SKU
Net revenue − commission − cost of goods (FOB/LDP) − allocated shipping & ads. Click a collection for its SKUs.
📦 Costs come from Data Manager → Landed Cost — set a $/sq ft rate per collection there and LDP flows into this table automatically.
↩️
No returns loaded yet
Upload the Order IDs your portals marked as returned — head to Data Manager → Returns. Everything else here fills in automatically.
Lifetime performance
Every year of sales in one place — from your first order to today.
Revenue by year
Full-year totals · the latest year is year-to-date
Year-by-year detail
Data Manager
Sync, commissions & fees, returns, and import/export — all in one place.
—Order lines
—Date range
—Channels
—Total revenue
Live data
⬆️ Import spreadsheet
For carrier fees & historic files. Excel (.xlsx) or CSV — recomputes every tab in your browser.
🔒 Importing data is limited to the admin. Sign in as admin to load or replace the dashboard data.
📤
Drop file(s) here, or click to choose
Sales file (Sheet1 = sales · Sheet2 = master) — add the Shipped Orders file too for shipping costs
🚚 Add the Shipped Orders export here (it has the Carrier Fee column) and shipping cost is joined onto sales by Order ID and shown per channel in the P&L. ShipStation Shipped Items exports are also accepted directly.
Expected columns (Sheet1)
Date, Customer (or MarketPlace), Item_code, Product, Quantity, Price, TOTAL
🏷️ Price & SKU data
Base cost (marketplace/dropship) plus the SKU → collection / size / colour mapping. Saved in the database; export any time to edit and re-upload. Two sheets: PRICE SHEET and SKU DETAILS.
🏷️
Drop the Price & SKU file, or click to choose
PRICE SHEET: SKU TYPE, No of PCs, SKU, MARKETPLACE, DROPSHIP · SKU DETAILS: SKU, PRODUCT TYPE, SIZE, COLOR, COLLECTION
💰 Commission & Fees by Marketplace
Rates used in the P&L. The marketplace name must match your channel label exactly.
↩️ Upload returns
Give me the Order IDs the portal marked as returned — each is matched to your sales data to work out the portal, SKU, collection, size & colour automatically. Return reason is optional.
📦
Drop your returns file, or click to choose
.xlsx / .csv · column 1 = Order ID · column 2 = Return Reason (optional)
OR PASTE ORDER IDs
One Order ID per line. Add a comma and a reason if you like — e.g. 200013787886652, WRONG ITEM. (A plain comma or space separated list on one line works too.)
Moved to a new copy of the dashboard? Restore a returns backup
📦 Landed cost calculator (FOB → LDP)
Give a $/sq ft rate per collection and each size's FOB = (L × W ÷ 144) × rate is calculated automatically (or upload exact FOB below). Set duty % and packed thickness per type; I then compute CBM/piece = L × W × thickness, Pcs/container = capacity ÷ CBM, Freight = (Container + Inland) ÷ Pcs, and LDP = FOB + Duty + Freight. Edit any rate and hit Recalculate.
FOB from $ / sq ft rate — by collection
FOB per item = (Length × Width ÷ 144) sq ft × the collection's rate. Set a rate and every size in that collection gets an FOB automatically. Uploading an FOB file below overrides these for the rows it contains.
Per-SKU costs override the collection $/sq ft rate for that exact SKU — use this when a specific SKU has a different FOB.
⬇️ Export current data
Download what's showing now as an Excel workbook or individual CSVs.
Or a single table as CSV:
Download your raw sale data exactly as uploaded — both years, original columns, original figures — ready to edit and re-upload:
📥 Export raw sales for a period
Every order line by order date (ShipStation-style columns incl. searchable Order #). Pick a date range and, if you like, a single channel.
Currently loaded