WHERE slug IN ('nxp','discountoffice','mcgreals','hurdleys'). These four are the only competitors in the Shopify cohort where the vendor field reliably maps to a real supplier. Use this set for every supplier-side analysis.products.brand across all 16 competitors instead — that gives the cleaner signal.D:/20-PROJECTS/officemax/competitor-intelligence/.