source_truth: bc:orders:backfill
This data as json
| source | api_total | api_oldest | api_newest | measured_at | method | notes | event_source | event_category | live_event_source | live_event_category | mode | freshness_sla_minutes | heartbeat_source |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| bc:orders:backfill | 715212 | 2026-05-20 12:28:18 | api_walk | BigCommerce orders backfill (/v3/orders REST). 2015-01-01 onward, both CV and WS stores. [HISTORY] 2026-05-20: bc_hash=NULL bug fixed; 48,834 legacy duplicate events in audit.db are immutable (chain hash design forbids retroactive UPDATE). DISTINCT_COUNT_SOURCES workaround in refresh_coverage_snapshot.py keeps display count accurate. Forward dedup verified working (gap-close run committed 397 new orders with 705,944 dedup hits). | bc:orders:backfill | backfill |