Refresh Data

Re-run any data fetch by hand — no SQL needed. A runner picks jobs up within 5 minutes.
Show:
Loading…
How this works: clicking Run puts the fetch in a queue; a runner in the database picks it up within 5 minutes and makes exactly the same calls the nightly schedule makes. Most fetches are two steps: Job 1 asks Amazon to start building the reports, then after the build gap (shown live as a countdown) Job 2 downloads them into the tables. Quick fetches (live stock, snapshots, ratings, the rollup) are a single step. When several fetches are queued at once, the runner starts one report-build every 5 minutes on purpose — Amazon limits how fast we may ask, and this spacing avoids losing data. "Done ✓" means the download was started; give it a few minutes to finish writing, then confirm on System Status ("Data through" is the honest check). PPC raw data only appears on the PPC dashboard after the Re-calculate PPC tables step — run it last, after the PPC fetches are done.