← back to Designer Wallcoverings
Groundworks: assign 67 DWKK SKUs (158394-159054) mirror-side, draft-only + audit JSON
11595f16b93560739e03ba0d1ed97af11d92fe68 · 2026-07-23 15:41:03 -0700 · Steve
Files touched
A scripts/groundworks-sku-assign/groundworks-sku-assign-2026-07-23.json
Diff
commit 11595f16b93560739e03ba0d1ed97af11d92fe68
Author: Steve <steve@designerwallcoverings.com>
Date: Thu Jul 23 15:41:03 2026 -0700
Groundworks: assign 67 DWKK SKUs (158394-159054) mirror-side, draft-only + audit JSON
---
.../groundworks-sku-assign-2026-07-23.json | 594 +++++++++++++++++++++
1 file changed, 594 insertions(+)
diff --git a/scripts/groundworks-sku-assign/groundworks-sku-assign-2026-07-23.json b/scripts/groundworks-sku-assign/groundworks-sku-assign-2026-07-23.json
new file mode 100644
index 00000000..6b70e88f
--- /dev/null
+++ b/scripts/groundworks-sku-assign/groundworks-sku-assign-2026-07-23.json
@@ -0,0 +1,594 @@
+{
+ "task": "Groundworks 67-row DW SKU assignment (mirror-side prep, reversible)",
+ "date": "2026-07-23",
+ "approved_by": "Steve",
+ "cost": "$0 (local dw_unified reads/writes only)",
+ "guards": {
+ "mirror_only": true,
+ "socket": "/tmp (inet_server_addr empty = local)",
+ "subscription_dw_unified_sub": "disabled (subenabled=f) — no propagation",
+ "shopify_write": false,
+ "activation": false,
+ "draft_only": true,
+ "triggers_on_tables": "none (groundworks_catalog + dw_sku_registry both trigger-free)"
+ },
+ "source_table": "dw_unified.groundworks_catalog",
+ "totals": { "line_total": 304, "had_dw_sku_before": 237, "assigned_now": 67, "have_dw_sku_after": 304 },
+ "series": {
+ "prefix": "DWKK",
+ "rationale": "Kravet-umbrella line; established Groundworks convention is DWKK (234/237 existing) — DWWC only 3 legacy rows. Continued the DWKK series.",
+ "step": 10,
+ "terminal_digit": 4,
+ "prior_global_max": "DWKK-158384",
+ "range_assigned": "DWKK-158394 .. DWKK-159054",
+ "ordering": "row_number() OVER (ORDER BY mfr_sku)"
+ },
+ "collision_checks": {
+ "vs_dw_sku_registry": "0 collisions (dw_sku and vendor_prefix+mfr_sku)",
+ "vs_shopify_products": "0 collisions",
+ "vs_groundworks_catalog_existing": "0 collisions",
+ "within_batch_dup_dw_sku": "0",
+ "within_batch_dup_mfr_sku": "0",
+ "blank_mfr_sku_in_batch": "0"
+ },
+ "post_verify": {
+ "groundworks_missing_dw_sku": 0,
+ "groundworks_distinct_dw_sku": 304,
+ "assigned_rows_with_shopify_product_id": 0,
+ "registry_rows_added": 67,
+ "registry_added_status": "draft"
+ },
+ "registry_writes": "67 rows inserted into dw_sku_registry (vendor_prefix=DWKK, vendor_name=Groundworks, status=draft)",
+ "reversal_sql": [
+ "-- Fully reverses this assignment (mirror-only):",
+ "BEGIN;",
+ "DELETE FROM dw_sku_registry WHERE dw_sku BETWEEN 'DWKK-158394' AND 'DWKK-159054' AND vendor_name='Groundworks' AND status='draft';",
+ "UPDATE groundworks_catalog SET dw_sku=NULL WHERE dw_sku BETWEEN 'DWKK-158394' AND 'DWKK-159054';",
+ "COMMIT;"
+ ],
+ "dup_of_existing_note": "7 of the 67 carry a dup_of_existing flag (6 Laryo Paper -> DWKK-139xxx Lee Jofa/ARCHIVED; 1 Signal Paper -> DWWC-506600 Phillipe Romano/ACTIVE). These point to OTHER vendors' products, not Groundworks DWKK duplicates, so fresh DWKK numbers are correct and collision-free. The dup flags remain a downstream review item, unaffected by SKU assignment.",
+ "remaining_blockers_before_active": [
+ "24 no-sample rows (23 Discontinued + 1 Limited Stock) -> keep DRAFT, never ACTIVE without a sellable/sample variant",
+ "6 settlement name-matches -> settlement-post-gen-vision before publish",
+ "1 blank product_type -> classify",
+ "activation-time: never ACTIVE without image + width metafield; 5/6-field canary gate on live write"
+ ],
+ "assignments": [
+ {
+ "name": "Channels Paper - Lake/Beige",
+ "dw_sku": "DWKK-158394",
+ "mfr_sku": "GWP-3302.316 NEW.0",
+ "color_name": "Soft Orange",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Channels Paper - Copper/Beige",
+ "dw_sku": "DWKK-158404",
+ "mfr_sku": "GWP-3302.424 NEW.0",
+ "color_name": "Gold",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Chroma Paper - Ebony/Granite",
+ "dw_sku": "DWKK-158414",
+ "mfr_sku": "GWP-3303.811.0",
+ "color_name": "Charcoal",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Currents Paper - Ebony/Gold",
+ "dw_sku": "DWKK-158424",
+ "mfr_sku": "GWP-3305.48.0",
+ "color_name": "Chalk",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Agate Paper - Taupe/Gold",
+ "dw_sku": "DWKK-158434",
+ "mfr_sku": "GWP-3307.411.0",
+ "color_name": "Charcoal",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Agate Paper - Silver/Linen",
+ "dw_sku": "DWKK-158444",
+ "mfr_sku": "GWP-3307.611.0",
+ "color_name": "Chalk",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Oblique Paper - Beige/Black",
+ "dw_sku": "DWKK-158454",
+ "mfr_sku": "GWP-3308.816.0",
+ "color_name": "Black",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Basket Weave - Nut",
+ "dw_sku": "DWKK-158464",
+ "mfr_sku": "GWP-3316.668.0",
+ "color_name": "Black",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Tokage - Silver",
+ "dw_sku": "DWKK-158474",
+ "mfr_sku": "GWP-3321.11.0",
+ "color_name": "Olive",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Honmono Silk - Gold",
+ "dw_sku": "DWKK-158484",
+ "mfr_sku": "GWP-3348.416.0",
+ "color_name": "Soft Orange",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Turkish Flower - Dove/Stone",
+ "dw_sku": "DWKK-158494",
+ "mfr_sku": "GWP-3400.116.0",
+ "color_name": "Grey",
+ "vendor_status": "Limited Stock",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Malatesta Damask - Aubergine",
+ "dw_sku": "DWKK-158504",
+ "mfr_sku": "GWP-3401.10.0",
+ "color_name": "Purple",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Malatesta Damask - Stone",
+ "dw_sku": "DWKK-158514",
+ "mfr_sku": "GWP-3401.16.0",
+ "color_name": "Silver",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Hicksonian - Silver/Charcoal",
+ "dw_sku": "DWKK-158524",
+ "mfr_sku": "GWP-3402.811.0",
+ "color_name": "Charcoal",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "La Fiorentina - Dove Grey",
+ "dw_sku": "DWKK-158534",
+ "mfr_sku": "GWP-3405.11.0",
+ "color_name": "Grey",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "La Fiorentina - Berry",
+ "dw_sku": "DWKK-158544",
+ "mfr_sku": "GWP-3405.7.0",
+ "color_name": "Wine",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "La Fiorentina - Charcoal",
+ "dw_sku": "DWKK-158554",
+ "mfr_sku": "GWP-3405.840.0",
+ "color_name": "Dark Teal",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "La Fiorentina Small - Mercury",
+ "dw_sku": "DWKK-158564",
+ "mfr_sku": "GWP-3406.11.0",
+ "color_name": "Charcoal",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "La Fiorentina Small - Dove Grey",
+ "dw_sku": "DWKK-158574",
+ "mfr_sku": "GWP-3406.111.0",
+ "color_name": "Silver",
+ "vendor_status": "Limited Stock",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "La Fiorentina Small - Slate/Bronze",
+ "dw_sku": "DWKK-158584",
+ "mfr_sku": "GWP-3406.664.0",
+ "color_name": "Grey",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Navajo - Dove Grey",
+ "dw_sku": "DWKK-158594",
+ "mfr_sku": "GWP-3407.11.0",
+ "color_name": "Grey",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Navajo - Stone",
+ "dw_sku": "DWKK-158604",
+ "mfr_sku": "GWP-3407.116.0",
+ "color_name": "Grey",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Navajo - Indigo",
+ "dw_sku": "DWKK-158614",
+ "mfr_sku": "GWP-3407.506.0",
+ "color_name": "White",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Navajo - Pewter",
+ "dw_sku": "DWKK-158624",
+ "mfr_sku": "GWP-3407.611.0",
+ "color_name": "Grey",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Navajo Foil - Silver",
+ "dw_sku": "DWKK-158634",
+ "mfr_sku": "GWP-3408.111.0",
+ "color_name": "Grey",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Drummond Damask - Stone",
+ "dw_sku": "DWKK-158644",
+ "mfr_sku": "GWP-3409.164.0",
+ "color_name": "Grey",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Hutch - Yellow",
+ "dw_sku": "DWKK-158654",
+ "mfr_sku": "GWP-3413.14.0",
+ "color_name": "Gold",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Channels Paper - Lake/Beige",
+ "dw_sku": "DWKK-158664",
+ "mfr_sku": "GWP-3417.316.0",
+ "color_name": "Soft Orange",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Channels Paper - Copper/Beige",
+ "dw_sku": "DWKK-158674",
+ "mfr_sku": "GWP-3417.424.0",
+ "color_name": "Gold",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Avant - Linen/Gold",
+ "dw_sku": "DWKK-158684",
+ "mfr_sku": "GWP-3500.114.0",
+ "color_name": "Gold",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Avant - Sky/Teal",
+ "dw_sku": "DWKK-158694",
+ "mfr_sku": "GWP-3500.155.0",
+ "color_name": "Teal",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Avant - Green/Black",
+ "dw_sku": "DWKK-158704",
+ "mfr_sku": "GWP-3500.308.0",
+ "color_name": "Forest",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Chalet - Blue/Black",
+ "dw_sku": "DWKK-158714",
+ "mfr_sku": "GWP-3502.158.0",
+ "color_name": "Sky Blue",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Chalet - Kraft/Gold",
+ "dw_sku": "DWKK-158724",
+ "mfr_sku": "GWP-3502.416.0",
+ "color_name": "Dark Beige",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Chalet - Shell/Gold",
+ "dw_sku": "DWKK-158734",
+ "mfr_sku": "GWP-3502.74.0",
+ "color_name": "Soft Orange",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Jubilee - Green/Gold/Blk",
+ "dw_sku": "DWKK-158744",
+ "mfr_sku": "GWP-3504.348.0",
+ "color_name": "Forest",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Rarity Paper - Almond/Ivory",
+ "dw_sku": "DWKK-158754",
+ "mfr_sku": "GWP-3700.116.0",
+ "color_name": "White",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Rarity Paper - Blush/Ivory",
+ "dw_sku": "DWKK-158764",
+ "mfr_sku": "GWP-3700.117.0",
+ "color_name": "White",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Rarity Paper - Pacific/Noir",
+ "dw_sku": "DWKK-158774",
+ "mfr_sku": "GWP-3700.853.0",
+ "color_name": "Dark Teal",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Rarity Paper - Mocha/Noir",
+ "dw_sku": "DWKK-158784",
+ "mfr_sku": "GWP-3700.868.0",
+ "color_name": "White",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Askew Paper - Ivory/Pool",
+ "dw_sku": "DWKK-158794",
+ "mfr_sku": "GWP-3701.115.0",
+ "color_name": "Ivory",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Askew Paper - Ivory/Taupe",
+ "dw_sku": "DWKK-158804",
+ "mfr_sku": "GWP-3701.116.0",
+ "color_name": "Soft Orange",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Askew Paper - Ivory/Onyx",
+ "dw_sku": "DWKK-158814",
+ "mfr_sku": "GWP-3701.18.0",
+ "color_name": "Charcoal",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Askew Paper - Slate/Jade",
+ "dw_sku": "DWKK-158824",
+ "mfr_sku": "GWP-3701.853.0",
+ "color_name": "Teal",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Verge Paper - Gilded/Ivory",
+ "dw_sku": "DWKK-158834",
+ "mfr_sku": "GWP-3702.140.0",
+ "color_name": "Soft Orange",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Verge Paper - Pinot/Noir",
+ "dw_sku": "DWKK-158844",
+ "mfr_sku": "GWP-3702.78.0",
+ "color_name": "Mauve",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Rapture Paper - Jade/Metal",
+ "dw_sku": "DWKK-158854",
+ "mfr_sku": "GWP-3705.348.0",
+ "color_name": "Dark Teal",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Rapture Paper - Gold/Metal",
+ "dw_sku": "DWKK-158864",
+ "mfr_sku": "GWP-3705.408.0",
+ "color_name": "Olive",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Hm - Red/Blue",
+ "dw_sku": "DWKK-158874",
+ "mfr_sku": "GWP-3706.195.0",
+ "color_name": "Coral",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Hula - Pink",
+ "dw_sku": "DWKK-158884",
+ "mfr_sku": "GWP-3713.7.0",
+ "color_name": "Wine",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Post Paper - Natural",
+ "dw_sku": "DWKK-158894",
+ "mfr_sku": "GWP-3717.116.0",
+ "color_name": "Cream",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Post Paper - Glow",
+ "dw_sku": "DWKK-158904",
+ "mfr_sku": "GWP-3717.401.0",
+ "color_name": "Light Yellow",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Mineral Paper - Burnt Umber",
+ "dw_sku": "DWKK-158914",
+ "mfr_sku": "GWP-3719.164.0",
+ "color_name": "Medium Beige",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Graffito Ii - Golden Rod",
+ "dw_sku": "DWKK-158924",
+ "mfr_sku": "GWP-3720.141.0",
+ "color_name": "Medium Beige",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Lyre Paper - Bronzed",
+ "dw_sku": "DWKK-158934",
+ "mfr_sku": "GWP-3722.166.0",
+ "color_name": "Clay",
+ "vendor_status": "Limited Stock",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Lyre Paper - Lotus",
+ "dw_sku": "DWKK-158944",
+ "mfr_sku": "GWP-3722.319.0",
+ "color_name": "Wine",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Simpatico Paper - Faded Terracotta",
+ "dw_sku": "DWKK-158954",
+ "mfr_sku": "GWP-3725.1112.0",
+ "color_name": "Beige",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Simpatico Paper - Teal",
+ "dw_sku": "DWKK-158964",
+ "mfr_sku": "GWP-3725.335.0",
+ "color_name": "Dark Teal",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Laryo Paper - Stone",
+ "dw_sku": "DWKK-158974",
+ "mfr_sku": "GWP-3728.11.0",
+ "color_name": "White",
+ "vendor_status": "Active",
+ "dup_of_existing": "DWKK-139684 (Lee Jofa/ARCHIVED)"
+ },
+ {
+ "name": "Laryo Paper - Sky",
+ "dw_sku": "DWKK-158984",
+ "mfr_sku": "GWP-3728.15.0",
+ "color_name": "Sky Blue",
+ "vendor_status": "Active",
+ "dup_of_existing": "DWKK-139685 (Lee Jofa/ARCHIVED)"
+ },
+ {
+ "name": "Laryo Paper - Sand",
+ "dw_sku": "DWKK-158994",
+ "mfr_sku": "GWP-3728.16.0",
+ "color_name": "White",
+ "vendor_status": "Active",
+ "dup_of_existing": "DWKK-139686 (Lee Jofa/ARCHIVED)"
+ },
+ {
+ "name": "Laryo Paper - Lagoon",
+ "dw_sku": "DWKK-159004",
+ "mfr_sku": "GWP-3728.35.0",
+ "color_name": "Teal",
+ "vendor_status": "Active",
+ "dup_of_existing": "DWKK-139687 (Lee Jofa/ARCHIVED)"
+ },
+ {
+ "name": "Laryo Paper - Indigo",
+ "dw_sku": "DWKK-159014",
+ "mfr_sku": "GWP-3728.50.0",
+ "color_name": "White",
+ "vendor_status": "Active",
+ "dup_of_existing": "DWKK-139688 (Lee Jofa/ARCHIVED)"
+ },
+ {
+ "name": "Laryo Paper - Ink",
+ "dw_sku": "DWKK-159024",
+ "mfr_sku": "GWP-3728.821.0",
+ "color_name": "Lavender",
+ "vendor_status": "Active",
+ "dup_of_existing": "DWKK-139689 (Lee Jofa/ARCHIVED)"
+ },
+ {
+ "name": "Refrakt Paper - Copper",
+ "dw_sku": "DWKK-159034",
+ "mfr_sku": "GWP-3734.1611.0",
+ "color_name": "Grey",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Refrakt Paper - Citron",
+ "dw_sku": "DWKK-159044",
+ "mfr_sku": "GWP-3734.34.0",
+ "color_name": "Olive",
+ "vendor_status": "Discontinued",
+ "dup_of_existing": ""
+ },
+ {
+ "name": "Signal Paper - Ecru",
+ "dw_sku": "DWKK-159054",
+ "mfr_sku": "GWP-3740.161.0",
+ "color_name": "White",
+ "vendor_status": "Active",
+ "dup_of_existing": "DWWC-506600 (Phillipe Romano/ACTIVE)"
+ }
+]
+}
← 5ba9f98e auto-save: 2026-07-23T14:52:02 (1 files) — shopify/scripts/c
·
back to Designer Wallcoverings
·
auto-save: 2026-07-23T15:52:21 (1 files) — shopify/scripts/c 9a242072 →