← back to Hollywood Import
Push Group-1 retail prices to 62 live Shopify products
5dd0e7467ceaeabf81479b6b642d98e5d30a9408 · 2026-06-17 13:49:23 -0700 · SteveStudio2
- push-g1-shopify.mjs: resolves each product's 'Sold Per Yard' variant live, sets price=hw
(list×1.448), never touches the $4.25 Sample variant; dry-run default, --apply to write
- 62/62 updated + confirmed, 0 errors, samples preserved
- token read from canonical secrets-manager/.env (not hardcoded)
Files touched
A push-g1-result.jsonA push-g1-shopify.mjs
Diff
commit 5dd0e7467ceaeabf81479b6b642d98e5d30a9408
Author: SteveStudio2 <stevestudio2@SteveStacStudio.lan>
Date: Wed Jun 17 13:49:23 2026 -0700
Push Group-1 retail prices to 62 live Shopify products
- push-g1-shopify.mjs: resolves each product's 'Sold Per Yard' variant live, sets price=hw
(list×1.448), never touches the $4.25 Sample variant; dry-run default, --apply to write
- 62/62 updated + confirmed, 0 errors, samples preserved
- token read from canonical secrets-manager/.env (not hardcoded)
---
push-g1-result.json | 808 ++++++++++++++++++++++++++++++++++++++++++++++++++++
push-g1-shopify.mjs | 51 ++++
2 files changed, 859 insertions(+)
diff --git a/push-g1-result.json b/push-g1-result.json
new file mode 100644
index 0000000..73410ef
--- /dev/null
+++ b/push-g1-result.json
@@ -0,0 +1,808 @@
+[
+ {
+ "pid": "7814879805491",
+ "title": "Signal Hill Minimalist | Hollywood Wallcoverings",
+ "mfr": "A179-001",
+ "yard_sku": "DWHD-500696-Yard",
+ "yard_vid": 44193896431667,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7815309819955",
+ "title": "Pacific Junction Reverie | Hollywood Wallcoverings",
+ "mfr": "AVF01-576",
+ "yard_sku": "DWHD-506955",
+ "yard_vid": 44190850940979,
+ "cur_price": "53.08",
+ "new_price": "49.09",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "49.09"
+ },
+ {
+ "pid": "7814464274483",
+ "title": "Asilomar - Biscuit Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127164",
+ "yard_sku": "DWHD-502872",
+ "yard_vid": 44188115697715,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814879576115",
+ "title": "Pacific Heights Loom | Hollywood Wallcoverings",
+ "mfr": "AVF27-681",
+ "yard_sku": "DWHD-505164-Yard",
+ "yard_vid": 44193896366131,
+ "cur_price": "56.41",
+ "new_price": "52.42",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "52.42"
+ },
+ {
+ "pid": "7814465421363",
+ "title": "Asilomar - Sparkle Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127523",
+ "yard_sku": "DWHD-502902",
+ "yard_vid": 44188118384691,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464471091",
+ "title": "Asilomar - Crystalline Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127011",
+ "yard_sku": "DWHD-502878",
+ "yard_vid": 44188116090931,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814465323059",
+ "title": "Asilomar - Shimmer Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127175",
+ "yard_sku": "DWHD-502899",
+ "yard_vid": 44188118188083,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464897075",
+ "title": "Asilomar - Fossil Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127549",
+ "yard_sku": "DWHD-502886",
+ "yard_vid": 44188117303347,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464340019",
+ "title": "Asilomar - Cerulean Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127340",
+ "yard_sku": "DWHD-502874",
+ "yard_vid": 44188115828787,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464766003",
+ "title": "Asilomar - Deep Shadow Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127552",
+ "yard_sku": "DWHD-502882",
+ "yard_vid": 44188116942899,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814465126451",
+ "title": "Asilomar - Pale Silver Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127538",
+ "yard_sku": "DWHD-502893",
+ "yard_vid": 44188117762099,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814465355827",
+ "title": "Asilomar - Silver Leaf Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127849",
+ "yard_sku": "DWHD-502900",
+ "yard_vid": 44188118253619,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814465257523",
+ "title": "Asilomar - Radiance Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127444",
+ "yard_sku": "DWHD-502897",
+ "yard_vid": 44188118057011,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464864307",
+ "title": "Asilomar - Firelight Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127675",
+ "yard_sku": "DWHD-502885",
+ "yard_vid": 44188117237811,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464831539",
+ "title": "Asilomar - Felt Grey Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127592",
+ "yard_sku": "DWHD-502884",
+ "yard_vid": 44188117073971,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814465159219",
+ "title": "Asilomar - Peridot Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127221",
+ "yard_sku": "DWHD-502894",
+ "yard_vid": 44188117827635,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464962611",
+ "title": "Asilomar - Hot Sun Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127492",
+ "yard_sku": "DWHD-502888",
+ "yard_vid": 44188117434419,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464929843",
+ "title": "Asilomar - Herbal Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127257",
+ "yard_sku": "DWHD-502887",
+ "yard_vid": 44188117368883,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814465290291",
+ "title": "Asilomar - Renaissance Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127505",
+ "yard_sku": "DWHD-502898",
+ "yard_vid": 44188118122547,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464438323",
+ "title": "Asilomar - Cocoa Bean Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127531",
+ "yard_sku": "DWHD-502877",
+ "yard_vid": 44188116025395,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814465191987",
+ "title": "Asilomar - Pewter Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127543",
+ "yard_sku": "DWHD-502895",
+ "yard_vid": 44188117893171,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464798771",
+ "title": "Asilomar - Ember Glow Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127682",
+ "yard_sku": "DWHD-502883",
+ "yard_vid": 44188117008435,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464995379",
+ "title": "Asilomar - Island Sky Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127390",
+ "yard_sku": "DWHD-502889",
+ "yard_vid": 44188117499955,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814465060915",
+ "title": "Asilomar - Moonlight Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127343",
+ "yard_sku": "DWHD-502891",
+ "yard_vid": 44188117631027,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814465224755",
+ "title": "Asilomar - Porcelain Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127014",
+ "yard_sku": "DWHD-502896",
+ "yard_vid": 44188117958707,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814465486899",
+ "title": "Asilomar - Summer Field Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127256",
+ "yard_sku": "DWHD-502903",
+ "yard_vid": 44188119072819,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464733235",
+ "title": "Asilomar - Dawn Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127874",
+ "yard_sku": "DWHD-502881",
+ "yard_vid": 44188116877363,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464503859",
+ "title": "Asilomar - Dappled Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127191",
+ "yard_sku": "DWHD-502879",
+ "yard_vid": 44188116156467,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814465093683",
+ "title": "Asilomar - Nimbus Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127818",
+ "yard_sku": "DWHD-502892",
+ "yard_vid": 44188117696563,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464602163",
+ "title": "Asilomar - Twilight Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127317",
+ "yard_sku": "DWHD-502906",
+ "yard_vid": 44188116484147,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814465028147",
+ "title": "Asilomar - Mirage Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127832",
+ "yard_sku": "DWHD-502890",
+ "yard_vid": 44188117565491,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464405555",
+ "title": "Asilomar - Coastal Fog Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127568",
+ "yard_sku": "DWHD-502876",
+ "yard_vid": 44188115959859,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814465388595",
+ "title": "Asilomar - Snow Field Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127003",
+ "yard_sku": "DWHD-502901",
+ "yard_vid": 44188118319155,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464307251",
+ "title": "Asilomar - Candlelight Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127760",
+ "yard_sku": "DWHD-502873",
+ "yard_vid": 44188115763251,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814464536627",
+ "title": "Asilomar - Tangerine Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127417",
+ "yard_sku": "DWHD-502905",
+ "yard_vid": 44188116222003,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7816351776819",
+ "title": "Del Mar - Natural Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "A203-552",
+ "yard_sku": "DWHD-500151",
+ "yard_vid": 44193672855603,
+ "cur_price": "55.54",
+ "new_price": "51.55",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "51.55"
+ },
+ {
+ "pid": "7816364326963",
+ "title": "Gorda - Silverworks Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "A183-500",
+ "yard_sku": "DWHD-503390",
+ "yard_vid": 44193687961651,
+ "cur_price": "52.28",
+ "new_price": "48.29",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "48.29"
+ },
+ {
+ "pid": "7816365211699",
+ "title": "Corona Del - Vapor Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "A217-040",
+ "yard_sku": "DWHD-505987",
+ "yard_vid": 44193689272371,
+ "cur_price": "60.90",
+ "new_price": "56.91",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "56.91"
+ },
+ {
+ "pid": "7816365932595",
+ "title": "Solimar Beach - Obsidian Jewel Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "MCV-DD-01",
+ "yard_sku": "DWHD-501779",
+ "yard_vid": 44193690320947,
+ "cur_price": "89.57",
+ "new_price": "85.58",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "85.58"
+ },
+ {
+ "pid": "7816365735987",
+ "title": "Point Pinos - Parchment Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "LLN-HU-04",
+ "yard_sku": "DWHD-503133",
+ "yard_vid": 44193690026035,
+ "cur_price": "63.72",
+ "new_price": "59.73",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "59.73"
+ },
+ {
+ "pid": "7816413216819",
+ "title": "Prewitt Ridge - Moonlight Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "LLN-KL-03",
+ "yard_sku": "DWHD-503447",
+ "yard_vid": 44193763393587,
+ "cur_price": "69.22",
+ "new_price": "65.23",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "65.23"
+ },
+ {
+ "pid": "7814464700467",
+ "title": "Asilomar - Dark Star Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127533",
+ "yard_sku": "DWHD-502880",
+ "yard_vid": 44188116811827,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814360989747",
+ "title": "Zipper Zing - Toasted Almond Wallcovering | Hollywood Wallcoverings",
+ "mfr": "T2-ZN-12",
+ "yard_sku": "DWHD-508021",
+ "yard_vid": 44187867119667,
+ "cur_price": "63.21",
+ "new_price": "58.72",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "58.72"
+ },
+ {
+ "pid": "7815312539699",
+ "title": "Dos Pueblos Mathematician | Hollywood Wallcoverings",
+ "mfr": "TEI-04",
+ "yard_sku": "DWHD-502334",
+ "yard_vid": 44190853627955,
+ "cur_price": "127.43",
+ "new_price": "122.94",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "122.94"
+ },
+ {
+ "pid": "7816413347891",
+ "title": "Hammond Point - Serene Dream Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "MCV-SM-02",
+ "yard_sku": "DWHD-506273",
+ "yard_vid": 44193763655731,
+ "cur_price": "3578.35",
+ "new_price": "3578.44",
+ "unit": "EA",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "3578.44"
+ },
+ {
+ "pid": "7816416493619",
+ "title": "China Camp - Jade Garden Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "A163-326",
+ "yard_sku": "DWHD-505645",
+ "yard_vid": 44193773092915,
+ "cur_price": "52.64",
+ "new_price": "48.65",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "48.65"
+ },
+ {
+ "pid": "7816416526387",
+ "title": "Sand City - Charcoal Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "A175-579",
+ "yard_sku": "DWHD-502930",
+ "yard_vid": 44193773158451,
+ "cur_price": "51.20",
+ "new_price": "47.20",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "47.20"
+ },
+ {
+ "pid": "7816416657459",
+ "title": "Laguna Beach - Madagascar Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "HAR-08",
+ "yard_sku": "DWHD-500264",
+ "yard_vid": 44193773420595,
+ "cur_price": "152.55",
+ "new_price": "148.06",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "148.06"
+ },
+ {
+ "pid": "7816416690227",
+ "title": "Cardiff - Ballpoint Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "LLN-AR-01",
+ "yard_sku": "DWHD-500177",
+ "yard_vid": 44193773486131,
+ "cur_price": "59.23",
+ "new_price": "55.24",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "55.24"
+ },
+ {
+ "pid": "7816413282355",
+ "title": "Partington Canyon - Night Wind Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "LYN-LR-07",
+ "yard_sku": "DWHD-503842",
+ "yard_vid": 44193763524659,
+ "cur_price": "60.46",
+ "new_price": "55.97",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "55.97"
+ },
+ {
+ "pid": "7816413380659",
+ "title": "Las Cruces - Lady Slipper Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "MVS-EF-03",
+ "yard_sku": "DWHD-502243",
+ "yard_vid": 44193763721267,
+ "cur_price": "57.79",
+ "new_price": "53.79",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "53.79"
+ },
+ {
+ "pid": "7816413478963",
+ "title": "Pacific Village - Rock Garden Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "SG3123",
+ "yard_sku": "DWHD-506862",
+ "yard_vid": 44193763917875,
+ "cur_price": "60.46",
+ "new_price": "55.97",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "55.97"
+ },
+ {
+ "pid": "7816413249587",
+ "title": "Pacific Valley - Bramble Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "LLN-LF-03",
+ "yard_sku": "DWHD-503666",
+ "yard_vid": 44193763459123,
+ "cur_price": "66.62",
+ "new_price": "62.63",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "62.63"
+ },
+ {
+ "pid": "7816413577267",
+ "title": "Felton - Rustic Jade Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "T2-MR-17",
+ "yard_sku": "DWHD-504193",
+ "yard_vid": 44193764114483,
+ "cur_price": "59.88",
+ "new_price": "55.39",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "55.39"
+ },
+ {
+ "pid": "7816413544499",
+ "title": "Treasure Island - Cypress Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "SWM-158",
+ "yard_sku": "DWHD-507824",
+ "yard_vid": 44193764048947,
+ "cur_price": "81.02",
+ "new_price": "80.36",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "80.36"
+ },
+ {
+ "pid": "7816414986291",
+ "title": "Anchor Bay - Jubilee Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "MCV-RS-01",
+ "yard_sku": "DWHD-505817",
+ "yard_vid": 44193771225139,
+ "cur_price": "3576.69",
+ "new_price": "3576.78",
+ "unit": "EA",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "3576.78"
+ },
+ {
+ "pid": "7816415051827",
+ "title": "Felton - Onyx Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "T2-MR-16",
+ "yard_sku": "DWHD-504190",
+ "yard_vid": 44193771356211,
+ "cur_price": "59.88",
+ "new_price": "55.39",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "55.39"
+ },
+ {
+ "pid": "7816413184051",
+ "title": "Templeton - Fairy Tale Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "LLN-FC-03",
+ "yard_sku": "DWHD-502591",
+ "yard_vid": 44193763328051,
+ "cur_price": "73.64",
+ "new_price": "69.65",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "69.65"
+ },
+ {
+ "pid": "7816413315123",
+ "title": "Los Osos - Dazzling Pearl Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "MCV-CU-02",
+ "yard_sku": "DWHD-501529",
+ "yard_vid": 44193763590195,
+ "cur_price": "88.77",
+ "new_price": "84.78",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "84.78"
+ },
+ {
+ "pid": "7814464372787",
+ "title": "Asilomar - Chestnut Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127581",
+ "yard_sku": "DWHD-502875",
+ "yard_vid": 44188115894323,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7814465519667",
+ "title": "Asilomar - Suntan Wallcovering | Hollywood Wallcoverings",
+ "mfr": "ASL-127168",
+ "yard_sku": "DWHD-502904",
+ "yard_vid": 44188119138355,
+ "cur_price": "49.02",
+ "new_price": "45.03",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "45.03"
+ },
+ {
+ "pid": "7816416624691",
+ "title": "Laguna Beach - Ecru Commercial Wallcovering | Hollywood Wallcoverings",
+ "mfr": "HAR-04",
+ "yard_sku": "DWHD-500262",
+ "yard_vid": 44193773355059,
+ "cur_price": "152.55",
+ "new_price": "148.06",
+ "unit": "YD",
+ "sample_price": "4.25",
+ "action": "UPDATED",
+ "confirmed": "148.06"
+ }
+]
\ No newline at end of file
diff --git a/push-g1-shopify.mjs b/push-g1-shopify.mjs
new file mode 100644
index 0000000..3de52b0
--- /dev/null
+++ b/push-g1-shopify.mjs
@@ -0,0 +1,51 @@
+// Push Group-1 retail prices to the 62 live Shopify products. For each product, resolve the
+// NON-sample ("Sold Per Yard") variant live and set its price = newhw. NEVER touch the $4.25
+// Sample variant. DRY-RUN by default (no writes); pass --apply to PUT. Read token from canonical .env.
+import fs from 'node:fs';
+import { execSync } from 'node:child_process';
+
+const APPLY = process.argv.includes('--apply');
+const envTxt = fs.readFileSync('/Users/stevestudio2/Projects/secrets-manager/.env', 'utf8');
+const TOKEN = (envTxt.match(/^SHOPIFY_ADMIN_TOKEN=(.+)$/m) || [])[1].trim();
+const STORE = (envTxt.match(/^SHOPIFY_STORE=(.+)$/m) || [])[1].trim();
+const API = `https://${STORE}/admin/api/2024-01`;
+const H = { 'X-Shopify-Access-Token': TOKEN, 'Content-Type': 'application/json' };
+
+const rows = fs.readFileSync('/tmp/g1_push.tsv', 'utf8').trim().split('\n').map(l => l.split('\t'));
+const sleep = ms => new Promise(r => setTimeout(r, ms));
+const log = [];
+let changed = 0, noop = 0, skipped = 0, errors = 0;
+
+for (const [pid, mfr, newhw, unit] of rows) {
+ try {
+ const r = await fetch(`${API}/products/${pid}.json?fields=id,title,variants`, { headers: H });
+ if (!r.ok) { errors++; log.push({ pid, mfr, err: 'GET ' + r.status }); continue; }
+ const p = (await r.json()).product;
+ // yard variant = the one that is NOT the sample
+ const sample = p.variants.find(v => /sample/i.test(v.sku || '') || /sample/i.test(v.title || ''));
+ const yard = p.variants.find(v => v !== sample);
+ if (!yard) { skipped++; log.push({ pid, title: p.title, note: 'no non-sample variant (sample-only)' }); continue; }
+ const cur = parseFloat(yard.price);
+ const next = parseFloat(newhw);
+ const rec = { pid, title: p.title, mfr, yard_sku: yard.sku, yard_vid: yard.id,
+ cur_price: yard.price, new_price: next.toFixed(2), unit,
+ sample_price: sample ? sample.price : '(none)' };
+ if (Math.abs(cur - next) < 0.005) { noop++; rec.action = 'noop'; log.push(rec); continue; }
+ rec.action = APPLY ? 'UPDATED' : 'would-update';
+ if (APPLY) {
+ const u = await fetch(`${API}/variants/${yard.id}.json`, { method: 'PUT', headers: H,
+ body: JSON.stringify({ variant: { id: yard.id, price: next.toFixed(2) } }) });
+ if (!u.ok) { errors++; rec.action = 'ERR ' + u.status; log.push(rec); await sleep(600); continue; }
+ const got = (await u.json()).variant?.price;
+ rec.confirmed = got;
+ if (parseFloat(got) !== next) { errors++; rec.action = 'MISMATCH'; }
+ await sleep(550); // ~2/s, safe under Shopify REST bucket
+ }
+ changed++; log.push(rec);
+ } catch (e) { errors++; log.push({ pid, mfr, err: String(e).slice(0, 80) }); }
+}
+
+fs.writeFileSync(new URL('push-g1-result.json', import.meta.url), JSON.stringify(log, null, 2));
+console.log(`mode=${APPLY ? 'APPLY' : 'DRY-RUN'} | total=${rows.length} change=${changed} noop=${noop} skip=${skipped} err=${errors}`);
+console.log('--- first 8 ---');
+log.slice(0, 8).forEach(r => console.log(' ' + JSON.stringify(r)));
← 540f7ea Add stage-names-alt.mjs generator (name-scrub + alt-tag stag
·
back to Hollywood Import
·
Tri-Kes/Momentum batch 2: price 992 via FileMaker col3→crawl 8538f43 →