Transaction Queries
From Wiki
Contents |
Introduction
A transaction query is a transaction manually added to the system by an affiliate. The circumstances for this to occur would be one of the following:
- Untracked
This can happen for a number of reasons; tracking maybe down on your confirmation page or a user may block 3rd party cookies.
- Incorrect
An affiliate wishes to dispute the commission amount of a transaction.
- Declined
An affiliate 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 Affiliate Window 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 selecting the option from the ‘To do’ list on the right side of the screen or by going to Validation -> ‘Validate Transaction Queries’ on the grey menu navigation bar near the top of the page.
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.
Validation
The two key differences to remember about the pending/validation screen are:
- You can edit the transaction and commission amounts as well as altering the order reference.
- You can search transactions by affiliate 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.
Data File Specification
| Field Name | Type | Description | Example |
| Affiliate ID | Integer | Max: 10 char. Uniquely identifies the affiliate in our system | 09876543 |
| Affiliate Site Name | All characters | Max 16,777,215 char. Identifies the affiliate in our system | 1072 |
| Enquiry Type | Integer Max: 10 char | Unique ID | 12345 |
| Trans.Amount | decimal(7,2) | Sale value without currency symbol – You can change this value | 10.21 |
| Comm.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 Ref | Text Max 16,777,215 char | Order Reference which should match to your system, this could also contain extra information the affiliate has chosen to add to identify the sale | LX10501, email@address.com |
| Description | Text Max 16,777,215 char | Further information from the affiliate to help process the query. | Commission received was 4.54GBP when it should have been 5.54GBP |
| Approved | Check Box | Will move the transaction into the approved status, so the affiliate will be paid for this transactions | n/a |
| Declined | Check Box | Will remove this transactions from your Untracked Sales bin, please remember to add a Reason for decline, this won’t affect your AWIN. | n/a |