The return batch file requirements are the same for file submission via the platform or by sending via SFTP.
BATCH RETURN FILE REQUIRED FIELDS
The batch return 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 |
|
Transaction/Order ID |
String |
The original sale ID of the order being returned. |
|
|
Return Item Amount |
Float |
The return amount of the sale. |
A blank value will return the full order amount and a partial value will return a partial amount. Enter positive value (no negative values). Dollar signs ($) and commas should NOT be included. Decimal points are the only special symbols allowed. 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. |
|
Return Reason Code
|
string |
The reason the sale is being returned (ADJUSTMENT, CANCELED, FRAUD, RETURN). Default is RETURN. |
If a reason code is not entered, the system will default to CANCELED. Affiliates will see this value in reporting. |
Type Definitions:
- String: text or special values
- Integer: a number without a decimal point
- Float: a number with a decimal point
ITEM BASED COMMISSION BATCH RETURN REQUIREMENTS
For merchants using Item Based Commission, the additional fields below are required to ensure the correct commission amount being returned.
|
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. |
|
Return Item Amount |
float |
The return order per-item price. If not utilizing per-item returns, a blank value will return the full amount and a partial value will return the partial amount |
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. |
|
Return Item Quantity |
integer |
The number of items/products being returned. |
|
ADDITIONAL QUESTIONS?
If you still have questions or need assistance please email support@avantlink.com.