Yamaha special issue gifted to advertisers — Brevo × Shopify

Context

For the launch of the first HiFi Lovers special issue (Yamaha 70th anniversary), I wanted to gift a copy to my advertisers and HF partners — with a mechanic that restricts the codes to targeted recipients only (no public leak). The brief: connect the advertisers Excel list → Brevo → Shopify with segmentation and restrictive combinable promo codes.

What was built

• Brevo import of 201 advertisers from the HF master Excel (categorical attributes + B2B opt-in). List "Annonceurs HF #16".
• Shopify import of 143 targeted customers with tag annonceur-yamaha-2026 → automatic segment "Annonceurs HS Yamaha 2026" (142 customers)
• 2 combinable Shopify promo codes, restricted to the segment AND the product: HIFI-LVRS-1-PART (100% off the special issue) + HIFI-LVRS-1-PORT (free shipping France). Valid May 11 → June 30, 1 use/customer.
• Brevo email template in YAML (HF logo, issue cover, red collector kicker, signed letter, monospace box for the 2nd code, 3-step instructional block)
• Email CTA pre-applying the 1st code via Shopify discount URL
• Campaign "HS Yamaha offert - Annonceurs - Mai 2026" scheduled May 12 at 10am, 147 recipients, UTM enabled

What was difficult / unexpected

• Brevo's YAML editor is very picky (rejects #, strict dash syntax) → Python YAML validation required before sending
• Shopify doesn't allow a single code combining free product + free shipping → 2 combinable codes (productDiscount + shippingDiscount with combinesWith). Trade-off: manual entry of the 2nd code at checkout, hence the instructional block in the email.

Stack

HF master Excel (pandas) → Brevo (contact import, YAML editor) → Shopify (segments via tags, discountCodeBasicCreate + discountCodeFreeShippingCreate with customerSelection by segment, combinesWith) → Shopify discount URL for pre-application. Syne + Montserrat fonts. HiFi Lovers colors (#d11514 / #292626 / #f5f2ec).

What this illustrates

End-to-end multi-tool orchestration (Excel → email marketing → e-commerce) with Claude handling data wrangling, marketing config, editorial copy and Shopify GraphQL code. A non-trivial business mechanic (combinable codes restricted by segment + product) translated into real config, tested at checkout before sending.