Ecommerce Projections

QuickBooks class 1010 Online/Retail · Feb 2026–Jul 2026 actual (invoiced) + Aug 2026–Jan 2027 forecast · data as of 2026-08-14 18:01 · refreshed 2026-08-15 06:09 · excludes lines > $5k · auto-refreshed daily

Product-family drill-down. Four levels: family (Tag’d / Fidgets) → base style (#503) → color SKU (Pink, Purple…) → sales channel (TT, SFCC, Amazon). Use the carets or the “Expand to…” buttons. Tag’d rolls up 300-series designs; Fidgets the rest. SKU lines use the real product color; channel lines use channel colors. Window rolls forward automatically: trailing 6 months actual + next 6 months forecast. Tip: click a column header to sort.

Seasonal index (mean = 1.0):

Jan 0.55 · Feb 0.54 · Mar 0.65 · Apr 0.66 · May 0.50 · Jun 0.53 · Jul 0.71 · Aug 1.36 · Sep 1.32 · Oct 0.91 · Nov 1.36 · Dec 2.91

· high season: Aug, Sep, Nov, Dec

Trend (Feb'26 – Jan'27)

0total projected units · Aug 2026–Jan 2027

Actual + Forecast (click a header to sort · shaded = high season)

Style	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	6-mo FC

Method & notes

Actuals = invoiced units (InvoiceLines) under QB class 1010 Online/Retail, trailing 6 completed months (Feb 2026-Jul 2026), lines >$5000 excluded. Rolling window: family (Tag'd / Fidgets) -> base style -> color SKU -> channel (TT, SFCC, Amazon). Tag'd = 300-series; Fidgets = the rest. Styles 058/498/618/812/901 removed. TT/SFCC keep styles >=10 units/mo; Amazon (relaunching) keeps all products. Forecast = next 6 months = (actual units / actual-window index sum) x monthly seasonal index. Seasonal index from trailing 24 months (mean=1.0).