[object Object]

← back to Designer Wallcoverings

auto-data-snapshot: 2026-09-15T13:06:09 (5 data files) — DW-Programming/ImportNewSkufromURL/database/create-batch-import-jobs.sql DW-Programming/versa-specs-push-report.json 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

ca1164957555b113f01ed7c6ffaaaf53d542bcf0 · 2026-09-15 13:08:32 -0700 · auto-commit-fleet

Files touched

Diff

commit ca1164957555b113f01ed7c6ffaaaf53d542bcf0
Author: auto-commit-fleet <steve@designerwallcoverings.com>
Date:   Tue Sep 15 13:08:32 2026 -0700

    auto-data-snapshot: 2026-09-15T13:06:09 (5 data files) — DW-Programming/ImportNewSkufromURL/database/create-batch-import-jobs.sql DW-Programming/versa-specs-push-report.json 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          |   8 +-
 DW-Programming/versa-specs-push-report.json        |  36 ++---
 shopify/scripts/cadence/data/cadence-cursor.json   |   4 +-
 .../cadence/data/cadence-plan-pm-2026-09-15.json   | 162 +++++++++++++++++++--
 .../cadence/data/upload-restore-2026-09-15.jsonl   |  12 ++
 5 files changed, 183 insertions(+), 39 deletions(-)

diff --git a/DW-Programming/ImportNewSkufromURL/database/create-batch-import-jobs.sql b/DW-Programming/ImportNewSkufromURL/database/create-batch-import-jobs.sql
index 268d4a1f..e58f74e2 100644
--- a/DW-Programming/ImportNewSkufromURL/database/create-batch-import-jobs.sql
+++ b/DW-Programming/ImportNewSkufromURL/database/create-batch-import-jobs.sql
@@ -1,9 +1,11 @@
 -- TK-11776 (DTD verdict B): background-job store for the bulk-import route.
 -- The synchronous /api/import/batch for-loop was converted into a fire-and-forget
 -- background worker; these two tables are the durable job record + per-item
