`novasuede-recon-20260826/novasuede_placeholder_APPLY_20260826.sql`

30 lines
-- Novasuede STAGING (novasuede_catalog) placeholder->authoritative mfr code fix
-- Source: novasuede.com live authoritative name->code map (atomic {name,code} pairs), fetched 2026-08-26, $0
-- Mac2-canonical staging table (*_catalog). Reversible via restore-map JSON.
-- Blast radius: 20 rows. Only fills rows whose mfr_sku was a non-code placeholder (the slug).

BEGIN;
UPDATE novasuede_catalog SET mfr_sku='T3R8W' WHERE sku='novasuede™-red' AND mfr_sku='novasuede™-red';
UPDATE novasuede_catalog SET mfr_sku='T3N1W' WHERE sku='novasuede™-marine-blue' AND mfr_sku='novasuede™-marine-blue';
UPDATE novasuede_catalog SET mfr_sku='T3PEW' WHERE sku='novasuede™-lime' AND mfr_sku='novasuede™-lime';
UPDATE novasuede_catalog SET mfr_sku='T3L3W' WHERE sku='novasuede™-gray' AND mfr_sku='novasuede™-gray';
UPDATE novasuede_catalog SET mfr_sku='T3RAW' WHERE sku='novasuede™-lilac' AND mfr_sku='novasuede™-lilac';
UPDATE novasuede_catalog SET mfr_sku='T3Q2W' WHERE sku='novasuede™-orange' AND mfr_sku='novasuede™-orange';
UPDATE novasuede_catalog SET mfr_sku='T3E3W' WHERE sku='novasuede™-latte' AND mfr_sku='novasuede™-latte';
UPDATE novasuede_catalog SET mfr_sku='T3E5W' WHERE sku='novasuede™-light-camel' AND mfr_sku='novasuede™-light-camel';
UPDATE novasuede_catalog SET mfr_sku='T3N8W' WHERE sku='novasuede™-sea-breeze' AND mfr_sku='novasuede™-sea-breeze';
UPDATE novasuede_catalog SET mfr_sku='T3S1W' WHERE sku='novasuede™-mauve' AND mfr_sku='novasuede™-mauve';
UPDATE novasuede_catalog SET mfr_sku='T3H4W' WHERE sku='novasuede™-java' AND mfr_sku='novasuede™-java';
UPDATE novasuede_catalog SET mfr_sku='T3WHW' WHERE sku='novasuede™-white' AND mfr_sku='novasuede™-white';
UPDATE novasuede_catalog SET mfr_sku='T3H7W' WHERE sku='novasuede™-mocha' AND mfr_sku='novasuede™-mocha';
UPDATE novasuede_catalog SET mfr_sku='T3NAW' WHERE sku='novasuede™-navy' AND mfr_sku='novasuede™-navy';
UPDATE novasuede_catalog SET mfr_sku='T3LEW' WHERE sku='novasuede™-silver' AND mfr_sku='novasuede™-silver';
UPDATE novasuede_catalog SET mfr_sku='T3R4W' WHERE sku='novasuede™-rose' AND mfr_sku='novasuede™-rose';
UPDATE novasuede_catalog SET mfr_sku='T3DDW' WHERE sku='novasuede™-mist' AND mfr_sku='novasuede™-mist';
UPDATE novasuede_catalog SET mfr_sku='T3PAW' WHERE sku='novasuede™-mint' AND mfr_sku='novasuede™-mint';
UPDATE novasuede_catalog SET mfr_sku='T3P5W' WHERE sku='novasuede™-green' AND mfr_sku='novasuede™-green';
UPDATE novasuede_catalog SET mfr_sku='T3J9W' WHERE sku='novasuede™-gold' AND mfr_sku='novasuede™-gold';

SELECT count(*) AS placeholders_remaining FROM novasuede_catalog WHERE mfr_sku LIKE 'novasuede%';
COMMIT;