Transaction Queries

From Wiki

Jump to: navigation, search

Français . Deutsch . Polski . Italiano . Nederlands . Svenska . Português (Brasil) . Español



A transaction query is a transaction manually added to the system by a publisher. The circumstances for this to occur would be when the publisher considers they may have an untracked sale, an incorrect commission or when they would like to dispute a declined transaction. Further examples:

  • Untracked

This can happen for a number of reasons; tracking may be down on your confirmation page or a user may block 3rd party cookies.

  • Incorrect

A publisher wishes to dispute the commission amount of a transaction.

  • Declined

A publisher would like a transaction re-validated as they believe it to be a valid transaction.

This guide provides details on how to validate transaction queries.

How it works

You will need to have the Transaction Queries functionality switched on by Awin in order to be able to use it.

Transaction queries added to the system will go into a separate validation screen, which will require you to validate the transaction as approved or declined.

You have 75 days in which to review any queried transaction. (Note: Declined transactions will not affect your AWIN Index).

  • Queried transactions left longer than 75 days will be automatically approved.

How to access Transaction Queries

You can view your transaction queries by:

  • 1. Selecting the option from the ‘To do’ list on the right side of the screen

If you have any outstanding transaction queries then you will see an item in your to-do list e.g. “You have 4 transaction queries waiting to be processed”. Clicking this link will take you to a validation area; similar to the validate pending sales area but with some notable differences.

  • 2. Accessing Validation -> ‘Validate Transaction Queries’ on the grey menu navigation bar near the top of the page


The two key differences to remember about the pending/validation screen are:

  • You can edit the transaction and commission amounts as well as alter the order reference.
  • You can search transactions by publisher ID or order reference using the input fields in the top left corner.

  • When you decline a transaction it will NOT affect your AWIN index. Please use the most appropriate decline reason from the drop down menu.

Batch Process Transaction Queries

You can process multiple transaction queries at once by uploading a file in CSV format. Transactions should be contained in a text file with each transaction on a new line.

Data File Specification

Field Name Type Description Example
ID Integer Max: 10 char. Uniquely identifies the transaction in our system 09876543
Publisher ID Integer Max: 10 char. Uniquely identifies the publisher in our system 09876543
Publisher Name All characters Max 16,777,215 char. Identifies the publisher in our system 1072
Enquiry Type Integer Max: 10 char Unique ID 12345
Sale Amount decimal(7,2) Sale value without currency symbol – You can change this value 10.21
Commission Amount decimal(7,2) Commission value without currency symbol – You can change this value 5.65
Date Date time Datetime of the order (yyyy-mm-dd HH:ii:ss) 2007-02-02 22:30:12
Order Reference Text Max 16,777,215 char Order Reference which should match to your system, this could also contain extra information the publisher has chosen to add to identify the sale LX10501,
Description Text Max 16,777,215 char Further information from the publisher to help process the query. Commission received was 4.54GBP when it should have been 5.54GBP
Auto Validation Check Box Will move the transaction into the approved status, so the publisher will be paid for this transactions n/a
Status Dropdown Will set the transaction status Approved
Decline reason Dropdown Will set the decline reason for the transaction. Invalid claim - Transaction has already been tracked
Duplicate Yes/No Will set if the query was duplicate or not. Yes


Due to new European legislation regarding how websites store information about you, AWIN is updating its privacy policy. You can see the new version of our policy here. If you would like to see the information we capture on this website, please click here for further details. In order to accept cookies on this site please click the 'I ACCEPT' button