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 |
|
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
orFa
in the column "First name" and the relevantcompany'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-7 columns)
Source order number | Currency | Amount | First name | Last name | Number | Customer statement [3] |
---|---|---|---|---|---|---|
1234567 |
EUR |
102,15 |
Max |
Mustermann |
17 |
|
7654321 |
EUR |
42,23 |
Lisa |
Kaufrausch |
18 |
ONr.18 recur |
Refunds (3-4 columns)
Currency | Amount | Number | Customer statement [4] |
---|---|---|---|
EUR |
1 |
12345 |
|
EUR |
35 |
54321 |
ONr.54321 refund |
SEPA Direct Debit, minimum (8 columns)
IBAN | BIC [5] | Currency | Amount | First name | Last name | Number | Customer statement [6] |
---|---|---|---|---|---|---|---|
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 [7] |
---|---|---|---|---|---|---|---|---|---|---|---|
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 [8] | Order number [9] | Authcode [10] | 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 [11] | Order number [12] | Authcode [13] | 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 |