Wix import dropped ticket-type dietary metadata

Someone · 5/12/2026, 11:11:47 PM

Discovered 2026-05-13 via Srinivas Madhurakavi case + Nick's Dallas weekend vegetarian count.

Wix encodes dietary in the ticket DEFINITION label, e.g. "General Admission (Vegetarian)" / "(Vegan)" / "(Classic)". Our scripts/wix-export extraction pulled order-level data but never called Wix's per-event tickets endpoint, so this metadata was silently dropped on import. Affected: all Wix-imported orders pre-cutover (Apr 29).

Symptom: tickets.dietary defaults to 'regular' even when customer purchased a vegetarian/vegan-typed ticket in Wix. Nick + the kitchen rely on tickets.dietary_curated for prep counts; they're flying blind unless they cross-reference Wix manually.

Fix path: new script scripts/wix-export/backfill-ticket-types.mjs that hits Wix per-event tickets endpoint, parses parenthetical out of definition name, maps to our tickets rows by order_id + ordinal position, updates dietary_curated. Likely 50-200 tickets across the platform.

Manual fix tonight for Srinivas's order applied (order_id 527617c0...). Other affected orders unknown until backfill runs.