Help Center/Reports & marketplace imports
Reports troubleshooting
Fix upgrade gates, file parse errors, Tracking ID mismatches, empty imports, and stale link stats.
Use this guide when imports fail, report pages stay empty, Tracking IDs do not match, or link conversions do not update after an import.
Outcome
You isolate plan/permission issues, file format problems, and tag mismatches, then re-import or sync successfully.
Before you start
- Confirm the active team and that you can open Affiliate Tags and Settings → Reports.
- Note the exact error toast or dialog message.
- Keep the original export file (do not rename away from
.xlsx/.csv/.zipif possible).
Image placeholder — add `images/troubleshooting-cover.png` under this category
Common problems
Import / View reports locked (upgrade)
- Tag menus and Settings cards are gated by store features (
amazon_tag_reports,ebay_tag_reports,walmart_tag_reports). - If you see a lock or “Upgrade to access sales reports by tag,” open Dashboard → Billing.
- Upgrade to a plan that includes tag reports (Individual or higher), then retry.
Image placeholder — add `images/troubleshooting-step-01.png` under this category
File rejected (type, size, or parse)
| Message / symptom | What to try |
|---|---|
| File too large (max 10 MB) | Export a shorter period or remove extra sheets outside Amazon’s download |
File must be .xlsx, .csv, or .zip | Use Amazon’s Fee Statement download; do not convert to .xls only |
| Failed to parse / not a recognized report | Confirm Fee Statement, Linked-Product, or SPCC—not an unrelated spreadsheet |
| CSV is not a recognized SPCC export | Use the Sponsored Products for Creators earnings CSV, not a random CSV |
| No Tracking IDs found | File may be Linked-Product format—select a tag manually and Import |
Image placeholder — add `images/troubleshooting-step-02.png` under this category
No rows match the selected tag
- Leave the tag empty and click Scan & Import to list Tracking IDs in the file.
- Compare each ID to Affiliate Tags → tag values.
- Import into the matching tag, or Create tag & import.
- Ensure the selected tag’s tag value is set (empty tracking IDs cannot match Excel rows).
Image placeholder — add `images/troubleshooting-step-03.png` under this category
Import succeeds but “no new rows”
- Re-importing the same data skips duplicates—this is expected.
- Download a newer period from Associates / EPN / Impact.com.
- Confirm you are viewing the correct tag report and date range.
Tag report looks empty
- Open View reports for the tag you imported into (not a different Tracking ID).
- Widen the date range; Linked-Product period aggregates may sit on
period_endonly. - Clear category / exclude filters and set Import to the latest batch.
- Confirm the import appears in the Import dropdown.
Image placeholder — add `images/troubleshooting-step-04.png` under this category
Link stats did not update
- Confirm the import finished successfully for that tag.
- Run Settings → Reports → Sync link stats.
- Wait for the background job / notification.
- Ensure links share the same tag and product ID (ASIN / item / SKU) as the report rows.
- See Report reconciliation.
Permission errors
- Ask a team admin for
reportsview/import oraffiliate_tagsimport/reports permissions. - Partnership / read-only tags hide monetary internals—use your own team’s tags for imports.
Tips
- Amazon Associates Fee Statement is the primary path for commission history; SPCC covers sponsored-product earnings CSVs.
- Settings → Reports still distinguishes Creators API (product/deals) from sales imports—use imports for charts.
- Keep Tracking IDs stable; renaming a tag’s display name does not change matching, but changing tag value does.