Big Y weekly ad, complex deals, all stores. Sample for DoorDash. Prepared by 248.ai (Ora), 2026-09-02.

Ad week: Thu 2026-09-03 to Wed 2026-09-09 (published by Big Y on 09-02).
Files:
  bigy_complex_deals_2026-09-03_all_stores.csv     every Big Y store that carries the weekly ad, fanned out by each store's own ad version
  bigy_complex_deals_2026-09-03_meriden_peabody.csv the two requested stores only (533 S Broad St Meriden CT = store 88, 637 Lowell St Peabody MA = store 106)
  bigy_stores.csv                                   store roster: store_id, address, ad version served
  msid_self_check.csv                               the four example items from the brief, with the MSID we derive vs the expected value

Columns: the 12 DoorDash fields, then loyalty_offer_required, mapping_note, item_name, source_deal_text, sku_source, flyer_id.
  sku_id = Big Y's own item code, which is the UPC without leading zeros or check digit; matches DoorDash MSID on all four examples.
  promo_group_id = Big Y's offer code; one row per participating UPC, so mix-and-match groups share a promo_group_id.
  promotion_start_time / promotion_end_time are UTC (Z). Big Y ads run 00:00 to 23:59:59 America/New_York.
  promotion_quantity_limit_per_cart is parsed from the ad's "LIMIT n" text; 0 when the ad states no limit.
  BOGO is emitted as BUY_X_GET_Y_Z_PERCENT_OFF with X=1, Y=1, Z=100 and a note.
  loyalty_offer_required = True when the price needs a myBigY offer loaded to the shopper's account (included, flagged).
  Plain markdowns (strike-through prices) are excluded by design.
  Items with no scannable code (a few produce and floral items) are omitted; count in the note below.

Run stats: 138 website requests, 162 seconds wall time, 97 stores in roster, 3 regional ad versions (CT, MA/Peabody, Springfield), 43 complex deals per ad (46 ad items, three of which share an offer code with another item), 36 deal detail pages read for full UPC lists.
