← back to Tk 10867 Gb Safe Plan
TK-10867: read-only live missing-Sample enumerator + verified cohort (81 GB ACTIVE missing sample)
e653247a27ae75a4f33793e01d0c04a02afe624e · 2026-08-31 02:59:45 -0700 · tk-11002-commerce-overnight
Files touched
A data/live-missing-sample.jsonA scripts/live-missing-sample-enumerate.mjs
Diff
commit e653247a27ae75a4f33793e01d0c04a02afe624e
Author: tk-11002-commerce-overnight <steve@designerwallcoverings.com>
Date: Mon Aug 31 02:59:45 2026 -0700
TK-10867: read-only live missing-Sample enumerator + verified cohort (81 GB ACTIVE missing sample)
---
data/live-missing-sample.json | 659 ++++++++++++++++++++++++++++++
scripts/live-missing-sample-enumerate.mjs | 24 ++
2 files changed, 683 insertions(+)
diff --git a/data/live-missing-sample.json b/data/live-missing-sample.json
new file mode 100644
index 0000000..6f55b1f
--- /dev/null
+++ b/data/live-missing-sample.json
@@ -0,0 +1,659 @@
+{
+ "ticket": "TK-10867",
+ "generated": "2026-08-31T09:59:29.286Z",
+ "store": "designer-laboratory-sandbox.myshopify.com",
+ "vendor": "Graham & Brown",
+ "active_count": 405,
+ "with_sample": 324,
+ "missing_sample_count": 81,
+ "missing_sample": [
+ {
+ "id": "7776864862259",
+ "title": "Allure Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200008"
+ ]
+ },
+ {
+ "id": "7776866336819",
+ "title": "Prism Rose Gold Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200024"
+ ]
+ },
+ {
+ "id": "7776866435123",
+ "title": "Gothic Damask Noir Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200025"
+ ]
+ },
+ {
+ "id": "7776866467891",
+ "title": "Gothic Damask Flock White Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200026"
+ ]
+ },
+ {
+ "id": "7776866631731",
+ "title": "Gothic Damask Flock Cobalt Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200028"
+ ]
+ },
+ {
+ "id": "7776866762803",
+ "title": "Gothic Damask Flock Black & Silver Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200029"
+ ]
+ },
+ {
+ "id": "7776866893875",
+ "title": "Gothic Damask Plum Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200030"
+ ]
+ },
+ {
+ "id": "7776868204595",
+ "title": "Atelier Geo Slate Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200045"
+ ]
+ },
+ {
+ "id": "7776868302899",
+ "title": "Atelier Geo Stone Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200046"
+ ]
+ },
+ {
+ "id": "7776868335667",
+ "title": "Harmony Deep Sky Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200047"
+ ]
+ },
+ {
+ "id": "7776868401203",
+ "title": "Harmony Navy Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200048"
+ ]
+ },
+ {
+ "id": "7776868433971",
+ "title": "Harmony White Rose Gold Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200049"
+ ]
+ },
+ {
+ "id": "7776868532275",
+ "title": "Sashiko Rose Gold Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200050"
+ ]
+ },
+ {
+ "id": "7776868630579",
+ "title": "Indigo Blue Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200051"
+ ]
+ },
+ {
+ "id": "7776869023795",
+ "title": "Heritage Plaid Charcoal Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200056"
+ ]
+ },
+ {
+ "id": "7776869089331",
+ "title": "Heritage Plaid Blue Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200057"
+ ]
+ },
+ {
+ "id": "7776869187635",
+ "title": "Heritage Plaid Plum Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200058"
+ ]
+ },
+ {
+ "id": "7776869220403",
+ "title": "Heritage Plaid Grey Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200059"
+ ]
+ },
+ {
+ "id": "7776869417011",
+ "title": "Rene Shimmer Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200061"
+ ]
+ },
+ {
+ "id": "7776869515315",
+ "title": "Rene Nightfall Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200062"
+ ]
+ },
+ {
+ "id": "7776869613619",
+ "title": "Bananas Bling Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200063"
+ ]
+ },
+ {
+ "id": "7776869974067",
+ "title": "Chevron Texture Natural Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200067"
+ ]
+ },
+ {
+ "id": "7776880951347",
+ "title": "Wild Flower Sand Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200188"
+ ]
+ },
+ {
+ "id": "7776881770547",
+ "title": "Anthriscus Summer Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200197"
+ ]
+ },
+ {
+ "id": "7776881836083",
+ "title": "Anthriscus Dusk Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200198"
+ ]
+ },
+ {
+ "id": "7776882196531",
+ "title": "Meiying Chalk Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200201"
+ ]
+ },
+ {
+ "id": "7776883769395",
+ "title": "Lotus Plum Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200215"
+ ]
+ },
+ {
+ "id": "7776883834931",
+ "title": "Lotus Cream Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200216"
+ ]
+ },
+ {
+ "id": "7776883998771",
+ "title": "Jardin Teal Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200217"
+ ]
+ },
+ {
+ "id": "7776884031539",
+ "title": "Jardin Magenta Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200218"
+ ]
+ },
+ {
+ "id": "7776884129843",
+ "title": "Jardin Black Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200219"
+ ]
+ },
+ {
+ "id": "7776884228147",
+ "title": "Jardin Grey Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200220"
+ ]
+ },
+ {
+ "id": "7776929185843",
+ "title": "Skull Roses Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200851"
+ ]
+ },
+ {
+ "id": "7776929513523",
+ "title": "Antique Gris Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200856"
+ ]
+ },
+ {
+ "id": "7776929710131",
+ "title": "Antique Taupe & Rose Gold Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200860"
+ ]
+ },
+ {
+ "id": "7776933314611",
+ "title": "Clarissa Hulse Gypsophila Paprika & Gold Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200905"
+ ]
+ },
+ {
+ "id": "7776943112243",
+ "title": "Orbit White Grey Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200939"
+ ]
+ },
+ {
+ "id": "7776945569843",
+ "title": "Steel Pearl Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200955"
+ ]
+ },
+ {
+ "id": "7776949796915",
+ "title": "Art Deco Black and Gold Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200979"
+ ]
+ },
+ {
+ "id": "7776950747187",
+ "title": "Origin Ground Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200983"
+ ]
+ },
+ {
+ "id": "7776951173171",
+ "title": "Clarissa Hulse Woodland Fern French Navy Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200985"
+ ]
+ },
+ {
+ "id": "7776951664691",
+ "title": "Woodland Spring Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-200987"
+ ]
+ },
+ {
+ "id": "7778835234867",
+ "title": "Baroque Bead Pearl Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700067"
+ ]
+ },
+ {
+ "id": "7778836873267",
+ "title": "Art Deco Gold and Pearl Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700115"
+ ]
+ },
+ {
+ "id": "7778839494707",
+ "title": "Betula Soft Gold Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700205"
+ ]
+ },
+ {
+ "id": "7778839527475",
+ "title": "Betula Blush & Rose Gold Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700206"
+ ]
+ },
+ {
+ "id": "7778840182835",
+ "title": "Woodland Pearl Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700226"
+ ]
+ },
+ {
+ "id": "7778841886771",
+ "title": "Botanica Midnight Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700285"
+ ]
+ },
+ {
+ "id": "7778841985075",
+ "title": "Grace Cloud Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700288"
+ ]
+ },
+ {
+ "id": "7778843295795",
+ "title": "Amalfi Cielo Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700327"
+ ]
+ },
+ {
+ "id": "7778843361331",
+ "title": "Amalfi White Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700328"
+ ]
+ },
+ {
+ "id": "7778843394099",
+ "title": "Amalfi Umore Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700329"
+ ]
+ },
+ {
+ "id": "7778845196339",
+ "title": "Tori Blossom Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700361"
+ ]
+ },
+ {
+ "id": "7778845851699",
+ "title": "Herringbone Texture Ecru Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700382"
+ ]
+ },
+ {
+ "id": "7778845884467",
+ "title": "Linen Beige Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700383"
+ ]
+ },
+ {
+ "id": "7778845950003",
+ "title": "Orbit Deep Silver Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700386"
+ ]
+ },
+ {
+ "id": "7778847096883",
+ "title": "Meiying Mauve Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700423"
+ ]
+ },
+ {
+ "id": "7778847490099",
+ "title": "Basuto Teal Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700437"
+ ]
+ },
+ {
+ "id": "7778847522867",
+ "title": "Basuto Duck Egg Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700438"
+ ]
+ },
+ {
+ "id": "7778847785011",
+ "title": "Buckley Black & White Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700448"
+ ]
+ },
+ {
+ "id": "7778850144307",
+ "title": "Boreas Soft Grey Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700514"
+ ]
+ },
+ {
+ "id": "7778850177075",
+ "title": "Boreas Midnight Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700515"
+ ]
+ },
+ {
+ "id": "7778850209843",
+ "title": "Boreas Teal & Silver Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700516"
+ ]
+ },
+ {
+ "id": "7778851520563",
+ "title": "Midsummer Fern Black Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700566"
+ ]
+ },
+ {
+ "id": "7778851618867",
+ "title": "Midsummer Fern Navy Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700568"
+ ]
+ },
+ {
+ "id": "7778851651635",
+ "title": "Edo Toile Navy Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700569"
+ ]
+ },
+ {
+ "id": "7778859810867",
+ "title": "Clarissa Hulse Gypsophila Mocha & Silver Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700431"
+ ]
+ },
+ {
+ "id": "7778859876403",
+ "title": "Clarissa Hulse Meadow Grass Shell & Pewter Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700432"
+ ]
+ },
+ {
+ "id": "7778860040243",
+ "title": "Clarissa Hulse Tisbury Mother of Pearl Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-800889"
+ ]
+ },
+ {
+ "id": "7778860073011",
+ "title": "Clarissa Hulse Summer Border Blue Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-800890"
+ ]
+ },
+ {
+ "id": "7778860105779",
+ "title": "Clarissa Hulse Tisbury French Navy Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700439"
+ ]
+ },
+ {
+ "id": "7778860138547",
+ "title": "Clarissa Hulse Meadow Grass French Navy & Copper Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700440"
+ ]
+ },
+ {
+ "id": "7778860269619",
+ "title": "Clarissa Hulse Wild Chervil Dove & Silver Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700443"
+ ]
+ },
+ {
+ "id": "7778860302387",
+ "title": "Clarissa Hulse Gypsophila Airforce Blue & Soft Gold Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700444"
+ ]
+ },
+ {
+ "id": "7778860335155",
+ "title": "Clarissa Hulse Wild Chervil Sage & Gold Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700445"
+ ]
+ },
+ {
+ "id": "7778860400691",
+ "title": "Clarissa Hulse Summer Border Verdigris Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700447"
+ ]
+ },
+ {
+ "id": "7778860498995",
+ "title": "Clarissa Hulse Meadow Grass Teal & Soft Gold Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700450"
+ ]
+ },
+ {
+ "id": "7778860531763",
+ "title": "Clarissa Hulse Tisbury Teal Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700451"
+ ]
+ },
+ {
+ "id": "7778860597299",
+ "title": "Clarissa Hulse Wild Chervil Kingfisher & Gold Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700453"
+ ]
+ },
+ {
+ "id": "7778860695603",
+ "title": "Clarissa Hulse Meadow Grass Damson & Soft Gold Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "DWGB-700455"
+ ]
+ },
+ {
+ "id": "7778860990515",
+ "title": "Skulls Flock Black Wallcovering | Graham & Brown",
+ "variantCount": 1,
+ "skus": [
+ "SKL10155"
+ ]
+ }
+ ]
+}
\ No newline at end of file
diff --git a/scripts/live-missing-sample-enumerate.mjs b/scripts/live-missing-sample-enumerate.mjs
new file mode 100644
index 0000000..6199a55
--- /dev/null
+++ b/scripts/live-missing-sample-enumerate.mjs
@@ -0,0 +1,24 @@
+#!/usr/bin/env node
+// TK-10867 — READ-ONLY live enumeration of Graham & Brown ACTIVE products
+// lacking a "Sample" variant. GraphQL query ONLY — zero mutations. $0 (Admin API).
+import fs from 'fs';
+const SECRETS = '/Users/macstudio3/Projects/secrets-manager/.env';
+const DOMAIN = 'designer-laboratory-sandbox.myshopify.com';
+const TOKEN = fs.readFileSync(SECRETS,'utf8').match(/^SHOPIFY_ADMIN_TOKEN=(.+)$/m)[1].trim();
+const API = `https://${DOMAIN}/admin/api/2024-10/graphql.json`;
+async function gql(q,v){for(let a=0;a<4;a++){const r=await fetch(API,{method:'POST',headers:{'X-Shopify-Access-Token':TOKEN,'Content-Type':'application/json'},body:JSON.stringify({query:q,variables:v})});const j=await r.json();if(j.errors&&/throttl/i.test(JSON.stringify(j.errors))){await new Promise(s=>setTimeout(s,2000));continue;}return j;}throw new Error('throttled out');}
+const Q=`query($c:String){products(first:100,after:$c,query:"vendor:'Graham & Brown' status:active"){pageInfo{hasNextPage endCursor} nodes{id title variants(first:30){nodes{sku title selectedOptions{name value}}}}}}`;
+let cursor=null,active=0,missing=[],withSample=0;
+while(true){
+ const j=await gql(Q,{c:cursor});
+ const p=j.data?.products; if(!p){console.error('ERR',JSON.stringify(j.errors||j).slice(0,300));process.exit(1);}
+ for(const n of p.nodes){active++;
+ const hasSample=n.variants.nodes.some(v=>/sample/i.test(v.title)||/-sample$/i.test(v.sku||"")||v.selectedOptions.some(o=>/sample/i.test(o.value)));
+ if(hasSample)withSample++; else missing.push({id:n.id.split('/').pop(),title:n.title,variantCount:n.variants.nodes.length,skus:n.variants.nodes.map(v=>v.sku).filter(Boolean).slice(0,3)});
+ }
+ if(!p.pageInfo.hasNextPage)break; cursor=p.pageInfo.endCursor;
+}
+const out={ticket:'TK-10867',generated:new Date().toISOString(),store:DOMAIN,vendor:'Graham & Brown',active_count:active,with_sample:withSample,missing_sample_count:missing.length,missing_sample:missing};
+fs.writeFileSync('data/live-missing-sample.json',JSON.stringify(out,null,2));
+console.log(`GB ACTIVE=${active} withSample=${withSample} MISSING_SAMPLE=${missing.length}`);
+console.log(missing.slice(0,15).map(m=>` ${m.id} ${m.title} [${m.variantCount}var] ${m.skus.join(',')}`).join('\n'));
← ce9df48 add Graham and Brown dry-run hold plan
·
back to Tk 10867 Gb Safe Plan
·
TK-10867: add DW-spec Sample-variant executor for 81 GB acti a8ec80c →