Batch Sales Specifications

 

Overview:

  • The Batch Sales Record File allows Merchants to post batch sales into the AvantLink transaction database.
  • Batch sales files can be scheduled to be imported on an hourly or daily basis.
  • Files will be uploaded to batch.avantlink.com, in the “sales” directory. (Login and password information will be supplied separately.)
  • If you need to process Batch Sales, you MUST first contact AvantLink Support in order to for them to create the login information for you.

CSV Support

As of 8/24/15, we can accept pipe-delimited text, or CSV formatted files for batch processing. If using CSV, please replace the 'pipe character'  |  in the documentation below with a comma, or if building it in a common spreadsheet program, you should be able to just build it in rows and columns and the spreadsheet will save it with the commas. 

Delimited file layout specifications:

Column delimiter: |

Column layout:

Merchant ID|Affiliate Data|Transaction ID|Sale Date|Product ID/SKU|Sale Item Amount|Sale Item Quantity

IMPORTANT! 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
Affiliate Data string An underscore (“_”) delimited string of information that uniquely identifies the affiliate information that triggered this sale. Supplied in the “avad” URL parameter in click-through URLs. (If 
Transaction ID string The sale transaction ID from your e-commerce system.
Sale Date datetime The date/time stamp from your e-commerce system for this sale. Formatted as: “yyyy-mm-dd hh:ii:ss”, e.g. “2008-01-30 13:15:00″.
Product ID/SKU string The sale record’s Product ID or SKU from your e-commerce system.
Sale Item Amount float The sale record’s order item price.By default, all currency values should be supplied as US dollars (USD).
Sale Item Quantity integer The sale record’s order item quantity.

 

File Naming Convention:

sales_[MERCHANT_ID]_yyyymmddhhiiss.txt (e.g. “sales_99999_20080130131500.txt”)

Optional Extensions:

If necessary, any or all of the following fields may also be appended to all of the records in a given batch sales file. Please contact support@avantlink.com before pursuing these options, for more details.

Column Type Description
Exclusive Coupon Code string Exclusive coupons are assigned to individual affiliates and can be used to uniquely identify which affiliate should get credit for a coupon-sale. Exclusive coupon codes will take precedence over any other tracking information as specified in the “A Data” field.
Affiliate Sale Commission float The total affiliate commission for this overall order (not per-item); dollar amount or percent, as specified in Merchant program terms. Should not be combined with other AvantLink item-based commission solutions. You must contact Support before using using this option, as it must be enabled on our end.
Network Sale Commission float The total network commission for this overall order (not per-item); dollar amount or percent, as specified in Merchant program terms. Should not be combined with other AvantLink item-based commission solutions.
Billing State string The U.S. state associated with the order’s billing address; preferably the standard (e.g. U.S. Postal Service) 2-letter abbreviation for the state.
Billing Country string The country associated with the order’s billing address; preferably the 2- or 3-letter ISO 3166 country code.
Custom Tracking Code string The custom tracking code passed by the affiliate who referred the customer.
New Customer string The value should be 'Y' (for a new customer), and 'N' (for an existing customer).
Have more questions? Submit a request
Powered by Zendesk