QFILE Checkout Automated :: QENTA Online Guides

QFILE Checkout Automated

QFILE Checkout Automated is intended for your non real-time critical applications such as catalog orders and subscriptions. The payment details of your consumers are prepared in tabular format, uploaded and automatically processed.

Demo access for testing purposes.

Uploading payment details

First, you need to create a transaction file that includes all your necessary payment data. If you use an xls file you must convert the file into a tab-delimited text file as you can see in the example below, since otherwise the transactions will not be uploaded.

After successful login, QFILE Checkout Automated opens and you may select and upload the relevant file which is then automatically processed.

Example of an xls file to upload in QFILE Checkout Automated: request example.

Defining the file format

The max. number of uploaded transactions must not exceed 3000 transactions per file, the max. file size must not exceed 2 MB.
Before uploading the file remember to convert the xls file into a tab-delimited text file since otherwise the transactions are not recognized and not uploaded.
If your consumer is a company instead of a private person, enter Firma or Fa in the column "First name" and the relevant company’s name in the column "Last name".

You must not use special character “ ' “ e.g. “Sarah O’Brian” otherwise all transactions in the file can’t be processed.

Use the following format for uploading the payment details of your customers and remember that the number of headers must correspond exactly to the number of columns.

Table 1. Credit Card (8-9 columns)
Credit card number	Expiration date	CVC	Currency	Amount	First name	Last name	Number	Customer statement
`9500000000000001`	12/2022	Has to be empty.	EUR	109,91	Max	Mustermann	12345
`9400000000000003`	05/2023	Has to be empty.	USD	44,60	Ingrid	Wantsall	263547
`9200000000000007`	04/2021	Has to be empty.	GBP	22,75	Sue	Shoppingmaster	2534
`9500000000000002`	12/2023	Has to be empty.	EUR	42,23	Lisa	Kaufrausch	54321	ONr.54321 payment

Table 2. Recurring Transactions (6-8 columns)
Source order number	Currency	Amount	First name	Last name	Number	Customer statement	Merchant CRM ID
`1234567`	EUR	112,15	Max	Mustermann	17
`7654321`	EUR	223,23	Lisa	Kaufrausch	18	ONr.18 recur
`7654000`	EUR	334,23	Sasha	Treukund	19	ONr.19 recur	253-651-abc-234

Merchant CRM ID should have only 40 characters.

Table 3. Refunds (3-4 columns)
Currency	Amount	Number	Customer statement
EUR	1	12345
EUR	35	54321	ONr.54321 refund

Table 4. SEPA Direct Debit, minimum (8 columns)
IBAN	BIC	Currency	Amount	First name	Last name	Number	Customer statement
DE42512308000000060004		EUR	123,34	Max	Mustermann	21

Table 5. SEPA Direct Debit, full (12 columns)
IBAN	BIC	MandateId	MandateSignatureDate	CreatorId
`DE42512308000000060004`		`Abo-12345`	`01.02.2021`	`AT12ZZZ00000000001`

Table 6. SEPA Direct Debit, full (12 columns)
Due date	Currency	Amount	First name	Last name	Number	Customer statement
13.02.2021	EUR	12,34	Max	Mustermann	42	My Statement 2

Value for the column "BIC" for SEPA Direct Debit is optional.

Downloading the result

After uploading the payment details of your customers, the file is processed and the transactions can be downloaded as a tab-delimited text file which you may convert back into an xls file.

The format is representing the returned transactions and the number of headers must correspond exactly to the number of columns.

Table 7. Credit Card (9 columns)
Credit card number	Currency	Amount	First name	Last name	Number	Order number	Authcode	Message
`9500000000000001`	EUR	109,91	Max	Mustermann	12345	12345	DEMO	Payment OK
`9400000000000003`	USD	44,6	Ingrid	Wantsall	263547	263547	DEMO	Payment OK
`9200000000000007`	GBP	22,75	Sue	Shoppingmaster	2534	2534	DEMO	Payment OK

Table 8. Credit Card with customer statement (10 columns)
Credit card number	Currency	Amount	First name	Last name	Customer statement	Number	Order number	Authcode	Message
`9500000000000002`	EUR	42,23	Lisa	Kaufrausch	ONr.54321 payment	54321	54321	DEMO	Payment OK

Table 9. SEPA Direct Debit, minimum (11 columns)
IBAN	BIC	Currency	Amount	First name	Last name
DE42512308000000060004		EUR	123,34	Max	Mustermann

Table 10. SEPA Direct Debit, minimum (11 columns)
Number	Customer statement	Order number	Authcode	Message
21	My statement 1	21	DEMO	Payment OK

Table 11. SEPA Direct Debit, full (15 columns)
IBAN	BIC	MandateId	Mandate signature date	Creditor Id	Due date
`DE42512308000000060004`		`Abo-12345`	`01.02.2014`	`AT12ZZZ00000000001`	13.02.2014

Table 12. SEPA Direct Debit, full (15 columns)
Currency	Amount	First name	Last name	Number	Customer statement	Order number	Authcode	Message
EUR	12,35	Max	Mustermann	42	My statement 2	0	DEMO	Payment OK

Value for the column "BIC" for SEPA Direct Debit is optional.

Table 13. Recurring transactions (6 columns)
Source order number	Currency	Amount	Order number	Authcode	Message
1234567	EUR	102,15	17	DEMO	Payment OK

Table 14. Recurring transactions with customer statement (7 columns)
Source order number	Currency	Amount	Customer statement	Order number	Authcode	Message
7654321	EUR	42,23	ONr.18 recur	18	DEMO	Payment OK

Table 15. Refund (4 columns)
Currency	Amount	Order number	Message
EUR	1	`123445`	Credit note OK

Table 16. Refund with customer statement (5 columns)
Currency	Amount	Customer statement	Order number	Message
EUR	35	ONr.54321 refund	`54321`	Credit note OK