Mfr Recovery 2026 08 23
Search the build
-
d137c992026-08-27 auto-data-snapshot: 2026-08-27T18:10:50 (1 data files) — out/mfr-push-restore-1787879088597.jsonl -
25fe4852026-08-27 TK-10827: fix Novasuede join-key bug in mfr push (nc.sku=handle, exclude slug placeholders) -
e08f75e2026-08-26 TK-10829 Gate 1 (Steve-approved): adopt-live for 32 mis-scraped novasuede_catalog codes + restore-map -
ed866642026-08-26 TK-10829 Novasuede mfr recovery: authoritative novasuede.com reconciliation + 20 placeholder staging fixes -
654c25e2026-08-25 zoffany durable mfr recovery builder + guarded apply/restore (TK-10677) -
88360032026-08-25 auto-data-snapshot: 2026-08-25T07:39:06 (3 data files) — zoffany_durable_apply.sql zoffany_restore.sql zoffany_restore_map.json -
d390b672026-08-24 TK-10827: durable two-surface mfr push (Kamatera DB + Shopify) + companion rollback; dry-run default, restore-map -
31981a92026-08-24 TK-10677: add push-mfr-to-shopify.mjs (dry-run default; sets custom.+dwc.manufacturer_sku; restore-map; reversible) -
fc2116f2026-08-24 TK-10677: verify 24 Zoffany recoverable (/bin/zsh join), mark stale/mirror-only SQL, add verified CSV -
3cc4ec02026-08-23 add pending-approval memo for dw_unified write — awaiting Steve approval -
b4fdc742026-08-23 initial: mfr recovery SQL for Zoffany (24) and Novasuede (14) — TK-10677/TK-10794
Authors
- Steve9
- auto-commit-fleet2
Agents used
Skills used
- /mfr-push-restore-17878790885971
- /restore1
- /zsh1
- /mirror-only1
Creative ideas + design notes
25fe485 · 2026-08-27 · TK-10827: fix Novasuede join-key bug in mfr push (nc.sku=handle, exclude slug placeholders)
The old join nc.mfr_sku=stripped_handle recovered 0 rows. Correct join nc.sku=handle recovers exactly 1: novasuede-sand -> T3D8W (real vendor code, verified vs authoritative novasuede.com). Dry-run confirmed planned=1 wrote=0. Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
b4fdc74 · 2026-08-23 · initial: mfr recovery SQL for Zoffany (24) and Novasuede (14) — TK-10677/TK-10794
Dry-run SQL proves recovery via local staging table join — no live scrape needed. APPLY SQL files drafted for pending-approval (dw_unified mirror write only). Co-Authored-By: rescrape-agent <noreply@anthropic.com>
File tree
- .gitignore
- PENDING-APPROVAL-memo.md
- build-zoffany-durable.mjs
- durable-push-mfr.mjs
- novasuede-recon-20260826/novasuede_32_conflicts_GATED_20260826.csv
- novasuede-recon-20260826/novasuede_conflicts_APPLY_20260826.sql
- novasuede-recon-20260826/novasuede_conflicts_RESTORE_20260826.sql
- novasuede-recon-20260826/novasuede_conflicts_restore_map_20260826.json
- novasuede-recon-20260826/novasuede_live_colors_data_20260826.json
- novasuede-recon-20260826/novasuede_live_source_namecode_20260826.json
- novasuede-recon-20260826/novasuede_placeholder_APPLY_20260826.sql
- novasuede-recon-20260826/novasuede_placeholder_RESTORE_20260826.sql
- novasuede-recon-20260826/novasuede_placeholder_restore_map_20260826.json
- novasuede-recon-20260826/novasuede_reconciliation_20260826.json
- novasuede_mfr_recovery_APPLY.sql
- novasuede_mfr_recovery_dryrun.sql
- out/mfr-push-restore-1787879088597.jsonl
- push-mfr-to-shopify.mjs
- rollback-durable-push.mjs
- zoffany_24_verified_20260824.csv
- zoffany_durable_apply.sql
- zoffany_mfr_recovery_APPLY.sql
- zoffany_mfr_recovery_dryrun.sql
- zoffany_restore.sql
- zoffany_restore_map.json