Vcc Cost Backfill
repo: ~/Projects/vcc-cost-backfill · 3 commits · 0 in last 24h, 0 in last 7d ·
Skills used
- /gated1
- /claude1
- /code1
- /thin1
Creative ideas + design notes
Commits with substantial prose (≥120 chars) — the rationale behind each move.
bfc5ef5 · 2026-09-10 · wallquest cost_price loader: use net_cost not our_price (retail) (TK-11410)
apply-2026-08-24.sql block 02 loaded cost_price=wallquest_catalog.our_price,
which is the DW RETAIL (=net_cost/0.65/0.85), not the net cost — zeroing margin
and false-flagging ~1,145 WallQuest products as below cost (NA508 cost_price
$226.68=retail vs real net_cost $125.24). Fixed to read vc.net_cost. Added
corrective-wallquest-cost-TK11410.sql (DRAFT/gated, snapshot+undo) to repair the
~2,484 already-contaminated rows; NOT run (live backfill is gated).
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01PuFgoHYPwznEaT5iBdCRny
b3d5e82 · 2026-08-24 · VCC cost backfill: real transaction-wrapped apply-2026-08-24.sql (4920 rows, Mac2 path)
Kravet already backfilled (no-op); Kamatera staging too stale/thin to host the
JOINs (missing cols) so target = Mac2 mirror. Proven via ROLLBACK dry-run.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
4bf2f27 · 2026-08-24 · Add VCC cost backfill dry-run analysis for TK-10785
Read-only analysis of cost data backfill potential:
- Baseline: 4,076/89,904 ACTIVE products have cost (4.53%)
- 13 vendor catalog sources identified with joinable cost data
- Best join: mfr_sku (more reliable than dw_sku)
- Total fillable: 17,227 distinct products after dedup
- After backfill: 21,303 products with cost (23.7%)
- Largest source: kravet_authoritative_pricing = 12,242 products
- Full gated SQL provided; write to shopify_products is Steve-gated
(Kamatera-canonical table, blast_radius > 500)
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
File tree
4 files tracked. Click any to browse the source at HEAD.
rendered in 0ms