--- progress. This makes the partial-write VISIBLE, not silent (observability). It is
--- the foundation for a future resume, but automatic resume is NOT yet implemented —
--- a mid-job restart leaves items 'pending'/job 'running'; a boot sweeper is the TODO.
+-- progress. This makes the partial-write VISIBLE, not silent (observability). A
+-- mid-job restart is handled by a boot-time orphan sweeper (reclaimOrphanedJobs in
+-- lib/batch-import-jobs.ts, run once per process): jobs left 'pending'/'running' by a
+-- dead process are marked 'failed' with a re-submit prompt (NOT auto-recreated — a
+-- re-submit skips already-created SKUs as duplicates).
 -- Canonical DB: dw_unified. Idempotent — safe to run repeatedly.
 
 CREATE TABLE IF NOT EXISTS batch_import_jobs (
diff --git a/DW-Programming/versa-specs-push-report.json b/DW-Programming/versa-specs-push-report.json
index b8e1e080..0f348808 100644
--- a/DW-Programming/versa-specs-push-report.json
+++ b/DW-Programming/versa-specs-push-report.json
@@ -1,30 +1,30 @@
 {
-  "timestamp": "2026-09-15T19:01:18.096Z",
-  "duration_minutes": 0.1,
+  "timestamp": "2026-09-15T19:36:58.714Z",
+  "duration_minutes": 34.4,
   "stats": {
     "total": 883,
-    "updated": 3,
+    "updated": 883,
     "skipped": 0,
     "errors": 0,
     "errorDetails": [],
     "fieldsSet": {
-      "weight": 3,
-      "material": 3,
-      "fire_rating": 3,
-      "backing": 3,
-      "width": 3,
-      "manufacturer_sku": 3,
-      "pattern_name": 3,
-      "color": 3,
-      "body_html": 3,
-      "repeat_v": 3,
-      "repeat_h": 3,
-      "application": 3,
-      "collection": 3,
-      "cleaning_code": 0,
+      "weight": 878,
+      "material": 878,
+      "fire_rating": 878,
+      "backing": 878,
+      "width": 883,
+      "manufacturer_sku": 883,
+      "pattern_name": 883,
+      "color": 883,
+      "body_html": 883,
+      "repeat_v": 867,
+      "repeat_h": 867,
+      "application": 883,
+      "collection": 883,
+      "cleaning_code": 3,
       "finish": 0,
       "match_type": 0,
-      "lead_time": 3
+      "lead_time": 883
     }
   },
   "description": "Versa Designed Surfaces specs push from PostgreSQL to Shopify"
diff --git a/shopify/scripts/cadence/data/cadence-cursor.json b/shopify/scripts/cadence/data/cadence-cursor.json
index 200b80aa..c6f41056 100644
--- a/shopify/scripts/cadence/data/cadence-cursor.json
+++ b/shopify/scripts/cadence/data/cadence-cursor.json
@@ -1,5 +1,5 @@
 {
- "idx": 8,
- "lastSlot": "am",
+ "idx": 5,
+ "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 72276e30..a15aed9e 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,94 @@
 [
+ {
+  "vendor": "Pierre Frey",
+  "dw_sku": "FQ030001",
+  "cost": 0,
+  "retail": 0,
+  "sample": "4.25",
+  "sampleOnly": true,
+  "title": "Aloe Vera Wallcoverings | Pierre Frey",
+  "willActivate": false
+ },
+ {
+  "vendor": "Pierre Frey",
+  "dw_sku": "",
+  "cost": 0,
+  "retail": 0,
+  "sample": "4.25",
+  "sampleOnly": true,
+  "title": "Glais, Amande Wallcoverings | Pierre Frey",
+  "willActivate": false
+ },
+ {
+  "vendor": "Pierre Frey",
+  "dw_sku": "",
+  "cost": 0,
+  "retail": 0,
+  "sample": "4.25",
+  "sampleOnly": true,
+  "title": "Tralee, Anis Wallcoverings | Pierre Frey",
+  "willActivate": false
+ },
+ {
+  "vendor": "Romo",
+  "dw_sku": "DWRM-240167",
+  "cost": 1302,
+  "retail": 2356.56,
+  "sample": "4.25",
+  "sampleOnly": false,
+  "title": "Bakbak, Indigo Wallcoverings | Romo",
+  "willActivate": false
+ },
+ {
+  "vendor": "Romo",
+  "dw_sku": "DWRM-240187",
+  "cost": 490.6,
+  "retail": 887.96,
+  "sample": "4.25",
+  "sampleOnly": false,
+  "title": "Suru, Typhoon Wallcoverings | Romo",
+  "willActivate": false
+ },
+ {
+  "vendor": "Romo",
+  "dw_sku": "DWRM-240194",
+  "cost": 451,
+  "retail": 816.29,
+  "sample": "4.25",
+  "sampleOnly": false,
+  "title": "Palm, Harvest Wallcoverings | Romo",
+  "willActivate": false
+ },
+ {
+  "vendor": "Osborne & Little",
+  "dw_sku": "DWOL-290257",
+  "cost": 147,
+  "retail": 266.06,
+  "sample": "4.25",
+  "sampleOnly": false,
+  "title": "Chenar, Colorway 04 Wallcoverings | Osborne & Little",
+  "willActivate": false
+ },
+ {
+  "vendor": "Osborne & Little",
+  "dw_sku": "DWOL-290274",
+  "cost": 200,
+  "retail": 361.99,
+  "sample": "4.25",
+  "sampleOnly": false,
+  "title": "Tessella, Colorway 01 Wallcoverings | Osborne & Little",
+  "willActivate": false
+ },
+ {
+  "vendor": "Osborne & Little",
+  "dw_sku": "DWOL-290275",
+  "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",
@@ -11,44 +101,84 @@
   "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-1006361",
+  "dw_sku": "DWXW-1006386",
   "cost": 104,
   "retail": 188.24,
   "sample": "4.25",
   "sampleOnly": false,
-  "title": "Vento White, Made to Measure Mural Type II Wallcoverings | Newwall",
+  "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-171311",
-  "cost": 70,
-  "retail": 126.7,
+  "dw_sku": "DWBR-171336",
+  "cost": 45,
+  "retail": 81.45,
   "sample": "4.25",
   "sampleOnly": false,
-  "title": "Oakcliff, Taupe Wallcoverings | Malibu Wallcovering",
+  "title": "Hennika, Blue Wallcoverings | Malibu Wallcovering",
   "willActivate": false
  },
  {
-  "vendor": "Kravet",
-  "dw_sku": "DWKK-103448",
-  "cost": 92.95,
-  "retail": 139.43,
+  "vendor": "Brewster & York",
+  "dw_sku": "DWBR-171337",
+  "cost": 90,
+  "retail": 162.9,
   "sample": "4.25",
   "sampleOnly": false,
-  "title": "Vero, Steel Blue Wallcoverings | Kravet",
+  "title": "Hennika, Light Pink Wallcoverings | Malibu Wallcovering",
   "willActivate": false
  },
  {
-  "vendor": "Schumacher",
-  "dw_sku": "DWLK-811660",
-  "cost": 22,
-  "retail": 39.82,
+  "vendor": "Brewster & York",
+  "dw_sku": "DWBR-171338",
+  "cost": 90,
+  "retail": 162.9,
   "sample": "4.25",
   "sampleOnly": false,
-  "title": "Edwin Stripe Narrow, Petal Wallcoverings | Schumacher",
+  "title": "Hennika, Multicolor Wallcoverings | Malibu Wallcovering",
   "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 fb4df450..035ae397 100644
--- a/shopify/scripts/cadence/data/upload-restore-2026-09-15.jsonl
+++ b/shopify/scripts/cadence/data/upload-restore-2026-09-15.jsonl
@@ -228,3 +228,15 @@
 {"table":"schumacher_catalog","mfr_sku":"5013664","dw_sku":"DWLK-811880","shopify_product_id":"7965199761459","action":"created","activated":false,"published":false,"sampleOnly":false,"status":"DRAFT","batch_id":"upload-am-2026-09-15T18-40-04-023Z","ts":"2026-09-15T18:40:35.595Z"}
 {"table":"schumacher_catalog","mfr_sku":"5013665","dw_sku":"DWLK-811890","shopify_product_id":"7965199794227","action":"created","activated":false,"published":false,"sampleOnly":false,"status":"DRAFT","batch_id":"upload-am-2026-09-15T18-40-04-023Z","ts":"2026-09-15T18:40:37.803Z"}
 {"table":"schumacher_catalog","mfr_sku":"5013666","dw_sku":"DWLK-811900","shopify_product_id":"7965199826995","action":"created","activated":false,"published":false,"sampleOnly":false,"status":"DRAFT","batch_id":"upload-am-2026-09-15T18-40-04-023Z","ts":"2026-09-15T18:40:40.122Z"}
+{"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-15T19-40-00-926Z","ts":"2026-09-15T19:40:04.335Z"}
+{"table":"osborne_catalog","mfr_sku":"W6497-04","dw_sku":"DWOL-290257","shopify_product_id":"7965317333043","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:13.800Z"}
+{"table":"osborne_catalog","mfr_sku":"W6580-01","dw_sku":"DWOL-290274","shopify_product_id":"7965317365811","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:16.802Z"}
+{"table":"osborne_catalog","mfr_sku":"W6580-02","dw_sku":"DWOL-290275","shopify_product_id":"7965317431347","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:19.253Z"}
+{"table":"designtex_catalog","mfr_sku":"6674102","dw_sku":"DWDX-220821","shopify_product_id":"7965317464115","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:21.653Z"}
+{"table":"designtex_catalog","mfr_sku":"6674103","dw_sku":"DWDX-220822","shopify_product_id":"7965317496883","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:24.028Z"}
+{"table":"newwall_catalog","mfr_sku":"M3216-3","dw_sku":"DWXW-1006386","shopify_product_id":"7965317529651","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:26.439Z"}
+{"table":"newwall_catalog","mfr_sku":"M3217-1","dw_sku":"DWXW-1006387","shopify_product_id":"7965317595187","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:28.746Z"}
+{"table":"newwall_catalog","mfr_sku":"M3217-2","dw_sku":"DWXW-1006388","shopify_product_id":"7965317627955","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:31.037Z"}
+{"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"}

← 9296de8b TK-11776: harden batch-import background job — atomic job se  ·  back to Designer Wallcoverings  ·  Brand McKenzie: make canonical lead time 3-5 Weeks sticky (T 9acf57b5 →