GIANT weekly ad, multi-buy deals, one store. Prepared by 248.ai (Ora), 2026-09-09.

Store: GIANT #6023, 700 Nutt Rd, Phoenixville PA 19460. Ad week: Fri 2026-08-28 to Thu 2026-09-10.
Files:
  giant_6023_multibuy_deals_2026-08-28.csv   one row per item per deal: 135 deals, 1949 rows, 1945 distinct UPCs
  giant_stores.csv                            all 166 GIANT stores with store number, address and coordinates

Columns: store_id, sku_id, promotion_type, promotion_purchase_quantity, promotion_total_price, promotion_quantity,
promotion_percentage, promotion_price_off, promotion_quantity_limit_per_cart, promotion_start_time, promotion_end_time,
promo_group_id, then mapping_note, item_name (the ad headline), product_name, product_size, item_url, source_deal_text.
  sku_id = the item's UPC as the store lists it: UPC-A without the leading zero and the check digit (Ken's Ranch 16 oz
    = 4133533218, full UPC-A 041335332183). Produce carries its 4-digit PLU. 4 rows have no code (the ad lists no items).
  item_url = the item's page on the store's site; it shows the deal price for the visitor's default store.
  promotion_type: BUY_X_FOR_Y (N for $Y) or BUY_X_GET_Y_Z_PERCENT_OFF (buy some, get some free or at a percent off).
  promo_group_id = the store's deal id; one row per qualifying item, so mix-and-match deals share a promo_group_id.
  promotion_start_time / promotion_end_time are UTC. The ad runs 00:00 to 23:59:59 America/New_York.
  promotion_quantity_limit_per_cart is parsed from the ad's "Limit N offers" text; 0 when the ad states no limit.
  Deals that only apply with a digital coupon (13) are excluded. Plain markdowns are excluded.
