← back to Sanderson Onboard

pilot/backfill_price_retail.sql

735 lines

begin;
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='palla-bamboo-haw0285-05';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='ankara-meadow-awakening-haw0230-03';
update harlequin_catalog set price_retail=295.02, updated_at=now() where mfr_sku='matupi-gilver-ebony-haw0227-02';
update harlequin_catalog set price_retail=295.02, updated_at=now() where mfr_sku='matupi-parchment-gold-haw0227-01';
update harlequin_catalog set price_retail=671.49, updated_at=now() where mfr_sku='above-and-below-marine-life-haw0194-01';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='acropora-brazilian-rosewood-nectar-tree-canopy-haw0219-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='arcus-oyster-haw0277-04';
update harlequin_catalog set price_retail=320.36, updated_at=now() where mfr_sku='melora-brazilian-rosewood-ink-amazonia-haw0228-02';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='acropora-exhale-murmuration-haw0219-02';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='adderstone-limestone-haw0293-02';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='adderstone-pacific-haw0293-01';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='adderstone-terracotta-haw0293-03';
update harlequin_catalog set price_retail=199.1, updated_at=now() where mfr_sku='affinity-cerise-teal-haw0133-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='arcus-sky-haw0277-03';
update harlequin_catalog set price_retail=199.1, updated_at=now() where mfr_sku='affinity-marine-zest-haw0133-03';
update harlequin_catalog set price_retail=199.1, updated_at=now() where mfr_sku='affinity-ochre-steel-haw0133-04';
update harlequin_catalog set price_retail=199.1, updated_at=now() where mfr_sku='affinity-rust-sky-haw0133-02';
update harlequin_catalog set price_retail=199.1, updated_at=now() where mfr_sku='affinity-sky-ochre-haw0133-07';
update harlequin_catalog set price_retail=199.1, updated_at=now() where mfr_sku='affinity-slate-chalk-haw0133-05';
update harlequin_catalog set price_retail=199.1, updated_at=now() where mfr_sku='affinity-teal-litchen-haw0133-06';
update harlequin_catalog set price_retail=854.3, updated_at=now() where mfr_sku='air-golden-light-haw0258-01';
update harlequin_catalog set price_retail=854.3, updated_at=now() where mfr_sku='air-sky-blue-haw0258-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='akoa-platinum-haw0024-01';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='all-about-me-best-of-friends-haw0016-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='amazilia-bronze-haw0045-06';
update harlequin_catalog set price_retail=264.25, updated_at=now() where mfr_sku='amazilia-french-grey-stone-haw0220-02';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='amazilia-gooseberry-haw0045-04';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='amazilia-indigo-haw0045-02';
update harlequin_catalog set price_retail=264.25, updated_at=now() where mfr_sku='amazilia-powder-pearl-haw0220-03';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='amazilia-silver-haw0045-05';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='amazilia-sky-haw0045-03';
update harlequin_catalog set price_retail=264.25, updated_at=now() where mfr_sku='amazilia-stone-gold-haw0220-04';
update harlequin_catalog set price_retail=264.25, updated_at=now() where mfr_sku='amazilia-teal-gold-haw0220-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='amborella-jute-haw0063-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='amborella-pebble-haw0063-02';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='amborella-seaglass-haw0063-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='amity-brass-pewter-haw0126-06';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='amity-linen-chalk-haw0126-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='amity-pewter-brass-haw0126-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='amity-rosegold-pearl-haw0126-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='amity-silver-chalk-haw0126-05';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='amity-slate-putty-haw0126-03';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='ananda-blush-haw0177-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='ananda-gold-haw0177-03';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='ananda-pearl-haw0177-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='ananda-platinum-haw0177-04';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='ananda-topaz-haw0176-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='ankara-sail-cloth-diffused-light-haw0230-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='ankara-sky-awakening-haw0230-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='ankara-sunflower-awakening-haw0230-04';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='arccos-cerise-neptune-teal-haw0134-01';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='arccos-emerald-blush-haw0134-02';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='arccos-ochre-steel-haw0134-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='arcus-first-light-grounded-haw0277-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='arcus-grounded-haw0277-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='ardisia-amazonia-teal-gold-haw0221-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='ardisia-positano-sailcloth-gold-haw0221-04';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='ardisia-soft-focus-oyster-gold-haw0221-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='ardisia-succulent-soft-focus-gold-haw0221-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='asuka-gold-onyx-haw0038-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='atoll-awakening-diffused-light-haw0222-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='atoll-bronze-sailcloth-haw0222-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='atoll-seaglass-emerald-haw0222-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='aucuba-bronze-sediment-pearl-haw0211-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='aucuba-forest-copper-haw0211-04';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='aucuba-gold-rosewood-parchment-haw0211-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='aucuba-slate-bronze-topaz-haw0211-01';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='aurelia-french-grey-silver-haw0025-03';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='aurelia-pebble-stone-haw0025-04';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='aurelia-sapphire-haw0025-02';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='aurelia-white-gold-haw0025-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='axal-chalk-haw0135-04';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='axal-litchen-haw0135-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='axal-rust-haw0135-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='axal-slate-haw0135-03';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='azurea-champagne-haw0106-02';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='azurea-ebony-rose-gold-haw0106-03';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='balancing-act-blossom-raspberry-grape-haw0195-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='blenets-check-atlantic-chocolate-haw0294-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='blenets-check-chocolate-haw0294-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='blenets-check-matcha-haw0294-04';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='gigi-shell-haw0060-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='blenets-check-oatmeal-haw0294-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='blocks-black-earth-sketched-diffused-light-haw0248-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='blocks-cornflower-black-earth-sketched-haw0248-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='blocks-nectar-sketched-diffused-light-haw0248-01';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='bon-bon-gilver-duck-egg-denim-haw0196-02';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='bon-bon-raspberry-grape-blossom-haw0197-01';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='bon-bon-sky-gecko-ochre-haw0196-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='brocha-beechwood-lagoon-haw0327-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='brocha-blush-charcoal-haw0327-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='brocha-forest-azul-haw0327-03';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='capas-bleached-denim-haw0071-01';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='caprice-chalk-pearl-silver-haw0021-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='ceiba-azul-haw0328-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='ceiba-nectar-haw0328-03';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='ceiba-pine-haw0328-01';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='chaco-agate-haw0315-01';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='chaco-olivine-haw0315-04';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='chaco-porcelain-haw0315-02';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='chaco-sky-haw0315-03';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='chaco-slate-haw0315-05';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='chaconia-amber-slate-haw0095-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='chaconia-emerald-lime-haw0095-03';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='chronicle-cloud-haw0142-06';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='chronicle-denim-haw0142-04';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='chronicle-eggshell-haw0142-08';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='houndstooth-taupe-soft-focus-haw0289-03';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='chronicle-elephant-haw0142-10';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='chronicle-emerald-haw0142-05';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='chronicle-linen-haw0142-03';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='chronicle-mushroom-haw0142-09';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='chronicle-nude-haw0142-07';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='chronicle-sand-haw0142-01';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='chronicle-straw-haw0142-02';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='commix-breeze-haw0143-01';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='commix-seal-haw0143-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='connor-chocolate-dusk-haw0295-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='connor-glacier-pacific-haw0295-04';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='dahlia-bunch-rose-quartz-spinel-haw0267-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='connor-neptune-green-matcha-haw0295-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='connor-pacific-terracotta-haw0295-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='coppice-ebony-putty-snow-haw0156-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='coppice-navy-lagoon-gold-haw0163-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='coppice-oyster-ebony-gilver-haw0163-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='coppice-peacock-azalea-midnight-haw0159-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='coppice-powder-truffle-gilver-haw0163-03';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='cranes-in-flight-blush-haw0065-03';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='cranes-in-flight-emerald-haw0065-04';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='dahlia-bunch-lapis-haw0267-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='cranes-in-flight-platinum-haw0065-01';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='crater-limonite-haw0316-02';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='crater-sandstone-haw0316-03';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='crater-slate-haw0316-01';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='dahlia-blossom-emerald-new-beginnings-haw0231-01';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='dahlia-coral-fig-leaf-gilver-haw0231-03';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='dahlia-fig-blossom-nectar-black-earth-haw0231-04';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='dahlia-sail-cloth-meadow-gilver-haw0231-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='daisy-trellis-emerald-pearl-haw0268-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='daisy-trellis-lapis-pearl-haw0268-02';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='dance-of-adornment-wilderness-nectar-pomegranate-haw0223-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='dappled-leaf-citrine-haw0269-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='dappled-leaf-emerald-haw0269-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='dappled-leaf-emerald-teal-haw0269-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='dappled-leaf-rose-quartz-haw0269-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='dardanella-ink-chartreuse-haw0066-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='dardanella-linden-heather-haw0066-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='dawning-copenhagen-blue-ritual-haw0249-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='dawning-grounded-ritual-haw0249-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='dawning-mineral-awakening-haw0249-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='demoiselle-cornflower-first-light-honey-haw0067-09';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='demoiselle-graphite-almond-haw0067-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='demoiselle-ink-chartreuse-haw0067-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='demoiselle-jute-slate-haw0067-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='demoiselle-kelly-first-light-blush-haw0067-08';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='demoiselle-ochre-grape-haw0067-05';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='demoiselle-positano-first-light-taupe-haw0067-07';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='demoiselle-seaglass-first-light-sand-haw0067-10';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='demoiselle-shell-haw0067-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='distinct-flint-haw0082-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='distinct-murmuration-haw0278-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='distinct-steel-haw0082-04';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='dolmens-chalk-porcelain-haw0317-01';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='dolmens-onyx-limestone-haw0317-03';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='dolmens-sandstone-gold-haw0317-02';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='edenfield-atlantic-haw0296-03';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='edenfield-chocolate-haw0296-01';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='edenfield-limestone-haw0296-05';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='edenfield-matcha-haw0296-04';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='edenfield-neptune-green-haw0296-02';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='elements-stone-teal-haw0117-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='eglomise-gold-haw0028-05';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='eglomise-pearl-haw0028-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='eizou-avocado-sky-chalk-haw0302-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='eizou-silver-frost-chalk-haw0302-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='eizou-sky-indigo-chalk-haw0302-01';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='elements-pebble-shell-haw0117-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='elixity-chalk-haw0168-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='elixity-onyx-haw0168-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='elixity-pearl-haw0168-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='elixity-rose-quartz-haw0168-05';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='elixity-titanium-haw0168-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='ella-fig-blossom-fig-leaf-nectarine-haw0239-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='ella-powder-sage-peach-haw0239-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='ella-sky-fig-leaf-nectarine-haw0239-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='elliptic-charcoal-haw0169-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='elliptic-emerald-haw0169-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='elliptic-oyster-haw0169-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='elliptic-plum-haw0169-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='elsworthy-aegean-haw0297-03';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='elsworthy-chocolate-haw0297-04';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='elsworthy-dusk-haw0297-08';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='elsworthy-ink-haw0297-05';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='elsworthy-moss-haw0297-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='elsworthy-nectar-haw0297-07';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='elsworthy-neptune-green-haw0297-02';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='elsworthy-oatmeal-haw0297-06';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='formation-grounded-haw0281-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='eminence-graded-stripe-rose-gold-oyster-haw0111-01';
update harlequin_catalog set price_retail=843.44, updated_at=now() where mfr_sku='enigmatic-black-earth-first-light-haw0279-02';
update harlequin_catalog set price_retail=843.44, updated_at=now() where mfr_sku='enigmatic-japanese-ink-origami-haw0232-01';
update harlequin_catalog set price_retail=843.44, updated_at=now() where mfr_sku='enigmatic-nectar-awakening-haw0232-02';
update harlequin_catalog set price_retail=843.44, updated_at=now() where mfr_sku='enigmatic-oyster-first-light-haw0279-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='entity-teal-linden-haw0101-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='epitome-copper-gold-sepia-haw0076-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='epitome-gilver-silver-chalk-haw0076-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='epitome-mint-duckegg-smoke-haw0076-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='epitome-turquoise-pea-gilver-haw0076-04';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='eternal-oak-ebony-firstlight-haw0259-03';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='eternal-oak-incense-pearl-haw0259-01';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='eternal-oak-skyblue-firstlight-haw0259-02';
update harlequin_catalog set price_retail=396.38, updated_at=now() where mfr_sku='extravagance-nectar-haw0280-01';
update harlequin_catalog set price_retail=396.38, updated_at=now() where mfr_sku='extravagance-paprika-haw0280-03';
update harlequin_catalog set price_retail=396.38, updated_at=now() where mfr_sku='extravagance-sky-haw0280-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='exuberance-coral-turquoise-haw0077-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='exuberance-heather-indigo-haw0077-04';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='fade-ink-bronze-haw0212-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='fade-slate-pearl-haw0212-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='fayola-celestial-firstlight-haw0260-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='fayola-clover-chalk-haw0260-04';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='fayola-figleaf-clover-haw0260-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='fayola-incense-firstlight-haw0260-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='fellcroft-champagne-haw0298-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='fellcroft-honeycombe-haw0298-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='fellcroft-neptune-green-haw0298-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='fellcroft-pacific-haw0298-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='fleur-de-joie-chalk-clover-honey-haw0287-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='fleur-de-joie-chalk-emerald-sky-haw0287-04';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='fleur-de-joie-french-blue-succulent-soft-focus-haw0287-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='fleur-de-joie-paprika-aqua-soft-focus-haw0287-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='floreale-tangerine-fuchsia-haw0078-03';
update harlequin_catalog set price_retail=981.0, updated_at=now() where mfr_sku='floreana-bleached-coral-succulent-fig-leaf-haw0224-01';
update harlequin_catalog set price_retail=981.0, updated_at=now() where mfr_sku='floreana-gilt-black-earth-tranquility-haw0224-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='formation-moonlight-haw0084-03';
update harlequin_catalog set price_retail=981.0, updated_at=now() where mfr_sku='florence-fig-blossom-apple-peony-haw0240-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='florence-oyster-haw0059-01';
update harlequin_catalog set price_retail=981.0, updated_at=now() where mfr_sku='florence-powder-china-blue-haw0240-02';
update harlequin_catalog set price_retail=981.0, updated_at=now() where mfr_sku='florence-sky-meadow-blossom-haw0240-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='florent-positano-maple-graphite-haw0261-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='florent-sailcloth-celestial-clay-haw0261-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='florent-seaglass-clover-rosehip-haw0261-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='florent-stone-tranquility-slate-haw0261-04';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='flores-clover-kelly-aqua-haw0288-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='formation-parchment-haw0281-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='flores-cornflower-first-light-denim-haw0288-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='flores-rosewood-baked-terracotta-haw0288-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='flourish-first-light-midsummers-eve-haw0250-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='flourish-first-light-nectar-haw0250-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='formation-pearl-haw0084-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='flourish-tree-canopy-silver-willow-haw0250-03';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='folia-wallpapers-110287-inga-haw0009-01';
update harlequin_catalog set price_retail=843.44, updated_at=now() where mfr_sku='foresta-baked-terracotta-cerulean-haw0262-02';
update harlequin_catalog set price_retail=843.44, updated_at=now() where mfr_sku='foresta-ethereal-parchment-haw0262-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='formation-cornflower-haw0281-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='foxley-fern-stone-haw0157-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='foxley-kingfisher-gold-haw0157-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='foxley-platinum-gold-haw0157-03';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='frescoes-charcoal-chalk-limestone-haw0318-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='frescoes-pumice-jasper-amber-haw0318-03';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='frescoes-sandstone-slate-granite-haw0318-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='frescoes-sapphire-kyanite-quartz-haw0318-04';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='funky-jungle-navy-haw0198-02';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='funky-jungle-stone-haw0198-01';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='garden-friends-poppy-ochre-leaf-haw0199-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='gardinum-chalk-wedgwood-gold-haw0023-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='gardinum-charcoal-flint-gilver-haw0023-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='gardinum-ivory-gold-haw0023-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='gardinum-seafoam-chalk-gold-haw0023-04';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='gigi-harbour-grey-haw0060-02';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='glyph-limonite-sunstone-haw0319-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='glyph-pumice-taupe-haw0319-03';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='glyph-sandstone-chalk-haw0319-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='gradiate-ebony-parchment-haw0213-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='gradiate-gold-slate-haw0213-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='gradiate-marble-oyster-haw0213-03';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='grounded-bakedterracotta-parchment-haw0263-04';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='grounded-blackearth-parchment-haw0263-02';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='grounded-celestial-awakening-haw0263-03';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='grounded-goldenlight-parchment-haw0263-01';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='hakone-graphite-haw0170-01';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='hakone-oyster-haw0170-02';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='hakone-titanium-haw0170-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='halfmoon-azurite-coral-haw0225-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='halfmoon-gilver-tranquility-haw0225-01';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='lacuna-stripe-paprika-haw0282-04';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='halfmoon-stillness-indigo-haw0225-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='hansha-buttermilk-sky-haw0304-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='hansha-kelly-lagoon-haw0303-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='hansha-paprika-teal-haw0304-02';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='hide-and-seek-linen-duck-egg-stone-haw0200-02';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='hide-and-seek-poppy-marine-ochre-haw0200-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='hide-basalt-haw0320-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='hide-pumice-haw0320-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='houndstooth-black-earth-soft-focus-haw0289-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='houndstooth-first-light-mist-haw0289-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='houndstooth-seaglass-soft-focus-haw0289-02';
update harlequin_catalog set price_retail=763.8, updated_at=now() where mfr_sku='in-the-woods-sky-emerald-carnelian-haw0270-01';
update harlequin_catalog set price_retail=924.89, updated_at=now() where mfr_sku='indienne-blush-forest-haw0329-05';
update harlequin_catalog set price_retail=924.89, updated_at=now() where mfr_sku='indienne-cornflower-pine-haw0329-03';
update harlequin_catalog set price_retail=924.89, updated_at=now() where mfr_sku='indienne-dove-nectar-haw0329-01';
update harlequin_catalog set price_retail=924.89, updated_at=now() where mfr_sku='indienne-emerald-citrine-haw0329-02';
update harlequin_catalog set price_retail=924.89, updated_at=now() where mfr_sku='indienne-indigo-birch-haw0329-04';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='into-the-meadow-duck-egg-haw0201-01';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='into-the-meadow-powder-haw0201-02';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='into-the-wild-midnight-jungle-haw0202-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='isabella-honey-porcelain-haw0241-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='isabella-porcelain-bamboo-haw0241-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='isabella-sky-porcelain-haw0241-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='iyanu-linen-blush-haw0118-03';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='iyanu-papaya-kiwi-haw0118-04';
update harlequin_catalog set price_retail=396.38, updated_at=now() where mfr_sku='journey-of-discovery-ionian-harissa-emerald-haw0251-01';
update harlequin_catalog set price_retail=396.38, updated_at=now() where mfr_sku='journey-of-discovery-wild-water-exhale-haw0251-02';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='just-keep-trucking-tomato-marine-gecko-haw0203-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='kalina-celestial-murmuration-awakening-haw0264-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='kalina-midnight-bakedterracotta-nectar-haw0264-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='lorenza-chalk-haw0180-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='kalina-parchment-forest-azalea-haw0264-02';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='kamanu-amber-slate-haw0097-03';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='kamanu-graphite-mustard-haw0097-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='kamanu-indigo-pebble-haw0097-04';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='kamanu-mandarin-fig-haw0097-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='kelapa-emerald-zest-haw0119-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='kelapa-lagoon-cerise-haw0119-01';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='kengai-blossom-chalk-haw0305-01';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='kengai-glint-taupe-haw0305-04';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='kengai-pearl-parchment-haw0305-02';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='kengai-sky-chalk-haw0305-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='kienze-bronze-graphite-haw0137-04';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='kienze-graphite-gilver-haw0137-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='kienze-marine-zest-haw0137-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='kienze-ochre-steel-haw0137-02';
update harlequin_catalog set price_retail=320.36, updated_at=now() where mfr_sku='kimiko-bottle-green-chartreuse-haw0252-01';
update harlequin_catalog set price_retail=320.36, updated_at=now() where mfr_sku='kimiko-japanese-ink-copper-haw0252-03';
update harlequin_catalog set price_retail=320.36, updated_at=now() where mfr_sku='kimiko-majorelle-clementine-haw0252-04';
update harlequin_catalog set price_retail=320.36, updated_at=now() where mfr_sku='kimiko-soft-focus-harissa-haw0252-02';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='kimono-clay-graphite-haw0306-03';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='kimono-lilac-periwinkle-haw0306-01';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='kimono-seaglass-evergreen-haw0306-04';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='kimono-sky-indigo-haw0306-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='kinabalu-linen-haw0120-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='koi-indigo-haw0040-03';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='koi-metal-haw0040-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='koi-paprika-haw0040-04';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='koi-saffron-haw0040-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='komovi-azalea-gilver-haw0160-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='komovi-dove-linen-haw0160-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='komovi-lagoon-gold-haw0160-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='komovi-midnight-gold-haw0160-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='kumo-wild-water-exhale-haw0253-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='kumo-wilderness-forest-haw0253-01';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='kuparr-burgundy-heather-haw0330-02';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='kuparr-evergreen-terracotta-haw0330-01';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='lacuna-stripe-bamboo-haw0282-01';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='lacuna-stripe-camel-haw0282-02';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='lacuna-stripe-cornflower-haw0282-05';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='lacuna-stripe-linen-haw0282-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='lady-alford-apple-magenta-haw0242-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='lady-alford-fig-blossom-magenta-haw0242-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='lady-alford-porcelain-china-blue-haw0242-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='lady-alford-sky-magenta-haw0242-04';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='lamina-ink-marine-haw0171-02';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='lamina-onyx-bronze-haw0171-03';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='lamina-titanium-oyster-haw0171-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='leaf-chalk-silver-haw0012-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='leaf-sky-gilver-haw0012-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='leaf-slate-silver-haw0012-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='lengau-oyster-haw0178-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='lengau-slate-haw0178-02';
update harlequin_catalog set price_retail=671.49, updated_at=now() where mfr_sku='lifes-a-circus-carousel-haw0204-01';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='limosa-indigo-mustard-stone-haw0052-03';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='limosa-loganberry-raspberry-olive-haw0052-04';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='lint-dove-haw0145-03';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='lint-maize-haw0145-02';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='lint-nickle-haw0145-04';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='lint-nude-haw0145-07';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='lint-rust-haw0145-08';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='lint-seaglass-haw0145-05';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='lint-sesame-haw0145-01';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='lint-stone-haw0145-06';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='lisle-carbon-haw0146-03';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='lisle-driftwood-haw0146-01';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='lisle-linen-haw0146-05';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='lisle-pummice-haw0146-02';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='lisle-shale-haw0146-04';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='little-hearts-linen-haw0205-02';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='little-hearts-powder-haw0205-01';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='little-owls-kiwi-haw0206-01';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='little-owls-powder-haw0206-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='llenya-blush-harbour-gold-haw0179-04';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='llenya-honey-jet-jute-haw0179-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='llenya-ink-coral-seaglass-haw0179-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='llenya-jet-stone-gold-haw0179-05';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='llenya-lime-jade-pebble-haw0179-03';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='loam-evergreen-haw0321-01';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='loam-kyanite-haw0321-03';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='loam-sandstone-haw0321-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='lorenza-oyster-haw0180-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='lorenza-pewter-haw0180-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='lorenza-platinum-haw0180-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='lotus-indigo-haw0042-05';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='lotus-ivory-gilver-haw0226-02';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='lotus-mustard-haw0042-03';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='lotus-onyx-silver-haw0226-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='lotus-pearl-haw0042-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='lotus-rose-gold-haw0042-02';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='lotus-silver-haw0042-04';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='louella-rose-quartz-pearl-haw0128-02';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='louella-seaglass-pearl-haw0128-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='lucielle-chalk-linen-haw0130-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='lucielle-linen-silver-haw0130-03';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='lucielle-putty-chalk-haw0130-02';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='ludaix-fossil-haw0299-03';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='ludaix-matcha-haw0299-02';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='ludaix-oatmeal-haw0299-04';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='ludaix-pacific-haw0299-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='luminance-bronze-haw0214-02';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='luminance-sediment-haw0214-03';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='luminance-slate-haw0214-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='lustica-powder-haw0161-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='lustica-raffia-haw0161-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='lustica-russett-haw0161-05';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='lustica-saffron-haw0161-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='lustica-stone-haw0161-03';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='lustre-amazonite-rose-quartz-haw0085-04';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='lustre-apatite-hessonite-haw0085-03';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='lustre-pyrite-aurelian-haw0085-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='lustre-topaz-argent-haw0085-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='malachite-gold-haw0283-04';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='makalu-moonlight-haw0086-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='makrana-emerald-haw0043-05';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='makrana-moonstone-haw0043-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='makrana-rose-quartz-haw0043-04';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='makrana-smoke-haw0043-03';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='sticky-grass-emerald-haw0272-03';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='mala-azalea-haw0162-04';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='mala-citrus-haw0162-01';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='mala-ebony-haw0162-05';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='mala-ochre-haw0162-02';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='mala-slate-haw0162-03';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='sumi-dove-white-haw0229-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='malachite-incense-haw0283-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='malachite-japanese-ink-haw0283-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='malachite-sky-haw0283-03';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='mansa-avocado-haw0307-01';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='mansa-dove-haw0147-03';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='mansa-nude-haw0147-05';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='mansa-pebble-haw0147-04';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='mansa-rust-haw0307-02';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='mansa-sesame-haw0147-01';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='mansa-walnut-haw0147-02';
update harlequin_catalog set price_retail=747.51, updated_at=now() where mfr_sku='manzara-brazilian-rosewood-bleached-coral-haw0254-02';
update harlequin_catalog set price_retail=747.51, updated_at=now() where mfr_sku='manzara-wild-water-exhale-haw0254-01';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='marble-amber-haw0030-02';
update harlequin_catalog set price_retail=747.51, updated_at=now() where mfr_sku='marble-atlantic-haw0300-02';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='marble-awakening-oyster-champagne-haw0233-03';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='marble-azurite-copper-japanese-ink-haw0233-02';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='marble-incense-soft-focus-gold-haw0233-01';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='marble-midnight-haw0030-05';
update harlequin_catalog set price_retail=747.51, updated_at=now() where mfr_sku='marble-oatmeal-haw0300-01';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='marble-rose-quartz-haw0030-01';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='marble-sulphur-haw0030-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='mirabella-pebble-haw0062-03';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='marble-truffle-haw0030-04';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='marie-fig-leaf-honey-blossom-haw0243-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='marie-rose-lagoon-haw0243-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='marsha-aqua-peony-magenta-haw0244-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='marsha-powder-peony-magenta-haw0244-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='melodic-gold-black-earth-haw0234-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='melodic-gold-paper-lantern-haw0234-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='melodic-japanese-ink-origami-haw0234-04';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='melodic-stone-awakening-haw0234-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='melograno-celestial-fig-blossom-haw0255-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='melograno-forest-first-light-haw0255-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='melograno-gold-awakening-haw0255-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='melograno-gold-wild-water-haw0255-04';
update harlequin_catalog set price_retail=320.36, updated_at=now() where mfr_sku='melora-hempseed-exhale-gold-haw0228-03';
update harlequin_catalog set price_retail=320.36, updated_at=now() where mfr_sku='melora-positano-succulent-gold-haw0228-01';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='meso-champagne-haw0087-01';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='meso-dove-haw0087-03';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='meso-linen-haw0087-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='mirabella-sky-diffused-light-haw0062-04';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='metamorphic-alabaster-sandstone-haw0148-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='metamorphic-ash-carrara-haw0148-02';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='metamorphic-flint-temple-grey-haw0148-10';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='metamorphic-lapis-copper-haw0148-05';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='metamorphic-taupe-linen-haw0148-09';
update harlequin_catalog set price_retail=671.49, updated_at=now() where mfr_sku='miscanthus-buttermilk-sky-haw0308-01';
update harlequin_catalog set price_retail=671.49, updated_at=now() where mfr_sku='miscanthus-parchment-frost-haw0308-02';
update harlequin_catalog set price_retail=671.49, updated_at=now() where mfr_sku='miscanthus-sky-celestial-haw0308-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='mitende-ink-platinum-haw0181-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='mitende-jet-gold-haw0181-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='mitende-oyster-gold-haw0181-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='mitende-pebble-chalk-haw0181-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='mitende-pewter-chalk-haw0181-05';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='moho-agate-haw0322-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='moho-citrine-haw0322-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='nuvola-gold-shell-haw0054-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='moho-midnight-haw0322-03';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='moji-evergreen-straw-haw0309-02';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='moji-gold-honey-haw0309-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='moku-graphite-mustard-haw0099-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='moku-indigo-pebble-haw0099-02';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='moku-mineral-pebble-haw0099-04';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='moku-ocean-sand-haw0099-05';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='moku-ochre-seaspray-haw0099-03';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='mokume-indigo-haw0310-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='mokume-pumice-bronze-haw0310-03';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='mokume-sage-green-haw0310-02';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='mokume-taupe-gilver-haw0310-04';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='monolith-cinnabar-amber-haw0323-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='monolith-jade-kyanite-haw0323-05';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='nuvola-ink-mica-haw0054-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='monolith-jasper-zircon-haw0323-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='monolith-sapphire-limestone-haw0323-04';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='monolith-topaz-citrine-haw0323-03';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='nakuru-chalk-haw0182-05';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='nakuru-graphite-haw0182-04';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='nakuru-jute-haw0182-02';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='nakuru-oyster-haw0182-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='nakuru-seaglass-haw0182-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='nalina-peach-haw0053-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='nalina-pearl-haw0053-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='nellie-gilver-meadow-haw0245-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='nellie-honey-meadow-haw0245-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='nirmala-chalk-ebony-haw0183-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='nirmala-gilver-oyster-haw0183-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='nirmala-jet-chalk-haw0183-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='nirmala-platinum-chalk-haw0183-02';
update harlequin_catalog set price_retail=747.51, updated_at=now() where mfr_sku='onburu-canopy-diffused-light-haw0284-02';
update harlequin_catalog set price_retail=747.51, updated_at=now() where mfr_sku='onburu-rosewood-seaglass-haw0284-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='operetta-pebble-haw0069-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='operetta-slate-haw0069-02';
update harlequin_catalog set price_retail=199.1, updated_at=now() where mfr_sku='oralia-cupra-haw0074-03';
update harlequin_catalog set price_retail=199.1, updated_at=now() where mfr_sku='oralia-midnight-haw0074-05';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='orlena-rosegold-pearl-haw0132-02';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='oscillation-adriatic-sand-haw0215-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='oscillation-rosewood-fig-haw0215-02';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='oscillation-tobacco-slate-haw0215-03';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='out-of-this-world-solar-haw0207-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='paeonia-azurite-meadow-nectar-haw0235-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='paeonia-black-earth-fig-leaf-gold-haw0235-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='paisley-grounded-haw0331-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='paisley-indigo-haw0331-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='paisley-seaglass-haw0331-01';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='palla-blush-haw0285-03';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='palla-emerald-haw0285-01';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='palla-french-blue-haw0285-02';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='palla-linen-haw0285-04';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='palla-ochre-paprika-haw0285-06';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='palla-rosewood-seaglass-haw0285-07';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='papilio-flamingo-papaya-olive-haw0055-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='papyrus-parchment-paprika-haw0311-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='papyrus-seaglass-emerald-haw0311-03';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='papyrus-sky-indigo-haw0311-02';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='parapet-biscotte-haw0150-01';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='parapet-dove-haw0150-03';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='parapet-emerald-haw0150-05';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='parapet-graphite-haw0150-06';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='parapet-indigo-haw0150-04';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='parapet-pebble-haw0150-02';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='parapet-rose-haw0150-07';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='parapet-slate-haw0150-08';
update harlequin_catalog set price_retail=345.7, updated_at=now() where mfr_sku='peninsula-palm-truffle-haw0031-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='perception-black-earth-gilver-new-beginnings-haw0236-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='perception-brazilian-rosewood-temple-grey-new-beginnings-haw0236-01';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='perlite-opal-gold-mineral-haw0151-06';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='perpetua-breeze-haw0152-03';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='perpetua-dove-haw0152-02';
update harlequin_catalog set price_retail=249.77, updated_at=now() where mfr_sku='perpetua-maize-haw0152-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='persico-coral-lemon-haw0079-03';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='persico-neutral-chalk-haw0079-01';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='persico-tangerine-duckegg-haw0079-02';
update harlequin_catalog set price_retail=253.39, updated_at=now() where mfr_sku='persico-turquoise-navy-haw0079-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='salinas-ice-linen-dijon-haw0164-02';
update harlequin_catalog set price_retail=763.8, updated_at=now() where mfr_sku='pintura-majorelle-spice-forest-haw0332-01';
update harlequin_catalog set price_retail=570.14, updated_at=now() where mfr_sku='quintessence-lagoon-cerise-haw0122-01';
update harlequin_catalog set price_retail=570.14, updated_at=now() where mfr_sku='quintessence-ochre-olive-heather-haw0080-01';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='rainbow-brights-cherry-blossom-pineapple-sky-haw0208-01';
update harlequin_catalog set price_retail=924.89, updated_at=now() where mfr_sku='reflected-obsidian-azurite-haw0237-01';
update harlequin_catalog set price_retail=924.89, updated_at=now() where mfr_sku='reflected-obsidian-snowflake-haw0237-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='ric-rac-lapis-haw0271-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='ric-rac-rose-quartz-haw0271-02';
update harlequin_catalog set price_retail=924.89, updated_at=now() where mfr_sku='rosa-blush-pearl-peony-meadow-haw0246-01';
update harlequin_catalog set price_retail=924.89, updated_at=now() where mfr_sku='rosa-feather-grey-paper-lantern-oyster-haw0246-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='salice-heather-gilver-haw0081-05';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='salice-mint-emerald-haw0081-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='salice-ochre-sepia-haw0081-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='salinas-limestone-blush-fern-haw0164-05';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='salice-rose-navy-haw0081-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='salice-tangerine-gilver-haw0081-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='salinas-champagne-rose-gold-haw0164-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='salinas-cloud-blossom-gold-haw0164-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='salinas-ebony-coral-lagoon-haw0164-03';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='sticky-grass-carnelian-haw0272-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='salon-ebony-azalea-fern-haw0165-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='salon-gold-russett-atlantic-haw0165-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='salon-platinum-peacock-seafoam-haw0165-01';
update harlequin_catalog set price_retail=763.8, updated_at=now() where mfr_sku='saltillo-grounded-succulent-haze-haw0333-01';
update harlequin_catalog set price_retail=763.8, updated_at=now() where mfr_sku='saltillo-midnight-burnt-umber-azure-haw0333-02';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='sanguine-pomegranate-clemantine-peony-blueberry-haw0238-01';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='sanguine-succulent-seaglass-nectar-sail-cloth-haw0238-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='saona-coral-silver-haw0123-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='saona-kiwi-charcoal-haw0123-02';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='sebal-earth-silver-haw0166-01';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='sebal-glacier-silver-haw0158-02';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='sebal-platinum-ebony-haw0158-01';
update harlequin_catalog set price_retail=843.44, updated_at=now() where mfr_sku='sedimentary-evergreen-haw0324-02';
update harlequin_catalog set price_retail=843.44, updated_at=now() where mfr_sku='sedimentary-midnight-haw0324-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='seduire-oyster-pearl-haw0112-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='selo-ebony-gold-haw0167-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='selo-gold-platinum-haw0167-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='selo-slate-platinum-haw0167-02';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='sequence-bronze-haw0216-02';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='sequence-sediment-haw0216-03';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='sequence-slate-haw0216-01';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='seri-amber-haw0033-01';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='seri-jet-haw0033-02';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='seri-midnight-haw0033-08';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='seri-mineral-haw0033-07';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='seri-parchment-haw0033-05';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='seri-pebble-mist-haw0033-09';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='seri-raffia-haw0033-04';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='seri-slate-haw0033-06';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='seri-truffle-haw0033-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='series-ebony-haw0217-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='series-forest-copper-haw0217-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='series-oyster-haw0217-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='series-saffron-haw0217-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='shamwari-chalk-gold-haw0184-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='shamwari-chalk-slate-haw0184-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='shiruku-wild-water-azu-haw0256-02';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='skies-above-duck-egg-linen-haw0209-01';
update harlequin_catalog set price_retail=371.04, updated_at=now() where mfr_sku='skiva-linen-haw0286-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='soboku-buttermilk-chalk-haw0312-02';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='soboku-oyster-gold-haw0312-01';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='soboku-sky-chalk-haw0312-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='southborough-chocolate-haw0301-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='southborough-matcha-haw0301-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='southborough-rose-haw0301-02';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='spectro-stripe-emerald-marine-haw0138-02';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='spectro-stripe-litchen-graphite-haw0138-03';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='spectro-stripe-steel-blush-haw0138-04';
update harlequin_catalog set price_retail=275.11, updated_at=now() where mfr_sku='spectro-stripe-teal-sedona-rust-haw0138-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='spiralis-ochre-turquoise-forest-haw0334-01';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='sticky-grass-aquamarine-haw0272-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='sumi-hessian-copper-haw0044-03';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='sumi-ivory-mustard-haw0044-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='sumi-linen-copper-haw0229-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='sumi-linen-indigo-haw0044-05';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='sumi-linen-onyx-haw0044-04';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='sumi-oyster-gilver-haw0229-04';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='sumi-pearl-charcoal-haw0229-03';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='sumi-pebble-chalk-haw0044-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='sumi-shimmer-linen-stone-haw0092-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='sunstone-celestial-figleaf-nectar-haw0265-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='sunstone-positano-chocolate-pistachio-haw0265-01';
update harlequin_catalog set price_retail=238.91, updated_at=now() where mfr_sku='suzuri-bronze-haw0172-02';
update harlequin_catalog set price_retail=238.91, updated_at=now() where mfr_sku='suzuri-cayenne-haw0172-03';
update harlequin_catalog set price_retail=238.91, updated_at=now() where mfr_sku='suzuri-emerald-haw0172-05';
update harlequin_catalog set price_retail=238.91, updated_at=now() where mfr_sku='suzuri-ink-haw0172-06';
update harlequin_catalog set price_retail=238.91, updated_at=now() where mfr_sku='suzuri-onyx-haw0172-04';
update harlequin_catalog set price_retail=238.91, updated_at=now() where mfr_sku='suzuri-oyster-haw0172-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='tessellation-gilver-haw0139-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='tessellation-graphite-gold-haw0139-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='tessellation-marine-copper-haw0139-04';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='tessellation-slate-chalk-haw0139-05';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='tessellation-teal-gold-haw0139-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='tessen-bronze-haw0173-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='tessen-copper-haw0173-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='tessen-oyster-haw0173-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='tessen-titanium-haw0173-04';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='tidam-indigo-haw0335-01';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='tidam-pine-haw0335-02';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='tidam-terracotta-haw0335-04';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='tidam-turquoise-haw0335-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='toluca-forest-onyx-haw0336-04';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='toluca-moss-turquoise-haw0336-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='toluca-spice-azul-haw0336-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='toluca-stone-nectar-haw0336-03';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='transverse-bronze-haw0218-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='transverse-ink-haw0218-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='transverse-marble-haw0218-03';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='tule-limestone-haw0325-02';
update harlequin_catalog set price_retail=309.5, updated_at=now() where mfr_sku='tule-zircon-haw0325-01';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='valentina-blush-blossom-haw0247-01';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='valentina-exhale-ink-haw0247-02';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='what-a-hoot-wallpapers-70504-go-go-retro-haw0002-01';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='what-a-hoot-wallpapers-70515-what-a-hoot-haw0005-01';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='what-a-hoot-wallpapers-70525-jolly-jurassic-haw0003-01';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='what-a-hoot-wallpapers-70532-rush-haw0004-01';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='what-a-hoot-wallpapers-70536-rush-haw0004-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='wiggle-carnelian-rose-quartz-haw0273-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='wiggle-lapis-sky-haw0273-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='wiggle-peridot-rose-quartz-haw0273-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='wildflower-meadow-carnelian-spinel-pearl-haw0274-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='wildflower-meadow-emerald-amethyst-peridot-haw0274-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='wildflower-meadow-lapis-carnelian-aquamarine-haw0274-02';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='wonderland-floral-amethyst-lapis-ruby-haw0275-02';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='wonderland-floral-lapis-emerald-carnelian-haw0275-03';
update harlequin_catalog set price_retail=334.84, updated_at=now() where mfr_sku='wonderland-floral-spinel-peridot-pearl-haw0275-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='wood-blocks-walnut-gloss-haw0313-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='zamora-forest-haw0337-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='wood-frog-forest-chalk-haw0266-01';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='wood-frog-gold-parchment-haw0266-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='wood-frog-wildwater-chalk-haw0266-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='woodland-floral-jade-malachite-rose-quartz-haw0276-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='woodland-floral-lapis-amethyst-pearl-haw0276-03';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='woodland-floral-peridot-ruby-pearl-haw0276-01';
update harlequin_catalog set price_retail=168.33, updated_at=now() where mfr_sku='world-at-your-feet-pebble-blossom-sky-haw0210-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='yasuni-emerald-zest-haw0125-02';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='yasuni-lagoon-cerise-haw0125-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='yasuni-paprika-kiwi-haw0125-04';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='zamora-onyx-haw0337-01';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='zamora-parchment-haw0337-03';
update harlequin_catalog set price_retail=228.05, updated_at=now() where mfr_sku='zamora-seaglass-haw0337-04';
update harlequin_catalog set price_retail=238.91, updated_at=now() where mfr_sku='zela-bronze-haw0174-02';
update harlequin_catalog set price_retail=238.91, updated_at=now() where mfr_sku='zela-copper-haw0174-06';
update harlequin_catalog set price_retail=238.91, updated_at=now() where mfr_sku='zela-emerald-haw0174-07';
update harlequin_catalog set price_retail=238.91, updated_at=now() where mfr_sku='zela-ink-haw0174-01';
update harlequin_catalog set price_retail=238.91, updated_at=now() where mfr_sku='zela-oyster-haw0174-03';
update harlequin_catalog set price_retail=238.91, updated_at=now() where mfr_sku='zela-pearl-haw0174-04';
update harlequin_catalog set price_retail=238.91, updated_at=now() where mfr_sku='zela-titanium-haw0174-05';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='zenith-blush-forest-haw0338-02';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='zenith-pine-seaglass-haw0338-01';
update harlequin_catalog set price_retail=269.68, updated_at=now() where mfr_sku='zenith-terracotta-azul-haw0338-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='zori-awakening-cornflower-haw0257-02';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='zori-forest-first-light-haw0257-03';
update harlequin_catalog set price_retail=208.14, updated_at=now() where mfr_sku='zori-shiitake-fig-blossom-haw0257-01';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='zuni-aloe-haw0326-03';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='zuni-dawn-haw0326-02';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='zuni-midnight-haw0326-01';
update harlequin_catalog set price_retail=202.71, updated_at=now() where mfr_sku='zuni-pumice-haw0326-04';
commit;