Batch Returns

Overview

  • The batch return file allows Merchants to post returns into the AvantLink transaction database.
  • Batch return files should be scheduled to be imported on daily or weekly basis.
  • Return records must be posted to the AvantLink system within 30 days of the original sale transaction date.
  • Files will be uploaded via FTP to batch.avantlink.com, in the “returns” directory. (Contact support@avantlink.com for FTP credentials).

 

Column Layout

Merchant ID,Transaction/Order ID,Product ID/SKU,Return Item Amount,Return Item Quantity,Return Reason Code

Note: Please include a column header row in your files with the column headers exactly as shown above.

Column Value Specifications:

Column Type Description
Merchant ID integer The Merchant ID supplied by AvantLink
Transaction/Order ID string The transaction or order ID from your e-commerce system.
Product ID/SKU string The return record Product ID or SKU from your e-commerce system. This must match the product ID/SKU provided with the datafeed file.
Return Item Amount float The return order per-item price, with no dollar sign or comma formatting (decimal places are allowed). By default, all currency values should be supplied as US dollars (USD).
Return Item Quantity integer The return order item quantity.
Return Reason Code string The reason the sale item is being reversed. Current codes are: ADJUSTMENT, CANCELED, FRAUD, RETURN.

 

File Naming Convention

We can accept CSV, or pipe-delimited text files for batch processing.

 

Pipe delimited ( .txt ): returns_[MERCHANT_ID]_Year_Month_Day.txt

EX: returns_99999_2019_01_01.txt

Comma delimited ( .csv ): returns_[MERCHANT_ID]_Year_Month_Day.csv

EX: returns_99999_2019_01_01.csv

 

Example Data File

title: returns_1234_2019_01_01.txt

Have more questions? Submit a request
Powered by Zendesk