When XLSX report price does not match Allegro API
Two sources of truth, the 10% threshold, and when to re-sync vs re-upload instead of treating it as a bug.
You uploaded Sales by offer and connected Allegro API — but price or stock on the offers list looks different from the spreadsheet. That is not necessarily a parser bug. SalesAmplifier treats XLSX and API as parallel history streams and surfaces mismatches instead of overwriting older facts.
Two sources, two questions
| Source | Best answers | |--------|----------------| | XLSX | Sales, visits, and Ads for the selected export period — a Sales Center snapshot | | Allegro API | Current offer state (price, availability, status) and live orders |
An XLSX row may show average offer price across the sales period. API returns state now (or from the last sync every few hours). Gaps usually come from timing and column definitions, not “broken data”.
10% threshold on price and stock
In the app we compare e.g.:
- gross price from API snapshot vs average price from the sales report,
- availability from API snapshot vs ending quantity from XLSX.
When the gap exceeds 10%, the offer gets a reconciliation status on the catalog and offer detail. Neither source is deleted — both events stay in history.
What to do step by step
- Check export date — does the XLSX cover the period you are asking about?
- Run API sync in account settings (or wait for the schedule).
- Open offer detail — compare API and XLSX values side by side.
- If you changed price after the export, API will be newer — upload a fresh report to update the sales timeline.
For daily revenue mismatches, check the dashboard — the API vs XLSX sales reconciliation card shows account-level trends.
This is timing, not a bug
Common scenarios:
- mid-week price promotion — API sees the new price, old XLSX still averages the whole period,
- delayed sales report upload,
- offer ended in API but still visible in the last export.
SalesAmplifier does not auto-pick a winner on ingest — it shows the conflict; you decide whether to refresh the export, sync API, or both.
Related
- XLSX or Allegro API — where to get sales data
- Sales by offer report guide
- Offer change log (offer-events) — when API records edits