← back to Carnegie Identity Audit
README.md
19 lines
# Carnegie identity audit — TK-11246
Read-only reconstruction of the 26 Carnegie Siltech Grain manufacturer-SKU
changes recorded on August 18, 2026. Category suffixes distinguish products;
never strip them table-wide.
The collector reads historical IDs, finds current products by exact variant SKU,
captures both manufacturer_sku namespaces, and reads staging in a PostgreSQL
read-only transaction. Shopify credentials are loaded in memory from the existing
registry and never emitted. Execution requires network/local database access.
Steve explicitly authorized the scoped repair on September 11: "ungate and run".
`execute.py` contains phased preflight, transactional database repair, canary,
compare-and-set metafield repair, rollback rehearsal, and idempotent retries.
`verify_live.py` independently reads REST and SQL, asserting corrected identities
and unchanged prices, product properties, other metafields and excluded products.
The original preparation remains in `verification/`; execution evidence is in
`execution-20260911/`. Approval applies only to the exact IDs in repair-plan.json.