- 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.
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: |
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:
|Merchant ID||integer||The Merchant ID supplied by AvantLink (Required).|
|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. (Required)|
|Transaction ID||string||The sale transaction ID from your e-commerce system. (Required)|
|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). (Required)|
|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”)
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 email@example.com before pursuing these options, for more details.
|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).|