Small topped focaccia variants not appearing in Numbers or WHB Formulas

Done

Bravo · 15 Jun 2026, 06:29

Tim flagged on 5 Jun that small topped focaccia products were not appearing in FORMULAS correctly. John forwarded an email on 6 Jun listing the OS product codes needed: foc1350, foc1350TomRose, foc1350Rose.

Ticket opened

Fix 1: added parent SKU field to product edit UI and API so variants can roll up to a Numbers column key.

Bravo · 15 Jun 2026, 06:29

Fix 2: added SKU_TO_COL mappings for EA–EE columns (smalltoprosefoca:131, smalltoptomfoca:132, slsmalltopfoca:133, slsmalltoprosefoca:134, slsmalltoptomfoca:135) in excel.ts.

Bravo · 15 Jun 2026, 06:29

Fix 3: created OS products foc1350, foc1350TomRose, foc1350Rose and set parent SKUs via script (fix-foca-parents.mts).

Bravo · 15 Jun 2026, 06:29

Status changed to Done