← back to Harlequin Sample Price Analysis

artifacts/job2-snapshots/apply.sql

101 lines

UPDATE shopify_products SET cost_price=134.40, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100002' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=94.50, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100033' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=94.50, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100034' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=99.50, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100040' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=181.65, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100042' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=75.55, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100273' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=102.85, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100276' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=102.85, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100279' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=102.85, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100280' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=102.85, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100281' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=102.85, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100283' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=102.85, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100284' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=102.85, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100285' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=102.85, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100288' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=102.85, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100291' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=102.85, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100297' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=181.65, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100304' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=186.90, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100309' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=203.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100314' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=153.30, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100318' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=204.75, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100319' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=242.55, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100330' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=192.15, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100364' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=192.15, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100368' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=192.15, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100369' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=192.15, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100370' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=192.15, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100371' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=192.15, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100375' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=207.90, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100378' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=207.90, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100379' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=232.05, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100384' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100523' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=181.65, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100529' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=270.90, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100530' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=270.90, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100534' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=270.90, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100535' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=160.65, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100539' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=253.05, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100549' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=253.05, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100551' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=261.45, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100553' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=207.90, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100570' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=134.40, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100580' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=134.40, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100581' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=118.65, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100591' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=118.65, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100592' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=118.65, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100594' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=207.90, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100600' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=206.85, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100607' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=207.90, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100608' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=169.05, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100614' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=131.25, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100616' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=131.25, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100622' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=226.80, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100627' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=226.80, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100629' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=181.65, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100635' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=208.95, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100645' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=208.95, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100646' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=207.90, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100653' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=244.65, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100657' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=267.75, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100664' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=243.60, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100665' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=179.55, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100672' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=160.65, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100674' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=160.65, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100675' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=152.25, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100679' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=150.15, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100688' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=152.25, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100690' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=261.45, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100704' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=207.90, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100709' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=242.55, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100711' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=204.75, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100714' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=268.80, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100718' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=481.95, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100735' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=200.55, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100739' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=200.55, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100740' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=193.20, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100744' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=192.15, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100755' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=192.15, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100757' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=278.25, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100758' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=278.25, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100759' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100852' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100853' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100854' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100857' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100859' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100864' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100883' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100888' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100892' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100893' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100896' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100909' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100913' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100916' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100921' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100929' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100937' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=140.70, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-100941' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=60.85, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-102153' AND (cost_price IS NULL OR cost_price=0);
UPDATE shopify_products SET cost_price=74.50, cost_source='kravet_catalog.price_trade (TK-10981)' WHERE sku='DWKK-102270' AND (cost_price IS NULL OR cost_price=0);