← back to Dwjs Bolt Single Roll Fix
Add York/Brewster bolt audit: only Apartment Wallpaper(14) + Phillipe Romano/GPR(21) have bolt-leak signature; JS/LA Walls/B&Y/Fentucci all 0
2e35a0e40018dd4620757ee2c465b1cc780a3cac · 2026-06-29 09:24:58 -0700 · steve
Files touched
A bolt-audit.csvA scan-york-brewster.js
Diff
commit 2e35a0e40018dd4620757ee2c465b1cc780a3cac
Author: steve <steve@designerwallcoverings.com>
Date: Mon Jun 29 09:24:58 2026 -0700
Add York/Brewster bolt audit: only Apartment Wallpaper(14) + Phillipe Romano/GPR(21) have bolt-leak signature; JS/LA Walls/B&Y/Fentucci all 0
---
bolt-audit.csv | 152 ++++++++++++++++++++++++++++++++++++++++++++++++++
scan-york-brewster.js | 78 ++++++++++++++++++++++++++
2 files changed, 230 insertions(+)
diff --git a/bolt-audit.csv b/bolt-audit.csv
new file mode 100644
index 0000000..10b741f
--- /dev/null
+++ b/bolt-audit.csv
@@ -0,0 +1,152 @@
+vendor,handle,sku,price,option,leak
+Apartment Wallpaper,dwjs-17579,DWJS-17579,60.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17581,DWJS-17581,31.86,Price Per Bolt,LEAK?
+Apartment Wallpaper,dwjs-17588,DWJS-17588,31.86,Price Per Bolt,LEAK?
+Apartment Wallpaper,dwjs-17618,DWJS-17618,31.86,Price Per Bolt,LEAK?
+Apartment Wallpaper,dwjs-17619,DWJS-17619,60.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17621,DWJS-17621,31.86,Price Per Bolt,LEAK?
+Apartment Wallpaper,dwjs-17627,DWJS-17627,60.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17629,DWJS-17629,31.86,Price Per Bolt,LEAK?
+Apartment Wallpaper,dwjs-17630,DWJS-17630,31.86,Price Per Bolt,LEAK?
+Apartment Wallpaper,dwjs-17633,DWJS-17633,31.86,Price Per Bolt,LEAK?
+Apartment Wallpaper,dwjs-17635,DWJS-17635,60.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17641,DWJS-17641,60.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17644,DWJS-17644,31.86,Price Per Bolt,LEAK?
+Apartment Wallpaper,dwjs-17721,DWJS-17721,34.31,Price Per Bolt,LEAK?
+Apartment Wallpaper,dwjs-17726,DWJS-17726,65.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17729,DWJS-17729,65.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17731,DWJS-17731,65.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17734,DWJS-17734,65.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17735,DWJS-17735,65.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17736,DWJS-17736,65.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17739,DWJS-17739,65.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17743,DWJS-17743,65.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17756,DWJS-17756,34.31,Price Per Bolt,LEAK?
+Apartment Wallpaper,dwjs-17760,DWJS-17760,31.86,Price Per Bolt,LEAK?
+Apartment Wallpaper,dwjs-17765,DWJS-17765,65.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17768,DWJS-17768,65.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17769,DWJS-17769,65.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17770,DWJS-17770,65.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17771,DWJS-17771,65.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17772,DWJS-17772,60.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17773,DWJS-17773,60.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17774,DWJS-17774,60.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17775,DWJS-17775,60.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17776,DWJS-17776,65.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17777,DWJS-17777,60.00,Price Per Bolt,bolt-priced
+Apartment Wallpaper,dwjs-17779,DWJS-17779,31.86,Price Per Bolt,LEAK?
+Apartment Wallpaper,dwjs-17780,DWJS-17780,31.86,Price Per Bolt,LEAK?
+Apartment Wallpaper,dwjs-17781,DWJS-17781,34.31,Price Per Bolt,LEAK?
+Phillipe Romano,retro-velvet-flocked-wallpapers-flock-9000,FLOCK-9000,263.76,Sold per Bolt,bolt-priced
+Phillipe Romano,retro-velvet-flocked-wallpapers-flock-9006,FLOCK-9006,263.76,Sold per Bolt,bolt-priced
+Phillipe Romano,couture-leopard-flocked-velvet-02-java-brown-fdo-100,FDO-100,248.53,Sold per Bolt,bolt-priced
+Phillipe Romano,stacy-s-hot-pink-damask-wallpaper-pri-3700,PRI-3700,72.65,Sold per bolt,bolt-priced
+Phillipe Romano,skully-skulls-wallpaper-bronze-on-oil-slick-skl-300,SKL-300,910.00,Sold per Bolt,bolt-priced
+Phillipe Romano,birds-in-paradise-wallpaper-ele-42511,ELE-42511,169.71,Sold in Bolts Only,bolt-priced
+Phillipe Romano,birds-in-paradise-wallpaper-ele-42514,ELE-42514,169.71,Sold in Bolts Only,bolt-priced
+Phillipe Romano,forest-tree-wallpaper-ele-42543,ELE-42543,161.86,Sold in Bolts Only,bolt-priced
+Phillipe Romano,forest-tree-wallpaper-ele-42547,ELE-42547,161.86,Sold in Bolts Only,bolt-priced
+Phillipe Romano,bouquet-tile-print-wallpaper-ele-42548,ELE-42548,161.86,Sold in Bolts Only,bolt-priced
+Phillipe Romano,bouquet-tile-print-wallpaper-ele-42550,ELE-42550,161.86,Sold in Bolts Only,bolt-priced
+Phillipe Romano,bouquet-tile-print-wallpaper-ele-42551,ELE-42551,161.86,Sold in Bolts Only,bolt-priced
+Phillipe Romano,braga-cork-wallcovering-cork-805,CORK-805,404.41,Sold Per Bolt,bolt-priced
+Phillipe Romano,espanoza-cork-wallcovering-cork-806,CORK-806,404.41,Sold Per Bolt,bolt-priced
+Phillipe Romano,reynoso-cork-wallcovering-cork-807,CORK-807,404.41,Sold Per Bolt,bolt-priced
+Phillipe Romano,suarez-cork-wallcovering-cork-809,CORK-809,404.41,Sold Per Bolt,bolt-priced
+Phillipe Romano,medelin-cork-wallcovering-cork-817,CORK-817,357.88,Sold Per Bolt,bolt-priced
+Phillipe Romano,florenza-cork-wallcovering-cork-823,CORK-823,381.41,Sold Per Bolt,bolt-priced
+Phillipe Romano,gregoria-cork-wallcovering-cork-825,CORK-825,357.88,Sold Per Bolt,bolt-priced
+Phillipe Romano,lafayette-cork-wallcovering-cork-826,CORK-826,357.88,Sold Per Bolt,bolt-priced
+Phillipe Romano,carolina-cork-wallcovering-cork-827,CORK-827,357.88,Sold Per Bolt,bolt-priced
+Phillipe Romano,rick-rack-rock-and-roll-diamond-3d-flock-wallpaper-rto-34623,RTO-34623,61.06,Sold Per Double Roll Bolt,bolt-priced
+Phillipe Romano,ala-lazio-wallpaper-ele-42700,ELE-42700,171.52,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-lazio-wallpaper-ele-42701,ELE-42701,171.52,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-lombardy-wallpaper-ele-42703,ELE-42703,162.47,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-lombardy-wallpaper-ele-42704,ELE-42704,162.47,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-lombardy-wallpaper-ele-42705,ELE-42705,162.47,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-lombardy-wallpaper-ele-42706,ELE-42706,162.47,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-campania-wallpaper-ele-42707,ELE-42707,162.47,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-dulce-european-wallpaper-ele-42708,ELE-42708,162.47,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-liguria-wallpaper-ele-42709,ELE-42709,162.47,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-dulce-european-wallpaper-ele-42710,ELE-42710,162.47,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-ligurio-wallpaper-ele-42711,ELE-42711,162.47,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-tuscany-wallpaper-ele-42712,ELE-42712,120.84,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-veneto-wallpaper-ele-42713,ELE-42713,173.33,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-veneto-wallpaper-ele-42714,ELE-42714,173.33,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-apulia-wallpaper-ele-42716,ELE-42716,173.33,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-apulia-wallpaper-ele-42717,ELE-42717,173.33,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-apulia-wallpaper-ele-42718,ELE-42718,173.33,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-apulia-wallpaper-ele-42719,ELE-42719,173.33,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-genoa-wallpaper-ele-42720,ELE-42720,173.33,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-genoa-wallpaper-ele-42721,ELE-42721,173.33,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-bari-wallpaper-ele-42722,ELE-42722,292.78,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-messina-wallpaper-ele-42730,ELE-42730,169.71,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-messina-wallpaper-ele-42731,ELE-42731,169.71,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-padua-wallpaper-ele-42733,ELE-42733,169.71,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-padua-wallpaper-ele-42734,ELE-42734,169.71,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-padua-wallpaper-ele-42735,ELE-42735,169.71,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-taranto-wallpaper-ele-42737,ELE-42737,158.85,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-taranto-wallpaper-ele-42738,ELE-42738,158.85,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-taranto-wallpaper-ele-42739,ELE-42739,158.85,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-taranto-wallpaper-ele-42740,ELE-42740,158.85,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-taranto-wallpaper-ele-42741,ELE-42741,158.85,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-taranto-wallpaper-ele-42742,ELE-42742,158.85,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-prato-wallpaper-ele-42743,ELE-42743,220.38,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-prato-wallpaper-ele-42744,ELE-42744,220.38,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-parma-wallpaper-ele-42745,ELE-42745,173.33,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-parma-wallpaper-ele-42746,ELE-42746,173.33,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-reggio-wallpaper-ele-42747,ELE-42747,372.42,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-reggio-wallpaper-ele-42748,ELE-42748,372.42,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-reggio-wallpaper-ele-42749,ELE-42749,372.42,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-modena-wallpaper-ele-42750,ELE-42750,826.72,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-perugia-wallpaper-ele-42751,ELE-42751,231.24,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-perugia-wallpaper-ele-42752,ELE-42752,231.24,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-perugia-wallpaper-ele-42753,ELE-42753,231.24,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-perugia-wallpaper-ele-42754,ELE-42754,231.24,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-perugia-wallpaper-ele-42755,ELE-42755,231.24,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-perugia-wallpaper-ele-42756,ELE-42756,231.24,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-perugia-wallpaper-ele-42757,ELE-42757,231.24,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-ferrara-wallpaper-ele-42763,ELE-42763,191.43,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-ferrara-wallpaper-ele-42764,ELE-42764,191.43,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-sassari-wallppaer-ele-42765,ELE-42765,412.24,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-sassari-wallppaer-ele-42766,ELE-42766,412.24,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-sassari-wallppaer-ele-42767,ELE-42767,412.24,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-sassari-wallppaer-ele-42768,ELE-42768,412.24,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-brescia-wallpaper-ele-42785,ELE-42785,48.44,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-brescia-wallpaper-ele-42786,ELE-42786,48.44,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-rimimi-wallpaper-ele-42828,ELE-42828,191.43,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-rimimi-wallpaper-ele-42829,ELE-42829,191.43,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-forliata-wallpaper-ele-42864,ELE-42864,195.05,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-tigre-ele-42911,ELE-42911,456.11,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-dulcivita-ele-42916,ELE-42916,194.75,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-modena-noche-ele-42937,ELE-42937,177.50,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-hexagon-wallpaper-ele-42865,ELE-42865,181.41,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-hexagon-wallpaper-ele-42866,ELE-42866,181.41,Sold in Bolts Only,bolt-priced
+Phillipe Romano,ala-hexagon-wallpaper-ele-42867,ELE-42867,181.41,Sold in Bolts Only,bolt-priced
+Phillipe Romano,annecy-wallpaper-xl2-68009,XL2-68009,55.00,Sold Per Yard - 8 yard bolts only,bolt-priced
+Phillipe Romano,annecy-wallpaper-xl2-68010,XL2-68010,55.00,Sold Per Yard - 8 yard bolts only,bolt-priced
+Phillipe Romano,annecy-wallpaper-xl2-68011,XL2-68011,55.00,Sold Per Yard - 8 yard bolts only,bolt-priced
+Phillipe Romano,annecy-wallpaper-xl2-68012,XL2-68012,55.00,Sold Per Yard - 8 yard bolts only,bolt-priced
+Phillipe Romano,annecy-wallpaper-xl2-68013,XL2-68013,55.00,Sold Per Yard - 8 yard bolts only,bolt-priced
+Phillipe Romano,origami-glam-folded-wallpaper-gpr-76567,GPR-76567,39.49,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,origami-glam-folded-wallpaper-gpr-76570,GPR-76570,34.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,georgio-glam-pleated-panel-gpr-76574,GPR-76574,34.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,georgio-glam-pleated-panel-gpr-76575,GPR-76575,34.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,glam-striated-stripe-wallpaper-gpr-76578,GPR-76578,33.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,glam-striated-stripe-wallpaper-gpr-76579,GPR-76579,33.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,glam-faux-stripe-wallpaper-gpr-76582,GPR-76582,33.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,glam-faux-stripe-wallpaper-gpr-76585,GPR-76585,40.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,shagreen-glam-shark-skin-galuchat-wallpaper-gpr-76588,GPR-76588,27.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,shagreen-glam-shark-skin-galuchat-wallpaper-gpr-76589,GPR-76589,27.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,glam-skin-faux-animal-skin-gpr-76600,GPR-76600,27.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,glam-skin-faux-animal-skin-gpr-76601,GPR-76601,27.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,glam-dragon-wallpaper-gpr-76602,GPR-76602,27.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,glam-dragon-wallpaper-gpr-76603,GPR-76603,27.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,glam-dragon-wallpaper-gpr-76604,GPR-76604,27.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,gilead-glam-vinyl-wallpaper-gpr-76605,GPR-76605,40.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,gilead-glam-vinyl-wallpaper-gpr-76606,GPR-76606,40.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,beijing-glam-water-color-faux-silk-gpr-76607,GPR-76607,40.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,beijing-glam-water-color-faux-silk-gpr-76608,GPR-76608,40.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,beijing-glam-water-color-faux-silk-gpr-76609,GPR-76609,40.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,beijing-glam-water-color-faux-silk-gpr-76610,GPR-76610,40.95,Sold Per Yard - 11 yard bolts only,LEAK?
+Phillipe Romano,shoji-panels-gpr-76611,GPR-76611,1236.37,Sold Per Yard - 11 yard bolts only,bolt-priced
\ No newline at end of file
diff --git a/scan-york-brewster.js b/scan-york-brewster.js
new file mode 100644
index 0000000..124ddcb
--- /dev/null
+++ b/scan-york-brewster.js
@@ -0,0 +1,78 @@
+#!/usr/bin/env node
+/*
+ * scan-york-brewster.js — READ-ONLY audit. Finds every live variant whose option
+ * value contains "bolt" across the York/Brewster house lines, records its price,
+ * and flags single-roll-priced bolts (the below-cost leak signature).
+ * Writes nothing to Shopify. Output: bolt-audit.csv + a console summary.
+ */
+'use strict';
+const fs = require('fs'); const path = require('path');
+const ENV = path.join(process.env.HOME, 'Projects/Designer-Wallcoverings/shopify/.env');
+const env = k => { try { const l = fs.readFileSync(ENV,'utf8').split('\n').find(x=>x.startsWith(k+'=')); return l?l.slice(k.length+1).trim():process.env[k]; } catch { return process.env[k]; } };
+const TOKEN = env('SHOPIFY_ADMIN_TOKEN');
+const STORE = env('SHOPIFY_STORE_DOMAIN') || 'designer-laboratory-sandbox.myshopify.com';
+const API = '2024-10';
+const sleep = ms => new Promise(r=>setTimeout(r,ms));
+
+// York/Brewster house lines (Phillipe Romano included to SEE if it has bolt variants)
+const VENDORS = ['Jeffrey Stevens','LA Walls','Apartment Wallpaper','Brewster & York','Fentucci','Phillipe Romano'];
+const LEAK_MAX = 45; // a "Per Bolt" variant priced below this is single-roll-priced => leak suspect
+
+async function gql(query, variables){
+ for (let a=0;a<6;a++){
+ const r = await fetch(`https://${STORE}/admin/api/${API}/graphql.json`,{method:'POST',
+ headers:{'X-Shopify-Access-Token':TOKEN,'Content-Type':'application/json'},
+ body:JSON.stringify({query,variables})});
+ const j = await r.json();
+ if (j.errors && JSON.stringify(j.errors).includes('THROTTLED')){ await sleep(2000); continue; }
+ if (j.errors) throw new Error(JSON.stringify(j.errors));
+ return j.data;
+ }
+ throw new Error('throttled out');
+}
+
+const Q = `query($q:String!,$cursor:String){ products(first:50, query:$q, after:$cursor){
+ pageInfo{ hasNextPage endCursor }
+ edges{ node{ id vendor handle
+ variants(first:15){ edges{ node{ sku price selectedOptions{ name value } } } } } } } }`;
+
+(async () => {
+ if (!TOKEN) { console.error('no token'); process.exit(1); }
+ const rows = [];
+ for (const v of VENDORS){
+ let cursor=null, page=0, vendorHits=0;
+ do {
+ const d = await gql(Q, { q:`vendor:'${v.replace(/'/g,"")}' status:active`, cursor });
+ const conn = d.products;
+ for (const e of conn.edges){
+ const p = e.node;
+ for (const ve of p.variants.edges){
+ const n = ve.node;
+ const opt = n.selectedOptions.map(o=>o.value).join(' ');
+ if (/bolt/i.test(opt)){
+ const price = parseFloat(n.price);
+ rows.push({ vendor:p.vendor, handle:p.handle, sku:n.sku||'', price:n.price,
+ option:opt, leak: price < LEAK_MAX ? 'LEAK?' : 'bolt-priced' });
+ vendorHits++;
+ }
+ }
+ }
+ cursor = conn.pageInfo.hasNextPage ? conn.pageInfo.endCursor : null;
+ page++; await sleep(400);
+ } while (cursor);
+ console.log(` ${v}: ${vendorHits} bolt variants (${page} pages)`);
+ }
+ // write csv
+ const cols=['vendor','handle','sku','price','option','leak'];
+ fs.writeFileSync(path.join(__dirname,'bolt-audit.csv'),
+ cols.join(',')+'\n'+rows.map(r=>cols.map(c=>String(r[c]).replace(/,/g,' ')).join(',')).join('\n'));
+ // summary
+ console.log(`\n=== ${rows.length} total "Per Bolt" variants across York/Brewster ===`);
+ const byVL = {};
+ for (const r of rows){ const k=`${r.vendor} | ${r.leak}`; byVL[k]=(byVL[k]||0)+1; }
+ Object.entries(byVL).sort().forEach(([k,c])=>console.log(` ${c.toString().padStart(5)} ${k}`));
+ const leaks = rows.filter(r=>r.leak==='LEAK?');
+ console.log(`\nLEAK SUSPECTS (Per Bolt priced < $${LEAK_MAX}): ${leaks.length}`);
+ const pc={}; leaks.forEach(r=>{pc[r.price]=(pc[r.price]||0)+1;});
+ Object.entries(pc).sort((a,b)=>b[1]-a[1]).slice(0,12).forEach(([p,c])=>console.log(` ${c.toString().padStart(4)} @ $${p}`));
+})().catch(e=>{console.error('ERR',e.message);process.exit(1);});
← 607694a DWJS peel&stick bolt→single-roll leak fix: staged gated exec
·
back to Dwjs Bolt Single Roll Fix
·
APPLIED LIVE: Apartment Wallpaper 38 SKUs bolt→single-roll @ 33a040c →