Tiles the Coles locations API across Australia, compares results with CockroachDB, then inserts new stores,
updates changed fields, and marks removed stores as Disabled. Also syncs to D1 and writes JSON files to R2.
Last synced: —
Syncing…—
Last Sync Results
—
Total Active
—
Added
—
Deactivated
—
Updated
Total
—
Enabled
—
Disabled
—
Breakdown by State
State
Stores
Distribution
Enabled
Disabled
Loading…
All Stores
Loading…
#
Store Name
Store ID
Address
Suburb
State
Postcode
Nearest City
Km
Status
Loading…
EAN Update Utility
Update Missing EANs via Bazaarvoice
Queries CockroachDB for Coles products with no EAN barcode, then fetches EAN data from the
Bazaarvoice API in batches and writes the results back to product_details.
Processes 800 SKUs per call in batches of 20 (BV limit).