R01: Full refundR02: Partial refundR03: CancelledRefund matching
Decline affiliate commission on refunds, with evidence.
Every pending transaction is matched to its Shopify order. Full refunds become declines, partial refunds become amends, each with its proof.
Nº 01The problem
The spreadsheet every validation cycle
Export pending transactions, VLOOKUP them against orders and refunds, work out the amended amount for partial refunds, then upload a batch file. Agencies call it “a labour-intensive task”. Anything you miss before the validation period ends is auto-approved and paid.
Nº 02How it works
How refund matching works
- Step 1Connect ShopifyInstall with read-only scopes. Orders and refunds from the last 60 days sync in the background.
- Step 2Import pending transactionsDrop in the network CSV. Saved mappings make the next import a two-minute job.
- Step 3Review the suggestionsFull refund → decline. Partial refund → amend to the kept amount. Cancelled → decline. Order not found → check.
Nº 03Without and with AffCheck
The same job, in minutes.
Typical times for about 400 transactions. Illustrative: we’ll replace them with real numbers from early users.
Without: a spreadsheet
- Export pending transactions
- 5 min
- VLOOKUP against orders and refunds
- 40 min
- Work out partial refunds
- 20 min
- Build the batch file
- 15 min
- Total
- 80 min
With AffCheck
- Drop the export
- 2 min
- Confirm suggestions
- 5 min
- Upload the file
- 2 min
- Total
- 9 min
Nº 04On your network
Each network, in its own words.
- AwinAwin calls it “decline”; the deadline is the auto-validation period (avp).Awin validation rules
- CJ AffiliateCJ Affiliate calls it “correction (full) or cancellation”; the deadline is the locking (locked / closed status).CJ Affiliate validation rules
- impact.comimpact.com calls it “reversal (amount 0)”; the deadline is the action locking date.impact.com validation rules
Nº 05Line items
What you get
- Evidence on every line
- Refund ID, date and amount next to each suggestion, so a publisher query takes one click to answer.
- Amend amounts worked out
- Partial refunds get the new sale amount and commission, ready for the network’s amend column.
- Checks the network’s own sync
- Already using Awin auto-validation or the CJ or Rakuten app? See the refunds it did not catch: older orders, other account types, late or partial refunds.
Questions
What about returns that happen after the deadline?
Commission can only be declined while the transaction is pending. The deadline email lists what is due, so you can validate as late as the period allows.
Does it see customer names or emails?
No. AffCheck uses Level 1 order data only: order IDs, amounts, refunds, cancellations and discount codes.
How far back does it go?
Shopify gives apps the last 60 days of orders by default, which covers most validation periods. Longer history needs Shopify’s approval for read_all_orders.
Does Awin’s Shopify app already decline refunds?
On Awin Classic accounts, for orders placed after activation, on whitelisted domains, it declines cancellations and adjusts for partial refunds. Everything outside that still needs checking, and AffCheck shows what it missed.
Statement · Last month
See what you paid for last month.
Two exports, five minutes, a dollar figure for your store.
Run the free checkFiles never leave your browser.
Not now? Get the Monday deadline email when we launch.