← back to Designer Wallcoverings
auto-data-snapshot: 2026-09-15T13:40:09 (4 data files) — DW-Programming/ImportNewSkufromURL/database/create-batch-import-jobs.sql shopify/scripts/cadence/data/cadence-cursor.json shopify/scripts/cadence/data/cadence-plan-pm-2026-09-15.json shopify/scripts/cadence/data/upload-restore-2026-09-15.jsonl
f5352ea7df213e351ebd033f830ba31911a7b39d · 2026-09-15 13:41:58 -0700 · auto-commit-fleet
Files touched
M DW-Programming/ImportNewSkufromURL/database/create-batch-import-jobs.sqlM shopify/scripts/cadence/data/cadence-cursor.jsonM shopify/scripts/cadence/data/cadence-plan-pm-2026-09-15.jsonM shopify/scripts/cadence/data/upload-restore-2026-09-15.jsonl
Diff
commit f5352ea7df213e351ebd033f830ba31911a7b39d
Author: auto-commit-fleet <steve@designerwallcoverings.com>
Date: Tue Sep 15 13:41:58 2026 -0700
auto-data-snapshot: 2026-09-15T13:40:09 (4 data files) — DW-Programming/ImportNewSkufromURL/database/create-batch-import-jobs.sql shopify/scripts/cadence/data/cadence-cursor.json shopify/scripts/cadence/data/cadence-plan-pm-2026-09-15.json shopify/scripts/cadence/data/upload-restore-2026-09-15.jsonl
---
.../database/create-batch-import-jobs.sql | 16 +-
shopify/scripts/cadence/data/cadence-cursor.json | 2 +-
.../cadence/data/cadence-plan-pm-2026-09-15.json | 168 +++++++++------------
.../cadence/data/upload-restore-2026-09-15.jsonl | 10 ++
4 files changed, 94 insertions(+), 102 deletions(-)
diff --git a/DW-Programming/ImportNewSkufromURL/database/create-batch-import-jobs.sql b/DW-Programming/ImportNewSkufromURL/database/create-batch-import-jobs.sql
index e58f74e2..31cb24ac 100644
--- a/DW-Programming/ImportNewSkufromURL/database/create-batch-import-jobs.sql
+++ b/DW-Programming/ImportNewSkufromURL/database/create-batch-import-jobs.sql
@@ -33,5 +33,19 @@ CREATE TABLE IF NOT EXISTS batch_import_job_items (
);
CREATE INDEX IF NOT EXISTS idx_batch_import_job_items_job ON batch_import_job_items(job_id);
--- dedup lookup: "has this SKU already been created in ANY prior job?"
+-- observability lookup: per-item progress by SKU.
CREATE INDEX IF NOT EXISTS idx_batch_import_job_items_sku ON batch_import_job_items(sku) WHERE sku IS NOT NULL AND sku <> '';
+
+-- TK-11776 F2: atomic cross-job dedup ledger. A plain SELECT-then-create is a TOCTOU —
+-- two concurrent/overlapping jobs (or a re-submit of a batch that looks stuck while the
+-- first is still 'running') both read "not yet created" and both mint the SKU. PRIMARY
+-- KEY(sku) is the concurrency arbiter: claimSku() INSERTs here ON CONFLICT DO NOTHING, so
+-- exactly one racing caller wins the SKU and every other skips the Shopify create. A kept
+-- row is the durable dedup record for a successfully-created SKU; a retryable failure
+-- releases it, a hard crash leaves it (safely blocking a re-mint — never auto-mint a dup).
+CREATE TABLE IF NOT EXISTS batch_import_created_skus (
+ sku TEXT PRIMARY KEY,
+ job_id UUID,
+ idx INTEGER,
+ created_at TIMESTAMPTZ NOT NULL DEFAULT now()
+);
diff --git a/shopify/scripts/cadence/data/cadence-cursor.json b/shopify/scripts/cadence/data/cadence-cursor.json
index c6f41056..da6e754d 100644
--- a/shopify/scripts/cadence/data/cadence-cursor.json
+++ b/shopify/scripts/cadence/data/cadence-cursor.json
@@ -1,5 +1,5 @@
{
- "idx": 5,
+ "idx": 2,
"lastSlot": "pm",
"lastRun": "2026-09-15"
}
\ No newline at end of file
diff --git a/shopify/scripts/cadence/data/cadence-plan-pm-2026-09-15.json b/shopify/scripts/cadence/data/cadence-plan-pm-2026-09-15.json
index a15aed9e..01af2c38 100644
--- a/shopify/scripts/cadence/data/cadence-plan-pm-2026-09-15.json
+++ b/shopify/scripts/cadence/data/cadence-plan-pm-2026-09-15.json
@@ -1,4 +1,64 @@
[
+ {
+ "vendor": "Kravet",
+ "dw_sku": "DWKK-103473",
+ "cost": 98.45,
+ "retail": 147.68,
+ "sample": "4.25",
+ "sampleOnly": false,
+ "title": "Gaffey, Off-White Wallcoverings | Kravet",
+ "willActivate": false
+ },
+ {
+ "vendor": "Kravet",
+ "dw_sku": "DWKK-103474",
+ "cost": 98.45,
+ "retail": 147.68,
+ "sample": "4.25",
+ "sampleOnly": false,
+ "title": "Gaffey, Pale Blue Wallcoverings | Kravet",
+ "willActivate": false
+ },
+ {
+ "vendor": "Kravet",
+ "dw_sku": "DWKK-103475",
+ "cost": 98.45,
+ "retail": 147.68,
+ "sample": "4.25",
+ "sampleOnly": false,
+ "title": "Gaffey, Off-White Wallcoverings | Kravet",
+ "willActivate": false
+ },
+ {
+ "vendor": "Schumacher",
+ "dw_sku": "DWLK-811910",
+ "cost": 28,
+ "retail": 50.68,
+ "sample": "4.25",
+ "sampleOnly": false,
+ "title": "White Lotus, Cool Gray Wallcoverings | Schumacher",
+ "willActivate": false
+ },
+ {
+ "vendor": "Schumacher",
+ "dw_sku": "DWLK-811920",
+ "cost": 28,
+ "retail": 50.68,
+ "sample": "4.25",
+ "sampleOnly": false,
+ "title": "White Lotus, Light Yellow Wallcoverings | Schumacher",
+ "willActivate": false
+ },
+ {
+ "vendor": "Schumacher",
+ "dw_sku": "DWLK-811930",
+ "cost": 32,
+ "retail": 57.92,
+ "sample": "4.25",
+ "sampleOnly": false,
+ "title": "1975, Graphite Wallcoverings | Schumacher",
+ "willActivate": false
+ },
{
"vendor": "Pierre Frey",
"dw_sku": "FQ030001",
@@ -61,124 +121,32 @@
},
{
"vendor": "Osborne & Little",
- "dw_sku": "DWOL-290257",
- "cost": 147,
- "retail": 266.06,
+ "dw_sku": "DWOL-290276",
+ "cost": 200,
+ "retail": 361.99,
"sample": "4.25",
"sampleOnly": false,
- "title": "Chenar, Colorway 04 Wallcoverings | Osborne & Little",
+ "title": "Tessella, Colorway 03 Wallcoverings | Osborne & Little",
"willActivate": false
},
{
"vendor": "Osborne & Little",
- "dw_sku": "DWOL-290274",
+ "dw_sku": "DWOL-290277",
"cost": 200,
"retail": 361.99,
"sample": "4.25",
"sampleOnly": false,
- "title": "Tessella, Colorway 01 Wallcoverings | Osborne & Little",
+ "title": "Tessella, Colorway 04 Wallcoverings | Osborne & Little",
"willActivate": false
},
{
"vendor": "Osborne & Little",
- "dw_sku": "DWOL-290275",
+ "dw_sku": "DWOL-290278",
"cost": 200,
"retail": 361.99,
"sample": "4.25",
"sampleOnly": false,
- "title": "Tessella, Colorway 02 Wallcoverings | Osborne & Little",
- "willActivate": false
- },
- {
- "vendor": "Designtex",
- "dw_sku": "DWDX-220516",
- "cost": 58,
- "retail": 104.98,
- "sample": "4.25",
- "sampleOnly": false,
- "title": "Fragments, New York Wallcoverings | Designtex",
- "willActivate": false,
- "held": true,
- "heldReason": "\"York Wallcoverings\" is a banned front-facing trade-parent name"
- },
- {
- "vendor": "Designtex",
- "dw_sku": "DWDX-220821",
- "cost": 40,
- "retail": 72.4,
- "sample": "4.25",
- "sampleOnly": false,
- "title": "Corrugate, Pearl Wallcoverings | Designtex",
- "willActivate": false
- },
- {
- "vendor": "Designtex",
- "dw_sku": "DWDX-220822",
- "cost": 40,
- "retail": 72.4,
- "sample": "4.25",
- "sampleOnly": false,
- "title": "Corrugate, Stardust Wallcoverings | Designtex",
- "willActivate": false
- },
- {
- "vendor": "Newwall",
- "dw_sku": "DWXW-1006386",
- "cost": 104,
- "retail": 188.24,
- "sample": "4.25",
- "sampleOnly": false,
- "title": "Caleira Red, Made to Measure Mural Type II Wallcoverings | Newwall",
- "willActivate": false
- },
- {
- "vendor": "Newwall",
- "dw_sku": "DWXW-1006387",
- "cost": 104,
- "retail": 188.24,
- "sample": "4.25",
- "sampleOnly": false,
- "title": "Onda Pink, Made to Measure Mural Type II Wallcoverings | Newwall",
- "willActivate": false
- },
- {
- "vendor": "Newwall",
- "dw_sku": "DWXW-1006388",
- "cost": 104,
- "retail": 188.24,
- "sample": "4.25",
- "sampleOnly": false,
- "title": "Onda Green-Orange, Made to Measure Mural Type II Wallcoverings | Newwall",
- "willActivate": false
- },
- {
- "vendor": "Brewster & York",
- "dw_sku": "DWBR-171336",
- "cost": 45,
- "retail": 81.45,
- "sample": "4.25",
- "sampleOnly": false,
- "title": "Hennika, Blue Wallcoverings | Malibu Wallcovering",
- "willActivate": false
- },
- {
- "vendor": "Brewster & York",
- "dw_sku": "DWBR-171337",
- "cost": 90,
- "retail": 162.9,
- "sample": "4.25",
- "sampleOnly": false,
- "title": "Hennika, Light Pink Wallcoverings | Malibu Wallcovering",
- "willActivate": false
- },
- {
- "vendor": "Brewster & York",
- "dw_sku": "DWBR-171338",
- "cost": 90,
- "retail": 162.9,
- "sample": "4.25",
- "sampleOnly": false,
- "title": "Hennika, Multicolor Wallcoverings | Malibu Wallcovering",
+ "title": "Bark, Colorway 02 Wallcoverings | Osborne & Little",
"willActivate": false
}
]
\ No newline at end of file
diff --git a/shopify/scripts/cadence/data/upload-restore-2026-09-15.jsonl b/shopify/scripts/cadence/data/upload-restore-2026-09-15.jsonl
index 035ae397..bd8fb713 100644
--- a/shopify/scripts/cadence/data/upload-restore-2026-09-15.jsonl
+++ b/shopify/scripts/cadence/data/upload-restore-2026-09-15.jsonl
@@ -240,3 +240,13 @@
{"table":"brewster_catalog","mfr_sku":"2821-25113","dw_sku":"DWBR-171336","shopify_product_id":"7965317660723","action":"created","activated":false,"published":false,"sampleOnly":false,"status":"DRAFT","batch_id":"upload-pm-2026-09-15T19-40-00-926Z","ts":"2026-09-15T19:40:33.691Z"}
{"table":"brewster_catalog","mfr_sku":"2821-25115","dw_sku":"DWBR-171337","shopify_product_id":"7965317693491","action":"created","activated":false,"published":false,"sampleOnly":false,"status":"DRAFT","batch_id":"upload-pm-2026-09-15T19-40-00-926Z","ts":"2026-09-15T19:40:36.131Z"}
{"table":"brewster_catalog","mfr_sku":"2821-25114","dw_sku":"DWBR-171338","shopify_product_id":"7965317726259","action":"created","activated":false,"published":false,"sampleOnly":false,"status":"DRAFT","batch_id":"upload-pm-2026-09-15T19-40-00-926Z","ts":"2026-09-15T19:40:39.260Z"}
+{"table":"kravet_catalog","mfr_sku":"3950.11.0","dw_sku":"DWKK-103473","shopify_product_id":"7965442932787","action":"created","activated":false,"published":false,"sampleOnly":false,"status":"DRAFT","batch_id":"upload-pm-2026-09-15T20-40-06-316Z","ts":"2026-09-15T20:40:13.655Z"}
+{"table":"kravet_catalog","mfr_sku":"3950.13.0","dw_sku":"DWKK-103474","shopify_product_id":"7965442965555","action":"created","activated":false,"published":false,"sampleOnly":false,"status":"DRAFT","batch_id":"upload-pm-2026-09-15T20-40-06-316Z","ts":"2026-09-15T20:40:16.297Z"}
+{"table":"kravet_catalog","mfr_sku":"3950.15.0","dw_sku":"DWKK-103475","shopify_product_id":"7965442998323","action":"created","activated":false,"published":false,"sampleOnly":false,"status":"DRAFT","batch_id":"upload-pm-2026-09-15T20-40-06-316Z","ts":"2026-09-15T20:40:18.635Z"}
+{"table":"schumacher_catalog","mfr_sku":"5013667","dw_sku":"DWLK-811910","shopify_product_id":"7965443031091","action":"created","activated":false,"published":false,"sampleOnly":false,"status":"DRAFT","batch_id":"upload-pm-2026-09-15T20-40-06-316Z","ts":"2026-09-15T20:40:21.221Z"}
+{"table":"schumacher_catalog","mfr_sku":"5013668","dw_sku":"DWLK-811920","shopify_product_id":"7965443063859","action":"created","activated":false,"published":false,"sampleOnly":false,"status":"DRAFT","batch_id":"upload-pm-2026-09-15T20-40-06-316Z","ts":"2026-09-15T20:40:23.556Z"}
+{"table":"schumacher_catalog","mfr_sku":"5013670","dw_sku":"DWLK-811930","shopify_product_id":"7965443096627","action":"created","activated":false,"published":false,"sampleOnly":false,"status":"DRAFT","batch_id":"upload-pm-2026-09-15T20-40-06-316Z","ts":"2026-09-15T20:40:25.942Z"}
+{"table":"pierre_frey_catalog","mfr_sku":"Nova","dw_sku":"FQ030001","shopify_product_id":"7953189929011","action":"linked-existing","activated":false,"batch_id":"upload-pm-2026-09-15T20-40-06-316Z","ts":"2026-09-15T20:40:26.829Z"}
+{"table":"osborne_catalog","mfr_sku":"W6580-03","dw_sku":"DWOL-290276","shopify_product_id":"7965443129395","action":"created","activated":false,"published":false,"sampleOnly":false,"status":"DRAFT","batch_id":"upload-pm-2026-09-15T20-40-06-316Z","ts":"2026-09-15T20:40:36.285Z"}
+{"table":"osborne_catalog","mfr_sku":"W6580-04","dw_sku":"DWOL-290277","shopify_product_id":"7965443162163","action":"created","activated":false,"published":false,"sampleOnly":false,"status":"DRAFT","batch_id":"upload-pm-2026-09-15T20-40-06-316Z","ts":"2026-09-15T20:40:38.525Z"}
+{"table":"osborne_catalog","mfr_sku":"W6581-02","dw_sku":"DWOL-290278","shopify_product_id":"7965443194931","action":"created","activated":false,"published":false,"sampleOnly":false,"status":"DRAFT","batch_id":"upload-pm-2026-09-15T20-40-06-316Z","ts":"2026-09-15T20:40:40.788Z"}
← 9acf57b5 Brand McKenzie: make canonical lead time 3-5 Weeks sticky (T
·
back to Designer Wallcoverings
·
auto-data-snapshot: 2026-09-15T14:44:34 (3 data files) — sho c152e82e →