QFILE Checkout Automated

QFILE Checkout Automated

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

All transactions are available in the QPC Payment Center. Currently we support payments via Credit Card and SEPA Direct Debit, and refund and recurring as back-end operations.

Detailed information in German for using this product: Bedienungsanleitung in Deutsch

Demo access for testing purposes

URL

https://portal.qenta.com/automated/

Username

test

Password

jcv45z

Uploading payment details

First, you need to create a transaction file which includes all your necessary payment data. Remember to meet the format requirements described later in this chapter. If you use an xls-file you need to convert the file into a tab-delimited text file 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 transaction must not exceed 3000 transaction 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".

Please 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 (except for the column for the customer statement, which is optional and can therefore be omitted):

Credit Card (8-9 columns)
Credit card number Expiration date CVC Currency Amount First name Last name Number [1] Customer statement [2]

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

Direct Debit without SEPA (9 columns)
Bank name Bank country Bank code Account number Currency Amount First name Last name Number

Wirecard Demobank

AT

12345

123456

EUR

1

Max

Mustermann

12342

Recurring Transactions (6-8 columns)
Source order number Currency Amount First name Last name Number Customer statement [3] Merchant CRM ID [4]

1234567

EUR

112,15

Max

Mustermann

17

7654321

EUR

223,23

Lisa

Kaufrausch

18

ONr.18 recur

7654000

EUR

Merchant CRM ID should have only 40 characters. Strings longer than 40 characters may be truncated.
Refunds (3-4 columns)
Currency Amount Number Customer statement [5]

EUR

1

12345

EUR

35

54321

ONr.54321 refund

SEPA Direct Debit, minimum (8 columns)
IBAN BIC [6] Currency Amount First name Last name Number Customer statement [7]

DE42512308000000060004

EUR

123,34

Max

Mustermann

21

SEPA Direct Debit, full (12 columns)
IBAN BIC MandateId MandateSignatureDate CreditorId Due date Currency Amount First name Last name Number Customer statement [8]

DE42512308000000060004

WIREDEMMXXX

Abo-12345

01.02.2021

AT12ZZZ00000000001

13.02.2021

EUR

12,34

Max

Mustermann

42

My Statement 2

Downloading the result

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

Example of an xls-file returned from QFILE Checkout Automated: response_wca-example.txt

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

Credit Card (9 columns)

Credit card number Currency Amount First name Last name Number [9] Order number [10] Authcode [11] 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

Credit Card with customer statement (10 columns)

Credit card number Currency Amount First name Last name Customer statement Number [12] Order number [13] Authcode [14] Message

9500000000000002

EUR

42,23

Lisa

Kaufrausch

ONr.54321 payment

54321

54321

DEMO

Payment OK

Direct debit without SEPA (12 columns)

Bank name Bank country Bank code Account number Currency Amount First name Last name Number Order number Authcode Message

Wirecard Demobank

AT

12345

123456

EUR

1

Max

Mustermann

12342

12342

DEMO

Payment OK

SEPA Direct Debit, minimum (11 columns)

IBAN BIC Currency Amount First name Last name Number Customer statement Order number Authcode Message

DE42512308000000060004

WIREDEMMXXX

EUR

123,34

Max

Mustermann

21

My statement 1

21

DEMO

Payment OK

SEPA Direct Debit, full (15 columns)

IBAN BIC Mandate Id Mandate signature date Creditor Id Due date Currency Amount First name Last name Number Customer statement Order number Authcode Message

DE42512308000000060004

WIREDEMMXXX

Abo-12345

01.02.2014

AT12ZZZ00000000001

13.02.2014

EUR

12,34

Max

Mustermann

42

My statement 2

0

DEMO

Payment OK

Recurring transactions (6 columns)

Source order number Currency Amount Order number Authcode Message

1234567

EUR

102,15

17

DEMO

Payment OK

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

Refund (4 columns)

Currency Amount Order number Message

EUR

1

12345

Credit note OK

Refund with customer statement (5 columns)

Currency Amount Customer statement Order number Message

EUR

35

ONr.54321 refund

54321

Credit note OK


1. Number defined by you and transmitted in the file. If the number is set to “0” by you, QENTA will assign a corresponding number.
2. Optional
3. Optional
4. Optional
5. Optional
6. Optional
7. Optional
8. Optional
9. Number defined by you and transmitted in the file. If the number is set to “0” by you, QENTA will assign a corresponding number.
10. Number used by QENTA for processing the file.
11. Authorization code from financial service provider which is automatically returned.
12. Number defined by you and transmitted in the file. If the number is set to “0” by you, QENTA will assign a corresponding number.
13. Number used by QENTA for processing the file.
14. Authorization code from financial service provider which is automatically returned.