Romo 339 cost backfill: pulled current trade prices from theromogroup.com (MAX roll, 44/45 reconcile), loaded 844 colorway rows, regenerated push worklist (332)

d05c6b584539236f3ed38693a26caca1920f72f7 · 2026-06-11 15:12:04 -0700 · SteveStudio2
Files touched

A shopify/scripts/data/romo-cost-backfill/load-pulled-costs.js
A shopify/scripts/data/romo-cost-backfill/romo-roll-push-pending-20260611.csv
A shopify/scripts/data/romo-cost-backfill/romo-trade-puller-v3.js
Diff

commit d05c6b584539236f3ed38693a26caca1920f72f7
Author: SteveStudio2 <steve@designerwallcoverings.com>
Date:   Thu Jun 11 15:12:04 2026 -0700

    Romo 339 cost backfill: pulled current trade prices from theromogroup.com (MAX roll, 44/45 reconcile), loaded 844 colorway rows, regenerated push worklist (332)
---
 .../data/romo-cost-backfill/load-pulled-costs.js   |  34 +++
 .../romo-roll-push-pending-20260611.csv            | 333 +++++++++++++++++++++
 .../romo-cost-backfill/romo-trade-puller-v3.js     |  45 +++
 3 files changed, 412 insertions(+)

diff --git a/shopify/scripts/data/romo-cost-backfill/load-pulled-costs.js b/shopify/scripts/data/romo-cost-backfill/load-pulled-costs.js
new file mode 100644
index 00000000..73992df0
--- /dev/null
+++ b/shopify/scripts/data/romo-cost-backfill/load-pulled-costs.js
@@ -0,0 +1,34 @@
+#!/usr/bin/env node
+// Load v3 browserbase-pulled Romo trade prices into romo_catalog (dw_unified FIRST).
+// Source: /tmp/romo_pulled_v3.jsonl. landed = MAX "Total Price Per Roll" (landed cost
+// incl 5% tariff, read directly off the trade PDP). trade = landed/1.05.
+const { execFileSync } = require('child_process');
+const fs = require('fs');
+const psql = sql => execFileSync('psql', ['-d','dw_unified','-At','-F','\t','-c',sql], {encoding:'utf8'}).trim();
+
+const rows = fs.readFileSync('/tmp/romo_pulled_v3.jsonl','utf8').trim().split('\n')
+  .map(l=>{try{return JSON.parse(l)}catch{return null}}).filter(Boolean);
+const unc = rows.filter(r => !r.known && r.landed>0 && r.unit==='roll');
+const yardOnly = rows.filter(r => !r.known && !r.landed && r.unit==='yard');
+const noProd = rows.filter(r => !r.known && r.err);
+console.log(`uncosted pulled: roll-priced=${unc.length} | yard-only=${yardOnly.length} | not-on-site=${noProd.length}`);
+
+let loaded=0, skip=0;
+for (const r of unc) {
+  const landed = +r.landed;
+  const trade = Math.round((landed/1.05)*100)/100;
+  if (landed < 30 || landed > 20000) { skip++; continue; }  // sanity envelope
+  const base = r.base.replace(/'/g,"''");
+  const out = psql(`UPDATE romo_catalog
+     SET trade_price_per_roll=${trade}, tariff_pct=5,
+         total_price_per_roll=${landed}, net_cost=${landed},
+         our_price=round((${landed}/0.65/0.85)::numeric,2),
+         price_updated_at=CURRENT_DATE
+     WHERE split_part(mfr_sku,'/',1)='${base}'
+       AND COALESCE(NULLIF(total_price_per_roll,0),0)=0
+     RETURNING id;`);
+  loaded += out ? out.split('\n').filter(Boolean).length : 0;
+}
+console.log(`LOADED onto ${loaded} colorway rows (skipped ${skip}).`);
+if (yardOnly.length) console.log('YARD-ONLY (review):', yardOnly.map(r=>r.base).join(','));
+if (noProd.length) console.log('NOT-ON-SITE (discontinued?):', noProd.map(r=>r.base).join(','));
diff --git a/shopify/scripts/data/romo-cost-backfill/romo-roll-push-pending-20260611.csv b/shopify/scripts/data/romo-cost-backfill/romo-roll-push-pending-20260611.csv
new file mode 100644
index 00000000..81a2f823
--- /dev/null
+++ b/shopify/scripts/data/romo-cost-backfill/romo-roll-push-pending-20260611.csv
@@ -0,0 +1,333 @@
+shopify_id,dw_sku,mfr_sku,pattern_name,color_name,cost,retail
+7787384733747,DWRM-240190,MW145/03,Medina,Indigo,2467.50,4466.06
+7781624971315,DWRM-240188,MW145/01,Medina,Whitewash,2467.50,4466.06
+7787383586867,DWRM-240155,MW137/04,Koshi,teal,1798.65,3255.48
+7781618581555,DWRM-240152,MW137/01,Koshi Jasper,White,1798.65,3255.48
+7789366313011,DWRM-240141,MW134/03,Root,Shale,1605.45,2905.79
+7787383652403,DWRM-240163,MW139/04,Abacá Patchwork,Typhoon,1302.00,2356.56
+7780861706291,DWRM-240164,MW139/05,Abacá Patchwork,Pewter,1302.00,2356.56
+7780862722099,DWRM-240165,MW139/06,Abacá Patchwork,Alabaster,1302.00,2356.56
+7786991517747,DWRM-240161,MW139/02,Abacá Patchwork,Gris,1302.00,2356.56
+7780862623795,DWRM-240115,MW124/02,Synamay,Mist,1177.05,2130.41
+7781633294387,DWRM-240084,MW114/02,Square Cut,Parchment,1172.60,2122.35
+7781647679539,DWRM-240088,MW116/02,Network,Nutmeg,1165.50,2109.50
+7785759866931,DWRM-241216,W934/01,Zalea,Oxide,1126.40,2038.73
+7789605290035,DWRM-241218,W934/03,Zalea,Jasper,1126.40,2038.73
+7786027909171,DWRM-241372,WK815/02,Reclaim Wall Mural,Clay,992.25,1795.93
+7789367656499,DWRM-240171,MW141/04,Hyacinth,Indigo,985.95,1784.52
+7785761931315,DWRM-240168,MW141/01,Hyacinth,Harvest,985.95,1784.52
+7789364674611,DWRM-241283,W960/03,Ruhani,Serpentine,978.60,1771.22
+7780864917555,DWRM-241517,ZW142/01,Lacquer,Vellum,968.10,1752.22
+7780864557107,DWRM-241270,W954/04,Contour,Avocet,968.10,1752.22
+7781583847475,DWRM-241268,W954/02,Contour,Stucco,968.10,1752.22
+7786026467379,DWRM-241269,W954/03,Contour,Soapstone,968.10,1752.22
+7786026303539,DWRM-241521,ZW142/05,Lacquer,Obsidian,968.10,1752.22
+7784982118451,DWRM-241526,ZW142/10,Lacquer,Racing,968.10,1752.22
+7785760063539,DWRM-241523,ZW142/07,Lacquer,Cognac,968.10,1752.22
+7785762488371,DWRM-241412,WK822/04,Solid Burnt,Orange,950.40,1720.18
+7786991321139,DWRM-241407,WK821/05,Jagged Roses,Teal,950.40,1720.18
+7785760522291,DWRM-241411,WK822/03,Solid Pink,Apricot,950.40,1720.18
+7786985291827,DWRM-240112,MW123/04,Washi,Stoneware,949.20,1718.01
+7789366345779,DWRM-240111,MW123/03,Washi,Metal,949.20,1718.01
+7785762357299,DWRM-241247,W948/01,Figura,Ashlar,946.05,1712.31
+7787384799283,DWRM-241248,W948/02,Figura,Verdure,946.05,1712.31
+7789364609075,DWRM-241241,W944/02,Makona,Kaitoke,912.45,1651.49
+7786029023283,DWRM-241226,W938/03,Imicu,Ash,912.45,1651.49
+7784993194035,DWRM-241244,W946/01,Mysa,Oro,894.60,1619.19
+7786028859443,DWRM-241245,W946/02,Mysa,Pewter,894.60,1619.19
+7780171087923,DWRM-241514,ZW141/06,Sueded Electric,Teal,883.30,1598.73
+7789367918643,DWRM-241516,ZW141/08,Sueded,copper,883.30,1598.73
+7786988765235,DWRM-241496,ZW134/08,Cazenove,Umber,852.60,1543.17
+7780171022387,DWRM-241498,ZW134/11,Cazenove,Cerulean,852.60,1543.17
+7785758916659,DWRM-241494,ZW134/03,Cazenove,Linen,852.60,1543.17
+7780863148083,DWRM-241492,ZW134/01,Cazenove Silver,Grey,852.60,1543.17
+7789601849395,DWRM-241501,ZW135/04,Zorelli,Sunset,852.60,1543.17
+7785064497203,DWRM-241402,WK820/07,Flash,Stone,804.10,1455.38
+7780862132275,DWRM-241398,WK820/03,Flash,Pistachio,804.10,1455.38
+7786025746483,DWRM-241364,WK813/02,Vandal Wall Mural,Monochrome,803.25,1453.85
+7786991747123,DWRM-241366,WK813/04,Vandal Wall Mural,Sienna,803.25,1453.85
+7781622612019,DWRM-240172,MW142/01,Duo Abacá,Atmosphere,792.00,1433.48
+7787384307763,DWRM-240175,MW142/04,Duo Abacá,Tempest,792.00,1433.48
+7785759047731,DWRM-241361,WK812/07,Glade,Jute,754.95,1366.43
+7786028269619,DWRM-241357,WK812/02,Glade,beige,754.95,1366.43
+7789364576307,DWRM-241276,W958/01,Ebru,Verdure,723.45,1309.41
+7786025779251,DWRM-241250,W949/01,Quadrata,Oxide,647.85,1172.58
+7780864622643,DWRM-240014,MW102/01,Savanna,Shell,610.50,1104.98
+7785016492083,DWRM-241235,W942/02,Jackson,Steel,598.50,1083.26
+7781645778995,DWRM-240235,MW155/03,Tama,Parchment,585.20,1059.19
+7786027057203,DWRM-240236,MW155/04,Tama,Pewter,585.20,1059.19
+7789364969523,DWRM-240237,MW155/05,Tama,Typhoon,585.20,1059.19
+7781672026163,DWRM-241375,WK816/02,Blend,Desert,544.95,986.33
+7787380768819,DWRM-240024,MW104/03,Akata,Storm,542.30,981.54
+7780864950323,DWRM-241297,W965/03,Mizu,Shadow,530.25,959.73
+7781643681843,DWRM-240227,MW153/02,Maze,Powder,530.20,959.64
+7785761800243,DWRM-240229,MW153/04,Maze,Indigo,530.20,959.64
+7786027810867,DWRM-241482,ZW129/04,Oolite Foil Night,charcoal gray,521.40,943.71
+7780863311923,DWRM-241534,ZW144/01,Oolite Matt,Stone,521.40,943.71
+7786025812019,DWRM-241540,ZW144/07,Oolite Matt,Obsidian,521.40,943.71
+7785762619443,DWRM-241488,ZW133/02,Edenite,Oyster,512.60,927.78
+7787382177843,DWRM-241196,W927/03,Orimono,Lotus,511.35,925.52
+7789365493811,DWRM-240203,MW148/06,Arrowroot,Typhoon,500.50,905.88
+7786991910963,DWRM-240199,MW148/02,Arrowroot Pale,Celadon,500.50,905.88
+7789366378547,DWRM-240202,MW148/05,Arrowroot,Metal,500.50,905.88
+7786991190067,DWRM-240200,MW148/03,Arrowroot,Tempest,500.50,905.88
+7785764257843,DWRM-241486,ZW132/03,Tantalum Silver,Grey,476.30,862.08
+7780861640755,DWRM-241483,ZW131/02,Monazite,Cerulean,476.30,862.08
+7781635031091,DWRM-240017,MW103/01,Raffia,Canvas,475.20,860.09
+7786027614259,DWRM-241266,W953/02,Sieta,Indium,473.55,857.10
+7786985652275,DWRM-240254,MW158/05,Offset,Loam,471.90,854.12
+7785055617075,DWRM-240251,MW157/07,Odyssey,Typhoon,469.70,850.14
+7781583585331,DWRM-240246,MW157/02,Odyssey,ivory,469.70,850.14
+7787381063731,DWRM-240006,MW100/06,Abaca,Lake,467.50,846.15
+7781650006067,DWRM-240004,MW100/04,Abaca,Sepia,467.50,846.15
+7785057648691,DWRM-240211,MW150/04,Wicker Dark,Teal,466.40,844.16
+7781631459379,DWRM-240208,MW150/01,Wicker,Whitewash,466.40,844.16
+7785762521139,DWRM-241466,ZW126/03,Jurbanite,Spacedust,454.30,822.26
+7786991845427,DWRM-240122,MW128/02,Panama,Dove,416.90,754.57
+7787381588019,DWRM-240056,MW110/03,Kami,Lake,408.10,738.64
+7786986045491,DWRM-240242,MW156/04,Facet,Chestnut,407.00,736.65
+7786991878195,DWRM-240240,MW156/02,Facet,Lake,407.00,736.65
+7787381391411,DWRM-240061,MW111/02,Papier,Lake,393.80,712.76
+7786985848883,DWRM-240066,MW111/07,Papier,Heath,393.80,712.76
+7785059713075,DWRM-240062,MW111/03,Papier,Atlantic,393.80,712.76
+7785762652211,DWRM-241472,ZW127/02,Trona,Spacedust,386.10,698.82
+7780863213619,DWRM-240026,MW105/01,Sisal,Alabaster,379.50,686.88
+7787381981235,DWRM-240031,MW105/06,Sisal,Lake,379.50,686.88
+7787381948467,DWRM-240028,MW105/03,Sisal Pale,Celadon,379.50,686.88
+7780864327731,DWRM-241198,W928/02,Marazzi,Peacock,374.85,678.46
+7786382295091,DWRM-241199,W928/03,Marazzi,Amazonia,374.85,678.46
+7786028073011,DWRM-241334,WK807/02,Peg Art Roses,Blush,330.75,598.64
+7785760129075,DWRM-241183,W923/02,Tomoko,Oxide,312.90,566.33
+7785044967475,DWRM-241055,W624/02,Shift Wall Mural,Silica,284.55,515.02
+7781601017907,DWRM-241052,W623/01,Drifting Wall Mural,gray,284.55,515.02
+7780865179699,DWRM-241452,WK829/05,Fragment,Chalk,268.80,486.52
+7789368082483,DWRM-241434,WK826/04,Stars,Pistachio,264.60,478.91
+7784984215603,DWRM-241435,WK826/05,Stars,Sunshine,264.60,478.91
+7820140904499,ROP-74585,W969/11,Seres,Ink,261.45,473.21
+7820140806195,ROP-74584,W969/10,Seres,Cacao,261.45,473.21
+7785762455603,DWRM-241423,WK824/05,Scribble,teal,254.10,459.91
+7785762226227,DWRM-241173,W920/03,Utsuro,Magma,231.00,418.10
+7780861739059,DWRM-240539,W445/03,Aula,Shibori,216.30,391.49
+7785007415347,DWRM-240541,W446/02,Sayuri Wild,Rose,216.30,391.49
+7786026369075,DWRM-240540,W446/01,Sayuri,Niebla,216.30,391.49
+7781591777331,DWRM-240529,W443/01,Odelia,Silver,216.30,391.49
+7781604261939,DWRM-240481,W435/01,Kali,Egret,215.25,389.59
+7785759178803,DWRM-241439,WK827/03,Checkerboard,Chai,213.15,385.79
+7786028171315,DWRM-241441,WK827/05,Checkerboard Pink,Apricot,213.15,385.79
+7786026598451,DWRM-240308,W398/03,Merletto,Indium,203.70,368.69
+7785051226163,DWRM-241344,WK810/03,Zig Zag Birds,Powder,193.20,349.68
+7789601292339,DWRM-241348,WK810/07,Zig Zag Birds,Ink,193.20,349.68
+7777861599283,DWRM-240658,W465/02,Cielo Mural,Tempest,183.75,332.58
+7781669699635,DWRM-240659,W465/03,Cielo Mural,Heather,183.75,332.58
+7789600800819,DWRM-240748,W483/03,Otillo,Watermint,178.50,323.08
+7785762258995,DWRM-240746,W483/01,Otillo,Beech,178.50,323.08
+7786026139699,DWRM-240753,W484/03,Manzu,Caper,178.50,323.08
+7786382065715,DWRM-241149,W902/14,Opus,Anthracite,177.45,321.18
+7781616615475,DWRM-240724,W479/01,Tali,Catkin,177.45,321.18
+7787382276147,DWRM-240731,W479/08,Tali,Artichoke,177.45,321.18
+7785762586675,DWRM-240729,W479/06,Tali,Coffee Bean,177.45,321.18
+7785760325683,DWRM-240726,W479/03,Tali,Doeskin,177.45,321.18
+7785763438643,DWRM-241170,W919/06,Mitoku,Sonnet,174.30,315.48
+7785760587827,DWRM-241444,WK828/01,Checkerboard Metallic Silver,Grey,162.75,294.57
+7786382622771,DWRM-240685,W470/05,Mima,Ebony,162.75,294.57
+7780863082547,DWRM-240681,W470/01,Mima,Tamarind,162.75,294.57
+7786990600243,DWRM-240993,W611/04,Kaolin,Dew,158.55,286.97
+7786027745331,DWRM-240990,W611/01,Kaolin,Lichen,158.55,286.97
+7781665112115,DWRM-241020,W615/18,Yelena,Birch,158.55,286.97
+7786028826675,DWRM-240435,W428/01,Kauri,Quartzite,158.55,286.97
+7786381836339,DWRM-240438,W428/04,Kauri,Carob,158.55,286.97
+7780862951475,DWRM-241019,W615/17,Yelena,Plaster,158.55,286.97
+7781612617779,DWRM-240431,W427/02,Mendel,Egret,158.55,286.97
+7789369393203,DWRM-240994,W611/05,Kaolin,Ice,158.55,286.97
+7789366575155,DWRM-241018,W615/16,Yelena,Ice,158.55,286.97
+7784980119603,DWRM-241015,W615/13,Yelena,Copper,158.55,286.97
+7789366902835,DWRM-241004,W614/02,Loess,ivory,158.55,286.97
+7786986209331,DWRM-241006,W614/04,Loess,Teal,158.55,286.97
+7784988704819,DWRM-241005,W614/03,Loess,Cappuccino,158.55,286.97
+7789369425971,DWRM-240998,W612/03,Betula,white,158.55,286.97
+7789601685555,DWRM-240452,W430/06,Etsu Eau de,Nil,157.50,285.07
+7785764192307,DWRM-240449,W430/03,Etsu,Mushroom,157.50,285.07
+7780865081395,DWRM-240469,W432/04,Ezri,Tempest,157.50,285.07
+7789600833587,DWRM-240458,W430/12,Etsu,Watermint,157.50,285.07
+7786027941939,DWRM-241395,WK819/06,Home Centre,Bohemia,157.50,285.07
+7786026663987,DWRM-240450,W430/04,Etsu,String,157.50,285.07
+7785005252659,DWRM-240488,W436/03,Delphie,Hoya,157.50,285.07
+7781662982195,DWRM-240497,W437/05,Inez,Rose,157.50,285.07
+7781606129715,DWRM-240448,W430/02,Etsu,Sandstone,157.50,285.07
+7780862165043,DWRM-240498,W437/06,Inez Swedish,Grey,157.50,285.07
+7789602046003,DWRM-241369,WK814/04,Hidden,Altitude,156.45,283.17
+7786381246515,DWRM-240444,W429/06,Elkin,Gunmetal,156.45,283.17
+7786028761139,DWRM-240740,W481/03,Zenya,Indium,156.45,283.17
+7785076195379,DWRM-240738,W481/01,Zenya,Chalk,156.45,283.17
+7781597184051,DWRM-240412,W424/01,Nyiri,Egret,155.40,281.27
+7786028793907,DWRM-240420,W425/03,Dufrene,Tweed,151.20,273.67
+7786983915571,DWRM-240423,W425/06,Dufrene Lava,Rock,151.20,273.67
+7781658099763,DWRM-240848,W554/07,Lucidato,Cappuccino,150.15,271.76
+7785035038771,DWRM-240856,W556/03,Intona,Cobweb,150.15,271.76
+7781589483571,DWRM-240462,W431/02,Koutu,Crema,150.15,271.76
+7789366607923,DWRM-240855,W556/02,Intona,Pumice,150.15,271.76
+7789601914931,DWRM-240840,W553/03,Cortona,Plaster,150.15,271.76
+7789366738995,DWRM-240852,W555/03,Arriccio,Jasmine,150.15,271.76
+7786381705267,DWRM-240409,W423/08,Lyra French,Grey,149.10,269.86
+7781583781939,DWRM-240405,W423/04,Lyra Wild,Rose,149.10,269.86
+7786026434611,DWRM-240408,W423/07,Lyra,Kelp,149.10,269.86
+7789601620019,DWRM-240410,W423/09,Lyra,Lovat,149.10,269.86
+7781654167603,DWRM-240978,W605/09,Nikko,Copper,144.90,262.26
+7780864786483,DWRM-240640,W464/01,Raya Silk Embossed,ivory,143.85,260.36
+7789367754803,DWRM-240649,W464/10,Raya Silk Embossed,Moonstone,143.85,260.36
+7785047031859,DWRM-240647,W464/08,Raya Silk Embossed,Auburn,143.85,260.36
+7787384766515,DWRM-240650,W464/11,Raya Silk Embossed,Caper,143.85,260.36
+7789365231667,DWRM-240651,W464/12,Raya Silk Embossed,Fern,143.85,260.36
+7789367001139,DWRM-240303,W396/05,Arbor Eau de,ivory,141.75,256.56
+7786028466227,DWRM-240301,W395/03,Marquise Turtle,ivory,141.75,256.56
+7785759244339,DWRM-240579,W453/03,Kitty Pale,Gold,135.45,245.16
+7789364838451,DWRM-240582,W453/06,Kitty,Peacock,135.45,245.16
+7786990895155,DWRM-240361,W415/02,Japura,Soleil,135.45,245.16
+7786027712563,DWRM-240676,W469/03,Shiri,Mushroom,135.45,245.16
+7780862591027,DWRM-240679,W469/06,Shiri,Twilight,135.45,245.16
+7785014853683,DWRM-240581,W453/05,Kitty Powder,Room,135.45,245.16
+7789365362739,DWRM-240580,W453/04,Kitty,teal,135.45,245.16
+7789368672307,DWRM-240864,W559/05,Venezia,Quartz,134.40,243.26
+7789601521715,DWRM-240342,W410/04,Edie,Fog,134.40,243.26
+7781610618931,DWRM-240340,W410/02,Edie,Arborio,134.40,243.26
+7785018327091,DWRM-240827,W551/05,Jali,Copper,134.40,243.26
+7780865146931,DWRM-240345,W410/07,Edie Wild,Rose,134.40,243.26
+7787384700979,DWRM-240708,W475/04,Eleni,Caper,134.40,243.26
+7786986864691,DWRM-240836,W552/06,Renzo,Teal,134.40,243.26
+7781608554547,DWRM-240335,W408/03,Striato,Mirin,134.40,243.26
+7789366771763,DWRM-240863,W559/03,Venezia,Jasmine,134.40,243.26
+7786381443123,DWRM-240516,W440/05,Sarita,Shadow,133.35,241.36
+7785030451251,DWRM-240695,W473/04,Alma,ivory,133.35,241.36
+7789602242611,DWRM-240698,W473/07,Alma Eau de,ivory,133.35,241.36
+7787382341683,DWRM-240688,W472/03,Aubin,Caper,133.35,241.36
+7789368049715,DWRM-240687,W472/02,Aubin,Mineral,133.35,241.36
+7780864819251,DWRM-240505,W438/04,Nula Wild,Rose,133.35,241.36
+7789605158963,DWRM-240964,W603/07,Temperate,Jasmine,133.35,241.36
+7786990010419,DWRM-240959,W603/02,Temperate,Verdigris,133.35,241.36
+7789604012083,DWRM-240963,W603/06,Temperate,Pumice,133.35,241.36
+7786989748275,DWRM-240960,W603/03,Temperate,Droplet,133.35,241.36
+7789365461043,DWRM-240569,W451/06,Roxanne,Jade,132.30,239.46
+7789364936755,DWRM-240568,W451/05,Roxanne,Peacock,132.30,239.46
+7789600997427,DWRM-240671,W468/03,Sikora,Lovat,130.20,235.66
+7786990665779,DWRM-240714,W476/05,Junie,gold,130.20,235.66
+7786984243251,DWRM-240635,W463/10,Neo Linen Embossed,Charcoal,130.20,235.66
+7785763536947,DWRM-240627,W463/02,Neo Linen Embossed,Soapstone,130.20,235.66
+7785762291763,DWRM-240636,W463/11,Neo Linen Embossed,Doeskin,130.20,235.66
+7785763930163,DWRM-240615,W462/05,Ciro Abaca Embossed,Doeskin,130.20,235.66
+7789367853107,DWRM-240621,W462/11,Ciro Abaca Embossed,Verdigris,130.20,235.66
+7787384668211,DWRM-240625,W462/15,Ciro Abaca Embossed,Caper,130.20,235.66
+7785001648179,DWRM-240620,W462/10,Ciro Abaca Embossed Wild,Rose,130.20,235.66
+7786028662835,DWRM-240558,W450/02,Delilah,Moonstone,130.20,235.66
+7786029056051,DWRM-240604,W461/07,Esai Seagrass Embossed,Mushroom,130.20,235.66
+7785003221043,DWRM-240713,W476/04,Junie Tuscan,Pink,130.20,235.66
+7789602209843,DWRM-240712,W476/03,Junie,ivory,130.20,235.66
+7785763602483,DWRM-240711,W476/02,Junie,beige,130.20,235.66
+7786381574195,DWRM-240672,W468/04,Sikora,Charcoal,130.20,235.66
+7786380722227,DWRM-240274,W369/06,Elysian Steeple,Grey,129.15,233.76
+7785758818355,DWRM-240554,W449/04,Fantasia Vintage,Gold,124.95,226.15
+7785759113267,DWRM-240389,W419/05,Kutai Vintage,Bronze,124.95,226.15
+7786026172467,DWRM-240552,W449/02,Fantasia,Quartz,124.95,226.15
+7781595480115,DWRM-240551,W449/01,Fantasia,Luna,124.95,226.15
+7786381082675,DWRM-240388,W419/04,Kutai Swedish,Grey,124.95,226.15
+7785010430003,DWRM-240396,W421/05,Sapo Rose,beige,124.95,226.15
+7787382374451,DWRM-240911,W595/04,Chandbali Wide,Tide,123.90,224.25
+7787381882931,DWRM-241104,W636/02,Reverie,Laguna,123.90,224.25
+7780861870131,DWRM-241106,W636/04,Reverie,Lustre,123.90,224.25
+7787380146227,DWRM-240912,W595/05,Chandbali Wide,Ink,123.90,224.25
+7785763635251,DWRM-240913,W595/08,Chandbali Wide,Copper,123.90,224.25
+7785062039603,DWRM-241107,W636/05,Reverie,Deco,123.90,224.25
+7780861837363,DWRM-240917,W595/14,Chandbali Wide,Macaroon,123.90,224.25
+7786988863539,DWRM-240920,W595/17,Chandbali Wide,Sage,123.90,224.25
+7789366444083,DWRM-240914,W595/09,Chandbali Wide,cream,123.90,224.25
+7780863049779,DWRM-240525,W442/04,Chiya,ivory,121.80,220.45
+7786028138547,DWRM-240380,W418/02,Areca,Mirin,118.65,214.75
+7787380637747,DWRM-240904,W594/02,Hockley,Tide,118.65,214.75
+7781660426291,DWRM-240906,W594/04,Hockley,Lustre,118.65,214.75
+7786028040243,DWRM-240544,W448/01,Euphoria Coral,Island,118.65,214.75
+7787383423027,DWRM-240547,W448/04,Euphoria Somerset,Green,118.65,214.75
+7789600899123,DWRM-240381,W418/03,Areca Eau de,Nil,118.65,214.75
+7789604929587,DWRM-240907,W594/05,Hockley,Jasmine,118.65,214.75
+7787382046771,DWRM-240814,W546/06,Hana Trail,Indigo,117.60,212.85
+7781599051827,DWRM-240365,W416/02,Pacaya Silver,Birch,114.45,207.15
+7781584633907,DWRM-240364,W416/01,Pacaya,ivory,114.45,207.15
+7787384340531,DWRM-240929,W597/06,Raval,steel blue,114.45,207.15
+7787382210611,DWRM-240936,W599/03,Naples Wide,Freshwater,113.40,205.25
+7786990764083,DWRM-240935,W599/02,Naples Wide,Verdigris,113.40,205.25
+7785039167539,DWRM-241068,W628/01,Ombre,Silica,113.40,205.25
+7780863508531,DWRM-241069,W628/02,Ombre,Bisque,113.40,205.25
+7785036972083,DWRM-240939,W599/07,Naples Wide,Ice,113.40,205.25
+7786990338099,DWRM-240950,W601/03,Ostara,Dew,113.40,205.25
+7789601390643,DWRM-241100,W635/04,Haldon,ivory,113.40,205.25
+7786990370867,DWRM-241099,W635/03,Haldon,pale green,113.40,205.25
+7787382505523,DWRM-241098,W635/02,Haldon,ivory,113.40,205.25
+7781673631795,DWRM-240937,W599/05,Naples Wide,Gold,113.40,205.25
+7780860887091,DWRM-240374,W417/04,Otishi Rose,beige,112.35,203.35
+7789605224499,DWRM-241045,W620/02,Still Life,Birch,112.35,203.35
+7785033039923,DWRM-241058,W625/03,Alumina,Silica,112.35,203.35
+7781620973619,DWRM-241072,W629/02,Sgraffito,Sienna,112.35,203.35
+7786990272563,DWRM-241064,W627/01,Ditto,light gray,112.35,203.35
+7786990698547,DWRM-240801,W544/04,Malmo,light blue,111.30,201.45
+7787382014003,DWRM-240806,W544/11,Malmo,Indigo,111.30,201.45
+7789605126195,DWRM-240758,W517/10,Malmo,Jasmine,111.30,201.45
+7785026388019,DWRM-240799,W544/02,Malmo,Carbon,111.30,201.45
+7781651644467,DWRM-240804,W544/08,Malmo,Malt,111.30,201.45
+7789601882163,DWRM-240803,W544/06,Malmo,cream,111.30,201.45
+7789369458739,DWRM-240986,W610/01,Heath,Ice,108.15,195.75
+7785764061235,DWRM-240988,W610/03,Heath,Tuscan,108.15,195.75
+7789600768051,DWRM-240324,W406/05,Mikado,Fog,108.15,195.75
+7789601980467,DWRM-240987,W610/02,Heath,Chalk,108.15,195.75
+7780864589875,DWRM-240320,W406/01,Mikado,Ivory,108.15,195.75
+7786380853299,DWRM-240325,W406/06,Mikado,Storm,108.15,195.75
+7786028498995,DWRM-240358,W414/03,Tiami,Perlino,108.15,195.75
+7786989781043,DWRM-241116,W644/02,Far Far Away,Glade,105.00,190.05
+7787382243379,DWRM-241117,W644/03,Far Far Away,Fjord,105.00,190.05
+7780861968435,DWRM-240703,W474/05,Orsin Boathouse,Blue,103.95,188.14
+7781638897715,DWRM-241154,W911/07,Lustro,Cashmere,103.95,188.14
+7789602177075,DWRM-241153,W911/04,Lustro,Glacier,103.95,188.14
+7789368016947,DWRM-240718,W477/03,Remi Eau de,pale green,102.90,186.24
+7786991648819,DWRM-241088,W633/08,Idyll,Ink,101.85,184.34
+7787382997043,DWRM-241083,W633/03,Idyll,Tide,101.85,184.34
+7789603520563,DWRM-241037,W618/03,Speckle,ivory,100.80,182.44
+7787383849011,DWRM-241038,W618/04,Speckle,light blue,100.80,182.44
+7789602340915,DWRM-241036,W618/02,Speckle,ivory,100.80,182.44
+7780862853171,DWRM-241040,W618/06,Speckle,coral,100.80,182.44
+7789368115251,DWRM-241042,W618/08,Speckle,ivory,100.80,182.44
+7786026238003,DWRM-240823,W548/09,Makisu,Maize,100.80,182.44
+7787384242227,DWRM-240819,W548/03,Makisu,Shaker,100.80,182.44
+7789605060659,DWRM-241033,W617/02,Liana,Birch,100.80,182.44
+7780863017011,DWRM-241050,W621/04,Broderie,Plaster,100.80,182.44
+7789604044851,DWRM-241051,W621/05,Broderie,ivory,100.80,182.44
+7789603553331,DWRM-241041,W618/07,Speckle,ivory,100.80,182.44
+7786990796851,DWRM-240820,W548/04,Makisu,Ocean,100.80,182.44
+7789601030195,DWRM-240355,W413/04,Danton,Lovat,99.75,180.54
+7789601456179,DWRM-240353,W412/05,Mitzi Eau de,Nil,99.75,180.54
+7781583683635,DWRM-240351,W412/01,Mitzi,Ivory,99.75,180.54
+7785078390835,DWRM-240290,W390/02,Castelli,Ochre,99.75,180.54
+7786026500147,DWRM-240292,W390/04,Castelli,Indium,99.75,180.54
+7789601947699,DWRM-240330,W407/04,Sefina Silver,Blue,99.75,180.54
+7786990534707,DWRM-240889,W582/01,Daydream Wallcovering,Off-White,98.70,178.64
+7787384373299,DWRM-240266,W367/05,Boheme,Oregano,96.60,174.84
+7781614485555,DWRM-240263,W366/02,Kasbah,beige,96.60,174.84
+7789366837299,DWRM-240869,W563/01,Flurry Wallcovering,Beige,93.45,169.14
+7789367623731,DWRM-240296,W392/03,Astratto,Mist,93.45,169.14
+7786028695603,DWRM-240891,W584/01,Tiny,Turtles,91.35,165.34
+7787384274995,DWRM-241095,W634/06,Daze,Fjord,89.25,161.54
+7785069248563,DWRM-240878,W570/01,Pink,City,89.25,161.54
+7789604110387,DWRM-240888,W581/04,Twinkle Twinkle,Chalk,89.25,161.54
+7785071837235,DWRM-241090,W634/01,Daze,Moorland,89.25,161.54
+7787383521331,DWRM-240874,W568/02,Swish,Ocean,89.25,161.54
+7787384635443,DWRM-241026,W616/03,Tabletop,pale blue,89.25,161.54
+7789367033907,DWRM-241031,W616/08,Tabletop,beige,89.25,161.54
+7789605191731,DWRM-241025,W616/02,Tabletop,beige,89.25,161.54
+7785041100851,DWRM-240877,W569/03,Teeny Santorini,Stone,89.25,161.54
+7780861771827,DWRM-241093,W634/04,Daze,Cashew,89.25,161.54
+7789604995123,DWRM-240902,W593/04,Gracia,Porcelain,87.15,157.74
+7789600669747,DWRM-240985,W609/03,Taiga,Chalk,86.10,155.84
+7785049161779,DWRM-240984,W609/02,Taiga,Carbon,86.10,155.84
+7787380178995,DWRM-241122,W646/03,Raindrops,ivory,81.90,148.24
+7787384602675,DWRM-240763,W519/08,Bruges Wallcovering,Agapanthus,73.50,133.03
+7789367132211,DWRM-240787,W538/02,Zeta,Shingle,72.45,131.13
+7789601161267,DWRM-240779,W537/02,Sascha,Quartz,72.45,131.13
+7789605093427,DWRM-240780,W537/04,Sascha,Pearl,72.45,131.13
+7784995225651,DWRM-240773,W536/01,Xander,Birch,72.45,131.13
+7784990998579,DWRM-240782,W537/06,Sascha,Cinder,72.45,131.13
diff --git a/shopify/scripts/data/romo-cost-backfill/romo-trade-puller-v3.js b/shopify/scripts/data/romo-cost-backfill/romo-trade-puller-v3.js
new file mode 100644
index 00000000..41e5a62c
--- /dev/null
+++ b/shopify/scripts/data/romo-cost-backfill/romo-trade-puller-v3.js
@@ -0,0 +1,45 @@
+const fs=require('fs'),{execFileSync}=require('child_process');
+const { chromium }=require('playwright-core');
+const Browserbase=require('@browserbasehq/sdk').default;
+const env=fs.readFileSync(__dirname+'/.env','utf8');
+const PROJECT=(env.match(/BROWSERBASE_PROJECT_ID=(.*)/)||[])[1].trim();
+const KEY=(env.match(/BROWSERBASE_API_KEY=(.*)/)||[])[1].trim();
+const psql=s=>execFileSync('psql',['-At','-F','\t','-d','dw_unified','-c',s],{encoding:'utf8'}).trim();
+const OUT='/tmp/romo_pulled_v3.jsonl';
+const sleep=ms=>new Promise(r=>setTimeout(r,ms));
+const CHUNK=18;
+function targetList(){
+  const rows=fs.readFileSync(process.env.HOME+'/Projects/Designer-Wallcoverings/shopify/scripts/data/romo-cost-backfill/romo-uncosted-queue-20260611.csv','utf8').trim().split('\n').slice(1);
+  const unc=[...new Set(rows.map(l=>l.split(',')[1]).filter(Boolean).map(s=>s.split('/')[0].trim()))].map(b=>({b,known:false}));
+  const known=psql("SELECT DISTINCT split_part(mfr_sku,'/',1) FROM romo_catalog WHERE COALESCE(NULLIF(trade_price_per_roll,0),0)>0 LIMIT 45").split('\n').filter(Boolean).map(b=>({b,known:true}));
+  return [...known,...unc];
+}
+function done(){ if(!fs.existsSync(OUT))return new Set(); const s=new Set(); for(const l of fs.readFileSync(OUT,'utf8').trim().split('\n')){if(!l)continue;try{const r=JSON.parse(l);if(r.landed>0||r.err==='no-product')s.add(r.base);}catch(_){}} return s;}
+async function login(page,u,p){await page.goto('https://trade.theromogroup.com/customer/account/login/',{waitUntil:'domcontentloaded'});await page.waitForTimeout(7000);await page.fill('#fmregister-email',u).catch(()=>{});await page.fill('#fmregister-password, input[type=password]',p).catch(()=>{});await page.keyboard.press('Enter');await page.waitForTimeout(8000);return !/login|\/local\?/.test(page.url());}
+async function pull(page,base){
+  const html=await page.evaluate(async(q)=>{const tok=(document.querySelector('meta[name=csrf-token]')||{}).content||'';const r=await fetch('/search/quick',{method:'POST',headers:{'X-CSRF-Token':tok,'X-Requested-With':'XMLHttpRequest','Content-Type':'application/x-www-form-urlencoded'},body:'q='+encodeURIComponent(q)});return await r.text();},base);
+  const m=html.match(/href="(\/collections\/[^"]+)"/); if(!m)return{base,err:'no-product'};
+  await page.goto('https://trade.theromogroup.com'+m[1],{waitUntil:'domcontentloaded'});await page.waitForTimeout(3500);
+  const data=await page.evaluate(()=>{
+    const body=document.body.innerText;
+    const rollM=[...body.matchAll(/Total Price Per Roll:?\s*\$([0-9,]+(?:\.[0-9]+)?)/gi)].map(x=>parseFloat(x[1].replace(/,/g,'')));
+    const yardM=[...body.matchAll(/Total Price Per Yard:?\s*\$([0-9,]+(?:\.[0-9]+)?)/gi)].map(x=>parseFloat(x[1].replace(/,/g,'')));
+    const tradeM=[...body.matchAll(/Trade Price:?\s*\$([0-9,]+(?:\.[0-9]+)?)/gi)].map(x=>parseFloat(x[1].replace(/,/g,'')));
+    return {rollM,yardM,tradeM};
+  });
+  const landed = data.rollM.length? Math.max(...data.rollM) : null;
+  return {base,url:m[1],landed,roll_all:data.rollM,yard_all:data.yardM,trade_shown:data.tradeM,unit: data.rollM.length?'roll':(data.yardM.length?'yard':null)};
+}
+(async()=>{
+  const [u,p]=psql("SELECT trade_username||E'\\t'||trade_password FROM vendor_registry WHERE vendor_name='Romo'").split('\t');
+  const all=targetList(); const dn=done(); const todo=all.filter(t=>!dn.has(t.b));
+  console.log(`targets=${all.length} done=${dn.size} todo=${todo.length}`);
+  const bb=new Browserbase({apiKey:KEY}); let i=0,found=0;
+  while(i<todo.length){
+    const chunk=todo.slice(i,i+CHUNK); let browser,page;
+    try{const s=await bb.sessions.create({projectId:PROJECT,browserSettings:{solveCaptchas:true}});browser=await chromium.connectOverCDP(s.connectUrl);const ctx=browser.contexts()[0];page=ctx.pages()[0]||await ctx.newPage();page.setDefaultTimeout(40000);if(!await login(page,u,p)){await browser.close().catch(()=>{});continue;}}catch(e){await sleep(3000);continue;}
+    for(const t of chunk){try{const r=await pull(page,t.b);r.known=t.known;fs.appendFileSync(OUT,JSON.stringify(r)+'\n');if(r.landed)found++;}catch(e){fs.appendFileSync(OUT,JSON.stringify({base:t.b,known:t.known,err:String(e).slice(0,60)})+'\n');if(/closed|detached/.test(String(e)))break;}await sleep(350);}
+    await browser.close().catch(()=>{}); i+=chunk.length; console.log(`progress ${Math.min(i,todo.length)}/${todo.length} found=${found}`);
+  }
+  console.log('DONE v3 found='+found);
+})();
← fd28444b Fix importer throttle bug (require real pid for success) + b · back to Designer Wallcoverings · schu-reimport: launchd-managed, restartable, loop-until-clea b6ac1130 →