From Wiki

Contents 1 Introduction 2 Capturing data 3 Multiple Commission Groups 4 Reporting

Introduction

Offline Transaction Processing is Affiliate Window’s system for processing affiliate transactions without the use of cookies or tracking code on the confirmation page.

Capturing data

This system requires the merchant to capture various values on click-through and store them until the point that the sale completes. The details are then reported back to Affiliate Window with any transaction details by a batch CSV file.

The click values to capture on click-through and store are as below.

• Affiliate id (Captured from click-through URL)
• Click date (Format (BST): dd/mm/yyyy hh:ii:ss).
• Group id (Captured from click-through URL)
• Banner id (Captured from click-through URL)
• Product id (Captured from click-through URL)
• Click ref (Captured from click-through URL)

On click-through to the merchant’s site the click values are added to the query string.

Example: awaid=12345&awgid=123456&awbid=234567&awpid=123456789&awcr=abcd1234

The parameters can be defined by the merchant.

All the values should be captured and stored to a cookie for the length that you would like to reward affiliates for (normally 30 days).

Multiple Commission Groups

In order to add multiple commission groups within offline tracking, you can do this by separating the parts parameter by a pipe delimiter, for example:

DEFAULT:1.00|GROUP1:5.00

The sale amounts will need to amount to the total within the sale_amount variable

Reporting

When the transaction is completed the values that have been stored in the cookie need to be taken and put together with the transaction information.

When the merchant is able to report the transaction through to Affiliate Window the information for each transaction needs adding to a CSV file. Each row of the file contains details of a single transaction.

The CSV file needs to be formatted in the format below.

COL 1:  com_date (This is the transaction date (BST) and should follow the format: dd/mm/yyyy hh:mm:ss)
COL 2:  order_ref
COL 3:  sale_amount
COL 4:  type (can be left blank if not used)
COL 5:  parts (commission code:sale_amount)
COL 6:  merchant_customer_id (can be left blank if not used)
COL 7:  affiliate_id
COL 8:  click_date (Format (BST): dd/mm/yyyy hh:mm:ss)
COL 9:  group_id (can be left blank if not used)
COL 10: banner_id (can be left blank if not used)
COL 11: product_id (can be left blank if not used)
COL 12: click_ref (can be left blank if not used)
COL 13: status (enter “pending” for pending and “confirmed” or leave blank for
confirmed).
COL 14: voucher_code (enter voucher code used in transaction or leave blank if none  was used).

Below is an example of how the CSV file should look: