[object Object]

← back to Harlequin Sample Price Analysis

auto-data-snapshot: 2026-08-31T02:00:54 (4 data files) — artifacts/job2-snapshots/apply.sql artifacts/job2-snapshots/prestate-kamatera.psv artifacts/job2-snapshots/prestate-local.psv artifacts/job2-snapshots/restore-map.json

6ce64083e049da5d739ab40ebd014c0a8e06c63b · 2026-08-31 02:03:27 -0700 · auto-commit-fleet

Files touched

Diff

commit 6ce64083e049da5d739ab40ebd014c0a8e06c63b
Author: auto-commit-fleet <steve@designerwallcoverings.com>
Date:   Mon Aug 31 02:03:27 2026 -0700

    auto-data-snapshot: 2026-08-31T02:00:54 (4 data files) — artifacts/job2-snapshots/apply.sql artifacts/job2-snapshots/prestate-kamatera.psv artifacts/job2-snapshots/prestate-local.psv artifacts/job2-snapshots/restore-map.json
---
 artifacts/job2-snapshots/apply.sql             | 100 ++++
 artifacts/job2-snapshots/prestate-kamatera.psv |  99 ++++
 artifacts/job2-snapshots/prestate-local.psv    | 100 ++++
 artifacts/job2-snapshots/restore-map.json      | 702 +++++++++++++++++++++++++
 4 files changed, 1001 insertions(+)

diff --git a/artifacts/job2-snapshots/apply.sql b/artifacts/job2-snapshots/apply.sql
new file mode 100644
index 0000000..0df5243
--- /dev/null
+++ b/artifacts/job2-snapshots/apply.sql
@@ -0,0 +1,100 @@
+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);
diff --git a/artifacts/job2-snapshots/prestate-kamatera.psv b/artifacts/job2-snapshots/prestate-kamatera.psv
new file mode 100644
index 0000000..c9a76d9
--- /dev/null
+++ b/artifacts/job2-snapshots/prestate-kamatera.psv
@@ -0,0 +1,99 @@
+DWKK-100608||
+DWKK-100607||
+DWKK-100896||
+DWKK-100888||
+DWKK-100384||
+DWKK-100551||
+DWKK-100581||
+DWKK-100653||
+DWKK-100718||
+DWKK-100758||
+DWKK-100852||
+DWKK-100883||
+DWKK-100893||
+DWKK-100892||
+DWKK-100909||
+DWKK-100913||
+DWKK-102270||
+DWKK-100757||
+DWKK-100755||
+DWKK-100280||
+DWKK-100378||
+DWKK-100034||
+DWKK-100744||
+DWKK-100281||
+DWKK-100283||
+DWKK-102153||
+DWKK-100679||
+DWKK-100580||
+DWKK-100534||
+DWKK-100622||
+DWKK-100941||
+DWKK-100370||
+DWKK-100759||
+DWKK-100690||
+DWKK-100688||
+DWKK-100646||
+DWKK-100704||
+DWKK-100530||
+DWKK-100371||
+DWKK-100664||
+DWKK-100309||
+DWKK-100297||
+DWKK-100614||
+DWKK-100937||
+DWKK-100318||
+DWKK-100319||
+DWKK-100553||
+DWKK-100549||
+DWKK-100921||
+DWKK-100929||
+DWKK-100635||
+DWKK-100714||
+DWKK-100627||
+DWKK-100916||
+DWKK-100330||
+DWKK-100364||
+DWKK-100864||
+DWKK-100859||
+DWKK-100853||
+DWKK-100539||
+DWKK-100535||
+DWKK-100279||
+DWKK-100304||
+DWKK-100273||
+DWKK-100033||
+DWKK-100040||
+DWKK-100594||
+DWKK-100854||
+DWKK-100857||
+DWKK-100291||
+DWKK-100657||
+DWKK-100616||
+DWKK-100369||
+DWKK-100368||
+DWKK-100592||
+DWKK-100591||
+DWKK-100600||
+DWKK-100379||
+DWKK-100288||
+DWKK-100523||
+DWKK-100529||
+DWKK-100042||
+DWKK-100629||
+DWKK-100674||
+DWKK-100675||
+DWKK-100570||
+DWKK-100735||
+DWKK-100375||
+DWKK-100276||
+DWKK-100285||
+DWKK-100672||
+DWKK-100739||
+DWKK-100740||
+DWKK-100314||
+DWKK-100709||
+DWKK-100711||
+DWKK-100645||
+DWKK-100284||
+DWKK-100002||
diff --git a/artifacts/job2-snapshots/prestate-local.psv b/artifacts/job2-snapshots/prestate-local.psv
new file mode 100644
index 0000000..749404a
--- /dev/null
+++ b/artifacts/job2-snapshots/prestate-local.psv
@@ -0,0 +1,100 @@
+DWKK-100364||
+DWKK-100551||
+DWKK-100304||
+DWKK-100580||
+DWKK-100581||
+DWKK-100759||
+DWKK-100539||
+DWKK-100896||
+DWKK-100664||
+DWKK-100892||
+DWKK-100033||
+DWKK-100739||
+DWKK-100913||
+DWKK-100042||
+DWKK-100314||
+DWKK-100570||
+DWKK-100319||
+DWKK-100330||
+DWKK-100368||
+DWKK-100369||
+DWKK-100600||
+DWKK-100378||
+DWKK-100384||
+DWKK-100635||
+DWKK-100688||
+DWKK-100690||
+DWKK-100852||
+DWKK-100530||
+DWKK-100535||
+DWKK-100549||
+DWKK-100280||
+DWKK-100281||
+DWKK-100283||
+DWKK-100288||
+DWKK-100291||
+DWKK-100297||
+DWKK-100309||
+DWKK-100853||
+DWKK-100859||
+DWKK-100883||
+DWKK-100937||
+DWKK-102270||
+DWKK-100002||
+DWKK-100273||
+DWKK-100370||
+DWKK-100371||
+DWKK-100276||
+DWKK-100284||
+DWKK-100375||
+DWKK-100608||
+DWKK-100523||
+DWKK-100529||
+DWKK-100614||
+DWKK-100627||
+DWKK-100591||
+DWKK-100646||
+DWKK-100592||
+DWKK-100594||
+DWKK-100607||
+DWKK-100709||
+DWKK-100665||
+DWKK-100714||
+DWKK-100718||
+DWKK-100674||
+DWKK-100675||
+DWKK-100893||
+DWKK-100744||
+DWKK-100909||
+DWKK-100916||
+DWKK-100929||
+DWKK-100854||
+DWKK-100864||
+DWKK-100888||
+DWKK-100318||
+DWKK-100279||
+DWKK-100657||
+DWKK-100711||
+DWKK-100735||
+DWKK-100757||
+DWKK-100857||
+DWKK-102153||
+DWKK-100629||
+DWKK-100921||
+DWKK-100285||
+DWKK-100379||
+DWKK-100653||
+DWKK-100553||
+DWKK-100034||
+DWKK-100672||
+DWKK-100679||
+DWKK-100645||
+DWKK-100534||
+DWKK-100740||
+DWKK-100704||
+DWKK-100040||
+DWKK-100616||
+DWKK-100622||
+DWKK-100755||
+DWKK-100758||
+DWKK-100941||
diff --git a/artifacts/job2-snapshots/restore-map.json b/artifacts/job2-snapshots/restore-map.json
new file mode 100644
index 0000000..9488725
--- /dev/null
+++ b/artifacts/job2-snapshots/restore-map.json
@@ -0,0 +1,702 @@
+[
+  {
+    "sku": "DWKK-100002",
+    "dw_sku": "DWKK-100002",
+    "new_cost": "134.40",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100033",
+    "dw_sku": "DWKK-100033",
+    "new_cost": "94.50",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100034",
+    "dw_sku": "DWKK-100034",
+    "new_cost": "94.50",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100040",
+    "dw_sku": "DWKK-100040",
+    "new_cost": "99.50",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100042",
+    "dw_sku": "DWKK-100042",
+    "new_cost": "181.65",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100273",
+    "dw_sku": "DWKK-100273",
+    "new_cost": "75.55",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100276",
+    "dw_sku": "DWKK-100276",
+    "new_cost": "102.85",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100279",
+    "dw_sku": "DWKK-100279",
+    "new_cost": "102.85",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100280",
+    "dw_sku": "DWKK-100280",
+    "new_cost": "102.85",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100281",
+    "dw_sku": "DWKK-100281",
+    "new_cost": "102.85",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100283",
+    "dw_sku": "DWKK-100283",
+    "new_cost": "102.85",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100284",
+    "dw_sku": "DWKK-100284",
+    "new_cost": "102.85",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100285",
+    "dw_sku": "DWKK-100285",
+    "new_cost": "102.85",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100288",
+    "dw_sku": "DWKK-100288",
+    "new_cost": "102.85",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100291",
+    "dw_sku": "DWKK-100291",
+    "new_cost": "102.85",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100297",
+    "dw_sku": "DWKK-100297",
+    "new_cost": "102.85",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100304",
+    "dw_sku": "DWKK-100304",
+    "new_cost": "181.65",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100309",
+    "dw_sku": "DWKK-100309",
+    "new_cost": "186.90",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100314",
+    "dw_sku": "DWKK-100314",
+    "new_cost": "203.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100318",
+    "dw_sku": "DWKK-100318",
+    "new_cost": "153.30",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100319",
+    "dw_sku": "DWKK-100319",
+    "new_cost": "204.75",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100330",
+    "dw_sku": "DWKK-100330",
+    "new_cost": "242.55",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100364",
+    "dw_sku": "DWKK-100364",
+    "new_cost": "192.15",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100368",
+    "dw_sku": "DWKK-100368",
+    "new_cost": "192.15",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100369",
+    "dw_sku": "DWKK-100369",
+    "new_cost": "192.15",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100370",
+    "dw_sku": "DWKK-100370",
+    "new_cost": "192.15",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100371",
+    "dw_sku": "DWKK-100371",
+    "new_cost": "192.15",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100375",
+    "dw_sku": "DWKK-100375",
+    "new_cost": "192.15",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100378",
+    "dw_sku": "DWKK-100378",
+    "new_cost": "207.90",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100379",
+    "dw_sku": "DWKK-100379",
+    "new_cost": "207.90",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100384",
+    "dw_sku": "DWKK-100384",
+    "new_cost": "232.05",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100523",
+    "dw_sku": "DWKK-100523",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100529",
+    "dw_sku": "DWKK-100529",
+    "new_cost": "181.65",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100530",
+    "dw_sku": "DWKK-100530",
+    "new_cost": "270.90",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100534",
+    "dw_sku": "DWKK-100534",
+    "new_cost": "270.90",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100535",
+    "dw_sku": "DWKK-100535",
+    "new_cost": "270.90",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100539",
+    "dw_sku": "DWKK-100539",
+    "new_cost": "160.65",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100549",
+    "dw_sku": "DWKK-100549",
+    "new_cost": "253.05",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100551",
+    "dw_sku": "DWKK-100551",
+    "new_cost": "253.05",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100553",
+    "dw_sku": "DWKK-100553",
+    "new_cost": "261.45",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100570",
+    "dw_sku": "DWKK-100570",
+    "new_cost": "207.90",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100580",
+    "dw_sku": "DWKK-100580",
+    "new_cost": "134.40",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100581",
+    "dw_sku": "DWKK-100581",
+    "new_cost": "134.40",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100591",
+    "dw_sku": "DWKK-100591",
+    "new_cost": "118.65",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100592",
+    "dw_sku": "DWKK-100592",
+    "new_cost": "118.65",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100594",
+    "dw_sku": "DWKK-100594",
+    "new_cost": "118.65",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100600",
+    "dw_sku": "DWKK-100600",
+    "new_cost": "207.90",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100607",
+    "dw_sku": "DWKK-100607",
+    "new_cost": "206.85",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100608",
+    "dw_sku": "DWKK-100608",
+    "new_cost": "207.90",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100614",
+    "dw_sku": "DWKK-100614",
+    "new_cost": "169.05",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100616",
+    "dw_sku": "DWKK-100616",
+    "new_cost": "131.25",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100622",
+    "dw_sku": "DWKK-100622",
+    "new_cost": "131.25",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100627",
+    "dw_sku": "DWKK-100627",
+    "new_cost": "226.80",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100629",
+    "dw_sku": "DWKK-100629",
+    "new_cost": "226.80",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100635",
+    "dw_sku": "DWKK-100635",
+    "new_cost": "181.65",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100645",
+    "dw_sku": "DWKK-100645",
+    "new_cost": "208.95",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100646",
+    "dw_sku": "DWKK-100646",
+    "new_cost": "208.95",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100653",
+    "dw_sku": "DWKK-100653",
+    "new_cost": "207.90",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100657",
+    "dw_sku": "DWKK-100657",
+    "new_cost": "244.65",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100664",
+    "dw_sku": "DWKK-100664",
+    "new_cost": "267.75",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100665",
+    "dw_sku": "DWKK-100665",
+    "new_cost": "243.60",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100672",
+    "dw_sku": "DWKK-100672",
+    "new_cost": "179.55",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100674",
+    "dw_sku": "DWKK-100674",
+    "new_cost": "160.65",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100675",
+    "dw_sku": "DWKK-100675",
+    "new_cost": "160.65",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100679",
+    "dw_sku": "DWKK-100679",
+    "new_cost": "152.25",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100688",
+    "dw_sku": "DWKK-100688",
+    "new_cost": "150.15",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100690",
+    "dw_sku": "DWKK-100690",
+    "new_cost": "152.25",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100704",
+    "dw_sku": "DWKK-100704",
+    "new_cost": "261.45",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100709",
+    "dw_sku": "DWKK-100709",
+    "new_cost": "207.90",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100711",
+    "dw_sku": "DWKK-100711",
+    "new_cost": "242.55",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100714",
+    "dw_sku": "DWKK-100714",
+    "new_cost": "204.75",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100718",
+    "dw_sku": "DWKK-100718",
+    "new_cost": "268.80",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100735",
+    "dw_sku": "DWKK-100735",
+    "new_cost": "481.95",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100739",
+    "dw_sku": "DWKK-100739",
+    "new_cost": "200.55",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100740",
+    "dw_sku": "DWKK-100740",
+    "new_cost": "200.55",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100744",
+    "dw_sku": "DWKK-100744",
+    "new_cost": "193.20",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100755",
+    "dw_sku": "DWKK-100755",
+    "new_cost": "192.15",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100757",
+    "dw_sku": "DWKK-100757",
+    "new_cost": "192.15",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100758",
+    "dw_sku": "DWKK-100758",
+    "new_cost": "278.25",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100759",
+    "dw_sku": "DWKK-100759",
+    "new_cost": "278.25",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100852",
+    "dw_sku": "DWKK-100852",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100853",
+    "dw_sku": "DWKK-100853",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100854",
+    "dw_sku": "DWKK-100854",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100857",
+    "dw_sku": "DWKK-100857",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100859",
+    "dw_sku": "DWKK-100859",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100864",
+    "dw_sku": "DWKK-100864",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100883",
+    "dw_sku": "DWKK-100883",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100888",
+    "dw_sku": "DWKK-100888",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100892",
+    "dw_sku": "DWKK-100892",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100893",
+    "dw_sku": "DWKK-100893",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100896",
+    "dw_sku": "DWKK-100896",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100909",
+    "dw_sku": "DWKK-100909",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100913",
+    "dw_sku": "DWKK-100913",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100916",
+    "dw_sku": "DWKK-100916",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100921",
+    "dw_sku": "DWKK-100921",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100929",
+    "dw_sku": "DWKK-100929",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100937",
+    "dw_sku": "DWKK-100937",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-100941",
+    "dw_sku": "DWKK-100941",
+    "new_cost": "140.70",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-102153",
+    "dw_sku": "DWKK-102153",
+    "new_cost": "60.85",
+    "old_cost": null,
+    "old_source": null
+  },
+  {
+    "sku": "DWKK-102270",
+    "dw_sku": "DWKK-102270",
+    "new_cost": "74.50",
+    "old_cost": null,
+    "old_source": null
+  }
+]
\ No newline at end of file

← 98be7db cycle 3: read-only verification — 25/25 green, cost-gap clos  ·  back to Harlequin Sample Price Analysis  ·  (newest)