auto-save: 2026-07-09T08:39:40 (1 files) — _diag425-tmp.js

282cc637837c17e203c48ed1cb76cfde5c1a7d23 · 2026-07-09 08:39:49 -0700 · Steve Abrams

Files touched

D _diag425-tmp.js

Diff

commit 282cc637837c17e203c48ed1cb76cfde5c1a7d23
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Thu Jul 9 08:39:49 2026 -0700

    auto-save: 2026-07-09T08:39:40 (1 files) — _diag425-tmp.js
---
 _diag425-tmp.js | 31 -------------------------------
 1 file changed, 31 deletions(-)

diff --git a/_diag425-tmp.js b/_diag425-tmp.js
deleted file mode 100644
index c8e2e5a..0000000
--- a/_diag425-tmp.js
+++ /dev/null
@@ -1,31 +0,0 @@
-const {token,MERCHANT}=require('./_auth.js');
-const fs=require('fs');
-// load feed skus
-const lines=fs.readFileSync('/Users/macstudio3/Projects/designerwallcoverings/today-viewer/data/google-merchant-feed.tsv','utf8').split('\n');
-const cols=lines[0].split('\t'); const iId=cols.indexOf('id');
-const feedSkus=new Set(); for(let i=1;i<lines.length;i++){if(lines[i]){const s=lines[i].split('\t')[iId]; if(s)feedSkus.add(s);}}
-(async()=>{
-  const t=await token(); const H={Authorization:'Bearer '+t};
-  let page=null,scanned=0,n425=0,sampleSku=0,baseInFeed=0,baseNotInFeed=0; const ex=[];
-  do{
-    const r=await (await fetch(`https://shoppingcontent.googleapis.com/content/v2.1/${MERCHANT}/products?maxResults=250`+(page?`&pageToken=${page}`:''),{headers:H})).json();
-    if(r.error)break;
-    for(const p of (r.resources||[])){
-      scanned++;
-      const price=parseFloat(p.price?.value||'0');
-      if(Math.abs(price-4.25)<0.01){ n425++;
-        const mpn=p.mpn||''; const isSampleSku=/sample/i.test(mpn)||/sample/i.test(p.offerId||'');
-        const base=mpn.replace(/-?sample.*$/i,'');
-        if(isSampleSku)sampleSku++; else if(feedSkus.has(base)||feedSkus.has(mpn))baseInFeed++; else baseNotInFeed++;
-        if(ex.length<12)ex.push(`offerId=${(p.offerId||'').slice(0,45)} | mpn=${mpn} | ${isSampleSku?'SAMPLE-SKU':feedSkus.has(base)?'BASE-IN-FEED':'NO-MATCH'} | ${(p.title||'').slice(0,35)}`);
-      }
-    }
-    page=r.nextPageToken;
-    if(scanned>=20000)break;
-  }while(page);
-  console.log(`sampled ${scanned} offers, ${n425} at $4.25`);
-  console.log(`  sample-SKU offers (mpn/offerId contains 'sample'): ${sampleSku}`);
-  console.log(`  base-sku IS in feed (roll exists, this is its sample): ${baseInFeed}`);
-  console.log(`  genuinely no match: ${baseNotInFeed}`);
-  console.log('--- examples ---'); ex.forEach(e=>console.log('  '+e));
-})().catch(e=>console.error('FATAL',e.message));

← a04456a auto-save: 2026-07-09T08:09:34 (2 files) — _diag425-tmp.js g · back to Gmc Titlefix · add gmc price-override + shipping-weight-override generators 0cd0040 →