`audit_summary.txt`

70 lines
=== PHASE 1 AUDIT SUMMARY ===
Timestamp: 2026-04-24T07:02:37.009Z
Total variants in audit: 8936
Unique products in audit: 4816

--- by prefix (current_sku) ---
    6315  DWJS
    1392  DWBR
     948  CCA
     152  TRF
     129  GGA

--- by status ---
    5930  ARCHIVED
    3006  ACTIVE

--- by series_guess ---
    4564  Unknown
    4124  Brewster
     248  York

--- flags ---
    6315  EXISTING_DWJS_NO_RENAME
    4564  UNKNOWN_SERIES
     696  NO_BOLT_VARIANT
       6  MISSING_MFR_SKU

Missing mfr_sku (legacy only, non-DWJS): 6
Unknown series (needs human review): 4564

--- sample UNKNOWN_SERIES rows (first 10) ---
  TRF-56800-sample         Jeffrey Stevens        Shangri La Bamboo Trellis | Jeffrey Stevens
  TRF-56800                Jeffrey Stevens        Shangri La Bamboo Trellis | Jeffrey Stevens
  TRF-56801-sample         Jeffrey Stevens        Shangri La Bamboo Trellis | Jeffrey Stevens
  TRF-56801                Jeffrey Stevens        Shangri La Bamboo Trellis | Jeffrey Stevens
  TRF-56809-sample         Jeffrey Stevens        Kingston Watercolor Jacobean | Jeffrey Stevens
  TRF-56809                Jeffrey Stevens        Kingston Watercolor Jacobean | Jeffrey Stevens
  TRF-56810-sample         Jeffrey Stevens        Kingston Watercolor Jacobean | Jeffrey Stevens
  TRF-56810                Jeffrey Stevens        Kingston Watercolor Jacobean | Jeffrey Stevens
  TRF-56811-sample         Jeffrey Stevens        Kingston Watercolor Jacobean | Jeffrey Stevens
  TRF-56811                Jeffrey Stevens        Kingston Watercolor Jacobean | Jeffrey Stevens

--- sample LEGACY rows by prefix (first 5 each) ---
[DWBR]
  DWBR-171605              mfr=4081-26348     Brewster  Chilton - Yellow Residential Wallpaper | Jeffrey S
  DWBR-171606              mfr=4081-26314     Brewster  Gallina - Blue Residential Wallpaper | Jeffrey Ste
  DWBR-171607              mfr=4081-26317     Brewster  Gallina - Orange Residential Wallpaper | Jeffrey S
  DWBR-171608              mfr=4081-26316     Brewster  Gallina - Green Residential Wallpaper | Jeffrey St
  DWBR-171609              mfr=4081-26315     Brewster  Gallina - Charcoal Residential Wallpaper | Jeffrey
[CCA]
  CCA-82817                mfr=82817          Brewster  Jada Pink Girly Floral Scroll Wallcovering Wallcov
  CCA-82818                mfr=82818          Brewster  Jada White Girly Floral Scroll Wallcovering Wallco
  CCA-82819                mfr=82819          Brewster  Jada Light Blue Girly Floral Scroll Wallcovering W
  CCA-82820                mfr=82820          Brewster  Jada Silver Girly Floral Scroll Wallcovering Wallc
  CCA-82821                mfr=82821          Brewster  Jada Lilac Girly Floral Scroll Wallcovering Wallco
[TRF]
  TRF-56800                mfr=TRF-56800      Unknown   Shangri La Bamboo Trellis | Jeffrey Stevens
  TRF-56801                mfr=TRF-56801      Unknown   Shangri La Bamboo Trellis | Jeffrey Stevens
  TRF-56809                mfr=TRF-56809      Unknown   Kingston Watercolor Jacobean | Jeffrey Stevens
  TRF-56810                mfr=TRF-56810      Unknown   Kingston Watercolor Jacobean | Jeffrey Stevens
  TRF-56811                mfr=TRF-56811      Unknown   Kingston Watercolor Jacobean | Jeffrey Stevens
[GGA]
  GGA-82642                mfr=GGA-82642      Unknown   Giulia Lavender Brocade Ribbon | Jeffrey Stevens
  GGA-82643                mfr=GGA-82643      Unknown   Haversham High Paintable Textured Vinyl | Jeffrey 
  GGA-82644                mfr=GGA-82644      Unknown   Winnipeg Paintable Textured Vinyl | Jeffrey Steven
  GGA-82645                mfr=GGA-82645      Unknown   Milford Plain Paintable Textured Vinyl | Jeffrey S
  GGA-82646                mfr=GGA-82646      Unknown   Texture B Paintable Textured Vinyl | Jeffrey Steve

Renumber range used: DWJS-90000 .. DWJS-91507