SKU Promo Converter

Import the raw promo location file and the master product file, confirm the column mapping, then pivot, VLOOKUP, and compare to find SKUs that still need a promo version created.

1. Raw data Loc Promo

Source: "List SKU Non Promo in DC Promo.xlsx"

2. Filter Master Prod w Promo

Source: "List Product Master with (Promo).xlsx"

What this does

  1. Loads raw promo location data and pivots unique mapped product values.
  2. Loads master product list and pivots unique mapped name values.
  3. For each product, builds "(PROMO) " & MID(name, 12) and VLOOKUPs against the master names.
  4. SKUs that return #N/A are listed in "Need to Create SKU Promo".