QFILE Checkout Automated

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.

Image

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