The sale batch file requirements are the same for file submission via the platform or by sending via SFTP.
REQUIRED FIELDS
The batch sale file must match the EXACT specifications outlined below. Please review all data carefully before submitting.
Additional fields are required If your program utilizes item-based commission.
Column |
Type |
Description |
Notes |
Affiliate Data | string |
A unique identifier for the affiliate click that triggered the sale. |
Two Options:
|
Transaction ID |
String |
The unique sale ID from your e-commerce system. |
|
Sale Item Amount | float | The order amount. | If using Item Based Commission this value will be the sale record's per-item price. |
Type Definitions:
- String: text or special values
- Integer: a number without a decimal point
- Float: a number with a decimal point
ITEM BASED COMMISSION REQUIRED FIELDS
For merchants using Item Based Commission, the fields below are also required to ensure the correct commission amount is being calculated.
Column |
Type |
Description |
Note |
Product ID/SKU |
string
|
The original sale record's Product ID or SKU |
Must match the product ID/SKU provided with the product datafeed file. |
Sale Item Amount |
float |
The sale record's per-item/product price. |
Currency values should be in the network default currently (USD in the US network, CAD in the CA network, or AUD in the AUS network. Dollar signs ($) and commas should NOT be included. Decimal points are the only special symbols allowed. |
Sale Item Quantity |
integer |
The number of items/products being purchased. |
|
OPTIONAL FIELDS
Please contact support@avantlink.com before implementing these fields.
Column |
Type |
Description |
Note |
Exclusive Coupon Code | string | Coupon code used with sale. | Exclusive coupon codes can be assigned to specific affiliates so that they always get credit for a sale. |
Affiliate Sale Commission | float | Total affiliate commission for the sale (not the per item). | Should not be combined with Item Based Commission. |
Network Sale Commission | float | Total network commission for the sale. | |
Billing State | string | Two letter abbreviation for the state. | |
Billing Country | string | The two or three letter ISO 3166 code | |
Custom Tracking Code | string | The custom tracking code passed by the affiliate. | |
New Customer | string | The value should be 'Y" for a new customer or 'N' for an existing customer. |
ADDITIONAL QUESTIONS?
If you still have questions or need assistance please email support@avantlink.com.