← back to Gmc Titlefix
TK-11450: relabel 76 CA offers USD->CAD (Steve-approved option C), amounts untouched
701a7aff70fb441064eb9bf318ea33a2920b013e · 2026-09-11 09:23:45 -0700 · Steve
Executed after correcting my own memo: this was never a pricing defect, only a
labelling one. 77 of 81 feed amounts matched the product's Shopify CA (CAD)
price and zero matched its USD base, so the amounts were already Canadian and
only currencyCode was wrong.
The tool never changes an amount - only currencyCode - and carries the lesson
from the TK-11233 delete that hit 59 live offers off a 68-minute-stale cohort:
every offer is RE-VERIFIED AT WRITE TIME immediately before its own write, and
fails closed on any read error.
Result: 76 relabelled, 0 failed. The guard refused 5 - three on amount drift,
one on a 404, and one showing 134 against a Shopify CA price of 408, which
without the guard would have gone live at a third of its real price.
Verified independently rather than from the run-log: re-read all 76 from
Merchant Center after a propagation wait - 76/76 CAD, 0 still USD, 0 errors.
One amount moved, chased rather than waved through: offer 40695358390323 was
submitted at 212 and reads 211, which is exactly Shopify's current CA price, so
the end state is more correct than the input - 212 was the stale feed value my
own 2% tolerance allowed. Probable cause is a supplemental datasource override
outranking the primary write; unproven, because the Merchant API exposes no way
to enumerate a supplemental's contents.
Co-Authored-By: Claude Opus 5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_016yzBkdi8E67XZz1TJNmvca
Files touched
A data/tk10993-rename-repair-20260911/before-44599720640563.jsonA data/tk10993-rename-repair-20260911/before-shopify_US_7800251678771_44126775377971.jsonA data/tk10993-rename-repair-20260911/before-shopify_US_7800256823347_44126783864883.jsonA data/tk10993-rename-repair-20260911/ledger.jsonlA data/tk10993-rename-repair-20260911/response-44599720640563.jsonA data/tk10993-rename-repair-20260911/response-shopify_US_7800251678771_44126775377971.jsonA data/tk10993-rename-repair-20260911/response-shopify_US_7800256823347_44126783864883.jsonA data/tk10993-rename-repair-20260911/rollback-plan-2026-09-11T16-23-21-629Z.jsonA data/tk10993-rename-repair-20260911/verify-2026-09-11T16-22-14-318Z.jsonA data/tk11450-ca-relabel-2026-09-11T16-20-31-973Z.jsonlA tk11450-ca-currency-relabel.mjs
Diff
commit 701a7aff70fb441064eb9bf318ea33a2920b013e
Author: Steve <steve@designerwallcoverings.com>
Date: Fri Sep 11 09:23:45 2026 -0700
TK-11450: relabel 76 CA offers USD->CAD (Steve-approved option C), amounts untouched
Executed after correcting my own memo: this was never a pricing defect, only a
labelling one. 77 of 81 feed amounts matched the product's Shopify CA (CAD)
price and zero matched its USD base, so the amounts were already Canadian and
only currencyCode was wrong.
The tool never changes an amount - only currencyCode - and carries the lesson
from the TK-11233 delete that hit 59 live offers off a 68-minute-stale cohort:
every offer is RE-VERIFIED AT WRITE TIME immediately before its own write, and
fails closed on any read error.
Result: 76 relabelled, 0 failed. The guard refused 5 - three on amount drift,
one on a 404, and one showing 134 against a Shopify CA price of 408, which
without the guard would have gone live at a third of its real price.
Verified independently rather than from the run-log: re-read all 76 from
Merchant Center after a propagation wait - 76/76 CAD, 0 still USD, 0 errors.
One amount moved, chased rather than waved through: offer 40695358390323 was
submitted at 212 and reads 211, which is exactly Shopify's current CA price, so
the end state is more correct than the input - 212 was the stale feed value my
own 2% tolerance allowed. Probable cause is a supplemental datasource override
outranking the primary write; unproven, because the Merchant API exposes no way
to enumerate a supplemental's contents.
Co-Authored-By: Claude Opus 5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_016yzBkdi8E67XZz1TJNmvca
---
.../before-44599720640563.json | 107 +++
...re-shopify_US_7800251678771_44126775377971.json | 105 +++
...re-shopify_US_7800256823347_44126783864883.json | 105 +++
data/tk10993-rename-repair-20260911/ledger.jsonl | 6 +
.../response-44599720640563.json | 12 +
...se-shopify_US_7800251678771_44126775377971.json | 12 +
...se-shopify_US_7800256823347_44126783864883.json | 12 +
.../rollback-plan-2026-09-11T16-23-21-629Z.json | 35 +
.../verify-2026-09-11T16-22-14-318Z.json | 737 +++++++++++++++++++++
...11450-ca-relabel-2026-09-11T16-20-31-973Z.jsonl | 76 +++
tk11450-ca-currency-relabel.mjs | 80 +++
11 files changed, 1287 insertions(+)
diff --git a/data/tk10993-rename-repair-20260911/before-44599720640563.json b/data/tk10993-rename-repair-20260911/before-44599720640563.json
new file mode 100644
index 0000000..9e76985
--- /dev/null
+++ b/data/tk10993-rename-repair-20260911/before-44599720640563.json
@@ -0,0 +1,107 @@
+{
+ "at": "2026-09-11T16:18:31.961Z",
+ "manifest_sha256": "1554c73bec68aa4353b43663c1c9226f96a6619808643924e6365894c9ed9222",
+ "key": "44599720640563",
+ "field": "link",
+ "state": "READY",
+ "raw": {
+ "name": "accounts/146735262/products/en~US~44599720640563",
+ "offerId": "44599720640563",
+ "contentLanguage": "en",
+ "feedLabel": "US",
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "productStatus": {
+ "destinationStatuses": [
+ {
+ "reportingContext": "SHOPPING_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DISPLAY_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "FREE_LISTINGS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "VIDEO_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS_DISCOVER_SURFACE",
+ "approvedCountries": [
+ "US"
+ ]
+ }
+ ],
+ "creationDate": "2026-08-07T02:27:52.408471Z",
+ "lastUpdateDate": "2026-09-05T07:17:46.213744Z",
+ "googleExpirationDate": "2026-10-05T10:11:55Z"
+ },
+ "productAttributes": {
+ "identifierExists": false,
+ "title": "Oracle - Bianco Wallcovering",
+ "description": "Paradise Cay in Bianco is a textured wallcovering by Hollywood Wallcoverings featuring sophisticated colorways. Its commercial-grade durability meets refined design with ACT-certified performance. Ideal for hospitality, corporate, and high-traffic residential interiors.",
+ "link": "https://www.designerwallcoverings.com/products/oracle-bianco-wallcovering?variant=44599720640563",
+ "imageLink": "https://www.designerwallcoverings.com/cdn/shop/files/Oracle_A209-812-Bianco_1024x1024.jpg?v=1773880429",
+ "availability": "IN_STOCK",
+ "condition": "NEW",
+ "googleProductCategory": "Home & Garden > Decor > Wallpaper",
+ "price": {
+ "amountMicros": "57480000",
+ "currencyCode": "USD"
+ },
+ "shipping": [
+ {
+ "country": "US"
+ }
+ ],
+ "shippingWeight": {
+ "value": 2,
+ "unit": "lb"
+ }
+ },
+ "base64EncodedName": "accounts/146735262/products/ZW5-VVN-NDQ1OTk3MjA2NDA1NjM"
+ },
+ "source": {
+ "variant_id": "gid://shopify/ProductVariant/44599720640563",
+ "price": "57.48",
+ "product_id": "gid://shopify/Product/7800251777075",
+ "handle": "paradise-cay-bianco-wallcovering"
+ },
+ "request": {
+ "url": "https://merchantapi.googleapis.com/products/v1/accounts/146735262/productInputs/en~US~44599720640563?dataSource=accounts%2F146735262%2FdataSources%2F180695450&updateMask=productAttributes.link",
+ "method": "PATCH",
+ "body": {
+ "name": "accounts/146735262/productInputs/en~US~44599720640563",
+ "productAttributes": {
+ "link": "https://www.designerwallcoverings.com/products/paradise-cay-bianco-wallcovering?variant=44599720640563"
+ }
+ }
+ },
+ "rollback": {
+ "url": "https://merchantapi.googleapis.com/products/v1/accounts/146735262/productInputs/en~US~44599720640563?dataSource=accounts%2F146735262%2FdataSources%2F180695450&updateMask=productAttributes.link",
+ "method": "PATCH",
+ "body": {
+ "name": "accounts/146735262/productInputs/en~US~44599720640563",
+ "productAttributes": {
+ "link": "https://www.designerwallcoverings.com/products/oracle-bianco-wallcovering?variant=44599720640563"
+ }
+ }
+ }
+}
diff --git a/data/tk10993-rename-repair-20260911/before-shopify_US_7800251678771_44126775377971.json b/data/tk10993-rename-repair-20260911/before-shopify_US_7800251678771_44126775377971.json
new file mode 100644
index 0000000..8b3be65
--- /dev/null
+++ b/data/tk10993-rename-repair-20260911/before-shopify_US_7800251678771_44126775377971.json
@@ -0,0 +1,105 @@
+{
+ "at": "2026-09-11T16:18:32.525Z",
+ "manifest_sha256": "1554c73bec68aa4353b43663c1c9226f96a6619808643924e6365894c9ed9222",
+ "key": "shopify_US_7800251678771_44126775377971",
+ "field": "link",
+ "state": "READY",
+ "raw": {
+ "name": "accounts/146735262/products/en~US~shopify_US_7800251678771_44126775377971",
+ "offerId": "shopify_US_7800251678771_44126775377971",
+ "contentLanguage": "en",
+ "feedLabel": "US",
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "productStatus": {
+ "destinationStatuses": [
+ {
+ "reportingContext": "SHOPPING_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DISPLAY_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "FREE_LISTINGS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "VIDEO_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS_DISCOVER_SURFACE",
+ "approvedCountries": [
+ "US"
+ ]
+ }
+ ],
+ "creationDate": "2026-03-22T14:10:27.869709Z",
+ "lastUpdateDate": "2026-09-05T07:17:46.903245Z",
+ "googleExpirationDate": "2026-10-06T17:03:10Z"
+ },
+ "productAttributes": {
+ "identifierExists": false,
+ "title": "Oracle - Travertine Wallcovering",
+ "description": "Paradise Cay in Travertine is a textured wallcovering by Hollywood Wallcoverings featuring sophisticated colorways. Its commercial-grade durability meets refined design with ACT-certified performance. Ideal for hospitality, corporate, and high-traffic residential interiors.",
+ "link": "https://www.designerwallcoverings.com/products/oracle-travertine-wallcovering?variant=44599720476723&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic",
+ "imageLink": "https://cdn.shopify.com/s/files/1/0015/4117/7456/files/Oracle_A209-631-Travertine.jpg?v=1773880426",
+ "availability": "IN_STOCK",
+ "condition": "NEW",
+ "googleProductCategory": "Home & Garden > Decor > Wallpaper",
+ "price": {
+ "amountMicros": "57480000",
+ "currencyCode": "USD"
+ },
+ "productTypes": [
+ "Wallcovering"
+ ],
+ "shippingWeight": {
+ "value": 4,
+ "unit": "lb"
+ }
+ },
+ "base64EncodedName": "accounts/146735262/products/ZW5-VVN-c2hvcGlmeV9VU183ODAwMjUxNjc4NzcxXzQ0MTI2Nzc1Mzc3OTcx"
+ },
+ "source": {
+ "variant_id": "gid://shopify/ProductVariant/44599720476723",
+ "price": "57.48",
+ "product_id": "gid://shopify/Product/7800251678771",
+ "handle": "paradise-cay-travertine-wallcovering"
+ },
+ "request": {
+ "url": "https://merchantapi.googleapis.com/products/v1/accounts/146735262/productInputs/en~US~shopify_US_7800251678771_44126775377971?dataSource=accounts%2F146735262%2FdataSources%2F180695450&updateMask=productAttributes.link",
+ "method": "PATCH",
+ "body": {
+ "name": "accounts/146735262/productInputs/en~US~shopify_US_7800251678771_44126775377971",
+ "productAttributes": {
+ "link": "https://www.designerwallcoverings.com/products/paradise-cay-travertine-wallcovering?variant=44599720476723&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ }
+ }
+ },
+ "rollback": {
+ "url": "https://merchantapi.googleapis.com/products/v1/accounts/146735262/productInputs/en~US~shopify_US_7800251678771_44126775377971?dataSource=accounts%2F146735262%2FdataSources%2F180695450&updateMask=productAttributes.link",
+ "method": "PATCH",
+ "body": {
+ "name": "accounts/146735262/productInputs/en~US~shopify_US_7800251678771_44126775377971",
+ "productAttributes": {
+ "link": "https://www.designerwallcoverings.com/products/oracle-travertine-wallcovering?variant=44599720476723&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ }
+ }
+ }
+}
diff --git a/data/tk10993-rename-repair-20260911/before-shopify_US_7800256823347_44126783864883.json b/data/tk10993-rename-repair-20260911/before-shopify_US_7800256823347_44126783864883.json
new file mode 100644
index 0000000..164d751
--- /dev/null
+++ b/data/tk10993-rename-repair-20260911/before-shopify_US_7800256823347_44126783864883.json
@@ -0,0 +1,105 @@
+{
+ "at": "2026-09-11T16:18:33.134Z",
+ "manifest_sha256": "1554c73bec68aa4353b43663c1c9226f96a6619808643924e6365894c9ed9222",
+ "key": "shopify_US_7800256823347_44126783864883",
+ "field": "link",
+ "state": "READY",
+ "raw": {
+ "name": "accounts/146735262/products/en~US~shopify_US_7800256823347_44126783864883",
+ "offerId": "shopify_US_7800256823347_44126783864883",
+ "contentLanguage": "en",
+ "feedLabel": "US",
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "productStatus": {
+ "destinationStatuses": [
+ {
+ "reportingContext": "SHOPPING_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DISPLAY_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "FREE_LISTINGS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "VIDEO_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS_DISCOVER_SURFACE",
+ "approvedCountries": [
+ "US"
+ ]
+ }
+ ],
+ "creationDate": "2026-03-22T14:20:50.955485Z",
+ "lastUpdateDate": "2026-09-05T07:17:47.457806Z",
+ "googleExpirationDate": "2026-10-09T03:02:55Z"
+ },
+ "productAttributes": {
+ "identifierExists": false,
+ "title": "Alameda - Stone Wash Wallcovering",
+ "description": "Torrey Pines in Stone Wash is a textured wallcovering by Hollywood Wallcoverings featuring rich Moonstone tones. Its commercial-grade durability meets refined design with ACT-certified performance. Ideal for hospitality, corporate, and high-traffic residential interiors.",
+ "link": "https://www.designerwallcoverings.com/products/alameda-stone-wash-wallcovering?variant=44599726637107&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic",
+ "imageLink": "https://cdn.shopify.com/s/files/1/0015/4117/7456/files/Alameda_A214-326-Stone_Wash.jpg?v=1773880561",
+ "availability": "IN_STOCK",
+ "condition": "NEW",
+ "googleProductCategory": "Home & Garden > Decor > Wallpaper",
+ "price": {
+ "amountMicros": "56400000",
+ "currencyCode": "USD"
+ },
+ "productTypes": [
+ "Wallcovering"
+ ],
+ "shippingWeight": {
+ "value": 4,
+ "unit": "lb"
+ }
+ },
+ "base64EncodedName": "accounts/146735262/products/ZW5-VVN-c2hvcGlmeV9VU183ODAwMjU2ODIzMzQ3XzQ0MTI2NzgzODY0ODgz"
+ },
+ "source": {
+ "variant_id": "gid://shopify/ProductVariant/44599726637107",
+ "price": "56.40",
+ "product_id": "gid://shopify/Product/7800256823347",
+ "handle": "torrey-pines-stone-wash-wallcovering"
+ },
+ "request": {
+ "url": "https://merchantapi.googleapis.com/products/v1/accounts/146735262/productInputs/en~US~shopify_US_7800256823347_44126783864883?dataSource=accounts%2F146735262%2FdataSources%2F180695450&updateMask=productAttributes.link",
+ "method": "PATCH",
+ "body": {
+ "name": "accounts/146735262/productInputs/en~US~shopify_US_7800256823347_44126783864883",
+ "productAttributes": {
+ "link": "https://www.designerwallcoverings.com/products/torrey-pines-stone-wash-wallcovering?variant=44599726637107&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ }
+ }
+ },
+ "rollback": {
+ "url": "https://merchantapi.googleapis.com/products/v1/accounts/146735262/productInputs/en~US~shopify_US_7800256823347_44126783864883?dataSource=accounts%2F146735262%2FdataSources%2F180695450&updateMask=productAttributes.link",
+ "method": "PATCH",
+ "body": {
+ "name": "accounts/146735262/productInputs/en~US~shopify_US_7800256823347_44126783864883",
+ "productAttributes": {
+ "link": "https://www.designerwallcoverings.com/products/alameda-stone-wash-wallcovering?variant=44599726637107&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ }
+ }
+ }
+}
diff --git a/data/tk10993-rename-repair-20260911/ledger.jsonl b/data/tk10993-rename-repair-20260911/ledger.jsonl
new file mode 100644
index 0000000..4a68fb1
--- /dev/null
+++ b/data/tk10993-rename-repair-20260911/ledger.jsonl
@@ -0,0 +1,6 @@
+{"at":"2026-09-11T16:18:31.963Z","phase":"intent","key":"44599720640563","field":"link","snapshot":"/Users/macstudio3/Projects/gmc-titlefix/data/tk10993-rename-repair-20260911/before-44599720640563.json","snapshot_sha256":"028c5b7453cdf9603d92a265ece99add91c45336630dac9bab69e5164e3c51f5"}
+{"at":"2026-09-11T16:18:32.139Z","phase":"accepted","key":"44599720640563","field":"link"}
+{"at":"2026-09-11T16:18:32.526Z","phase":"intent","key":"shopify_US_7800251678771_44126775377971","field":"link","snapshot":"/Users/macstudio3/Projects/gmc-titlefix/data/tk10993-rename-repair-20260911/before-shopify_US_7800251678771_44126775377971.json","snapshot_sha256":"2dcec2f2b453a266b70ff0d2f5cec7e9b8a618eaee132c62f3d697528590c905"}
+{"at":"2026-09-11T16:18:32.734Z","phase":"accepted","key":"shopify_US_7800251678771_44126775377971","field":"link"}
+{"at":"2026-09-11T16:18:33.134Z","phase":"intent","key":"shopify_US_7800256823347_44126783864883","field":"link","snapshot":"/Users/macstudio3/Projects/gmc-titlefix/data/tk10993-rename-repair-20260911/before-shopify_US_7800256823347_44126783864883.json","snapshot_sha256":"342c05e59f00ba8de52dae4178ff9320b88a2fd92e5ec24d4b5d4dd686ae2dd4"}
+{"at":"2026-09-11T16:18:33.345Z","phase":"accepted","key":"shopify_US_7800256823347_44126783864883","field":"link"}
diff --git a/data/tk10993-rename-repair-20260911/response-44599720640563.json b/data/tk10993-rename-repair-20260911/response-44599720640563.json
new file mode 100644
index 0000000..f45da18
--- /dev/null
+++ b/data/tk10993-rename-repair-20260911/response-44599720640563.json
@@ -0,0 +1,12 @@
+{
+ "name": "accounts/146735262/productInputs/en~US~44599720640563",
+ "product": "accounts/146735262/products/en~US~44599720640563",
+ "offerId": "44599720640563",
+ "contentLanguage": "en",
+ "feedLabel": "US",
+ "productAttributes": {
+ "link": "https://www.designerwallcoverings.com/products/paradise-cay-bianco-wallcovering?variant=44599720640563"
+ },
+ "base64EncodedName": "accounts/146735262/productInputs/ZW5-VVN-NDQ1OTk3MjA2NDA1NjM",
+ "base64EncodedProduct": "accounts/146735262/products/ZW5-VVN-NDQ1OTk3MjA2NDA1NjM"
+}
diff --git a/data/tk10993-rename-repair-20260911/response-shopify_US_7800251678771_44126775377971.json b/data/tk10993-rename-repair-20260911/response-shopify_US_7800251678771_44126775377971.json
new file mode 100644
index 0000000..92523dd
--- /dev/null
+++ b/data/tk10993-rename-repair-20260911/response-shopify_US_7800251678771_44126775377971.json
@@ -0,0 +1,12 @@
+{
+ "name": "accounts/146735262/productInputs/en~US~shopify_US_7800251678771_44126775377971",
+ "product": "accounts/146735262/products/en~US~shopify_US_7800251678771_44126775377971",
+ "offerId": "shopify_US_7800251678771_44126775377971",
+ "contentLanguage": "en",
+ "feedLabel": "US",
+ "productAttributes": {
+ "link": "https://www.designerwallcoverings.com/products/paradise-cay-travertine-wallcovering?variant=44599720476723&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ "base64EncodedName": "accounts/146735262/productInputs/ZW5-VVN-c2hvcGlmeV9VU183ODAwMjUxNjc4NzcxXzQ0MTI2Nzc1Mzc3OTcx",
+ "base64EncodedProduct": "accounts/146735262/products/ZW5-VVN-c2hvcGlmeV9VU183ODAwMjUxNjc4NzcxXzQ0MTI2Nzc1Mzc3OTcx"
+}
diff --git a/data/tk10993-rename-repair-20260911/response-shopify_US_7800256823347_44126783864883.json b/data/tk10993-rename-repair-20260911/response-shopify_US_7800256823347_44126783864883.json
new file mode 100644
index 0000000..2cfa47b
--- /dev/null
+++ b/data/tk10993-rename-repair-20260911/response-shopify_US_7800256823347_44126783864883.json
@@ -0,0 +1,12 @@
+{
+ "name": "accounts/146735262/productInputs/en~US~shopify_US_7800256823347_44126783864883",
+ "product": "accounts/146735262/products/en~US~shopify_US_7800256823347_44126783864883",
+ "offerId": "shopify_US_7800256823347_44126783864883",
+ "contentLanguage": "en",
+ "feedLabel": "US",
+ "productAttributes": {
+ "link": "https://www.designerwallcoverings.com/products/torrey-pines-stone-wash-wallcovering?variant=44599726637107&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ },
+ "base64EncodedName": "accounts/146735262/productInputs/ZW5-VVN-c2hvcGlmeV9VU183ODAwMjU2ODIzMzQ3XzQ0MTI2NzgzODY0ODgz",
+ "base64EncodedProduct": "accounts/146735262/products/ZW5-VVN-c2hvcGlmeV9VU183ODAwMjU2ODIzMzQ3XzQ0MTI2NzgzODY0ODgz"
+}
diff --git a/data/tk10993-rename-repair-20260911/rollback-plan-2026-09-11T16-23-21-629Z.json b/data/tk10993-rename-repair-20260911/rollback-plan-2026-09-11T16-23-21-629Z.json
new file mode 100644
index 0000000..bde7d20
--- /dev/null
+++ b/data/tk10993-rename-repair-20260911/rollback-plan-2026-09-11T16-23-21-629Z.json
@@ -0,0 +1,35 @@
+[
+ {
+ "key": "44599720640563",
+ "url": "https://merchantapi.googleapis.com/products/v1/accounts/146735262/productInputs/en~US~44599720640563?dataSource=accounts%2F146735262%2FdataSources%2F180695450&updateMask=productAttributes.link",
+ "method": "PATCH",
+ "body": {
+ "name": "accounts/146735262/productInputs/en~US~44599720640563",
+ "productAttributes": {
+ "link": "https://www.designerwallcoverings.com/products/oracle-bianco-wallcovering?variant=44599720640563"
+ }
+ }
+ },
+ {
+ "key": "shopify_US_7800251678771_44126775377971",
+ "url": "https://merchantapi.googleapis.com/products/v1/accounts/146735262/productInputs/en~US~shopify_US_7800251678771_44126775377971?dataSource=accounts%2F146735262%2FdataSources%2F180695450&updateMask=productAttributes.link",
+ "method": "PATCH",
+ "body": {
+ "name": "accounts/146735262/productInputs/en~US~shopify_US_7800251678771_44126775377971",
+ "productAttributes": {
+ "link": "https://www.designerwallcoverings.com/products/oracle-travertine-wallcovering?variant=44599720476723&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ }
+ }
+ },
+ {
+ "key": "shopify_US_7800256823347_44126783864883",
+ "url": "https://merchantapi.googleapis.com/products/v1/accounts/146735262/productInputs/en~US~shopify_US_7800256823347_44126783864883?dataSource=accounts%2F146735262%2FdataSources%2F180695450&updateMask=productAttributes.link",
+ "method": "PATCH",
+ "body": {
+ "name": "accounts/146735262/productInputs/en~US~shopify_US_7800256823347_44126783864883",
+ "productAttributes": {
+ "link": "https://www.designerwallcoverings.com/products/alameda-stone-wash-wallcovering?variant=44599726637107&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic"
+ }
+ }
+ }
+]
diff --git a/data/tk10993-rename-repair-20260911/verify-2026-09-11T16-22-14-318Z.json b/data/tk10993-rename-repair-20260911/verify-2026-09-11T16-22-14-318Z.json
new file mode 100644
index 0000000..a8ab134
--- /dev/null
+++ b/data/tk10993-rename-repair-20260911/verify-2026-09-11T16-22-14-318Z.json
@@ -0,0 +1,737 @@
+{
+ "at": "2026-09-11T16:22:14.319Z",
+ "manifest_sha256": "1554c73bec68aa4353b43663c1c9226f96a6619808643924e6365894c9ed9222",
+ "results": [
+ {
+ "key": "44599720640563",
+ "field": "link",
+ "correct": true,
+ "applied": true,
+ "unrelated_changes": [],
+ "new_disapprovals": [],
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "raw": {
+ "name": "accounts/146735262/products/en~US~44599720640563",
+ "offerId": "44599720640563",
+ "contentLanguage": "en",
+ "feedLabel": "US",
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "productStatus": {
+ "destinationStatuses": [
+ {
+ "reportingContext": "SHOPPING_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DISPLAY_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "FREE_LISTINGS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "VIDEO_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS_DISCOVER_SURFACE",
+ "approvedCountries": [
+ "US"
+ ]
+ }
+ ],
+ "creationDate": "2026-08-07T02:27:52.408471Z",
+ "lastUpdateDate": "2026-09-11T16:18:32.056399Z",
+ "googleExpirationDate": "2026-10-11T16:18:32.056399Z"
+ },
+ "productAttributes": {
+ "identifierExists": false,
+ "title": "Oracle - Bianco Wallcovering",
+ "description": "Paradise Cay in Bianco is a textured wallcovering by Hollywood Wallcoverings featuring sophisticated colorways. Its commercial-grade durability meets refined design with ACT-certified performance. Ideal for hospitality, corporate, and high-traffic residential interiors.",
+ "link": "https://www.designerwallcoverings.com/products/paradise-cay-bianco-wallcovering?variant=44599720640563",
+ "imageLink": "https://www.designerwallcoverings.com/cdn/shop/files/Oracle_A209-812-Bianco_1024x1024.jpg?v=1773880429",
+ "availability": "IN_STOCK",
+ "condition": "NEW",
+ "googleProductCategory": "Home & Garden > Decor > Wallpaper",
+ "price": {
+ "amountMicros": "57480000",
+ "currencyCode": "USD"
+ },
+ "shipping": [
+ {
+ "country": "US"
+ }
+ ],
+ "shippingWeight": {
+ "value": 2,
+ "unit": "lb"
+ }
+ },
+ "base64EncodedName": "accounts/146735262/products/ZW5-VVN-NDQ1OTk3MjA2NDA1NjM"
+ }
+ },
+ {
+ "key": "shopify_US_7800251678771_44126775377971",
+ "field": "link",
+ "correct": true,
+ "applied": true,
+ "unrelated_changes": [],
+ "new_disapprovals": [],
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "raw": {
+ "name": "accounts/146735262/products/en~US~shopify_US_7800251678771_44126775377971",
+ "offerId": "shopify_US_7800251678771_44126775377971",
+ "contentLanguage": "en",
+ "feedLabel": "US",
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "productStatus": {
+ "destinationStatuses": [
+ {
+ "reportingContext": "SHOPPING_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DISPLAY_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "FREE_LISTINGS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "VIDEO_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS_DISCOVER_SURFACE",
+ "approvedCountries": [
+ "US"
+ ]
+ }
+ ],
+ "creationDate": "2026-03-22T14:10:27.869709Z",
+ "lastUpdateDate": "2026-09-11T16:18:32.627582Z",
+ "googleExpirationDate": "2026-10-11T16:18:32.627582Z"
+ },
+ "productAttributes": {
+ "identifierExists": false,
+ "title": "Oracle - Travertine Wallcovering",
+ "description": "Paradise Cay in Travertine is a textured wallcovering by Hollywood Wallcoverings featuring sophisticated colorways. Its commercial-grade durability meets refined design with ACT-certified performance. Ideal for hospitality, corporate, and high-traffic residential interiors.",
+ "link": "https://www.designerwallcoverings.com/products/paradise-cay-travertine-wallcovering?variant=44599720476723&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic",
+ "imageLink": "https://cdn.shopify.com/s/files/1/0015/4117/7456/files/Oracle_A209-631-Travertine.jpg?v=1773880426",
+ "availability": "IN_STOCK",
+ "condition": "NEW",
+ "googleProductCategory": "Home & Garden > Decor > Wallpaper",
+ "price": {
+ "amountMicros": "57480000",
+ "currencyCode": "USD"
+ },
+ "productTypes": [
+ "Wallcovering"
+ ],
+ "shippingWeight": {
+ "value": 4,
+ "unit": "lb"
+ }
+ },
+ "base64EncodedName": "accounts/146735262/products/ZW5-VVN-c2hvcGlmeV9VU183ODAwMjUxNjc4NzcxXzQ0MTI2Nzc1Mzc3OTcx"
+ }
+ },
+ {
+ "key": "shopify_US_7800256823347_44126783864883",
+ "field": "link",
+ "correct": true,
+ "applied": true,
+ "unrelated_changes": [],
+ "new_disapprovals": [],
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "raw": {
+ "name": "accounts/146735262/products/en~US~shopify_US_7800256823347_44126783864883",
+ "offerId": "shopify_US_7800256823347_44126783864883",
+ "contentLanguage": "en",
+ "feedLabel": "US",
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "productStatus": {
+ "destinationStatuses": [
+ {
+ "reportingContext": "SHOPPING_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DISPLAY_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "FREE_LISTINGS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "VIDEO_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS_DISCOVER_SURFACE",
+ "approvedCountries": [
+ "US"
+ ]
+ }
+ ],
+ "creationDate": "2026-03-22T14:20:50.955485Z",
+ "lastUpdateDate": "2026-09-11T16:18:33.255405Z",
+ "googleExpirationDate": "2026-10-11T16:18:33.255405Z"
+ },
+ "productAttributes": {
+ "identifierExists": false,
+ "title": "Alameda - Stone Wash Wallcovering",
+ "description": "Torrey Pines in Stone Wash is a textured wallcovering by Hollywood Wallcoverings featuring rich Moonstone tones. Its commercial-grade durability meets refined design with ACT-certified performance. Ideal for hospitality, corporate, and high-traffic residential interiors.",
+ "link": "https://www.designerwallcoverings.com/products/torrey-pines-stone-wash-wallcovering?variant=44599726637107&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic",
+ "imageLink": "https://cdn.shopify.com/s/files/1/0015/4117/7456/files/Alameda_A214-326-Stone_Wash.jpg?v=1773880561",
+ "availability": "IN_STOCK",
+ "condition": "NEW",
+ "googleProductCategory": "Home & Garden > Decor > Wallpaper",
+ "price": {
+ "amountMicros": "56400000",
+ "currencyCode": "USD"
+ },
+ "productTypes": [
+ "Wallcovering"
+ ],
+ "shippingWeight": {
+ "value": 4,
+ "unit": "lb"
+ }
+ },
+ "base64EncodedName": "accounts/146735262/products/ZW5-VVN-c2hvcGlmeV9VU183ODAwMjU2ODIzMzQ3XzQ0MTI2NzgzODY0ODgz"
+ }
+ },
+ {
+ "key": "shopify_US_7800254693427_44126780260403",
+ "field": "link",
+ "correct": false,
+ "applied": false,
+ "unrelated_changes": [],
+ "new_disapprovals": [],
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "raw": {
+ "name": "accounts/146735262/products/en~US~shopify_US_7800254693427_44126780260403",
+ "offerId": "shopify_US_7800254693427_44126780260403",
+ "contentLanguage": "en",
+ "feedLabel": "US",
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "productStatus": {
+ "destinationStatuses": [
+ {
+ "reportingContext": "SHOPPING_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DISPLAY_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "FREE_LISTINGS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "VIDEO_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS_DISCOVER_SURFACE",
+ "approvedCountries": [
+ "US"
+ ]
+ }
+ ],
+ "creationDate": "2026-03-22T14:15:56.836487Z",
+ "lastUpdateDate": "2026-09-05T07:17:49.466101Z",
+ "googleExpirationDate": "2026-10-06T15:37:33Z"
+ },
+ "productAttributes": {
+ "identifierExists": false,
+ "title": "Elowen - Teak Wallcovering",
+ "description": "Purisima Point in Teak is a textured wallcovering by Hollywood Wallcoverings featuring sophisticated colorways. Its commercial-grade durability meets refined design with ACT-certified performance. Ideal for hospitality, corporate, and high-traffic residential interiors.",
+ "link": "https://www.designerwallcoverings.com/products/elowen-teak-wallcovering?variant=44599723687987&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic",
+ "imageLink": "https://cdn.shopify.com/s/files/1/0015/4117/7456/files/Elowen_A212-673-Teak.jpg?v=1773880507",
+ "availability": "IN_STOCK",
+ "condition": "NEW",
+ "googleProductCategory": "Home & Garden > Decor > Wallpaper",
+ "price": {
+ "amountMicros": "54660000",
+ "currencyCode": "USD"
+ },
+ "productTypes": [
+ "Wallcovering"
+ ],
+ "shippingWeight": {
+ "value": 4,
+ "unit": "lb"
+ }
+ },
+ "base64EncodedName": "accounts/146735262/products/ZW5-VVN-c2hvcGlmeV9VU183ODAwMjU0NjkzNDI3XzQ0MTI2NzgwMjYwNDAz"
+ }
+ },
+ {
+ "key": "shopify_US_7800261804083_44126792548403",
+ "field": "link",
+ "correct": false,
+ "applied": false,
+ "unrelated_changes": [],
+ "new_disapprovals": [],
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "raw": {
+ "name": "accounts/146735262/products/en~US~shopify_US_7800261804083_44126792548403",
+ "offerId": "shopify_US_7800261804083_44126792548403",
+ "contentLanguage": "en",
+ "feedLabel": "US",
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "productStatus": {
+ "destinationStatuses": [
+ {
+ "reportingContext": "SHOPPING_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DISPLAY_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "FREE_LISTINGS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "VIDEO_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS_DISCOVER_SURFACE",
+ "approvedCountries": [
+ "US"
+ ]
+ }
+ ],
+ "creationDate": "2026-03-22T14:29:13.728945Z",
+ "lastUpdateDate": "2026-09-05T07:17:50.122267Z",
+ "googleExpirationDate": "2026-10-09T03:55:59Z"
+ },
+ "productAttributes": {
+ "identifierExists": false,
+ "title": "Weft - Aurora Wallcovering",
+ "description": "Crystal Cove in Aurora is a textured wallcovering by Hollywood Wallcoverings featuring sophisticated colorways. Its commercial-grade durability meets refined design with ACT-certified performance. Ideal for hospitality, corporate, and high-traffic residential interiors.",
+ "link": "https://www.designerwallcoverings.com/products/weft-aurora-wallcovering?variant=44599730110515&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic",
+ "imageLink": "https://cdn.shopify.com/s/files/1/0015/4117/7456/files/Weft_A220-449-Aurora.jpg?v=1773880700",
+ "availability": "IN_STOCK",
+ "condition": "NEW",
+ "googleProductCategory": "Home & Garden > Decor > Wallpaper",
+ "price": {
+ "amountMicros": "50100000",
+ "currencyCode": "USD"
+ },
+ "productTypes": [
+ "Fabric"
+ ],
+ "shippingWeight": {
+ "value": 1,
+ "unit": "lb"
+ }
+ },
+ "base64EncodedName": "accounts/146735262/products/ZW5-VVN-c2hvcGlmeV9VU183ODAwMjYxODA0MDgzXzQ0MTI2NzkyNTQ4NDAz"
+ }
+ },
+ {
+ "key": "shopify_US_7800258297907_44126786519091",
+ "field": "link",
+ "correct": false,
+ "applied": false,
+ "unrelated_changes": [],
+ "new_disapprovals": [],
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "raw": {
+ "name": "accounts/146735262/products/en~US~shopify_US_7800258297907_44126786519091",
+ "offerId": "shopify_US_7800258297907_44126786519091",
+ "contentLanguage": "en",
+ "feedLabel": "US",
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "productStatus": {
+ "destinationStatuses": [
+ {
+ "reportingContext": "SHOPPING_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DISPLAY_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "FREE_LISTINGS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "VIDEO_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS_DISCOVER_SURFACE",
+ "approvedCountries": [
+ "US"
+ ]
+ }
+ ],
+ "creationDate": "2026-03-22T14:22:24.872365Z",
+ "lastUpdateDate": "2026-09-05T07:17:53.994834Z",
+ "googleExpirationDate": "2026-10-06T08:11:44Z"
+ },
+ "productAttributes": {
+ "identifierExists": false,
+ "title": "Ascoli - Opal Mylar Wallcovering",
+ "description": "Santa Catalina in Opal is a textured wallcovering by Hollywood Wallcoverings featuring rich Oatmeal tones. Its commercial-grade durability meets refined design with ACT-certified performance. Ideal for hospitality, corporate, and high-traffic residential interiors.",
+ "link": "https://www.designerwallcoverings.com/products/ascoli-opal-mylar-wallcovering?variant=44599727521843&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic",
+ "imageLink": "https://cdn.shopify.com/s/files/1/0015/4117/7456/files/Ascoli_A216-185-Opal_Mylar.jpg?v=1773880606",
+ "availability": "IN_STOCK",
+ "condition": "NEW",
+ "googleProductCategory": "Home & Garden > Decor > Wallpaper",
+ "price": {
+ "amountMicros": "59660000",
+ "currencyCode": "USD"
+ },
+ "productTypes": [
+ "Wallcovering"
+ ],
+ "shippingWeight": {
+ "value": 4,
+ "unit": "lb"
+ }
+ },
+ "base64EncodedName": "accounts/146735262/products/ZW5-VVN-c2hvcGlmeV9VU183ODAwMjU4Mjk3OTA3XzQ0MTI2Nzg2NTE5MDkx"
+ }
+ },
+ {
+ "key": "shopify_US_7800261673011_44126792351795",
+ "field": "link",
+ "correct": false,
+ "applied": false,
+ "unrelated_changes": [],
+ "new_disapprovals": [],
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "raw": {
+ "name": "accounts/146735262/products/en~US~shopify_US_7800261673011_44126792351795",
+ "offerId": "shopify_US_7800261673011_44126792351795",
+ "contentLanguage": "en",
+ "feedLabel": "US",
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "productStatus": {
+ "destinationStatuses": [
+ {
+ "reportingContext": "SHOPPING_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DISPLAY_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "FREE_LISTINGS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "VIDEO_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS_DISCOVER_SURFACE",
+ "approvedCountries": [
+ "US"
+ ]
+ }
+ ],
+ "creationDate": "2026-03-22T14:28:55.087194Z",
+ "lastUpdateDate": "2026-09-05T07:17:54.569054Z",
+ "googleExpirationDate": "2026-10-06T01:35:49Z"
+ },
+ "productAttributes": {
+ "identifierExists": false,
+ "title": "Weft - Prairie Wallcovering",
+ "description": "Crystal Cove in Prairie is a textured wallcovering by Hollywood Wallcoverings featuring sophisticated colorways. Its commercial-grade durability meets refined design with ACT-certified performance. Ideal for hospitality, corporate, and high-traffic residential interiors.",
+ "link": "https://www.designerwallcoverings.com/products/weft-prairie-wallcovering?variant=44599729979443&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic",
+ "imageLink": "https://cdn.shopify.com/s/files/1/0015/4117/7456/files/Weft_A220-185-Prairie.jpg?v=1773880696",
+ "availability": "IN_STOCK",
+ "condition": "NEW",
+ "googleProductCategory": "Home & Garden > Decor > Wallpaper",
+ "price": {
+ "amountMicros": "50100000",
+ "currencyCode": "USD"
+ },
+ "productTypes": [
+ "Fabric"
+ ],
+ "shippingWeight": {
+ "value": 1,
+ "unit": "lb"
+ }
+ },
+ "base64EncodedName": "accounts/146735262/products/ZW5-VVN-c2hvcGlmeV9VU183ODAwMjYxNjczMDExXzQ0MTI2NzkyMzUxNzk1"
+ }
+ },
+ {
+ "key": "shopify_US_7800259149875_44126787960883",
+ "field": "link",
+ "correct": false,
+ "applied": false,
+ "unrelated_changes": [],
+ "new_disapprovals": [],
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "raw": {
+ "name": "accounts/146735262/products/en~US~shopify_US_7800259149875_44126787960883",
+ "offerId": "shopify_US_7800259149875_44126787960883",
+ "contentLanguage": "en",
+ "feedLabel": "US",
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "productStatus": {
+ "destinationStatuses": [
+ {
+ "reportingContext": "SHOPPING_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DISPLAY_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "FREE_LISTINGS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "VIDEO_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS_DISCOVER_SURFACE",
+ "approvedCountries": [
+ "US"
+ ]
+ }
+ ],
+ "creationDate": "2026-03-22T14:24:32.697523Z",
+ "lastUpdateDate": "2026-09-05T07:17:55.173415Z",
+ "googleExpirationDate": "2026-10-07T02:01:33Z"
+ },
+ "productAttributes": {
+ "identifierExists": false,
+ "title": "Orsay - Paperback Wallcovering",
+ "description": "Fort Baker in Paperback is a textured wallcovering by Hollywood Wallcoverings featuring sophisticated colorways. Its commercial-grade durability meets refined design with ACT-certified performance. Ideal for hospitality, corporate, and high-traffic residential interiors.",
+ "link": "https://www.designerwallcoverings.com/products/orsay-paperback-wallcovering?variant=44599727947827&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic",
+ "imageLink": "https://cdn.shopify.com/s/files/1/0015/4117/7456/files/Orsay_A218-033-Paperback.jpg?v=1773880630",
+ "availability": "IN_STOCK",
+ "condition": "NEW",
+ "googleProductCategory": "Home & Garden > Decor > Wallpaper",
+ "price": {
+ "amountMicros": "50460000",
+ "currencyCode": "USD"
+ },
+ "productTypes": [
+ "Fabric"
+ ],
+ "shippingWeight": {
+ "value": 1,
+ "unit": "lb"
+ }
+ },
+ "base64EncodedName": "accounts/146735262/products/ZW5-VVN-c2hvcGlmeV9VU183ODAwMjU5MTQ5ODc1XzQ0MTI2Nzg3OTYwODgz"
+ }
+ },
+ {
+ "key": "shopify_US_7800257347635_44126784651315",
+ "field": "link",
+ "correct": false,
+ "applied": false,
+ "unrelated_changes": [],
+ "new_disapprovals": [],
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "raw": {
+ "name": "accounts/146735262/products/en~US~shopify_US_7800257347635_44126784651315",
+ "offerId": "shopify_US_7800257347635_44126784651315",
+ "contentLanguage": "en",
+ "feedLabel": "US",
+ "dataSource": "accounts/146735262/dataSources/180695450",
+ "productStatus": {
+ "destinationStatuses": [
+ {
+ "reportingContext": "SHOPPING_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DISPLAY_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "FREE_LISTINGS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "VIDEO_ADS",
+ "approvedCountries": [
+ "US"
+ ]
+ },
+ {
+ "reportingContext": "DEMAND_GEN_ADS_DISCOVER_SURFACE",
+ "approvedCountries": [
+ "US"
+ ]
+ }
+ ],
+ "creationDate": "2026-03-22T14:20:07.846754Z",
+ "lastUpdateDate": "2026-09-05T07:17:56.397740Z",
+ "googleExpirationDate": "2026-10-05T21:15:06Z"
+ },
+ "productAttributes": {
+ "identifierExists": false,
+ "title": "Secret Garden - Refresh Wallcovering",
+ "description": "Fort Funston in Refresh is a textured wallcovering by Hollywood Wallcoverings featuring sophisticated colorways. Its commercial-grade durability meets refined design with ACT-certified performance. Ideal for hospitality, corporate, and high-traffic residential interiors.",
+ "link": "https://www.designerwallcoverings.com/products/secret-garden-refresh-wallcovering?variant=44599726833715&country=US¤cy=USD&utm_medium=product_sync&utm_source=google&utm_content=sag_organic&utm_campaign=sag_organic",
+ "imageLink": "https://cdn.shopify.com/s/files/1/0015/4117/7456/files/Secret_Garden_A215-017-Refresh.jpg?v=1773880576",
+ "availability": "IN_STOCK",
+ "condition": "NEW",
+ "googleProductCategory": "Home & Garden > Decor > Wallpaper",
+ "price": {
+ "amountMicros": "54590000",
+ "currencyCode": "USD"
+ },
+ "productTypes": [
+ "Wallcovering"
+ ],
+ "shippingWeight": {
+ "value": 4,
+ "unit": "lb"
+ }
+ },
+ "base64EncodedName": "accounts/146735262/products/ZW5-VVN-c2hvcGlmeV9VU183ODAwMjU3MzQ3NjM1XzQ0MTI2Nzg0NjUxMzE1"
+ }
+ }
+ ]
+}
diff --git a/data/tk11450-ca-relabel-2026-09-11T16-20-31-973Z.jsonl b/data/tk11450-ca-relabel-2026-09-11T16-20-31-973Z.jsonl
new file mode 100644
index 0000000..50c597c
--- /dev/null
+++ b/data/tk11450-ca-relabel-2026-09-11T16-20-31-973Z.jsonl
@@ -0,0 +1,76 @@
+{"offerId":"43491051536435","amount":6,"shopifyCA":6,"title":"Stevie Grey - White Commercial Wallcovering | Ko","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"31799652024371","amount":7,"shopifyCA":6,"title":"Lyra Silk Weave - Citrine | Scalamandre","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44612731338803","amount":429,"shopifyCA":423,"title":"Boutis Tone on Tone Jais Black | Christian Lacro","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"43693628391475","amount":7,"shopifyCA":6,"title":"Broderie - Bordeaux Wallcovering | Backdrop","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42681027330099","amount":6,"shopifyCA":6,"title":"Spike Blue | Coordone Europe","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"43243580358707","amount":200,"shopifyCA":198,"title":"Grand Palace Blush - Blush Wallcovering | Thibau","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42680888721459","amount":7,"shopifyCA":6,"title":"Coordonné Durable Vinyl Wallcovering | Coordone ","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44492740362291","amount":353,"shopifyCA":349,"title":"Tweak - Cocoa Brown By G P & J Baker | Kit Kemp ","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"43328577372211","amount":7,"shopifyCA":6,"title":"Insight Grid Cove Bay Gray - Gray Commercial Wal","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44463261384755","amount":276,"shopifyCA":275,"title":"Kravet Design - Silver Wallcovering | Kravet","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44492611715123","amount":92,"shopifyCA":91,"title":"Kravet Design - W3922-16 Beige Natural Wallcover","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"43328308674611","amount":7,"shopifyCA":6,"title":"Zaft Weave Basalt - Gray Commercial Wallcovering","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44489357328435","amount":168,"shopifyCA":166,"title":"One Man’s Trash (Is Another Man’s Treasure) | Re","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44612742381619","amount":442,"shopifyCA":436,"title":"Meredith 06 - Aqua Blue Wallcovering | Nina Camp","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42368197886003","amount":146,"shopifyCA":145,"title":"Carmela Folk Floral Contemporary Floral - Summer","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"43328354025523","amount":7,"shopifyCA":6,"title":"Ingenuity Royalty - Dark Gray Fabric | Koroseal","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"43483876491315","amount":7,"shopifyCA":6,"title":"Splash - White Commercial Wallcovering | Korosea","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"43696222109747","amount":7,"shopifyCA":6,"title":"Botanique - Spring Wallcovering | Kravet","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44090092486707","amount":7,"shopifyCA":6,"title":"Prado - Neptune Vegan Leather | Phillipe Romano","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"40695358390323","amount":212,"shopifyCA":211,"title":"Animalier Giungla | Versace","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"41354101915699","amount":7,"shopifyCA":6,"title":"Tantilizing Texture Durable Vinyl | Phillipe Rom","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"13967064957040","amount":7,"shopifyCA":6,"title":"Le Gita Durable Faux Grass Vinyl","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"43328523796531","amount":7,"shopifyCA":6,"title":"Wallcovering | Architectural Wallcoverings","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"43693868843059","amount":7,"shopifyCA":6,"title":"Memento Chevron Wallcovering","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44137436479539","amount":390,"shopifyCA":388,"title":"Lilliana - Blush Pink Wallcovering | 1838 Wallco","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42301330587699","amount":92,"shopifyCA":91,"title":"Malibu Bloom - Driftwood | Malibu Wallcovering","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42681008783411","amount":6,"shopifyCA":6,"title":"Riz Acier II B00037 | Coordone Europe","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44444554854451","amount":274,"shopifyCA":271,"title":"Dahlia - Coral on Robin's Egg Wallcovering | Ann","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"17659015692353","amount":45,"shopifyCA":44,"title":"Palazzo Lane - Wood & Metal Chevron | Hollywood ","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44171421646899","amount":7,"shopifyCA":6,"title":"La Foggia Moderno Wallcoverings","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"17828881006657","amount":512,"shopifyCA":504,"title":"Fantastic Faces","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"43328591527987","amount":7,"shopifyCA":6,"title":"House of Tweed Creole Beige - Beige Commercial W","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44482800058419","amount":327,"shopifyCA":322,"title":"W3602-1 Beige | Kravet Design | Botanical & Flor","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44093071589427","amount":91,"shopifyCA":90,"title":"Park Ave Contemporary Faux Grasscloth | Hollywoo","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"32525072662579","amount":7,"shopifyCA":6,"title":"Soliloquy - Neutrals | Daisy Bennett","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44548455694387","amount":272,"shopifyCA":269,"title":"Floral Garden, Blue Wallcoverings | Rebel Walls","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44454876905523","amount":528,"shopifyCA":519,"title":"Chameleon Trail Wp - 21 Brown | Kravet Couture |","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44466521407539","amount":89,"shopifyCA":88,"title":"Kravet Design - W3694-850 Indigo Commercial Wall","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44495154577459","amount":2381,"shopifyCA":2346,"title":"Post Paper - Shadow Multi By Lee Jofa Modern | K","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"40348631695411","amount":152,"shopifyCA":150,"title":"Rio - Teal Wallcovering | Sandberg","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44346659536947","amount":319,"shopifyCA":315,"title":"Stravinsky - Silver Beige | Cole & Son","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42693800198195","amount":142,"shopifyCA":140,"title":"Carte Marin M2506-2 - White Commercial Wallcover","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42321863082035","amount":147,"shopifyCA":145,"title":"Broadway Arches Contemporary Geometric - Chrome ","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44444484370483","amount":221,"shopifyCA":221,"title":"Martin - Marron/Azul Multi By Gaston Y Daniela |","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42650794328115","amount":232,"shopifyCA":229,"title":"Quartz - Pearl By Clarke And Clarke | Clarke & C","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44475670233139","amount":769,"shopifyCA":756,"title":"Divergent - Vicuna White | Kravet Couture | Linh","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44490341384243","amount":93,"shopifyCA":92,"title":"Kravet Design - W3682-11 Grey Commercial Wallcov","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42680998723635","amount":7,"shopifyCA":6,"title":"Check 11,5 Curry | Coordone Europe","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"43174419759155","amount":97,"shopifyCA":97,"title":"Pass Christian Charcoal Wallcovering | Jeffrey S","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42641055842355","amount":284,"shopifyCA":281,"title":"Dawson - Ocean Turquoise By Clarke And Clarke | ","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"41438430527539","amount":7,"shopifyCA":6,"title":"Lamina - Ink/Marine Wallcovering | Harlequin","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"43170475376691","amount":126,"shopifyCA":125,"title":"Daufuskie Cream Light Peach Wallcovering | Jeffr","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44175744925747","amount":193,"shopifyCA":190,"title":"Irina - Navy Residential Wallcovering | Jeffrey ","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42537716809779","amount":7,"shopifyCA":6,"title":"Zen Garden - Shakkei Grey | Maya Romanoff","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44493760233523","amount":214,"shopifyCA":212,"title":"W3931 - 11 Grey | Kravet Design | Ronald Redding","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44442774962227","amount":375,"shopifyCA":373,"title":"Bibury - Green By G P & J Baker | House Small Pr","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42680995971123","amount":7,"shopifyCA":6,"title":"Check 8 Príncipe | Coordone Europe","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44175746433075","amount":182,"shopifyCA":180,"title":"Integrity - Dove Residential Wallcovering | Jeff","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"40348265938995","amount":209,"shopifyCA":206,"title":"Fabian white Wallcovering | Sandberg","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"41353967009843","amount":7,"shopifyCA":6,"title":"Geneva-Mulberry Flicker Durable Vinyl | Phillipe","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42511636201523","amount":7,"shopifyCA":6,"title":"Common Threads - Heathered Brown","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42511667757107","amount":7,"shopifyCA":6,"title":"Sunset Silk - Golden Sun","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44438501326899","amount":217,"shopifyCA":214,"title":"Sunset Boulevard Blue - Blue Wallcovering | Thib","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"41354085040179","amount":7,"shopifyCA":6,"title":"Vienna Linen Durable Vinyl | Phillipe Romano","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"41353977757747","amount":7,"shopifyCA":6,"title":"Lebanon-Satin Park Durable Vinyl | Phillipe Roma","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44431392768051","amount":347,"shopifyCA":343,"title":"Venezia - Quartz Wallcovering | Romo","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44493870727219","amount":373,"shopifyCA":368,"title":"Geo Graphica Wp - Stone Grey | Kravet Couture | ","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44491819155507","amount":844,"shopifyCA":834,"title":"Striate Wp - Champagne Beige | Kravet Couture | ","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42321760223283","amount":147,"shopifyCA":145,"title":"Water Lilies Contemporary Floral - White Pearl |","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"41353984081971","amount":7,"shopifyCA":6,"title":"Hudson Vine-Dimgray Durable Vinyl | Phillipe Rom","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"13963614388336","amount":7,"shopifyCA":6,"title":"Saroma Durable Vinyl","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44242806407219","amount":161,"shopifyCA":161,"title":"Big Sur Bluff - Sage Dune | Malibu Wallcovering","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44438500704307","amount":145,"shopifyCA":145,"title":"Monstera Spa Blue - Spa Blue Wallcovering | Thib","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42511905947699","amount":7,"shopifyCA":6,"title":"Flight (Clouds) - Sunrise on Cotton Canvas Linen","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"44482708799539","amount":225,"shopifyCA":222,"title":"Kravet Design - W3587-81 Ivory Wallcovering | Kr","prior_currency":"USD","new_currency":"CAD","ok":true}
+{"offerId":"42511624405043","amount":7,"shopifyCA":6,"title":"Reflections - Beige Brilliance","prior_currency":"USD","new_currency":"CAD","ok":true}
diff --git a/tk11450-ca-currency-relabel.mjs b/tk11450-ca-currency-relabel.mjs
new file mode 100644
index 0000000..18906f3
--- /dev/null
+++ b/tk11450-ca-currency-relabel.mjs
@@ -0,0 +1,80 @@
+#!/usr/bin/env node
+/**
+ * TK-11450 — relabel the CA-feed offers that carry a CAD amount stamped USD.
+ *
+ * The amounts are NOT wrong; only the currencyCode is. Verified live: 77 of 81 feed amounts match
+ * the product's Shopify CA contextual price and ZERO match its USD base price. Google requires the
+ * offer currency to match an available shipping service; the only CA service is CAD, so all 81 are
+ * disapproved and serving nothing. Relabelling USD -> CAD, amount unchanged, can only improve them.
+ *
+ * SAFETY, learned from the TK-11233 delete that hit 59 live offers because its cohort had been
+ * verified 68 minutes earlier: every offer is RE-VERIFIED AT WRITE TIME, immediately before its own
+ * write. Any offer that is no longer USD, no longer in the CA feed, or whose amount no longer matches
+ * its live Shopify CA price is SKIPPED, not written. Fails closed on any read error.
+ *
+ * node tk11450-ca-currency-relabel.mjs # DRY-RUN (default), zero writes
+ * node tk11450-ca-currency-relabel.mjs --apply --yes-i-am-steve # fire
+ */
+import fs from 'fs';
+import { createRequire } from 'module';
+const require = createRequire(import.meta.url);
+const { token, MERCHANT } = require('./_auth.js');
+const { getProduct } = require('./_mc-read-v1.js');
+
+const args = process.argv.slice(2);
+const APPLY = args.includes('--apply') && args.includes('--yes-i-am-steve');
+const CA_DS = 'accounts/146735262/dataSources/10708797233'; // PRIMARY en/CA Content API
+const TOL = 0.02; // 2% tolerance vs Shopify CA price
+const shopTok = (fs.readFileSync(process.env.HOME + '/Projects/secrets-manager/.env', 'utf8').match(/^SHOPIFY_FULL_ACCESS_TOKEN=(.+)$/m) || [])[1];
+if (!shopTok) { console.error('REFUSING: no SHOPIFY_FULL_ACCESS_TOKEN — cannot verify amounts at write time.'); process.exit(2); }
+
+async function shopCA(variantId) {
+ const Q = `query($id:ID!){productVariant(id:$id){price ctxCA:contextualPricing(context:{country:CA}){price{amount currencyCode}}}}`;
+ const r = await fetch('https://designer-laboratory-sandbox.myshopify.com/admin/api/2024-10/graphql.json', {
+ method: 'POST', headers: { 'X-Shopify-Access-Token': shopTok, 'Content-Type': 'application/json' },
+ body: JSON.stringify({ query: Q, variables: { id: `gid://shopify/ProductVariant/${variantId}` } }), signal: AbortSignal.timeout(45000) });
+ const j = await r.json();
+ const v = j?.data?.productVariant;
+ if (!v) return null;
+ return { base: parseFloat(v.price), ca: v.ctxCA ? parseFloat(v.ctxCA.price.amount) : null };
+}
+
+const cohort = JSON.parse(fs.readFileSync('data/tk11450-ca-disapprovals.json', 'utf8')).filter(r => /USD/.test(r.price));
+console.log(`${APPLY ? 'APPLY' : 'DRY-RUN'} — CA currency relabel, ${cohort.length} candidate offers\n`);
+
+let write = [], skip = [];
+for (const r of cohort) {
+ const feedAmt = parseFloat(r.price);
+ let live, sp;
+ try { live = await getProduct('online:en:CA:' + r.offerId); } catch (e) { skip.push({ id: r.offerId, why: 'MC read failed: ' + e.message.slice(0, 50) }); continue; }
+ const cur = live?._v1?.productAttributes?.price?.currencyCode;
+ const amt = live?._v1?.productAttributes?.price ? Number(live._v1.productAttributes.price.amountMicros) / 1e6 : null;
+ if (cur !== 'USD') { skip.push({ id: r.offerId, why: `already ${cur} — nothing to fix` }); continue; }
+ try { sp = await shopCA(r.offerId); } catch (e) { skip.push({ id: r.offerId, why: 'shopify read failed' }); continue; }
+ if (!sp || sp.ca === null) { skip.push({ id: r.offerId, why: 'no Shopify CA contextual price — cannot verify' }); continue; }
+ if (Math.abs(amt - sp.ca) > Math.max(1, sp.ca * TOL)) { skip.push({ id: r.offerId, why: `amount ${amt} does not match Shopify CA ${sp.ca} — NOT relabelling` }); continue; }
+ write.push({ offerId: r.offerId, amount: amt, shopifyCA: sp.ca, title: (r.title || '').slice(0, 48) });
+}
+
+console.log(`WOULD RELABEL USD -> CAD (amount unchanged): ${write.length}`);
+for (const w of write.slice(0, 6)) console.log(` ${w.offerId} ${w.amount} -> same amount, CAD (Shopify CA ${w.shopifyCA}) ${w.title}`);
+if (write.length > 6) console.log(` ... and ${write.length - 6} more`);
+console.log(`\nSKIPPED (failed write-time verification): ${skip.length}`);
+for (const s of skip) console.log(` ${s.id} ${s.why}`);
+
+if (!APPLY) { console.log('\nDRY-RUN only — ZERO writes. To fire: --apply --yes-i-am-steve'); process.exit(0); }
+
+const tok = await token();
+let ok = 0, fail = 0; const log = [];
+for (const w of write) {
+ const url = `https://merchantapi.googleapis.com/products/v1/accounts/${MERCHANT}/productInputs:insert?dataSource=${encodeURIComponent(CA_DS)}`;
+ const body = { offerId: w.offerId, contentLanguage: 'en', feedLabel: 'CA',
+ productAttributes: { price: { amountMicros: String(Math.round(w.amount * 1e6)), currencyCode: 'CAD' } } };
+ const r = await fetch(url, { method: 'POST', headers: { Authorization: 'Bearer ' + tok, 'Content-Type': 'application/json' }, body: JSON.stringify(body) });
+ if (r.ok) { ok++; log.push({ ...w, prior_currency: 'USD', new_currency: 'CAD', ok: true }); }
+ else { fail++; log.push({ ...w, ok: false, err: (await r.text()).slice(0, 140) }); }
+}
+const f = `data/tk11450-ca-relabel-${new Date().toISOString().replace(/[:.]/g, '-')}.jsonl`;
+fs.writeFileSync(f, log.map(l => JSON.stringify(l)).join('\n') + '\n');
+console.log(`\nDONE: ${ok} relabelled, ${fail} failed. Run-log -> ${f}`);
+console.log('UNDO: re-insert the same offerIds with currencyCode USD and the same amountMicros from that log.');
← 4adf88c TK-10993: fix a 5th hardcoded parent constant that would hav
·
back to Gmc Titlefix
·
TK-11449: 115 true Fentucci duplicate pairs, and the trap in a32a20b →