← back to Dw Dead Image Recovery

data/tk11050-versa-image-repair/apply-mac2-image-repair.sql

142 lines

-- TK-11050 versa_catalog image_url repair (Mac2 ONLY). 127 rows.
-- Source of truth: Kamatera values, each HEAD-verified 200 + filename matches SKU.
BEGIN;
CREATE TABLE IF NOT EXISTS versa_catalog_imgfix_bak_20260904 AS
  SELECT mfr_sku, image_url FROM versa_catalog WHERE mfr_sku IN (
    'a119-592-258','a119-872-258','a119-897-258','a132-320-262','a151-505-263','a151-841-263','a151-898-263','a153-085-264','a153-163-264','a153-841-264','a156-101-265','a156-152-265','a157-114-266','a157-196-266','a158-310-267','a158-480-267','a158-892-267','a166-322-270','a166-357-270','a167-000-271','a167-101-271','a167-865-271','a169-308-272','a169-312-272','a169-804-272','a171-520-273','a171-864-273','a171-899-273','a176-329-276','a176-852-276','a177-263-277','a177-890-277','a180-231-279','a180-342-279','a180-386-279','a181-082-280','a181-213-280','a183-007-281','a183-466-281','a183-667-281','a187-012-284','a187-111-284','a187-115-284','a188-722-285','a189-058-286','a189-117-286','a189-190-286','a190-127-287','a190-633-287','a191-401-288','a191-502-288','a191-540-288','a192-588-289','a194-610-290','a195-502-291','a197-081-293','a198-458-294','a198-592-294','a198-763-294','a200-958-296','a202-885-298','a203-571-299','a207-501-303','a207-899-303','a208-379-304','a208-801-304','a208-890-304','a209-805-305','a209-834-305','a210-347-306','a210-502-306','a210-516-306','a211-175-307','a211-310-307','a211-941-307','a213-302-309','a213-838-309','a213-879-309','a214-196-310','a214-380-310','a214-863-310','a215-146-311','a215-896-311','a216-710-312','a222-039','a222-317','a95-556-316','abs03-758-38','abs03-849-38','abs04-819-39','abs04-879-39','abs07-346-42','abs07-883-42','asl-141852-322','avf01-025-70','avf01-216-70','avf01-591-70','avf02-590-71','avf03-874-72','avf04-857-73','avf06-500-75','avf06-773-75','avf07-188-76','avf07-330-76','avf10-827-78','avf10-859-78','avf13-898-81','avf14-295-82','avf14-885-82','avf16-325-84','avf17-218-85','avf17-772-85','avf18-014-86','avf18-027-86','avf20-652-87','avf21-271-88','avf21-387-88','avf23-426-89','avf23-637-89','avf23-898-89','avf24-341-90','avf25-867-91','avf26-029-92','avf26-050-92','avf26-157-92','avf27-179-93','avf29-801'
  );

UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/1/7/csm_Brio_A119-592-Sepia_3db1c67665.jpg' WHERE mfr_sku='a119-592-258';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/7/csm_Brio_A119-872-Travertino_5e26820103.jpg' WHERE mfr_sku='a119-872-258';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/9/f/csm_Brio_A119-897-Peony_7348fe8247.jpg' WHERE mfr_sku='a119-897-258';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/6/csm_Lombard_A132-320-Marina_Blvd._5bd14e9e3b.jpg' WHERE mfr_sku='a132-320-262';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/8/csm_Fabrications_A151-505-Oxide_170f27e93f.jpg' WHERE mfr_sku='a151-505-263';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/3/csm_Fabrications_A151-841-Glaze_82e72538ac.jpg' WHERE mfr_sku='a151-841-263';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/5/csm_Fabrications_A151-898-Oiled_Brass_93e3147b76.jpg' WHERE mfr_sku='a151-898-263';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/b/csm_Prism_A153-085-Silver_Lining_d720057100.jpg' WHERE mfr_sku='a153-085-264';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/1/csm_Prism_A153-163-Temptation_7fe25c756f.jpg' WHERE mfr_sku='a153-163-264';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/9/csm_Prism_A153-841-Boot_Strap_a42c0c9f96.jpg' WHERE mfr_sku='a153-841-264';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/1/csm_Embarcadero_A156-101-Spring_Wood_0a86e3f071.jpg' WHERE mfr_sku='a156-101-265';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/f/csm_Embarcadero_A156-152-Promenade_e6fd56113e.jpg' WHERE mfr_sku='a156-152-265';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/9/csm_Urban_Oasis_A157-114-Horn_a7257a68a3.jpg' WHERE mfr_sku='a157-114-266';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/5/csm_Urban_Oasis_A157-196-Sandstone_a8dfcd9000.jpg' WHERE mfr_sku='a157-196-266';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/5/csm_Kouri_A158-310-Tempest_b3b2facb66.jpg' WHERE mfr_sku='a158-310-267';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/3/csm_Kouri_A158-480-Treasure_Island_5c3ff2a29b.jpg' WHERE mfr_sku='a158-480-267';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/c/csm_Kouri_A158-892-Flax_bc0d4e6acb.jpg' WHERE mfr_sku='a158-892-267';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/4/csm_Aura_A166-322-Lagoon_c891c135db.jpg' WHERE mfr_sku='a166-322-270';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/2/csm_Aura_A166-357-Night_Watchman_0dacc24adf.jpg' WHERE mfr_sku='a166-357-270';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/9/d/csm_Chesapeake_A167-000-Chiffon_3d498bf789.jpg' WHERE mfr_sku='a167-000-271';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/e/csm_Chesapeake_A167-101-Lino_03669e8cdb.jpg' WHERE mfr_sku='a167-101-271';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/9/csm_Chesapeake_A167-865-Flint_ab5f42b421.jpg' WHERE mfr_sku='a167-865-271';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/b/csm_Omni_Linen_A169-308-Plume_387517b3a2.jpg' WHERE mfr_sku='a169-308-272';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/8/b/csm_Omni_Linen_A169-312-Night_Owl_a189b59ec4.jpg' WHERE mfr_sku='a169-312-272';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/b/csm_Omni_Linen_A169-804-Windsor_64ad60754d.jpg' WHERE mfr_sku='a169-804-272';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/5/e/csm_Sonoma_A171-520-Meditation_b3b65e95ad.jpg' WHERE mfr_sku='a171-520-273';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/1/e/csm_Sonoma_A171-864-Shoreline_6543544b78.jpg' WHERE mfr_sku='a171-864-273';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/b/csm_Sonoma_A171-899-Daybreak_79fe8ade3d.jpg' WHERE mfr_sku='a171-899-273';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/c/csm_Alley_Cat_A176-329-Tidal_Wave_b04e4dd592.jpg' WHERE mfr_sku='a176-329-276';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/a/csm_Alley_Cat_A176-852-Stone_Wash_bfa8888a20.jpg' WHERE mfr_sku='a176-852-276';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/b/csm_Interlude_A177-263-Ivy_fe2cf1cbff.jpg' WHERE mfr_sku='a177-263-277';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/4/csm_Interlude_A177-890-Opal_4a63618d40.jpg' WHERE mfr_sku='a177-890-277';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/d/csm_Atmosphere_A180-231-Organic_5a99b79a3c.jpg' WHERE mfr_sku='a180-231-279';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/0/csm_Atmosphere_A180-342-Pewter_666177d4e8.jpg' WHERE mfr_sku='a180-342-279';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/5/2/csm_Atmosphere_A180-386-Blue_Lava_245cf5e78e.jpg' WHERE mfr_sku='a180-386-279';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/d/csm_Mandolin_A181-082-Birch_236d3923f3.jpg' WHERE mfr_sku='a181-082-280';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/9/c/csm_Mandolin_A181-213-Tropics_fdcb42dd44.jpg' WHERE mfr_sku='a181-213-280';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/1/csm_Ithaca_A183-007-Bay_East_738611332c.jpg' WHERE mfr_sku='a183-007-281';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/5/d/csm_Ithaca_A183-466-Butter_Rum_210551fc94.jpg' WHERE mfr_sku='a183-466-281';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/3/csm_Ithaca_A183-667-Earth_Tone_1b2f9ed02b.jpg' WHERE mfr_sku='a183-667-281';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/f/csm_Matka_A187-012-Keshii_0aa570da9d.jpg' WHERE mfr_sku='a187-012-284';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/a/csm_Matka_A187-111-Patina_1db4f2a970.jpg' WHERE mfr_sku='a187-111-284';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/7/csm_Matka_A187-115-Arbor_79d8459bf6.jpg' WHERE mfr_sku='a187-115-284';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/b/csm_Aries_A188-722-Akoya_39ee4bb75b.jpg' WHERE mfr_sku='a188-722-285';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/0/csm_Miura_A189-058-Cirrus_7d7748ef6e.jpg' WHERE mfr_sku='a189-058-286';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/7/csm_Miura_A189-117-Flax_74f50c6d10.jpg' WHERE mfr_sku='a189-117-286';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/c/csm_Miura_A189-190-Fawn_26d20dcc14.jpg' WHERE mfr_sku='a189-190-286';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/4/csm_Yoki_A190-127-Toffee_4521db879d.jpg' WHERE mfr_sku='a190-127-287';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/a/csm_Yoki_A190-633-Etruscan_ae8f5f8933.jpg' WHERE mfr_sku='a190-633-287';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/5/csm_Ocean_Drive_A191-401-Espirit_198a3f2546.jpg' WHERE mfr_sku='a191-401-288';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/f/d/csm_Ocean_Drive_A191-502-Gatsby_70b042bd9f.jpg' WHERE mfr_sku='a191-502-288';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/9/csm_Ocean_Drive_A191-540-Mirage_86f0c5976e.jpg' WHERE mfr_sku='a191-540-288';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/0/csm_Capri_A192-588-Alloy_4ee5330738.jpg' WHERE mfr_sku='a192-588-289';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/f/e/csm_Caba_A194-610-Cayenne_f236d6e3d0.jpg' WHERE mfr_sku='a194-610-290';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/3/csm_Parallel_A195-502-Slate_40b8a637f7.jpg' WHERE mfr_sku='a195-502-291';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/4/csm_Astoria_A197-081-Silver_Leaf_d7124adaab.jpg' WHERE mfr_sku='a197-081-293';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/0/csm_Burnished_Silk_A198-458-Spiced_Cider_072c320c3d.jpg' WHERE mfr_sku='a198-458-294';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/d/csm_Burnished_Silk_A198-592-Noir_d81207b504.jpg' WHERE mfr_sku='a198-592-294';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/8/f/csm_Burnished_Silk_A198-763-Marigold_b16b270bbc.jpg' WHERE mfr_sku='a198-763-294';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/a/csm_Senza_A200-958-Signoria_Mylar_608272391f.jpg' WHERE mfr_sku='a200-958-296';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/c/csm_Navarre_A202-885-Thistle_5a759d0435.jpg' WHERE mfr_sku='a202-885-298';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/a/csm_Alegre_A203-571-Cadenza_bee4c40644.jpg' WHERE mfr_sku='a203-571-299';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/5/3/csm_Sterling_Heights_A207-501-Sun_Ray_d4765a1921.jpg' WHERE mfr_sku='a207-501-303';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/1/csm_Sterling_Heights_A207-899-Luceat_bf2093bfba.jpg' WHERE mfr_sku='a207-899-303';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/e/csm_Patina_Blocks_A208-379-Kyanite_0359f67e9f.jpg' WHERE mfr_sku='a208-379-304';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/d/csm_Patina_Blocks_A208-801-Brushed_Silver_bd899e3938.jpg' WHERE mfr_sku='a208-801-304';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/d/csm_Patina_Blocks_A208-890-Obsidian_989b8ffaba.jpg' WHERE mfr_sku='a208-890-304';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/a/csm_Oracle_A209-805-Macael_f57e9eb98e.jpg' WHERE mfr_sku='a209-805-305';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/0/9/csm_Oracle_A209-834-Cielo_73ee337b46.jpg' WHERE mfr_sku='a209-834-305';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/1/csm_Ossian_A210-347-Pelagic_5032bf1f92.jpg' WHERE mfr_sku='a210-347-306';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/6/csm_Ossian_A210-502-Lightwave_54a9e0b84d.jpg' WHERE mfr_sku='a210-502-306';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/f/4/csm_Ossian_A210-516-Argent_882d131523.jpg' WHERE mfr_sku='a210-516-306';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/9/csm_Bellevue_A211-175-Cherry_Wine_d941a8fe9d.jpg' WHERE mfr_sku='a211-175-307';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/8/7/csm_Bellevue_A211-310-Savvy_8d8755af0e.jpg' WHERE mfr_sku='a211-310-307';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/b/csm_Bellevue_A211-941-Upstream_2b7e01a256.jpg' WHERE mfr_sku='a211-941-307';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/f/csm_Isla_Grass_A213-302-Tahitian_b2fe949a80.jpg' WHERE mfr_sku='a213-302-309';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/a/csm_Isla_Grass_A213-838-Ceramic_54750be1b5.jpg' WHERE mfr_sku='a213-838-309';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/5/csm_Isla_Grass_A213-879-Nocturnal_4dc2047684.jpg' WHERE mfr_sku='a213-879-309';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/0/f/csm_Alameda_A214-196-Snug_9c4744b242.jpg' WHERE mfr_sku='a214-196-310';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/3/csm_Alameda_A214-380-Hideaway_2f71bbdddf.jpg' WHERE mfr_sku='a214-380-310';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/7/csm_Alameda_A214-863-Bedrock_da640c986e.jpg' WHERE mfr_sku='a214-863-310';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/f/csm_Secret_Garden_A215-146-Heavy_Cream_ac92823bd3.jpg' WHERE mfr_sku='a215-146-311';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/1/csm_Secret_Garden_A215-896-Overcast_fff755e777.jpg' WHERE mfr_sku='a215-896-311';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/b/csm_Ascoli_A216-710-Aurum_Mylar_a91c0b9028.jpg' WHERE mfr_sku='a216-710-312';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/7/csm_Brenn_A222-039-Limewash_4397ed618a.jpg' WHERE mfr_sku='a222-039';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/5/csm_Brenn_A222-317-Inkroot_5c3edb7bdf.jpg' WHERE mfr_sku='a222-317';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/2/csm_Sakai_A95-556-Silver_Point_46aab2138b.jpg' WHERE mfr_sku='a95-556-316';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/a/csm_Loma_ABS03-758-Cabana_a5ce177e1f.jpg' WHERE mfr_sku='abs03-758-38';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/6/b/csm_Loma_ABS03-849-Windflower_544852e58b.jpg' WHERE mfr_sku='abs03-849-38';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/9/5/csm_Zari_ABS04-819-Gold_Pavement_32e020ef45.jpg' WHERE mfr_sku='abs04-819-39';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/0/7/csm_Zari_ABS04-879-Pewter_ecf4c0af16.jpg' WHERE mfr_sku='abs04-879-39';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/c/csm_Tanglewood_ABS07-346-Hemlock_a757f7220f.jpg' WHERE mfr_sku='abs07-346-42';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/5/csm_Tanglewood_ABS07-883-Charwood_59082ef0b2.jpg' WHERE mfr_sku='abs07-883-42';
UPDATE versa_catalog SET image_url='fileadmin/_processed_/3/8/csm_Vallejo_ASL-141_ASL_141_Room_Image_Install_98ed062ff3.jpg' WHERE mfr_sku='asl-141852-322';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/d/6/csm_Terra_AVF01-025-Ice_Blink_PVC-free_df75398070.jpg' WHERE mfr_sku='avf01-025-70';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/b/csm_Terra_AVF01-216-Water_Sky_PVC-free_f2435a1c16.jpg' WHERE mfr_sku='avf01-216-70';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/f/csm_Terra_AVF01-591-Rolling_Hills_PVC-free_7b11c56e25.jpg' WHERE mfr_sku='avf01-591-70';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/5/csm_Cape_Town_AVF02-590-Acorn_Street_PVC-free_cc37c4026e.jpg' WHERE mfr_sku='avf02-590-71';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/9/csm_Verda_AVF03-874-Frost_PVC-free_7010717e19.jpg' WHERE mfr_sku='avf03-874-72';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/7/csm_Tesoro_AVF04-857-Cinder_PVC-free_e92adb127e.jpg' WHERE mfr_sku='avf04-857-73';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/2/csm_High_Plains_AVF06-500-Rock_Crystal_PVC-free_1e0297a3be.jpg' WHERE mfr_sku='avf06-500-75';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/f/2/csm_High_Plains_AVF06-773-Honey_Mist_PVC-free_97ac245014.jpg' WHERE mfr_sku='avf06-773-75';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/0/csm_Mirelli_AVF07-188-Basswood_PVC-free_b43ad87ba5.jpg' WHERE mfr_sku='avf07-188-76';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/8/csm_Mirelli_AVF07-330-Ocean_Abyss_PVC-free_1178b4350f.jpg' WHERE mfr_sku='avf07-330-76';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/0/a/csm_Lino_AVF10-827-French_Grey_PVC-free_b3085abebe.jpg' WHERE mfr_sku='avf10-827-78';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/8/5/csm_Lino_AVF10-859-Slate_PVC-free_2234f2eda9.jpg' WHERE mfr_sku='avf10-859-78';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/a/csm_Aspect_AVF13-898-Solar_Carve_PVC-free_b4b24d625a.jpg' WHERE mfr_sku='avf13-898-81';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/b/b/csm_Barege_Texture_AVF14-295-Aveyron_4964116122.jpg' WHERE mfr_sku='avf14-295-82';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/4/7/csm_Barege_Texture_AVF14-885-Granite_34e7e3b946.jpg' WHERE mfr_sku='avf14-885-82';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/8/3/csm_Linden_AVF16-325-Mist_PVC-free_15f03f9a6c.jpg' WHERE mfr_sku='avf16-325-84';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/8/csm_Via_Monte_AVF17-218-Ravine_PVC-free_f2c68d1ad5.jpg' WHERE mfr_sku='avf17-218-85';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/4/csm_Via_Monte_AVF17-772-Halogen_PVC-free_6f52b89792.jpg' WHERE mfr_sku='avf17-772-85';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/7/4/csm_Sisley_AVF18-014-Verbena_PVC-free_09ec169b18.jpg' WHERE mfr_sku='avf18-014-86';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/5/6/csm_Sisley_AVF18-027-Aspen_PVC-free_9924aabd05.jpg' WHERE mfr_sku='avf18-027-86';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/d/csm_Englewood_AVF20-652-Chestnut_PVC-free_361914c71d.jpg' WHERE mfr_sku='avf20-652-87';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/c/8/csm_Haku_AVF21-271-Mystic_PVC-free_8e0a3a178b.jpg' WHERE mfr_sku='avf21-271-88';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/8/csm_Haku_AVF21-387-Serene_PVC-free_77f698bb68.jpg' WHERE mfr_sku='avf21-387-88';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/e/9/csm_Alsace_AVF23-426-Picturesque_PVC-free_2c98fa2cec.jpg' WHERE mfr_sku='avf23-426-89';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/8/8/csm_Alsace_AVF23-637-Fa%C3%A7ade_PVC-free_3b29ee1f73.jpg' WHERE mfr_sku='avf23-637-89';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/0/0/csm_Alsace_AVF23-898-Dark_Matter_PVC-free_28480389e9.jpg' WHERE mfr_sku='avf23-898-89';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/8/2/csm_Terramo_AVF24-341-Daybreak_PVC-free_e9c4aaf73e.jpg' WHERE mfr_sku='avf24-341-90';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/2/4/csm_Douro_AVF25-867-Up_The_Road_PVC-free_b93e59003e.jpg' WHERE mfr_sku='avf25-867-91';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/a/e/csm_Lenox_AVF26-029-Chiffon_PVC-free_7089e19f14.jpg' WHERE mfr_sku='avf26-029-92';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/3/0/csm_Lenox_AVF26-050-Street_Car_PVC-free_38e0695ea6.jpg' WHERE mfr_sku='avf26-050-92';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/5/a/csm_Lenox_AVF26-157-Tapestry_PVC-free_fe4b9290fa.jpg' WHERE mfr_sku='avf26-157-92';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/5/3/csm_Pallas_AVF27-179-Sediment_PVC-free_5d5b3d5e57.jpg' WHERE mfr_sku='avf27-179-93';
UPDATE versa_catalog SET image_url='https://www.versadesignedsurfaces.com/fileadmin/_processed_/f/c/csm_Kaolin_AVF29-801-Cinder_c6d9015627.jpg' WHERE mfr_sku='avf29-801';

-- verify BEFORE commit:
SELECT count(*) AS should_be_127 FROM versa_catalog v
  JOIN versa_catalog_imgfix_bak_20260904 b USING (mfr_sku)
  WHERE v.image_url IS DISTINCT FROM b.image_url;
COMMIT;