eWAY API

Example batch files

We have an example CSV file for download in zip format. This file contains test data only and will fail to upload. The purpose of this document is to show the format only.

We also have an example Excel file for download in the correct XLS format.  This file contains test data only and will fail to upload. The purpose of this document is to show the headings required for the Excel Batch file to upload and process correctly.  The order of the headings is not important and only the required field headings are mandatory - any extra fields (including your own) can be included ot omitted as required. 

To use the eWAY Batch Processor you must login to eWAY and then upload a request file via the secure eWAY Merchant Administration Area.  You can then select to upload either a CSV batch file or an Excel (XLS) batch file. 

Rules for Excel batch files:

1. The Excel batch file MUST be formatted as a XLS file.
2. The Excel batch file must contain the header labels as shown in the example file. 
3. eWAY will NOT accept the XLS file until it is 100% correct.
4. Required fields type must be in "TEXT" field format.  
5. Each horizontal row is ONE record and will be processed as a single transaction.
6. All required fields are MANDATORY. If you do NOT enter a value for these fields the transaction cannot be processed.
7. The eWAY batch is run between 3 - 7am each morning, on the day following submittal of the job. This can NOT be changed. You can remove a batch job at anytime before the batch is started.

1. The CSV batch file MUST be formatted as a CSV file. We recommend you use MS Notepad and save as ".CSV".
2. eWAY will NOT accept the CSV file until it is 100% correct.
3. The CSV batch file must NOT contain any header information - only data is allowed.
4. The order of the fields must be EXACTLY as documented below. 
5. Each horizontal row is ONE record and will be processed as a single transaction.
6. All fields are REQUIRED. If you do NOT want to enter a value for a field, you must enter "N/A".
7. The eWAY batch is run between 3 - 7am each morning, on the day following submittal of the job. This can NOT be changed. You can remove a batch job at anytime before the batch is started.

CSV Batch record field order

The correct order. All data MUST be passed in this order. If there is no data then pass "N/A"

1. eWAYTotalAmount
2. eWAYCustomerFirstName
3. eWAYCustomerLastName
4. eWAYCustomerEmail
5. eWAYCustomerAddress
6. eWAYCustomerPostCode
7. eWAYCustomerInvoiceRef
8. eWAYCustomerInvoiceDescription
9. eWAYCardHoldersName
10. eWAYCardNumber
11. eWAYCardExpiryMonth
12. eWAYCardExpiryYear
13. eWAYTrxnNumber
14. eWAYTrxnOption1
15. eWAYTrxnOption2
16. eWAYTrxnOption3

Correct CSV batch file record

100,Joe,Bloggs,matt@webactive.com.au,18 Test St Sydney,2000,1234,red socks,Joe Bloggs,4520021000407209,00,03,N/A,N/A,N/A,N/A