Import from any other network
AffCheck reads any transactions CSV. What the six required columns are, how to map them once, and what to enter as the validation period.
By The AffCheck team · Updated
AffCheck is not limited to the networks it has presets for. If your network can export transactions as CSV, it can be checked. Pick Another network when you import, map the columns once, and everything after that works exactly as it does for Awin or CJ.
The six columns it needs
| Column | What it is | Why |
|---|---|---|
| Order reference | The order number the network recorded | This is what is matched against your Shopify orders |
| Sale amount | The transaction value | The basis for an amend |
| Commission | What the publisher earns | The money at stake on the row |
| Status | Pending, approved, declined … | Only pending rows become suggestions |
| Transaction date | When the sale was tracked | The deadline is counted from it |
| Publisher id | Who claimed the sale | Duplicates and voucher rules are about who |
Four more are used when your file has them: the transaction id (without it, rows de-duplicate on the order reference and the date instead), the publisher name, the voucher code — needed for voucher rules — and the currency.
Mapping the columns
When AffCheck does not recognise the layout, it shows you your own header row and asks which column is which. It saves the answer against that network and that exact set of headers, so the second import asks nothing. If you change the report's columns later, it asks again — which is the safe behaviour, not a bug.
Status words are read generously: pending, open, new, extended, on hold, awaiting approval and unconfirmed all mean pending; approved, accepted, confirmed, validated, locked, closed and paid mean approved; declined, rejected, reversed, cancelled, void and corrected mean declined. A status word AffCheck has never seen is reported and the row is skipped, rather than guessed at.
The validation period
AffCheck cannot know your network's deadline, so rows on "another network" start undated. Enter the period from your agreement on the Deadlines screen and every pending row is dated from its transaction date. Until you do, the rows are still flagged and still reviewable — they just have no countdown.
Declines and amends
The queue says decline, amend, approve and check. Your network will have its own word — cancel, reject, reverse, reclassify, correct — and the evidence sentence AffCheck writes works in any of their reason boxes. See reason codes.
Tell us which network you use
Presets exist for eight networks and they were written from public documentation, not from real exports. If you send us a redacted export — or just the header row — we will add a preset so nobody has to map that layout again.
What the free check does with it
The free commission leak check reads the same files, with the same mapper, entirely in your browser. It is a good way to confirm a new network's export parses cleanly before importing it into a workspace.
FAQ
Questions, answered
Which columns does AffCheck need?
Six: the order reference, the sale amount, the commission, the status, the transaction date and the publisher id. A transaction id, publisher name, voucher code and currency column are used when they are there.
My network is not in the list. Will it work?
Yes. Pick “Another network”, map the columns once and AffCheck remembers the layout. Tell us which network it is and we will add a preset.
Related
- Import a network export How the Imports screen reads a pending-transactions CSV in your browser, what it stores, and what happens when it asks you to match the columns.
- Deadlines and validation periods How AffCheck dates every pending transaction, where each network’s default period comes from, and why the dates are the network’s UTC calendar day.
- Reason codes R01 to R07 explained What each AffCheck reason code means, which Shopify facts it was raised from, what it suggests and what to write in the network’s reason box.
- Affiliate commission leak check (free tool) Drop a network export and a Shopify orders export to see commission on refunded, cancelled and double-claimed orders. Files never leave your browser.
See what you paid for last month.
Two exports, five minutes, a dollar figure for your store. Files never leave your browser.