← back to Designer Wallcoverings
auto-save: 2026-07-10T14:39:00 (7 files) — DW-Programming/ImportNewSkufromURL/data/scraper-audit/reconcile/brewster-import-queue.jsonl pending-approval/boost-filter-consolidation-2026-06-25 scripts/pr-contact-for-price shopify/scripts/schu-api-recrawl.js vendor-scrapers/china-seas-refresh
1f2a3a610a66bbfcb524d36da5218ebd2c8407e9 · 2026-07-10 14:39:04 -0700 · Steve Abrams
Files touched
M DW-Programming/ImportNewSkufromURL/data/scraper-audit/reconcile/brewster-import-queue.jsonlM shopify/scripts/schu-api-recrawl.jsA shopify/scripts/schu-api-recrawl.js.backup-20260710-141735A shopify/scripts/schu-pillow-orphan-resolve.js
Diff
commit 1f2a3a610a66bbfcb524d36da5218ebd2c8407e9
Author: Steve Abrams <steve@designerwallcoverings.com>
Date: Fri Jul 10 14:39:04 2026 -0700
auto-save: 2026-07-10T14:39:00 (7 files) — DW-Programming/ImportNewSkufromURL/data/scraper-audit/reconcile/brewster-import-queue.jsonl pending-approval/boost-filter-consolidation-2026-06-25 scripts/pr-contact-for-price shopify/scripts/schu-api-recrawl.js vendor-scrapers/china-seas-refresh
---
.../reconcile/brewster-import-queue.jsonl | 136 ++++++++---------
shopify/scripts/schu-api-recrawl.js | 10 +-
.../schu-api-recrawl.js.backup-20260710-141735 | 164 +++++++++++++++++++++
shopify/scripts/schu-pillow-orphan-resolve.js | 65 ++++++++
4 files changed, 304 insertions(+), 71 deletions(-)
diff --git a/DW-Programming/ImportNewSkufromURL/data/scraper-audit/reconcile/brewster-import-queue.jsonl b/DW-Programming/ImportNewSkufromURL/data/scraper-audit/reconcile/brewster-import-queue.jsonl
index dd563ee4..2b054fda 100644
--- a/DW-Programming/ImportNewSkufromURL/data/scraper-audit/reconcile/brewster-import-queue.jsonl
+++ b/DW-Programming/ImportNewSkufromURL/data/scraper-audit/reconcile/brewster-import-queue.jsonl
@@ -960,74 +960,74 @@
{"vendor":"brewster","sku":"PLS4212","url":"https://www.brewsterwallcovering.com/pls4212-gold-cranberry-poise-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PLS4212 - Gold Cranberry Poise Peel and Stick Wallpaper - by Pip & Lo x Wall","color":"","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T14:31:17.708Z"}
{"vendor":"brewster","sku":"PLS4213","url":"https://www.brewsterwallcovering.com/pls4213-blues-poise-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PLS4213 - Blues Poise Peel and Stick Wallpaper - by Pip & Lo x WallPops","color":"","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T14:31:25.715Z"}
{"vendor":"brewster","sku":"PLS4215","url":"https://www.brewsterwallcovering.com/pls4215-grey-aqua-jaybird-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PLS4215 - Grey Aqua Jaybird Peel and Stick Wallpaper - by Pip & Lo x WallPop","color":"","image":"","specs":{"repeat":"21 inches."},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T14:31:33.721Z"}
-{"vendor":"brewster","sku":"PLS4216","url":"https://www.brewsterwallcovering.com/pls4216-teal-pink-jaybird-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"PLS4216 - Teal Pink Jaybird Peel and Stick Wallpaper - by Pip & Lo x WallPop","color":"","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"PLS4217","url":"https://www.brewsterwallcovering.com/pls4217-sage-jaybird-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"PLS4217 - Sage Jaybird Peel and Stick Wallpaper - by Pip & Lo x WallPops","color":"","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"PLS4218","url":"https://www.brewsterwallcovering.com/pls4218-plum-cat-nap-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"PLS4218 - Plum Cat Nap Peel and Stick Wallpaper - by Pip & Lo x WallPops","color":"","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"PLS4219","url":"https://www.brewsterwallcovering.com/pls4219-greens-cat-nap-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"PLS4219 - Greens Cat Nap Peel and Stick Wallpaper - by Pip & Lo x WallPops","color":"","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"PLS4220","url":"https://www.brewsterwallcovering.com/pls4220-cream-grey-cat-nap-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"PLS4220 - Cream Grey Cat Nap Peel and Stick Wallpaper - by Pip & Lo x WallPo","color":"","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"PP4697","url":"https://www.brewsterwallcovering.com/pp4697-palm-leaf-stay-palm-leaf-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"PP4697 - Palm Leaf Stay Palm Leaf Peel and Stick Wallpaper - by Packed Party","color":"by Packed Party","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"PP4700","url":"https://www.brewsterwallcovering.com/pp4700-polka-dot-spot-the-fun-polka-dots-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"PP4700 - Polka Dot Spot The Fun Polka Dots Peel and Stick Wallpaper - by Packed ","color":"by Packed Party","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"PP4703","url":"https://www.brewsterwallcovering.com/pp4703-geometric-gold-standard-geometric-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"PP4703 - Geometric Gold Standard Geometric Peel and Stick Wallpaper - by Packed ","color":"by Packed Party","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"PP4706","url":"https://www.brewsterwallcovering.com/pp4706-plaid-think-pink-geometric-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"PP4706 - Plaid Think Pink Geometric Peel and Stick Wallpaper - by Packed Party","color":"by Packed Party","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"PP4709","url":"https://www.brewsterwallcovering.com/pp4709-garden-simply-stated-florals-flower-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"PP4709 - Garden Simply Stated Florals Flower Peel and Stick Wallpaper - by Packe","color":"by Packed Party","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"PS40102","url":"https://www.brewsterwallcovering.com/ps40102-endless-summer-blue-palm-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"PS40102 - Endless Summer Blue Palm Wallpaper - by Kenneth James","color":"by Kenneth James","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"PS40204","url":"https://www.brewsterwallcovering.com/ps40204-arcadia-light-green-banana-leaf-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"PS40204 - Arcadia Light Green Banana Leaf Wallpaper - by Kenneth James","color":"by Kenneth James","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"PS40305","url":"https://www.brewsterwallcovering.com/ps40305-away-on-holiday-beige-palm-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"PS40305 - Away On Holiday Beige Palm Wallpaper - by Kenneth James","color":"by Kenneth James","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"QE14104","url":"https://www.brewsterwallcovering.com/qe14104-white-leanne","status":"pending","brand":"Jeffrey Stevens","name":"QE14104 White Leanne Wallpaper - Quintessential Vol II by Chesapeake","color":"","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"QE19321","url":"https://www.brewsterwallcovering.com/qe19321-white-meadow-lark","status":"pending","brand":"Jeffrey Stevens","name":"QE19321 White Meadow Lark - Quintessentials II Wallpaper by Chesapeake","color":"","image":"","specs":{"repeat":"27 in. x 27 ft. ="},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RAS6258","url":"https://www.brewsterwallcovering.com/ras6258-black-artichoke-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RAS6258 - Black Artichoke Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RAS6259","url":"https://www.brewsterwallcovering.com/ras6259-orange-worst-in-show-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RAS6259 - Orange Worst in Show Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RAS6260","url":"https://www.brewsterwallcovering.com/ras6260-black-worst-in-show-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RAS6260 - Black Worst in Show Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RAS6261","url":"https://www.brewsterwallcovering.com/ras6261-green-the-chase-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RAS6261 - Green The Chase Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RAS6262","url":"https://www.brewsterwallcovering.com/ras6262-pink-the-chase-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RAS6262 - Pink The Chase Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RAS6263","url":"https://www.brewsterwallcovering.com/ras6263-black-the-chase-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RAS6263 - Black The Chase Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RAS6264","url":"https://www.brewsterwallcovering.com/ras6264-blue-the-chase-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RAS6264 - Blue The Chase Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RAS6265","url":"https://www.brewsterwallcovering.com/ras6265-black-pasta-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RAS6265 - Black Pasta Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RAS6266","url":"https://www.brewsterwallcovering.com/ras6266-white-pasta-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RAS6266 - White Pasta Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RAS6267","url":"https://www.brewsterwallcovering.com/ras6267-cream-sardine-tins-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RAS6267 - Cream Sardine Tins Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RAS6268","url":"https://www.brewsterwallcovering.com/ras6268-blue-sardine-tins-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RAS6268 - Blue Sardine Tins Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RH464849","url":"https://www.brewsterwallcovering.com/rh464849-giacometti-grey-flora-and-faces-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RH464849 - Giacometti Grey Flora & Faces Wallpaper - by Rasch","color":"by Rasch","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RH560565","url":"https://www.brewsterwallcovering.com/rh560565-villon-multicolor-ikat-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RH560565 - Villon Multicolor Ikat Wallpaper - by Rasch","color":"by Rasch","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RH687408","url":"https://www.brewsterwallcovering.com/rh687408-merian-multicolor-architectural-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RH687408 - Merian Multicolor Architectural Wallpaper - by Rasch","color":"by Rasch","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMDM5559","url":"https://www.brewsterwallcovering.com/rmdm5559-batwheels-characters-blue-wall-decals","status":"pending","brand":"Jeffrey Stevens","name":"RMDM5559 - Batwheels Characters Blue Wall Decals - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMDM5561","url":"https://www.brewsterwallcovering.com/rmdm5561-shrek-and-donkey-green-wall-decals","status":"pending","brand":"Jeffrey Stevens","name":"RMDM5561 - Shrek and Donkey Green Wall Decals - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMDM5570","url":"https://www.brewsterwallcovering.com/rmdm5570-peppa-pig-pink-wall-decals","status":"pending","brand":"Jeffrey Stevens","name":"RMDM5570 - Peppa Pig Pink Wall Decals - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMDM5574","url":"https://www.brewsterwallcovering.com/rmdm5574-x-men-97-characters-black-wall-decals","status":"pending","brand":"Jeffrey Stevens","name":"RMDM5574 - X-MEN '97 Characters Black Wall Decals - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMDM5575","url":"https://www.brewsterwallcovering.com/rmdm5575-iron-man-and-his-awesome-friends-red-wall-decals","status":"pending","brand":"Jeffrey Stevens","name":"RMDM5575 - Iron Man and His Awesome Friends Red Wall Decals - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMDM5599","url":"https://www.brewsterwallcovering.com/rmdm5599-wonderfully-made-quote-green-religious-wall-decals","status":"pending","brand":"Jeffrey Stevens","name":"RMDM5599 - Wonderfully Made Quote Green Religious Wall Decals - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMDM5600","url":"https://www.brewsterwallcovering.com/rmdm5600-in-his-sight-watercolor-tree-multicolor-religious-wall-decals","status":"pending","brand":"Jeffrey Stevens","name":"RMDM5600 - In His Sight Watercolor Tree Multicolor Religious Wall Decals - by Ro","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMDM5601","url":"https://www.brewsterwallcovering.com/rmdm5601-tree-of-life-cross-green-religious-wall-decals","status":"pending","brand":"Jeffrey Stevens","name":"RMDM5601 - Tree of Life Cross Green Religious Wall Decals - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1234","url":"https://www.brewsterwallcovering.com/rmws1234-wicked-emerald-city-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1234 - Wicked Emerald City Peel and Stick Wallpaper - by Wicked","color":"by Wicked","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1250","url":"https://www.brewsterwallcovering.com/rmws1250-love-letters-parchment-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1250 - Love Letters Parchment Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1251","url":"https://www.brewsterwallcovering.com/rmws1251-love-letters-ink-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1251 - Love Letters Ink Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1252","url":"https://www.brewsterwallcovering.com/rmws1252-wildflower-impressions-magenta-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1252 - Wildflower Impressions Magenta Peel and Stick Wallpaper - by RoomMate","color":"by RoomMates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1253","url":"https://www.brewsterwallcovering.com/rmws1253-wildflower-impressions-aqua-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1253 - Wildflower Impressions Aqua Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1254","url":"https://www.brewsterwallcovering.com/rmws1254-wildflower-impressions-yellow-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1254 - Wildflower Impressions Yellow Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1255","url":"https://www.brewsterwallcovering.com/rmws1255-mystic-serpent-black-gold-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1255 - Mystic Serpent Black Gold Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1256","url":"https://www.brewsterwallcovering.com/rmws1256-mystic-serpent-plum-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1256 - Mystic Serpent Plum Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1257","url":"https://www.brewsterwallcovering.com/rmws1257-mystic-serpent-navy-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1257 - Mystic Serpent Navy Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1258","url":"https://www.brewsterwallcovering.com/rmws1258-mystic-serpent-taupe-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1258 - Mystic Serpent Taupe Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1259","url":"https://www.brewsterwallcovering.com/rmws1259-cowgirl-like-me-pink-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1259 - Cowgirl Like Me Pink Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1260","url":"https://www.brewsterwallcovering.com/rmws1260-cowgirl-like-me-blue-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1260 - Cowgirl Like Me Blue Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1261","url":"https://www.brewsterwallcovering.com/rmws1261-cowgirl-like-me-beige-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1261 - Cowgirl Like Me Beige Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1264","url":"https://www.brewsterwallcovering.com/rmws1264-cowgirl-like-me-black-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1264 - Cowgirl Like Me Black Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1302","url":"https://www.brewsterwallcovering.com/rmws1302-miraculous-ladybug-charming-paris-pink-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1302 - Miraculous Ladybug Charming Paris Pink Peel and Stick Wallpaper - by ","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1303","url":"https://www.brewsterwallcovering.com/rmws1303-miraculous-ladybug-charming-paris-black-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1303 - Miraculous Ladybug Charming Paris Black Peel and Stick Wallpaper - by","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1305","url":"https://www.brewsterwallcovering.com/rmws1305-miraculous-ladybug-sketch-charcoal-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1305 - Miraculous Ladybug Sketch Charcoal Peel and Stick Wallpaper - by Room","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1307","url":"https://www.brewsterwallcovering.com/rmws1307-bluey-and-bingo-hearts-multicolor-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1307 - Bluey & Bingo Hearts Multicolor Peel and Stick Wallpaper - by Roo","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1308","url":"https://www.brewsterwallcovering.com/rmws1308-wicked-land-of-oz-green-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1308 - Wicked Land of Oz Green Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1309","url":"https://www.brewsterwallcovering.com/rmws1309-daphne-limewash-mocha-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1309 - Daphne Limewash Mocha Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1310","url":"https://www.brewsterwallcovering.com/rmws1310-daphne-limewash-moody-blue-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1310 - Daphne Limewash Moody Blue Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1311","url":"https://www.brewsterwallcovering.com/rmws1311-daphne-limewash-dusty-blue-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1311 - Daphne Limewash Dusty Blue Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1312","url":"https://www.brewsterwallcovering.com/rmws1312-watercolor-glass-neutral-beige-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1312 - Watercolor Glass Neutral Beige Peel and Stick Wallpaper - by Roommate","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1313","url":"https://www.brewsterwallcovering.com/rmws1313-watercolor-glass-olive-green-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1313 - Watercolor Glass Olive Green Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1314","url":"https://www.brewsterwallcovering.com/rmws1314-watercolor-glass-dark-blue-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1314 - Watercolor Glass Dark Blue Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1316","url":"https://www.brewsterwallcovering.com/rmws1316-tess-watercolor-checker-sage-green-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1316 - Tess Watercolor Checker Sage Green Peel and Stick Wallpaper - by Room","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1317","url":"https://www.brewsterwallcovering.com/rmws1317-tess-watercolor-checker-pale-yellow-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1317 - Tess Watercolor Checker Pale Yellow Peel and Stick Wallpaper - by Roo","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1318","url":"https://www.brewsterwallcovering.com/rmws1318-x-men-97-faces-black-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1318 - X-MEN '97 Faces Black Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1319","url":"https://www.brewsterwallcovering.com/rmws1319-x-men-97-comic-cast-black-and-white-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1319 - X-MEN ‘97 Comic Cast Black and White Peel and Stick Wallpaper ","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1323","url":"https://www.brewsterwallcovering.com/rmws1323-clueless-cher-yellow-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1323 - Clueless Cher Yellow Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
-{"vendor":"brewster","sku":"RMWS1324","url":"https://www.brewsterwallcovering.com/rmws1324-clueless-dionne-black-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1324 - Clueless Dionne Black Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
+{"vendor":"brewster","sku":"PLS4216","url":"https://www.brewsterwallcovering.com/pls4216-teal-pink-jaybird-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PLS4216 - Teal Pink Jaybird Peel and Stick Wallpaper - by Pip & Lo x WallPop","color":"","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:30:05.296Z"}
+{"vendor":"brewster","sku":"PLS4217","url":"https://www.brewsterwallcovering.com/pls4217-sage-jaybird-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PLS4217 - Sage Jaybird Peel and Stick Wallpaper - by Pip & Lo x WallPops","color":"","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:30:13.303Z"}
+{"vendor":"brewster","sku":"PLS4218","url":"https://www.brewsterwallcovering.com/pls4218-plum-cat-nap-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PLS4218 - Plum Cat Nap Peel and Stick Wallpaper - by Pip & Lo x WallPops","color":"","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:30:21.308Z"}
+{"vendor":"brewster","sku":"PLS4219","url":"https://www.brewsterwallcovering.com/pls4219-greens-cat-nap-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PLS4219 - Greens Cat Nap Peel and Stick Wallpaper - by Pip & Lo x WallPops","color":"","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:30:29.315Z"}
+{"vendor":"brewster","sku":"PLS4220","url":"https://www.brewsterwallcovering.com/pls4220-cream-grey-cat-nap-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PLS4220 - Cream Grey Cat Nap Peel and Stick Wallpaper - by Pip & Lo x WallPo","color":"","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:30:37.322Z"}
+{"vendor":"brewster","sku":"PP4697","url":"https://www.brewsterwallcovering.com/pp4697-palm-leaf-stay-palm-leaf-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PP4697 - Palm Leaf Stay Palm Leaf Peel and Stick Wallpaper - by Packed Party","color":"by Packed Party","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:30:45.329Z"}
+{"vendor":"brewster","sku":"PP4700","url":"https://www.brewsterwallcovering.com/pp4700-polka-dot-spot-the-fun-polka-dots-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PP4700 - Polka Dot Spot The Fun Polka Dots Peel and Stick Wallpaper - by Packed ","color":"by Packed Party","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:30:53.336Z"}
+{"vendor":"brewster","sku":"PP4703","url":"https://www.brewsterwallcovering.com/pp4703-geometric-gold-standard-geometric-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PP4703 - Geometric Gold Standard Geometric Peel and Stick Wallpaper - by Packed ","color":"by Packed Party","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:31:01.341Z"}
+{"vendor":"brewster","sku":"PP4706","url":"https://www.brewsterwallcovering.com/pp4706-plaid-think-pink-geometric-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PP4706 - Plaid Think Pink Geometric Peel and Stick Wallpaper - by Packed Party","color":"by Packed Party","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:31:09.346Z"}
+{"vendor":"brewster","sku":"PP4709","url":"https://www.brewsterwallcovering.com/pp4709-garden-simply-stated-florals-flower-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PP4709 - Garden Simply Stated Florals Flower Peel and Stick Wallpaper - by Packe","color":"by Packed Party","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:31:17.353Z"}
+{"vendor":"brewster","sku":"PS40102","url":"https://www.brewsterwallcovering.com/ps40102-endless-summer-blue-palm-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PS40102 - Endless Summer Blue Palm Wallpaper - by Kenneth James","color":"by Kenneth James","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:31:25.359Z"}
+{"vendor":"brewster","sku":"PS40204","url":"https://www.brewsterwallcovering.com/ps40204-arcadia-light-green-banana-leaf-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PS40204 - Arcadia Light Green Banana Leaf Wallpaper - by Kenneth James","color":"by Kenneth James","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:31:33.367Z"}
+{"vendor":"brewster","sku":"PS40305","url":"https://www.brewsterwallcovering.com/ps40305-away-on-holiday-beige-palm-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"PS40305 - Away On Holiday Beige Palm Wallpaper - by Kenneth James","color":"by Kenneth James","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:31:41.373Z"}
+{"vendor":"brewster","sku":"QE14104","url":"https://www.brewsterwallcovering.com/qe14104-white-leanne","status":"failed","brand":"Jeffrey Stevens","name":"QE14104 White Leanne Wallpaper - Quintessential Vol II by Chesapeake","color":"","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:31:49.379Z"}
+{"vendor":"brewster","sku":"QE19321","url":"https://www.brewsterwallcovering.com/qe19321-white-meadow-lark","status":"failed","brand":"Jeffrey Stevens","name":"QE19321 White Meadow Lark - Quintessentials II Wallpaper by Chesapeake","color":"","image":"","specs":{"repeat":"27 in. x 27 ft. ="},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:31:57.384Z"}
+{"vendor":"brewster","sku":"RAS6258","url":"https://www.brewsterwallcovering.com/ras6258-black-artichoke-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RAS6258 - Black Artichoke Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:32:05.388Z"}
+{"vendor":"brewster","sku":"RAS6259","url":"https://www.brewsterwallcovering.com/ras6259-orange-worst-in-show-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RAS6259 - Orange Worst in Show Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:32:13.394Z"}
+{"vendor":"brewster","sku":"RAS6260","url":"https://www.brewsterwallcovering.com/ras6260-black-worst-in-show-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RAS6260 - Black Worst in Show Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:32:21.398Z"}
+{"vendor":"brewster","sku":"RAS6261","url":"https://www.brewsterwallcovering.com/ras6261-green-the-chase-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RAS6261 - Green The Chase Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:32:29.402Z"}
+{"vendor":"brewster","sku":"RAS6262","url":"https://www.brewsterwallcovering.com/ras6262-pink-the-chase-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RAS6262 - Pink The Chase Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:32:37.408Z"}
+{"vendor":"brewster","sku":"RAS6263","url":"https://www.brewsterwallcovering.com/ras6263-black-the-chase-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RAS6263 - Black The Chase Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:32:45.413Z"}
+{"vendor":"brewster","sku":"RAS6264","url":"https://www.brewsterwallcovering.com/ras6264-blue-the-chase-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RAS6264 - Blue The Chase Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:32:53.420Z"}
+{"vendor":"brewster","sku":"RAS6265","url":"https://www.brewsterwallcovering.com/ras6265-black-pasta-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RAS6265 - Black Pasta Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:33:01.426Z"}
+{"vendor":"brewster","sku":"RAS6266","url":"https://www.brewsterwallcovering.com/ras6266-white-pasta-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RAS6266 - White Pasta Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:33:09.431Z"}
+{"vendor":"brewster","sku":"RAS6267","url":"https://www.brewsterwallcovering.com/ras6267-cream-sardine-tins-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RAS6267 - Cream Sardine Tins Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:33:17.436Z"}
+{"vendor":"brewster","sku":"RAS6268","url":"https://www.brewsterwallcovering.com/ras6268-blue-sardine-tins-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RAS6268 - Blue Sardine Tins Peel and Stick Wallpaper - by WallPops","color":"by WallPops","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:33:25.442Z"}
+{"vendor":"brewster","sku":"RH464849","url":"https://www.brewsterwallcovering.com/rh464849-giacometti-grey-flora-and-faces-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RH464849 - Giacometti Grey Flora & Faces Wallpaper - by Rasch","color":"by Rasch","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:33:33.447Z"}
+{"vendor":"brewster","sku":"RH560565","url":"https://www.brewsterwallcovering.com/rh560565-villon-multicolor-ikat-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RH560565 - Villon Multicolor Ikat Wallpaper - by Rasch","color":"by Rasch","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:33:41.454Z"}
+{"vendor":"brewster","sku":"RH687408","url":"https://www.brewsterwallcovering.com/rh687408-merian-multicolor-architectural-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RH687408 - Merian Multicolor Architectural Wallpaper - by Rasch","color":"by Rasch","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:33:49.459Z"}
+{"vendor":"brewster","sku":"RMDM5559","url":"https://www.brewsterwallcovering.com/rmdm5559-batwheels-characters-blue-wall-decals","status":"failed","brand":"Jeffrey Stevens","name":"RMDM5559 - Batwheels Characters Blue Wall Decals - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:33:57.466Z"}
+{"vendor":"brewster","sku":"RMDM5561","url":"https://www.brewsterwallcovering.com/rmdm5561-shrek-and-donkey-green-wall-decals","status":"failed","brand":"Jeffrey Stevens","name":"RMDM5561 - Shrek and Donkey Green Wall Decals - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:34:05.470Z"}
+{"vendor":"brewster","sku":"RMDM5570","url":"https://www.brewsterwallcovering.com/rmdm5570-peppa-pig-pink-wall-decals","status":"failed","brand":"Jeffrey Stevens","name":"RMDM5570 - Peppa Pig Pink Wall Decals - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:34:13.475Z"}
+{"vendor":"brewster","sku":"RMDM5574","url":"https://www.brewsterwallcovering.com/rmdm5574-x-men-97-characters-black-wall-decals","status":"failed","brand":"Jeffrey Stevens","name":"RMDM5574 - X-MEN '97 Characters Black Wall Decals - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:34:21.479Z"}
+{"vendor":"brewster","sku":"RMDM5575","url":"https://www.brewsterwallcovering.com/rmdm5575-iron-man-and-his-awesome-friends-red-wall-decals","status":"failed","brand":"Jeffrey Stevens","name":"RMDM5575 - Iron Man and His Awesome Friends Red Wall Decals - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:34:29.484Z"}
+{"vendor":"brewster","sku":"RMDM5599","url":"https://www.brewsterwallcovering.com/rmdm5599-wonderfully-made-quote-green-religious-wall-decals","status":"failed","brand":"Jeffrey Stevens","name":"RMDM5599 - Wonderfully Made Quote Green Religious Wall Decals - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:34:37.491Z"}
+{"vendor":"brewster","sku":"RMDM5600","url":"https://www.brewsterwallcovering.com/rmdm5600-in-his-sight-watercolor-tree-multicolor-religious-wall-decals","status":"failed","brand":"Jeffrey Stevens","name":"RMDM5600 - In His Sight Watercolor Tree Multicolor Religious Wall Decals - by Ro","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:34:45.497Z"}
+{"vendor":"brewster","sku":"RMDM5601","url":"https://www.brewsterwallcovering.com/rmdm5601-tree-of-life-cross-green-religious-wall-decals","status":"failed","brand":"Jeffrey Stevens","name":"RMDM5601 - Tree of Life Cross Green Religious Wall Decals - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:34:53.504Z"}
+{"vendor":"brewster","sku":"RMWS1234","url":"https://www.brewsterwallcovering.com/rmws1234-wicked-emerald-city-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1234 - Wicked Emerald City Peel and Stick Wallpaper - by Wicked","color":"by Wicked","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:35:01.509Z"}
+{"vendor":"brewster","sku":"RMWS1250","url":"https://www.brewsterwallcovering.com/rmws1250-love-letters-parchment-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1250 - Love Letters Parchment Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:35:09.516Z"}
+{"vendor":"brewster","sku":"RMWS1251","url":"https://www.brewsterwallcovering.com/rmws1251-love-letters-ink-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1251 - Love Letters Ink Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:35:17.520Z"}
+{"vendor":"brewster","sku":"RMWS1252","url":"https://www.brewsterwallcovering.com/rmws1252-wildflower-impressions-magenta-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1252 - Wildflower Impressions Magenta Peel and Stick Wallpaper - by RoomMate","color":"by RoomMates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:35:25.526Z"}
+{"vendor":"brewster","sku":"RMWS1253","url":"https://www.brewsterwallcovering.com/rmws1253-wildflower-impressions-aqua-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1253 - Wildflower Impressions Aqua Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:35:33.533Z"}
+{"vendor":"brewster","sku":"RMWS1254","url":"https://www.brewsterwallcovering.com/rmws1254-wildflower-impressions-yellow-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1254 - Wildflower Impressions Yellow Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:35:41.535Z"}
+{"vendor":"brewster","sku":"RMWS1255","url":"https://www.brewsterwallcovering.com/rmws1255-mystic-serpent-black-gold-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1255 - Mystic Serpent Black Gold Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:35:49.541Z"}
+{"vendor":"brewster","sku":"RMWS1256","url":"https://www.brewsterwallcovering.com/rmws1256-mystic-serpent-plum-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1256 - Mystic Serpent Plum Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:35:57.547Z"}
+{"vendor":"brewster","sku":"RMWS1257","url":"https://www.brewsterwallcovering.com/rmws1257-mystic-serpent-navy-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1257 - Mystic Serpent Navy Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:36:05.553Z"}
+{"vendor":"brewster","sku":"RMWS1258","url":"https://www.brewsterwallcovering.com/rmws1258-mystic-serpent-taupe-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1258 - Mystic Serpent Taupe Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:36:13.559Z"}
+{"vendor":"brewster","sku":"RMWS1259","url":"https://www.brewsterwallcovering.com/rmws1259-cowgirl-like-me-pink-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1259 - Cowgirl Like Me Pink Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:36:21.564Z"}
+{"vendor":"brewster","sku":"RMWS1260","url":"https://www.brewsterwallcovering.com/rmws1260-cowgirl-like-me-blue-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1260 - Cowgirl Like Me Blue Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:36:29.569Z"}
+{"vendor":"brewster","sku":"RMWS1261","url":"https://www.brewsterwallcovering.com/rmws1261-cowgirl-like-me-beige-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1261 - Cowgirl Like Me Beige Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:36:37.574Z"}
+{"vendor":"brewster","sku":"RMWS1264","url":"https://www.brewsterwallcovering.com/rmws1264-cowgirl-like-me-black-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1264 - Cowgirl Like Me Black Peel and Stick Wallpaper - by RoomMates","color":"by RoomMates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:36:45.581Z"}
+{"vendor":"brewster","sku":"RMWS1302","url":"https://www.brewsterwallcovering.com/rmws1302-miraculous-ladybug-charming-paris-pink-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1302 - Miraculous Ladybug Charming Paris Pink Peel and Stick Wallpaper - by ","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:36:53.588Z"}
+{"vendor":"brewster","sku":"RMWS1303","url":"https://www.brewsterwallcovering.com/rmws1303-miraculous-ladybug-charming-paris-black-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1303 - Miraculous Ladybug Charming Paris Black Peel and Stick Wallpaper - by","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:37:01.595Z"}
+{"vendor":"brewster","sku":"RMWS1305","url":"https://www.brewsterwallcovering.com/rmws1305-miraculous-ladybug-sketch-charcoal-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1305 - Miraculous Ladybug Sketch Charcoal Peel and Stick Wallpaper - by Room","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:37:09.601Z"}
+{"vendor":"brewster","sku":"RMWS1307","url":"https://www.brewsterwallcovering.com/rmws1307-bluey-and-bingo-hearts-multicolor-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1307 - Bluey & Bingo Hearts Multicolor Peel and Stick Wallpaper - by Roo","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:37:17.607Z"}
+{"vendor":"brewster","sku":"RMWS1308","url":"https://www.brewsterwallcovering.com/rmws1308-wicked-land-of-oz-green-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1308 - Wicked Land of Oz Green Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:37:25.612Z"}
+{"vendor":"brewster","sku":"RMWS1309","url":"https://www.brewsterwallcovering.com/rmws1309-daphne-limewash-mocha-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1309 - Daphne Limewash Mocha Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:37:33.619Z"}
+{"vendor":"brewster","sku":"RMWS1310","url":"https://www.brewsterwallcovering.com/rmws1310-daphne-limewash-moody-blue-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1310 - Daphne Limewash Moody Blue Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:37:41.624Z"}
+{"vendor":"brewster","sku":"RMWS1311","url":"https://www.brewsterwallcovering.com/rmws1311-daphne-limewash-dusty-blue-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1311 - Daphne Limewash Dusty Blue Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:37:49.628Z"}
+{"vendor":"brewster","sku":"RMWS1312","url":"https://www.brewsterwallcovering.com/rmws1312-watercolor-glass-neutral-beige-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1312 - Watercolor Glass Neutral Beige Peel and Stick Wallpaper - by Roommate","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:37:57.633Z"}
+{"vendor":"brewster","sku":"RMWS1313","url":"https://www.brewsterwallcovering.com/rmws1313-watercolor-glass-olive-green-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1313 - Watercolor Glass Olive Green Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:38:05.637Z"}
+{"vendor":"brewster","sku":"RMWS1314","url":"https://www.brewsterwallcovering.com/rmws1314-watercolor-glass-dark-blue-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1314 - Watercolor Glass Dark Blue Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:38:13.641Z"}
+{"vendor":"brewster","sku":"RMWS1316","url":"https://www.brewsterwallcovering.com/rmws1316-tess-watercolor-checker-sage-green-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1316 - Tess Watercolor Checker Sage Green Peel and Stick Wallpaper - by Room","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:38:21.646Z"}
+{"vendor":"brewster","sku":"RMWS1317","url":"https://www.brewsterwallcovering.com/rmws1317-tess-watercolor-checker-pale-yellow-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1317 - Tess Watercolor Checker Pale Yellow Peel and Stick Wallpaper - by Roo","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:38:29.650Z"}
+{"vendor":"brewster","sku":"RMWS1318","url":"https://www.brewsterwallcovering.com/rmws1318-x-men-97-faces-black-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1318 - X-MEN '97 Faces Black Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:38:37.655Z"}
+{"vendor":"brewster","sku":"RMWS1319","url":"https://www.brewsterwallcovering.com/rmws1319-x-men-97-comic-cast-black-and-white-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1319 - X-MEN ‘97 Comic Cast Black and White Peel and Stick Wallpaper ","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:38:45.661Z"}
+{"vendor":"brewster","sku":"RMWS1323","url":"https://www.brewsterwallcovering.com/rmws1323-clueless-cher-yellow-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1323 - Clueless Cher Yellow Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:38:53.666Z"}
+{"vendor":"brewster","sku":"RMWS1324","url":"https://www.brewsterwallcovering.com/rmws1324-clueless-dionne-black-peel-and-stick-wallpaper","status":"failed","brand":"Jeffrey Stevens","name":"RMWS1324 - Clueless Dionne Black Peel and Stick Wallpaper - by Roommates","color":"by Roommates","image":"","specs":{},"attempts":6,"note":"connect ECONNREFUSED 127.0.0.1:9830","doneAt":"2026-07-10T21:39:01.671Z"}
{"vendor":"brewster","sku":"RMWS1347","url":"https://www.brewsterwallcovering.com/rmws1347-disney-lilo-and-stitch-angel-pink-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RMWS1347 - Disney Lilo & Stitch Angel Pink Peel and Stick Wallpaper - by Roo","color":"by Roommates","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
{"vendor":"brewster","sku":"RPS6140","url":"https://www.brewsterwallcovering.com/rps6140-ghost-grey-rudeco-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RPS6140 - Ghost Grey RuDeco Peel and Stick Wallpaper - by RuPaul x WallPops","color":"by RuPaul x WallPops","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
{"vendor":"brewster","sku":"RPS6144","url":"https://www.brewsterwallcovering.com/rps6144-lorange-rujardin-peel-and-stick-wallpaper","status":"pending","brand":"Jeffrey Stevens","name":"RPS6144 - L'orange RuJardin Peel and Stick Wallpaper - by RuPaul x WallPops","color":"by RuPaul x WallPops","image":"","specs":{},"attempts":5,"note":"connect ECONNREFUSED 127.0.0.1:9830 (left pending for retry)"}
diff --git a/shopify/scripts/schu-api-recrawl.js b/shopify/scripts/schu-api-recrawl.js
index deead856..5e30796a 100644
--- a/shopify/scripts/schu-api-recrawl.js
+++ b/shopify/scripts/schu-api-recrawl.js
@@ -24,6 +24,10 @@ const args = process.argv.slice(2);
const TEST = args.includes('--test');
const COMMIT = args.includes('--commit');
const ALL = args.includes('--all');
+// --pillows: backfill the Schumacher Pillows line (product_type='pillow') instead of
+// the default wallcovering set. Same authed API + parse + upsert; only the row filter changes.
+const PILLOWS = args.includes('--pillows');
+const TYPES = PILLOWS ? "'pillow'" : "'Wallcovering','Commercial Wallcovering'";
const lIdx = args.indexOf('--limit');
const LIMIT = TEST ? 3 : (lIdx >= 0 ? parseInt(args[lIdx + 1], 10) : (ALL ? 100000 : 25));
// --refresh N: re-fetch the N already-priced rows with the OLDEST price_fetched_at
@@ -100,14 +104,14 @@ function parse(j) {
let skus;
if (TEST) {
- skus = ['R11358658', ...psql(`SELECT mfr_sku FROM schumacher_catalog WHERE product_type IN ('Wallcovering','Commercial Wallcovering') AND retail_price IS NULL ORDER BY mfr_sku LIMIT 2;`).split('\n').filter(Boolean)];
+ skus = [(PILLOWS ? 'SO7720102' : 'R11358658'), ...psql(`SELECT mfr_sku FROM schumacher_catalog WHERE product_type IN (${TYPES}) AND retail_price IS NULL ORDER BY mfr_sku LIMIT 2;`).split('\n').filter(Boolean)];
} else if (REFRESH) {
// rolling refresh: re-price the N oldest-fetched live rows (keeps prices current)
- skus = psql(`SELECT mfr_sku FROM schumacher_catalog WHERE product_type IN ('Wallcovering','Commercial Wallcovering') AND retail_price IS NOT NULL AND COALESCE(excluded,false)=false AND mfr_sku IS NOT NULL AND mfr_sku<>'' ORDER BY price_fetched_at ASC NULLS FIRST LIMIT ${REFRESH};`).split('\n').filter(Boolean);
+ skus = psql(`SELECT mfr_sku FROM schumacher_catalog WHERE product_type IN (${TYPES}) AND retail_price IS NOT NULL AND COALESCE(excluded,false)=false AND mfr_sku IS NOT NULL AND mfr_sku<>'' ORDER BY price_fetched_at ASC NULLS FIRST LIMIT ${REFRESH};`).split('\n').filter(Boolean);
console.log(`REFRESH mode: re-pricing ${skus.length} oldest-fetched rows`);
} else {
// resume-safe: only rows still missing price AND not already marked discontinued/excluded
- skus = psql(`SELECT mfr_sku FROM schumacher_catalog WHERE product_type IN ('Wallcovering','Commercial Wallcovering') AND retail_price IS NULL AND COALESCE(excluded,false)=false AND mfr_sku IS NOT NULL AND mfr_sku<>'' ORDER BY mfr_sku LIMIT ${LIMIT};`).split('\n').filter(Boolean);
+ skus = psql(`SELECT mfr_sku FROM schumacher_catalog WHERE product_type IN (${TYPES}) AND retail_price IS NULL AND COALESCE(excluded,false)=false AND mfr_sku IS NOT NULL AND mfr_sku<>'' ORDER BY mfr_sku LIMIT ${LIMIT};`).split('\n').filter(Boolean);
}
console.log(`SKUs to fetch: ${skus.length}`);
diff --git a/shopify/scripts/schu-api-recrawl.js.backup-20260710-141735 b/shopify/scripts/schu-api-recrawl.js.backup-20260710-141735
new file mode 100644
index 00000000..deead856
--- /dev/null
+++ b/shopify/scripts/schu-api-recrawl.js.backup-20260710-141735
@@ -0,0 +1,164 @@
+#!/usr/bin/env node
+/**
+ * Schumacher RECRAWL via the authenticated product API (browser-free).
+ *
+ * Cracked 2026-06-11: schumacher.com gates pricing behind trade login, and the price
+ * is NOT in __NEXT_DATA__ (always null) — it lives in api.schumacher.com/products/{SKU},
+ * returned with a Bearer JWT. Steve's logged-in trade session token (sub=466516,
+ * TRADE_ACCOUNT_OWNER, ~92d expiry) is read from .schu-token. With it we fetch price +
+ * full specs for every SKU server-side. No browser, no Browserbase, no Mac2 Chrome.
+ *
+ * Schumacher = "Designer Net": vendor_registry discount 0.00 → priceUsd IS our net cost.
+ * retail_price = trade_price = cost = priceUsd. (our DW retail = cost/0.65/0.85, computed at import)
+ *
+ * node schu-api-recrawl.js --test # 3 SKUs incl R11358658, parse+print, NO write
+ * node schu-api-recrawl.js --limit 50 --commit
+ * node schu-api-recrawl.js --all --commit # all ~4,977 wallpaper rows needing data (resume-safe)
+ */
+const fs = require('fs');
+const path = require('path');
+const { execFileSync } = require('child_process');
+
+const TOKEN = fs.readFileSync(path.join(__dirname, '.schu-token'), 'utf8').trim();
+const args = process.argv.slice(2);
+const TEST = args.includes('--test');
+const COMMIT = args.includes('--commit');
+const ALL = args.includes('--all');
+const lIdx = args.indexOf('--limit');
+const LIMIT = TEST ? 3 : (lIdx >= 0 ? parseInt(args[lIdx + 1], 10) : (ALL ? 100000 : 25));
+// --refresh N: re-fetch the N already-priced rows with the OLDEST price_fetched_at
+// (rolling price refresh for the cadence loop), instead of only filling NULL prices.
+const rfIdx = args.indexOf('--refresh');
+const REFRESH = rfIdx >= 0 ? (parseInt(args[rfIdx + 1], 10) || 300) : 0;
+const sleep = ms => new Promise(r => setTimeout(r, ms));
+
+function psql(sql) { return execFileSync('psql', ['-At', '-F', '\t', '-d', 'dw_unified', '-c', sql], { encoding: 'utf8', maxBuffer: 1 << 28 }).trim(); }
+const q = s => "'" + String(s).replace(/'/g, "''") + "'"; // sql string literal
+const qn = v => (v == null || v === '' || isNaN(parseFloat(v))) ? 'NULL' : parseFloat(v);
+
+// token expiry guard
+function tokenExp() { try { const p = JSON.parse(Buffer.from(TOKEN.split('.')[1], 'base64').toString()); return p.exp; } catch { return 0; } }
+
+async function fetchProduct(sku) {
+ const url = `https://api.schumacher.com/products/${encodeURIComponent(sku)}?skipAnalytics=true`;
+ const r = await fetch(url, { headers: {
+ 'authorization': 'Bearer ' + TOKEN,
+ 'x-version': '1.2',
+ 'x-domain': 'PDP',
+ 'origin': 'https://schumacher.com',
+ 'referer': 'https://schumacher.com/',
+ 'user-agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36',
+ 'accept': '*/*',
+ }});
+ if (r.status === 401 || r.status === 403) { const e = new Error('AUTH_' + r.status); e.auth = true; throw e; }
+ if (!r.ok) throw new Error('HTTP_' + r.status);
+ return r.json();
+}
+
+// attributes[] → { slug: firstValue } (each attr.value is [{value}])
+function attrMap(j) {
+ const m = {};
+ for (const a of (j.attributes || [])) {
+ const vals = (a.value || []).map(v => v.value).filter(Boolean);
+ if (vals.length) m[a.slug] = vals.length === 1 ? vals[0] : vals;
+ }
+ return m;
+}
+
+function parse(j) {
+ const a = attrMap(j);
+ const img = j.imageUrl || (j.images && j.images[0] && j.images[0].largeUrl) || null;
+ // Dedup: Schumacher's API repeats the same largeUrl across image entries
+ // (size variants of one photo) -> previously caused duplicate PDP galleries.
+ const gallery = [...new Set((j.images || []).map(x => x.largeUrl).filter(Boolean))];
+ return {
+ sku: j.itemNumber,
+ priceUsd: (typeof j.priceUsd === 'number') ? j.priceUsd : null,
+ priceCad: (typeof j.priceCad === 'number') ? j.priceCad : null,
+ name: j.name || null,
+ color: j.colorName || null,
+ collection: (j.collection && j.collection.name) || a['collection'] || null,
+ category: (j.category && j.category.name) || null,
+ description: j.description || null,
+ composition: a['content'] || a['content1'] || null, // "100% WOOL"
+ country: a['country-of-origin'] || a['country-of-finish'] || null,
+ size: a['size'] || null,
+ width: a['item-width-imperial-fraction'] || null,
+ repeat_v: a['vertical-repeat'] || a['repeat-vertical'] || null,
+ repeat_h: a['horizontal-repeat'] || a['repeat-horizontal'] || null,
+ image_url: img,
+ gallery,
+ specs: a,
+ };
+}
+
+(async () => {
+ const exp = tokenExp();
+ const daysLeft = Math.round((exp - Date.now() / 1000) / 86400);
+ if (exp && exp < Date.now() / 1000) { console.error('TOKEN EXPIRED — refresh .schu-token from a logged-in browser session.'); process.exit(2); }
+ console.log(`token ok (~${daysLeft}d left) | mode: ${TEST ? 'TEST' : COMMIT ? 'COMMIT' : 'DRY'} | limit ${LIMIT}`);
+
+ let skus;
+ if (TEST) {
+ skus = ['R11358658', ...psql(`SELECT mfr_sku FROM schumacher_catalog WHERE product_type IN ('Wallcovering','Commercial Wallcovering') AND retail_price IS NULL ORDER BY mfr_sku LIMIT 2;`).split('\n').filter(Boolean)];
+ } else if (REFRESH) {
+ // rolling refresh: re-price the N oldest-fetched live rows (keeps prices current)
+ skus = psql(`SELECT mfr_sku FROM schumacher_catalog WHERE product_type IN ('Wallcovering','Commercial Wallcovering') AND retail_price IS NOT NULL AND COALESCE(excluded,false)=false AND mfr_sku IS NOT NULL AND mfr_sku<>'' ORDER BY price_fetched_at ASC NULLS FIRST LIMIT ${REFRESH};`).split('\n').filter(Boolean);
+ console.log(`REFRESH mode: re-pricing ${skus.length} oldest-fetched rows`);
+ } else {
+ // resume-safe: only rows still missing price AND not already marked discontinued/excluded
+ skus = psql(`SELECT mfr_sku FROM schumacher_catalog WHERE product_type IN ('Wallcovering','Commercial Wallcovering') AND retail_price IS NULL AND COALESCE(excluded,false)=false AND mfr_sku IS NOT NULL AND mfr_sku<>'' ORDER BY mfr_sku LIMIT ${LIMIT};`).split('\n').filter(Boolean);
+ }
+ console.log(`SKUs to fetch: ${skus.length}`);
+
+ let ok = 0, priced = 0, miss = 0, err = 0, disco = 0;
+ for (let i = 0; i < skus.length; i++) {
+ const sku = skus[i];
+ try {
+ const j = await fetchProduct(sku);
+ const p = parse(j);
+ if (p.priceUsd == null) miss++;
+ if (TEST || !COMMIT) {
+ console.log(` ${sku} $${p.priceUsd} ${p.composition || ''} | ${p.country || ''} | ${p.size || p.width || ''} | ${(p.name||'').slice(0,30)}`);
+ } else {
+ const our = p.priceUsd != null ? (p.priceUsd / 0.65 / 0.85) : null; // DW retail (kept in `price` text for now)
+ const sets = [
+ `retail_price=${qn(p.priceUsd)}`,
+ `trade_price=${qn(p.priceUsd)}`, // discount 0.00 → net = listed
+ `cost=${qn(p.priceUsd)}`,
+ `price=${p.priceUsd != null ? q('$' + p.priceUsd.toFixed(2)) : 'NULL'}`,
+ `price_fetched_at=now()`, `updated_at=now()`,
+ p.name ? `pattern_name=COALESCE(NULLIF(pattern_name,''),${q(p.name)})` : null,
+ p.color ? `color_name=COALESCE(NULLIF(color_name,''),${q(p.color)})` : null,
+ p.collection ? `collection=COALESCE(NULLIF(collection,''),${q(p.collection)})` : null,
+ p.description ? `description=COALESCE(NULLIF(description,''),${q(p.description)})` : null,
+ p.composition ? `composition=${q(p.composition)}` : null,
+ p.composition ? `material=COALESCE(NULLIF(material,''),${q(p.composition)})` : null,
+ p.country ? `country_of_origin=${q(p.country)}` : null,
+ p.width ? `width=COALESCE(NULLIF(width,''),${q(p.width)})` : null,
+ p.image_url ? `image_url=COALESCE(NULLIF(image_url,''),${q(p.image_url)})` : null,
+ p.gallery.length ? `gallery_images=${q(JSON.stringify(p.gallery))}::jsonb` : null,
+ `specs=${q(JSON.stringify(p.specs))}::jsonb`,
+ ].filter(Boolean).join(', ');
+ psql(`UPDATE schumacher_catalog SET ${sets} WHERE mfr_sku=${q(sku)};`);
+ if (p.priceUsd != null) priced++;
+ }
+ ok++;
+ } catch (e) {
+ if (e.auth) { console.error(`\nAUTH FAILURE on ${sku} (${e.message}) — token likely expired/invalid. Stopping.`); break; }
+ if (e.message === 'HTTP_404') {
+ // discontinued at vendor — log + mark excluded so it's skipped on resume + queued for Shopify archive
+ disco++;
+ if (COMMIT && !TEST) psql(`UPDATE schumacher_catalog SET excluded=true, price='DISCONTINUED', agent_updated_at=now() WHERE mfr_sku=${q(sku)};`);
+ fs.appendFileSync('/tmp/schu-disco-skus.txt', sku + '\n');
+ console.log(` ${sku} DISCONTINUED (404) — marked excluded`);
+ } else {
+ err++;
+ console.log(` ${sku} ERR ${e.message}`);
+ }
+ }
+ if (!TEST && (i + 1) % 50 === 0) process.stdout.write(`\r progress ${i + 1}/${skus.length} | priced ${priced} | disco ${disco} | err ${err}`);
+ await sleep(350);
+ }
+ console.log(`\nDONE: fetched ${ok}, priced ${priced}, no-price ${miss}, discontinued ${disco}, errors ${err}${COMMIT && !TEST ? ' (written to schumacher_catalog; disco marked excluded → /tmp/schu-disco-skus.txt)' : ' (dry — no write)'}`);
+})();
diff --git a/shopify/scripts/schu-pillow-orphan-resolve.js b/shopify/scripts/schu-pillow-orphan-resolve.js
new file mode 100644
index 00000000..0bd9fdea
--- /dev/null
+++ b/shopify/scripts/schu-pillow-orphan-resolve.js
@@ -0,0 +1,65 @@
+#!/usr/bin/env node
+/* One-off resolver: 471 live DWPIL sample-only pillows carry a real SO code only in their
+ * image_url (mfr_sku is corrupted). 231 already match staging; this resolves the other ~240
+ * whose SO code isn't in schumacher_catalog by fetching each from the authed Schumacher API
+ * with the existing .schu-token. Priced -> INSERT into schumacher_catalog (product_type=pillow,
+ * STAGING only). 404 -> collected as discontinued. No Shopify writes. Reversible.
+ * node schu-pillow-orphan-resolve.js # dry (fetch + categorize, NO write)
+ * node schu-pillow-orphan-resolve.js --commit # insert priced orphans into staging
+ */
+const fs = require('fs'); const path = require('path'); const { execFileSync } = require('child_process');
+const TOKEN = fs.readFileSync(path.join(__dirname, '.schu-token'), 'utf8').trim();
+const COMMIT = process.argv.includes('--commit');
+const sleep = ms => new Promise(r => setTimeout(r, ms));
+function psql(sql){ return execFileSync('psql',['-At','-F','\t','-d','dw_unified','-c',sql],{encoding:'utf8',maxBuffer:1<<28}).trim(); }
+const q = s => "'"+String(s).replace(/'/g,"''")+"'";
+const qn = v => (v==null||v===''||isNaN(parseFloat(v)))?'NULL':parseFloat(v);
+
+async function fetchProduct(sku){
+ const r = await fetch(`https://api.schumacher.com/products/${encodeURIComponent(sku)}?skipAnalytics=true`, { headers:{
+ 'authorization':'Bearer '+TOKEN,'x-version':'1.2','x-domain':'PDP','origin':'https://schumacher.com',
+ 'referer':'https://schumacher.com/','user-agent':'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 Chrome/149 Safari/537.36','accept':'*/*' }});
+ if (r.status===401||r.status===403){ const e=new Error('AUTH_'+r.status); e.auth=true; throw e; }
+ if (r.status===404) return { _404:true };
+ if (!r.ok) throw new Error('HTTP_'+r.status);
+ return r.json();
+}
+const attr=(j,slug)=>{const a=(j.attributes||[]).find(x=>x.slug===slug); if(!a)return null; const v=(a.value||[]).map(x=>x.value).filter(Boolean); return v[0]||null;};
+
+(async()=>{
+ // live pillow SO codes (from image_url) that are NOT already priced pillows in staging
+ const rows = psql(`
+ WITH live AS (
+ SELECT dw_sku, (regexp_match(image_url,'SO[0-9]+'))[1] AS code
+ FROM shopify_products
+ WHERE (dw_sku ILIKE 'DWPIL%' OR sku ILIKE 'DWPIL%') AND status='ACTIVE'
+ AND has_sample_variant AND NOT has_product_variant AND image_url ~ 'SO[0-9]+'
+ )
+ SELECT DISTINCT l.code FROM live l
+ LEFT JOIN schumacher_catalog sc ON sc.mfr_sku=l.code AND sc.product_type='pillow'
+ WHERE sc.mfr_sku IS NULL AND l.code IS NOT NULL;`).split('\n').filter(Boolean);
+ console.log(`orphan SO codes to resolve: ${rows.length} | mode ${COMMIT?'COMMIT':'DRY'}`);
+ let priced=0, disco=0, err=0, np=0; const discoList=[];
+ for (let i=0;i<rows.length;i++){
+ const sku=rows[i];
+ try{
+ const j=await fetchProduct(sku);
+ if (j._404){ disco++; discoList.push(sku); continue; }
+ const price=(typeof j.priceUsd==='number')?j.priceUsd:null;
+ if (price==null) np++;
+ else {
+ priced++;
+ if (COMMIT){
+ const img=j.imageUrl||(j.images&&j.images[0]&&j.images[0].largeUrl)||null;
+ psql(`INSERT INTO schumacher_catalog (mfr_sku,pattern_name,color_name,product_type,retail_price,trade_price,cost,price,image_url,description,width,price_fetched_at,crawled_at,updated_at)
+ VALUES (${q(sku)},${q(j.name||'')},${q(j.colorName||'')},'pillow',${qn(price)},${qn(price)},${qn(price)},${q('$'+price.toFixed(2))},${img?q(img):'NULL'},${j.description?q(j.description):'NULL'},${q(attr(j,'size')||'')},now(),now(),now())
+ ON CONFLICT (mfr_sku) DO UPDATE SET retail_price=EXCLUDED.retail_price, trade_price=EXCLUDED.trade_price, cost=EXCLUDED.cost, price=EXCLUDED.price, product_type='pillow', price_fetched_at=now(), updated_at=now();`);
+ }
+ }
+ }catch(e){ if(e.auth){console.error('AUTH FAIL — stopping');break;} err++; }
+ if((i+1)%40===0) process.stdout.write(`\r ${i+1}/${rows.length} | priced ${priced} disco ${disco} err ${err}`);
+ await sleep(320);
+ }
+ if (discoList.length) fs.writeFileSync('/tmp/schu-pillow-disco.txt', discoList.join('\n'));
+ console.log(`\nDONE: priced ${priced}, discontinued(404) ${disco}, no-price ${np}, err ${err}${COMMIT?' (priced inserted into staging)':' (dry)'}${discoList.length?' | disco list -> /tmp/schu-pillow-disco.txt':''}`);
+})();
\ No newline at end of file
← 65a5023e auto-save: 2026-07-10T14:08:52 (4 files) — pending-approval/
·
back to Designer Wallcoverings
·
auto-save: 2026-07-10T15:09:07 (5 files) — DW-Programming/Im 94758019 →