← back to Dw Unbuyable Recovery Pilot
TK-11252 Tier 2: make 7 more unbuyable Hollywood products buyable
cf93e5891cfc192c18aa760adc50a17b63194950 · 2026-09-04 14:33:31 -0700 · Steve
5 Sold-Per-Yard (DUR/XWH/XWJ) + 2 Single-Roll (Senza A200). Price, option name,
inventory policy and tracked flag all read PER-LINE from live sellable siblings
rather than hardcoded — the canary caught a wrong option-name mapping, a value
not reaching the mutation, and a wrong tracked flag before the batch. 7/7 verified.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_011rLMRd91EREgUHbEMQDNiy
Files touched
M tk11252-hollywood/add-roll-variants.mjsA tk11252-hollywood/canary2.tsvA tk11252-hollywood/created-tier1.jsonM tk11252-hollywood/created.jsonA tk11252-hollywood/targets-tier2-final.tsvA tk11252-hollywood/targets-tier2-fixed.tsv
Diff
commit cf93e5891cfc192c18aa760adc50a17b63194950
Author: Steve <steve@designerwallcoverings.com>
Date: Fri Sep 4 14:33:31 2026 -0700
TK-11252 Tier 2: make 7 more unbuyable Hollywood products buyable
5 Sold-Per-Yard (DUR/XWH/XWJ) + 2 Single-Roll (Senza A200). Price, option name,
inventory policy and tracked flag all read PER-LINE from live sellable siblings
rather than hardcoded — the canary caught a wrong option-name mapping, a value
not reaching the mutation, and a wrong tracked flag before the batch. 7/7 verified.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_011rLMRd91EREgUHbEMQDNiy
---
tk11252-hollywood/add-roll-variants.mjs | 10 +-
tk11252-hollywood/canary2.tsv | 1 +
tk11252-hollywood/created-tier1.json | 128 ++++++++++++++++++++++++++
tk11252-hollywood/created.json | 147 +++++++-----------------------
tk11252-hollywood/targets-tier2-final.tsv | 7 ++
tk11252-hollywood/targets-tier2-fixed.tsv | 7 ++
6 files changed, 183 insertions(+), 117 deletions(-)
diff --git a/tk11252-hollywood/add-roll-variants.mjs b/tk11252-hollywood/add-roll-variants.mjs
index 062432a..fbf0727 100644
--- a/tk11252-hollywood/add-roll-variants.mjs
+++ b/tk11252-hollywood/add-roll-variants.mjs
@@ -18,7 +18,7 @@ const gql = async (query, variables={}) => {
}
};
const targets = fs.readFileSync(process.argv[2]||'targets.tsv','utf8').trim().split('\n')
- .filter(Boolean).map(l=>{const [pid,title,sku,price,optName]=l.split('\t');return {pid,title,sku,price,optName};});
+ .filter(Boolean).map(l=>{const [pid,title,sku,price,optName,value,policy,tracked]=l.split('\t');return {pid,title,sku,price,optName,value:value||'Single Roll',policy:policy||'CONTINUE',tracked:(tracked||'False').toLowerCase()==='true'};});
const M = `mutation($productId: ID!, $variants: [ProductVariantsBulkInput!]!) {
productVariantsBulkCreate(productId: $productId, variants: $variants) {
@@ -29,10 +29,10 @@ const M = `mutation($productId: ID!, $variants: [ProductVariantsBulkInput!]!) {
const created=[]; let ok=0, fail=0;
for (const t of targets) {
const vars={ productId:`gid://shopify/Product/${t.pid}`,
- variants:[{ price:String(t.price), inventoryPolicy:'CONTINUE',
- inventoryItem:{ sku:t.sku, tracked:false },
- optionValues:[{ name:'Single Roll', optionName:t.optName }] }] };
- if(!APPLY){ console.log(`DRY ${t.pid} | ${t.sku.padEnd(16)} | $${String(t.price).padStart(6)} | opt='${t.optName}' | ${t.title.slice(0,42)}`); ok++; continue; }
+ variants:[{ price:String(t.price), inventoryPolicy:t.policy,
+ inventoryItem:{ sku:t.sku, tracked:t.tracked },
+ optionValues:[{ name:t.value, optionName:t.optName }] }] };
+ if(!APPLY){ console.log(`DRY ${t.pid} | ${t.sku.padEnd(16)} | $${String(t.price).padStart(6)} | ${t.optName}='${t.value}' | ${t.title.slice(0,40)}`); ok++; continue; }
try {
const j = await gql(M,vars);
const res = j.data.productVariantsBulkCreate;
diff --git a/tk11252-hollywood/canary2.tsv b/tk11252-hollywood/canary2.tsv
new file mode 100644
index 0000000..ce0fcee
--- /dev/null
+++ b/tk11252-hollywood/canary2.tsv
@@ -0,0 +1 @@
+1502199316592 La Roche Durable Vinyl | Hollywood Wallcoverings DUR-72076-yard 46.70 Size Sold Per Yard
diff --git a/tk11252-hollywood/created-tier1.json b/tk11252-hollywood/created-tier1.json
new file mode 100644
index 0000000..f86abd7
--- /dev/null
+++ b/tk11252-hollywood/created-tier1.json
@@ -0,0 +1,128 @@
+[
+ {
+ "pid": "7800009752627",
+ "sku": "A188-722-285",
+ "price": "26.43",
+ "variant_id": "gid://shopify/ProductVariant/44820507492403",
+ "title": "Aries - Single Color Commercial Wallcovering | DW Commercial Surfaces"
+ },
+ {
+ "pid": "7800243454003",
+ "sku": "A201-706-297",
+ "price": "63.86",
+ "variant_id": "gid://shopify/ProductVariant/44820508082227",
+ "title": "Akasha - Eris Mylar Type II Vinyl Wallcovering"
+ },
+ {
+ "pid": "7800003952691",
+ "sku": "A176-762",
+ "price": "66.90",
+ "variant_id": "gid://shopify/ProductVariant/44820508147763",
+ "title": "Alley Cat - Cougar Mylar Wallcovering"
+ },
+ {
+ "pid": "7800003723315",
+ "sku": "A176-054",
+ "price": "66.90",
+ "variant_id": "gid://shopify/ProductVariant/44820508180531",
+ "title": "Alley Cat - Downtown Mylar Wallcovering"
+ },
+ {
+ "pid": "7800007360563",
+ "sku": "A185-336-283",
+ "price": "46.19",
+ "variant_id": "gid://shopify/ProductVariant/44820508213299",
+ "title": "Balliano - Indigo Type II Vinyl Wallcovering"
+ },
+ {
+ "pid": "7800006934579",
+ "sku": "A184-592-282",
+ "price": "46.19",
+ "variant_id": "gid://shopify/ProductVariant/44820508311603",
+ "title": "Balliano Texture - Chennai Type II Vinyl Wallcovering"
+ },
+ {
+ "pid": "7800019484723",
+ "sku": "A194-100",
+ "price": "55.24",
+ "variant_id": "gid://shopify/ProductVariant/44820508409907",
+ "title": "Caba - Iced Cappuccino Wallcovering"
+ },
+ {
+ "pid": "7800001953843",
+ "sku": "A167-865-271",
+ "price": "48.22",
+ "variant_id": "gid://shopify/ProductVariant/44820508475443",
+ "title": "Flint Type II Vinyl Wallcovering"
+ },
+ {
+ "pid": "7800256364595",
+ "sku": "A213-879-309",
+ "price": "49.95",
+ "variant_id": "gid://shopify/ProductVariant/44820508508211",
+ "title": "Isla Grass - Nocturnal Type II Vinyl Wallcovering"
+ },
+ {
+ "pid": "7800005591091",
+ "sku": "A181-777-280",
+ "price": "58.43",
+ "variant_id": "gid://shopify/ProductVariant/44820508606515",
+ "title": "Mandolin - Deep Space Type II Vinyl Wallcovering"
+ },
+ {
+ "pid": "7800007786547",
+ "sku": "A187",
+ "price": "47.78",
+ "variant_id": "gid://shopify/ProductVariant/44820508704819",
+ "title": "Matka - Single Color Commercial Wallcovering | DW Commercial Surfaces"
+ },
+ {
+ "pid": "7800260198451",
+ "sku": "A218-810-314",
+ "price": "50.46",
+ "variant_id": "gid://shopify/ProductVariant/44820508737587",
+ "title": "Orsay - Boulevard Type II Vinyl Wallcovering"
+ },
+ {
+ "pid": "7800251285555",
+ "sku": "A208-890-304",
+ "price": "52.71",
+ "variant_id": "gid://shopify/ProductVariant/44820508770355",
+ "title": "Patina Blocks - Obsidian Type II Vinyl Wallcovering"
+ },
+ {
+ "pid": "7800000249907",
+ "sku": "A162-896-268",
+ "price": "45.47",
+ "variant_id": "gid://shopify/ProductVariant/44820508901427",
+ "title": "Ravelle - Fossil Type II Vinyl Wallcovering"
+ },
+ {
+ "pid": "7800000380979",
+ "sku": "A163-164-269",
+ "price": "48.14",
+ "variant_id": "gid://shopify/ProductVariant/44820508966963",
+ "title": "Ravelle Texture - Stucco Type II Vinyl Wallcovering"
+ },
+ {
+ "pid": "7800258035763",
+ "sku": "A215-896-311",
+ "price": "54.59",
+ "variant_id": "gid://shopify/ProductVariant/44820509065267",
+ "title": "Secret Garden - Overcast Type II Vinyl Wallcovering"
+ },
+ {
+ "pid": "7800249417779",
+ "sku": "A207-501-303",
+ "price": "52.71",
+ "variant_id": "gid://shopify/ProductVariant/44820509130803",
+ "title": "Sterling Heights - Sun Ray Type II Vinyl Wallcovering"
+ },
+ {
+ "pid": "7800261378099",
+ "sku": "A219-847-315",
+ "price": "53.14",
+ "variant_id": "gid://shopify/ProductVariant/44820509163571",
+ "title": "Zenith - Solstice Type II Vinyl Wallcovering"
+ }
+]
\ No newline at end of file
diff --git a/tk11252-hollywood/created.json b/tk11252-hollywood/created.json
index f86abd7..486f22c 100644
--- a/tk11252-hollywood/created.json
+++ b/tk11252-hollywood/created.json
@@ -1,128 +1,51 @@
[
{
- "pid": "7800009752627",
- "sku": "A188-722-285",
- "price": "26.43",
- "variant_id": "gid://shopify/ProductVariant/44820507492403",
- "title": "Aries - Single Color Commercial Wallcovering | DW Commercial Surfaces"
+ "pid": "1502199316592",
+ "sku": "DUR-72076-yard",
+ "price": "46.70",
+ "variant_id": "gid://shopify/ProductVariant/44820976795699",
+ "title": "La Roche Durable Vinyl | Hollywood Wallcoverings"
},
{
- "pid": "7800243454003",
- "sku": "A201-706-297",
- "price": "63.86",
- "variant_id": "gid://shopify/ProductVariant/44820508082227",
- "title": "Akasha - Eris Mylar Type II Vinyl Wallcovering"
+ "pid": "1502199480432",
+ "sku": "DUR-72077-yard",
+ "price": "46.70",
+ "variant_id": "gid://shopify/ProductVariant/44820976828467",
+ "title": "La Roche Durable Vinyl | Hollywood Wallcoverings"
},
{
- "pid": "7800003952691",
- "sku": "A176-762",
- "price": "66.90",
- "variant_id": "gid://shopify/ProductVariant/44820508147763",
- "title": "Alley Cat - Cougar Mylar Wallcovering"
+ "pid": "1499495399536",
+ "sku": "XWH-52368-yard",
+ "price": "60.96",
+ "variant_id": "gid://shopify/ProductVariant/44820976894003",
+ "title": "Pearl Bay Vertical Faux Durable | Hollywood Wallcoverings"
},
{
- "pid": "7800003723315",
- "sku": "A176-054",
- "price": "66.90",
- "variant_id": "gid://shopify/ProductVariant/44820508180531",
- "title": "Alley Cat - Downtown Mylar Wallcovering"
+ "pid": "1499512930416",
+ "sku": "XWJ-52446-yard",
+ "price": "41.85",
+ "variant_id": "gid://shopify/ProductVariant/44820976959539",
+ "title": "Rivington Rice Paper Durable Vinyl | Hollywood Wallcoverings"
},
{
- "pid": "7800007360563",
- "sku": "A185-336-283",
- "price": "46.19",
- "variant_id": "gid://shopify/ProductVariant/44820508213299",
- "title": "Balliano - Indigo Type II Vinyl Wallcovering"
+ "pid": "1502285889648",
+ "sku": "DUR-72409-yard",
+ "price": "54.01",
+ "variant_id": "gid://shopify/ProductVariant/44820976992307",
+ "title": "Rivo Dulce Durable Vinyl | Hollywood Wallcoverings"
},
{
- "pid": "7800006934579",
- "sku": "A184-592-282",
- "price": "46.19",
- "variant_id": "gid://shopify/ProductVariant/44820508311603",
- "title": "Balliano Texture - Chennai Type II Vinyl Wallcovering"
+ "pid": "7800242470963",
+ "sku": "A200-673-296",
+ "price": "45.25",
+ "variant_id": "gid://shopify/ProductVariant/44820977221683",
+ "title": "Senza - Campo Type II Vinyl Wallcovering"
},
{
- "pid": "7800019484723",
- "sku": "A194-100",
- "price": "55.24",
- "variant_id": "gid://shopify/ProductVariant/44820508409907",
- "title": "Caba - Iced Cappuccino Wallcovering"
- },
- {
- "pid": "7800001953843",
- "sku": "A167-865-271",
- "price": "48.22",
- "variant_id": "gid://shopify/ProductVariant/44820508475443",
- "title": "Flint Type II Vinyl Wallcovering"
- },
- {
- "pid": "7800256364595",
- "sku": "A213-879-309",
- "price": "49.95",
- "variant_id": "gid://shopify/ProductVariant/44820508508211",
- "title": "Isla Grass - Nocturnal Type II Vinyl Wallcovering"
- },
- {
- "pid": "7800005591091",
- "sku": "A181-777-280",
- "price": "58.43",
- "variant_id": "gid://shopify/ProductVariant/44820508606515",
- "title": "Mandolin - Deep Space Type II Vinyl Wallcovering"
- },
- {
- "pid": "7800007786547",
- "sku": "A187",
- "price": "47.78",
- "variant_id": "gid://shopify/ProductVariant/44820508704819",
- "title": "Matka - Single Color Commercial Wallcovering | DW Commercial Surfaces"
- },
- {
- "pid": "7800260198451",
- "sku": "A218-810-314",
- "price": "50.46",
- "variant_id": "gid://shopify/ProductVariant/44820508737587",
- "title": "Orsay - Boulevard Type II Vinyl Wallcovering"
- },
- {
- "pid": "7800251285555",
- "sku": "A208-890-304",
- "price": "52.71",
- "variant_id": "gid://shopify/ProductVariant/44820508770355",
- "title": "Patina Blocks - Obsidian Type II Vinyl Wallcovering"
- },
- {
- "pid": "7800000249907",
- "sku": "A162-896-268",
- "price": "45.47",
- "variant_id": "gid://shopify/ProductVariant/44820508901427",
- "title": "Ravelle - Fossil Type II Vinyl Wallcovering"
- },
- {
- "pid": "7800000380979",
- "sku": "A163-164-269",
- "price": "48.14",
- "variant_id": "gid://shopify/ProductVariant/44820508966963",
- "title": "Ravelle Texture - Stucco Type II Vinyl Wallcovering"
- },
- {
- "pid": "7800258035763",
- "sku": "A215-896-311",
- "price": "54.59",
- "variant_id": "gid://shopify/ProductVariant/44820509065267",
- "title": "Secret Garden - Overcast Type II Vinyl Wallcovering"
- },
- {
- "pid": "7800249417779",
- "sku": "A207-501-303",
- "price": "52.71",
- "variant_id": "gid://shopify/ProductVariant/44820509130803",
- "title": "Sterling Heights - Sun Ray Type II Vinyl Wallcovering"
- },
- {
- "pid": "7800261378099",
- "sku": "A219-847-315",
- "price": "53.14",
- "variant_id": "gid://shopify/ProductVariant/44820509163571",
- "title": "Zenith - Solstice Type II Vinyl Wallcovering"
+ "pid": "7800242241587",
+ "sku": "A200-145-296",
+ "price": "45.25",
+ "variant_id": "gid://shopify/ProductVariant/44820977254451",
+ "title": "Senza - Valle Type II Vinyl Wallcovering"
}
]
\ No newline at end of file
diff --git a/tk11252-hollywood/targets-tier2-final.tsv b/tk11252-hollywood/targets-tier2-final.tsv
new file mode 100644
index 0000000..c802675
--- /dev/null
+++ b/tk11252-hollywood/targets-tier2-final.tsv
@@ -0,0 +1,7 @@
+1502199316592 La Roche Durable Vinyl | Hollywood Wallcoverings DUR-72076-yard 46.70 Size Sold Per Yard CONTINUE True
+1502199480432 La Roche Durable Vinyl | Hollywood Wallcoverings DUR-72077-yard 46.70 Size Sold Per Yard CONTINUE True
+1499495399536 Pearl Bay Vertical Faux Durable | Hollywood Wallcoverings XWH-52368-yard 60.96 Size Sold Per Yard DENY True
+1499512930416 Rivington Rice Paper Durable Vinyl | Hollywood Wallcoverings XWJ-52446-yard 41.85 Size Sold Per Yard CONTINUE True
+1502285889648 Rivo Dulce Durable Vinyl | Hollywood Wallcoverings DUR-72409-yard 54.01 Size Sold Per Yard CONTINUE True
+7800242470963 Senza - Campo Type II Vinyl Wallcovering A200-673-296 45.25 Purchase Option Single Roll CONTINUE False
+7800242241587 Senza - Valle Type II Vinyl Wallcovering A200-145-296 45.25 Purchase Option Single Roll CONTINUE False
diff --git a/tk11252-hollywood/targets-tier2-fixed.tsv b/tk11252-hollywood/targets-tier2-fixed.tsv
new file mode 100644
index 0000000..fffc642
--- /dev/null
+++ b/tk11252-hollywood/targets-tier2-fixed.tsv
@@ -0,0 +1,7 @@
+1502199316592 La Roche Durable Vinyl | Hollywood Wallcoverings DUR-72076-yard 46.70 Size Sold Per Yard
+1502199480432 La Roche Durable Vinyl | Hollywood Wallcoverings DUR-72077-yard 46.70 Size Sold Per Yard
+1499495399536 Pearl Bay Vertical Faux Durable | Hollywood Wallcoverings XWH-52368-yard 60.96 Size Sold Per Yard
+1499512930416 Rivington Rice Paper Durable Vinyl | Hollywood Wallcoverings XWJ-52446-yard 41.85 Size Sold Per Yard
+1502285889648 Rivo Dulce Durable Vinyl | Hollywood Wallcoverings DUR-72409-yard 54.01 Size Sold Per Yard
+7800242470963 Senza - Campo Type II Vinyl Wallcovering A200-673-296 45.25 Purchase Option Single Roll
+7800242241587 Senza - Valle Type II Vinyl Wallcovering A200-145-296 45.25 Purchase Option Single Roll
← dc82409 auto-data-snapshot: 2026-09-04T12:10:54 (1 data files) — tk1
·
back to Dw Unbuyable Recovery Pilot
·
auto-data-snapshot: 2026-09-04T14:52:10 (1 data files) — tk1 b5b3182 →