Owner: Shalaco · Opened 2026-05-02 · Last updated 2026-05-02
A controlled SKU vocabulary for SF in Bloom — shakers, seed mixes, and combos — feeding a single Squarespace mega-product. The local matrix is the source of truth; Squarespace is downstream.
v3 covers 16 mixes × 10 containers = 160 SKUs in the main grid. Promo/BOGO/Kit SKUs separated. Legacy SQ codes preserved alongside our canonical readable convention (BAY-CBD, MW-ST-6OZ, etc.).
⚠ Review before upload
→ Pricing Lock (planning view) · all 160 SKUs with COGS · Live · Suggested · Margin %. Toggle views, filter by source/margin. Use this to TUNE the cost model — don't push these prices live.
→ Import CSV (auto-loaded, focused view) · opens straight to the 7 columns that matter (SKU · Container · Mix · Price · Stock · Tags · Visible). Toggle other cols on as needed. ← use this to verify before upload.
→ CSV Dashboard (generic, drop any CSV) · for any other CSV file.
cardboard 2oz, steel + glass 2oz, xxl
{REGION}-{CONTAINER} · e.g. BAY-1OZ, MW-ST-6OZ{container} ~ {sqft} sq ft{shaker-or-mix-code}-{001}.jpg| Decision | Choice |
|---|---|
| Mix scope | 14 regional + 2 Xerces = 16 (High Plains & Specialty subs out) |
| Container scope | 5 shakers + 5 bags = 10 (XXL Messenger initially out — under review) |
| SKU naming | {REGION}-{CONTAINER} readable, 5–11 chars; legacy SQ kept in column |
| Variant label | {container} ~ {sqft} sq ft · tilde flags estimate |
| Promo SKUs | Separate sheet; filtered out of main grid |
| Combo strategy | Cart bundles (no standalone combo SKUs) |
| Page structure | Local matrix = source of truth; Squarespace = downstream view |
| Cutover method | CSV import for first push (fresh new product, Visible:No); API for ongoing sync |
| Cost data | Cost Inputs sheet skeleton; margin formulas pre-wired |
products_updated_04-29.csv into SKU Flat (currently $19 placeholder).bee → Bee in Squarespace product editor.