No Google Sheets data synced yet. Click "📊 Sync Sheets" to pull data.
Wholesale Forecast
Jake's periodic wholesale demand forecast — synced from Google Drive or uploaded manually, compared release-over-release for drops, increases, and drift.
Loading Wholesale Variance report…
Upload Wholesale Forecast Files
Upload one or more .xlsx "Event & Demand Forecast" files directly — the same
parser used for the Google Drive sync runs here too, so results are identical either way.
Each file is validated automatically when you click Import; nothing is written if any file fails validation.
📊
Drop .xlsx files here or click to browse (multiple allowed)
Inventory Flow
SKU
SALES & STOCK 2.0
ATTRIBUTES
RUNRATES
INVENTORY
OPEN ORDERS
FORECAST
MOS & SAFETY
ACTION
NOTES
Style
Description
2 Months Back
Previous Month
Current MTD
Projected
Run Rate /mo
On Hand
Net Inv
MOS
ABC
Long LT
Leadtime (mo)
Avg Cons /mo
Total Inv
Committed
NET Inv
Open PO
Next Wk Fcst
Next 4wk Fcst
MOS OH
MOS Inv+PO
Below Safety
Recommended Order
Comments
Loading inventory flow...
Import Data
Upload a CSV with columns: sku, channel, week_start, units_sold, revenue
Channel values: shopify, amazon, wholesale
📄
Drop CSV here or click to browse
Upload a CSV with columns: sku, location, snapshot_date, on_hand, in_transit, allocated, available
Location values: main, fba, 3pl
📦
Drop CSV here or click to browse
Upload the Weekly Event Review Meeting export (CSV). Columns used:
Ship Date, Account, Event Name, Event Status, Event Type, Style #, SKU, Item Description, Order Qty.
Events are stored per SKU and upserted by account + event name + SKU.
🏬
Drop CSV here or click to browse
Upload the adjustment workbook (export the sheet to CSV). Columns used:
Style/SKU, Peak Season Adjustment, Update Comment, Adjusted Runrate.
Adjusted Runrate overrides the statistical weekly run-rate; Peak Season Adjustment
multiplies it. Rows are matched to existing SKUs and applied to forecasts in bulk.