← back to Mfr Recovery 2026 08 23

novasuede-recon-20260826/novasuede_placeholder_RESTORE_20260826.sql

24 lines

-- ROLLBACK: restore placeholder mfr codes
BEGIN;
UPDATE novasuede_catalog SET mfr_sku='novasuede™-red' WHERE sku='novasuede™-red';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-marine-blue' WHERE sku='novasuede™-marine-blue';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-lime' WHERE sku='novasuede™-lime';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-gray' WHERE sku='novasuede™-gray';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-lilac' WHERE sku='novasuede™-lilac';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-orange' WHERE sku='novasuede™-orange';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-latte' WHERE sku='novasuede™-latte';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-light-camel' WHERE sku='novasuede™-light-camel';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-sea-breeze' WHERE sku='novasuede™-sea-breeze';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-mauve' WHERE sku='novasuede™-mauve';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-java' WHERE sku='novasuede™-java';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-white' WHERE sku='novasuede™-white';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-mocha' WHERE sku='novasuede™-mocha';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-navy' WHERE sku='novasuede™-navy';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-silver' WHERE sku='novasuede™-silver';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-rose' WHERE sku='novasuede™-rose';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-mist' WHERE sku='novasuede™-mist';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-mint' WHERE sku='novasuede™-mint';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-green' WHERE sku='novasuede™-green';
UPDATE novasuede_catalog SET mfr_sku='novasuede™-gold' WHERE sku='novasuede™-gold';
COMMIT;