← back to Gmc Titlefix
auto-data-snapshot: 2026-09-16T15:11:20 (1 data files) — data/tk11844-pj-authoritative-join.json
192552cd3f37ead505c0a2473c608c0a917571d9 · 2026-09-16 15:13:37 -0700 · auto-commit-fleet
Files touched
A data/tk11844-pj-authoritative-join.json
Diff
commit 192552cd3f37ead505c0a2473c608c0a917571d9
Author: auto-commit-fleet <steve@designerwallcoverings.com>
Date: Wed Sep 16 15:13:37 2026 -0700
auto-data-snapshot: 2026-09-16T15:11:20 (1 data files) — data/tk11844-pj-authoritative-join.json
---
data/tk11844-pj-authoritative-join.json | 474 ++++++++++++++++++++++++++++++++
1 file changed, 474 insertions(+)
diff --git a/data/tk11844-pj-authoritative-join.json b/data/tk11844-pj-authoritative-join.json
new file mode 100644
index 0000000..af0ce9f
--- /dev/null
+++ b/data/tk11844-pj-authoritative-join.json
@@ -0,0 +1,474 @@
+{
+ "ticket": "TK-11844",
+ "read_only": true,
+ "fetched_at": "2026-09-16T21:41:39.126Z",
+ "method": "authoritative Shopify vendor->id-set join on live GMC offers (both offerId forms)",
+ "walk_complete": true,
+ "total_offers_walked": 61992,
+ "pj_shopify": {
+ "products": 4147,
+ "active_products": 3392,
+ "variants": 4278
+ },
+ "pj_gmc_offers": 27,
+ "pj_serving": 16,
+ "pj_disapproved_only": 11,
+ "offers_text_matcher_would_MISS": 20,
+ "prior_text_count_TK11449": 7,
+ "rows": [
+ {
+ "offerId": "44455859126323",
+ "form": "bare",
+ "matched_by": "variantId",
+ "text_matcher_would_catch": true,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Sakka - White on Marshmallow Manila Hemp 11' Panel Height - Mural Repeat: 264\" (",
+ "brand": null,
+ "price": 5212.67,
+ "shopify_productId": null,
+ "shopify_variantId": "44455859126323",
+ "shopify_product_status": "(bare-offer:unknown-pid)",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-13182-philip-jeffries-sakka-white-on-marshmallow-manila-hemp-11-panel-height-mural-repeat-264-670-6-cm-h-9022"
+ },
+ {
+ "offerId": "44455856701491",
+ "form": "bare",
+ "matched_by": "variantId",
+ "text_matcher_would_catch": true,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Haiku - Red Rejuvination on Venetian Glass Glam Grass 11' Panel Height - Mural R",
+ "brand": null,
+ "price": 5212.67,
+ "shopify_productId": null,
+ "shopify_variantId": "44455856701491",
+ "shopify_product_status": "(bare-offer:unknown-pid)",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-13178-philip-jeffries-haiku-red-rejuvination-on-venetian-glass-glam-grass-11-panel-height-mural-repeat-264-670-6-cm-h-9020?variant=44455856701491"
+ },
+ {
+ "offerId": "shopify_US_7375889465395_42512083681331",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": true,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Sakka - Beige on Manicured White Zen Washi 11' Panel Height - Mural Repeat: 264\"",
+ "brand": null,
+ "price": 5212.67,
+ "shopify_productId": "7375889465395",
+ "shopify_variantId": "42512083681331",
+ "shopify_product_status": "ACTIVE",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-13180-philip-jeffries-sakka-beige-on-manicured-white-zen-washi-11-panel-height-mural-repeat-264-670-6-cm-h-9021?variant=44455857848371&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375725035571_42511883108403",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": false,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Chain Mail - Platinum Sword",
+ "brand": null,
+ "price": 369.23,
+ "shopify_productId": "7375725035571",
+ "shopify_variantId": "42511883108403",
+ "shopify_product_status": "ACTIVE",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-11882-philip-jeffries-chain-mail-platinum-sword-5855?variant=44455852507187&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375725330483_42511883239475",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": false,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Rivets - Chrome on Blue Linen Repeat: 11.33\" (28.8cm)V x 11.33\"(28.8cm) H",
+ "brand": null,
+ "price": 369.23,
+ "shopify_productId": "7375725330483",
+ "shopify_variantId": "42511883239475",
+ "shopify_product_status": "ACTIVE",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-11886-philip-jeffries-rivets-chrome-on-blue-linen-repeat-11-33-28-8cmv-x-11-3328-8cm-h-5872?variant=44455853490227&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375754395699_42511926263859",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": true,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Vinyl Husk - Banana Bark | Phillip Jeffries",
+ "brand": null,
+ "price": 358.37,
+ "shopify_productId": "7375754395699",
+ "shopify_variantId": "42511926263859",
+ "shopify_product_status": "ACTIVE",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-12278-philip-jeffries-vinyl-husk-banana-bark-7264?variant=44788370669619&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375685222451_42511777890355",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": false,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Vinyl Leo's Luxe Linens II - Satin Fringe",
+ "brand": null,
+ "price": 358.37,
+ "shopify_productId": "7375685222451",
+ "shopify_variantId": "42511777890355",
+ "shopify_product_status": "ACTIVE",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-11298-philip-jeffries-vinyl-leos-luxe-linens-ii-satin-fringe-4537?variant=44788368212019&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375650684979_42511663824947",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": false,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Harmony Herringbone - Peaceful Ocean",
+ "brand": null,
+ "price": 358.37,
+ "shopify_productId": "7375650684979",
+ "shopify_variantId": "42511663824947",
+ "shopify_product_status": "ACTIVE",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-10531-philip-jeffries-harmony-herringbone-peaceful-ocean-2073?variant=44788367261747&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375650619443_42511663726643",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": false,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Harmony Herringbone - Mink Repose",
+ "brand": null,
+ "price": 358.37,
+ "shopify_productId": "7375650619443",
+ "shopify_variantId": "42511663726643",
+ "shopify_product_status": "ACTIVE",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-10530-philip-jeffries-harmony-herringbone-mink-repose-2072?variant=44788367228979&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375681912883_42511770517555",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": false,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Glaziér - Glazed Earthware on Natural African Raffia of Glaze",
+ "brand": null,
+ "price": 318.55,
+ "shopify_productId": "7375681912883",
+ "shopify_variantId": "42511770517555",
+ "shopify_product_status": "ACTIVE",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-11227-philip-jeffries-glazier-glazed-earthware-on-natural-african-raffia-11-3-35m-panel-repeat-approx-42-106-68-cm-of-glaze-4410?variant=44788367884339&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375682502707_42511771828275",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": false,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Savile Suiting - Solids - Grey Lapel",
+ "brand": null,
+ "price": 318.55,
+ "shopify_productId": "7375682502707",
+ "shopify_variantId": "42511771828275",
+ "shopify_product_status": "ACTIVE",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-11242-philip-jeffries-savile-suiting-solids-grey-lapel-4432?variant=44788367982643&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375662710835_42511679062067",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": false,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Silk & Abaca II - Polis Blue",
+ "brand": null,
+ "price": 318.55,
+ "shopify_productId": "7375662710835",
+ "shopify_variantId": "42511679062067",
+ "shopify_product_status": "ACTIVE",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-10815-philip-jeffries-silk-abaca-ii-polis-blue-3263?variant=44788367556659&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375641149491_42511652847667",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": false,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Tranquil Weave - Power Blue",
+ "brand": null,
+ "price": 318.55,
+ "shopify_productId": "7375641149491",
+ "shopify_variantId": "42511652847667",
+ "shopify_product_status": "ACTIVE",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-10365-philip-jeffries-tranquil-weave-power-blue-1457?variant=44788366704691&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375649931315_42511663038515",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": false,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Vinyl Metalworks - Lacquered Brushed",
+ "brand": null,
+ "price": 318.55,
+ "shopify_productId": "7375649931315",
+ "shopify_variantId": "42511663038515",
+ "shopify_product_status": "ACTIVE",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-10509-philip-jeffries-vinyl-metalworks-lacquered-brushed-2022?variant=44788367130675&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375724544051_42511883010099",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": false,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Island Raffia - Canvas",
+ "brand": null,
+ "price": 278.73,
+ "shopify_productId": "7375724544051",
+ "shopify_variantId": "42511883010099",
+ "shopify_product_status": "ACTIVE",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-11879-philip-jeffries-island-raffia-canvas-5827?variant=44788369981491&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375699050547_42511796437043",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": false,
+ "serving": true,
+ "status": "SERVING",
+ "title": "Heathered Linens - Seaglass",
+ "brand": null,
+ "price": 144.8,
+ "shopify_productId": "7375699050547",
+ "shopify_variantId": "42511796437043",
+ "shopify_product_status": "ACTIVE",
+ "issues": [],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-11605-philip-jeffries-heathered-linens-seaglass-5323?variant=44788368801843&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375663071283_42511680077875",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": false,
+ "serving": false,
+ "status": "disapproved",
+ "title": "Chevron Chic - Bay Blue Repeat: 1.25” V x 5” H (3.175 cm V x 12.7 cm H)",
+ "brand": null,
+ "price": 358.37,
+ "shopify_productId": "7375663071283",
+ "shopify_variantId": "42511680077875",
+ "shopify_product_status": "ACTIVE",
+ "issues": [
+ "DISAPPROVED|price_mismatch"
+ ],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-10825-philip-jeffries-chevron-chic-bay-blue-repeat-1-25-v-x-5-h-3-175-cm-v-x-12-7-cm-h-3293?variant=44788367622195&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375774941235_42511949398067",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": true,
+ "serving": false,
+ "status": "disapproved",
+ "title": "Vinyl Brushstroke Silk - Picasso Plum Repeat: 18\" (45.7cm) V x 54\" (137.2cm) H |",
+ "brand": null,
+ "price": 318.55,
+ "shopify_productId": "7375774941235",
+ "shopify_variantId": "42511949398067",
+ "shopify_product_status": "ACTIVE",
+ "issues": [
+ "DISAPPROVED|price_mismatch"
+ ],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-12420-philip-jeffries-vinyl-brushstroke-silk-picasso-plum-repeat-18-45-7cm-v-x-54-137-2cm-h-7479?variant=44788370898995&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375678636083_42511767699507",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": true,
+ "serving": false,
+ "status": "disapproved",
+ "title": "Against The Grain - Chevronic Charcoal | Phillip Jeffries",
+ "brand": null,
+ "price": 318.55,
+ "shopify_productId": "7375678636083",
+ "shopify_variantId": "42511767699507",
+ "shopify_product_status": "ACTIVE",
+ "issues": [
+ "DISAPPROVED|price_mismatch"
+ ],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-11159-philip-jeffries-against-the-grain-chevronic-charcoal-repeat-12-30-5cmhorizontal-4274?variant=44788367851571&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375731589171_42511891922995",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": false,
+ "serving": false,
+ "status": "disapproved",
+ "title": "Gilded Grid - Onyx and Gold",
+ "brand": null,
+ "price": 171.95,
+ "shopify_productId": "7375731589171",
+ "shopify_variantId": "42511891922995",
+ "shopify_product_status": "ACTIVE",
+ "issues": [
+ "DISAPPROVED|price_mismatch"
+ ],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-12052-philip-jeffries-gilded-grid-onyx-and-gold-6411?variant=44788370341939&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7375731556403_42511891890227",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": false,
+ "serving": false,
+ "status": "disapproved",
+ "title": "Gilded Grid - Green and Gold",
+ "brand": null,
+ "price": 171.95,
+ "shopify_productId": "7375731556403",
+ "shopify_variantId": "42511891890227",
+ "shopify_product_status": "ACTIVE",
+ "issues": [
+ "DISAPPROVED|price_mismatch"
+ ],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-12051-philip-jeffries-gilded-grid-green-and-gold-6410?variant=44788370309171&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "shopify_US_7857804935219_44425863299123",
+ "form": "prefixed",
+ "matched_by": "pid+vid",
+ "text_matcher_would_catch": true,
+ "serving": false,
+ "status": "disapproved",
+ "title": "Suede Lounge - Taupe Topaz | Wallcovering | Phillip Jeffries Roll",
+ "brand": null,
+ "price": 94,
+ "shopify_productId": "7857804935219",
+ "shopify_variantId": "44425863299123",
+ "shopify_product_status": "ACTIVE",
+ "issues": [
+ "DISAPPROVED|item_missing_required_attribute"
+ ],
+ "link": "https://www.designerwallcoverings.com/products/suede-lounge-taupe-topaz-wallcovering-phillip-jeffries?variant=44425863299123&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ {
+ "offerId": "42511636201523",
+ "form": "bare",
+ "matched_by": "variantId",
+ "text_matcher_would_catch": false,
+ "serving": false,
+ "status": "disapproved",
+ "title": "",
+ "brand": null,
+ "price": 7,
+ "shopify_productId": null,
+ "shopify_variantId": "42511636201523",
+ "shopify_product_status": "(bare-offer:unknown-pid)",
+ "issues": [
+ "DISAPPROVED|item_missing_required_attribute"
+ ],
+ "link": null
+ },
+ {
+ "offerId": "42511667757107",
+ "form": "bare",
+ "matched_by": "variantId",
+ "text_matcher_would_catch": false,
+ "serving": false,
+ "status": "disapproved",
+ "title": "",
+ "brand": null,
+ "price": 7,
+ "shopify_productId": null,
+ "shopify_variantId": "42511667757107",
+ "shopify_product_status": "(bare-offer:unknown-pid)",
+ "issues": [
+ "DISAPPROVED|item_missing_required_attribute"
+ ],
+ "link": null
+ },
+ {
+ "offerId": "42511905947699",
+ "form": "bare",
+ "matched_by": "variantId",
+ "text_matcher_would_catch": false,
+ "serving": false,
+ "status": "disapproved",
+ "title": "",
+ "brand": null,
+ "price": 7,
+ "shopify_productId": null,
+ "shopify_variantId": "42511905947699",
+ "shopify_product_status": "(bare-offer:unknown-pid)",
+ "issues": [
+ "DISAPPROVED|item_missing_required_attribute"
+ ],
+ "link": null
+ },
+ {
+ "offerId": "42511624405043",
+ "form": "bare",
+ "matched_by": "variantId",
+ "text_matcher_would_catch": false,
+ "serving": false,
+ "status": "disapproved",
+ "title": "",
+ "brand": null,
+ "price": 7,
+ "shopify_productId": null,
+ "shopify_variantId": "42511624405043",
+ "shopify_product_status": "(bare-offer:unknown-pid)",
+ "issues": [
+ "DISAPPROVED|item_missing_required_attribute"
+ ],
+ "link": null
+ },
+ {
+ "offerId": "42511885860915",
+ "form": "bare",
+ "matched_by": "variantId",
+ "text_matcher_would_catch": false,
+ "serving": false,
+ "status": "disapproved",
+ "title": "Saint Germain Hemp II - Silver On White",
+ "brand": null,
+ "price": 4.25,
+ "shopify_productId": null,
+ "shopify_variantId": "42511885860915",
+ "shopify_product_status": "(bare-offer:unknown-pid)",
+ "issues": [
+ "DISAPPROVED|tobacco_policy_violation"
+ ],
+ "link": "https://www.designerwallcoverings.com/products/dwjp-11930-philip-jeffries-saint-germain-hemp-ii-silver-on-white-5980"
+ }
+ ]
+}
\ No newline at end of file
← 19c2e6c TK-11449: account-wide policy-family locate (61,992 offers)
·
back to Gmc Titlefix
·
fix(mc-read): stop 400 on legacy bare-variant-id offers; tag c9c9e59 →