File upload
You can submit transactions in a variety of ways. The first option is by using various gateways: JSON, HTML, NVP & SOAP. The second option is to submit transactions via batch.
By using the Upload file feature, you can execute multiple transactions simultaneously. In doing so, keep in mind that there is no customer interaction, which means an iDEAL payment is not possible.
File upload via the Plaza
If your user account has the necessary permissions, you can upload a file by following the steps below.
1. Click on Execute > File Upload
2. In the top-right corner, click on Actions > Upload new batch.
3. Place your file (.CSV) in the file drop screen and select the correct settings on the right.
a. Submit file as a test: If you wish to run a compliance test
b. Is a refund batch: Check this box if you're uploading a Refund batch.
(See Refund.csv below for an example. A refund file does not have any service or action parameters.)
c. Website dropdown: Select one of your websites, unless the key/keys are already included in the .csv file.
4. Click on Upload file and wait for approval.
If a file is submitted successfully, the applicant will receive an email containing an approval code. This code must be entered in order to start processing the file.
Status
If an error has occurred while uploading the file, the status will change to The batch failed. There can be various reasons for the batch to fail. For example because a specific value is missing or is incorrect. Below you’ll find some suggestions for the processing of the file.
- The currency is usually euro, the value is EUR. For the American dollar, this is USD.
- You can find the Website key of a website via Settings > Websites
- With regards to Amount, make sure the figures are seperated with a decimal point instead of a comma.
- Culture refers to the language used. Read more about it here.
- The file has to be submitted in .csv format, not in .xls or other format.
- For certain keys (such as gender, service and action), there are a number of specific values. For more information, refer to the API docs.
- You can never submit the exact same file more than once: if you’re testing something or if an error occurs and you want to submit the file again, make sure the title and content of the file are not identical to the file submitted previously. If you do submit a file that is identical, you will receive an error message.
If everything is processed correctly, the status will change to Batch waiting for merchant verification. After the uploading, the (logged in) user will receive an email containing a confirmation code. Open the batch details in the Plaza, and use the Verify batch button to enter the security code.
Batch features
Click on the specific batch for batch details. You’ll find more information in the Details column.
Submitted: Time and date the file was submitted
Number of lines: Number of lines in the csv used for the batch
Debit amount: Total debit amount in batch (for example receivables)
Credit amount: Total credit amount (for example refunds)
File name: Name of the uploaded file
File type: CSV (can be opened with Microsoft Excel)
Source: Usually Plaza, but sFTP is another option
Processed batch
Once a batch has been processed and approved, you can click on it to see the results.
- Original file: The submitted file.
- Validation results: This file describes per line in the submitted file whether it could be uploaded to the Plaza or not. If everything went according to plan, this is stated in this file. If an error occurred, this is also stated in this file. It is specified what exactly went wrong, so you can make adjustments accordingly.
- Processing results: An overview of batch lines and the status/details of the created transactions (e.g. TransactionKey, Status, ErrorMessage)
Multi-level authorisation
It is possible to set up approval settings. This enables you to use the four eyes principle in order to prevent possible mistakes. You can find more information on multi-level authorization under Approval settings.
Sample files
Below, you’ll find various sample files, including a brief explanation of the content of a specific entry field.
iDEAL QR
SEPA Direct Debit transactions
Sepadirectdebit payrecurrent.csv
SepaDirectDebit with mandatereference.csv
SepaDirectDebit with BCM minimal.csv
SepaDirectDebit with BCM extended.csv
Transfer
Transfer with BCM extended.csv
PayPerEmail
PayPerEmail with BCM minimal.csv
PayPerEmail with BCM extended.csv
Buckaroo Credit Management
BCM CreateInvoice extended.csv
BCM CreateInvoice extended B2B.csv
Subscription
CreateSubscription PayperEmail.csv
CreateSubscription with IBAN.csv
UpdateSubscription price update.csv
Other
Diacritics
Diacritics are signs written above or below a letter. The diacritical mark above or beneath the letter indicates a difference in pronunciation from the same letter when unmarked or differently marked. An example of a diacritic is the sign above the ‘a’ in the word Fryslân (the Dutch province Frisia). In order to be able to process these signs, Buckaroo uses the UTF-8 encoding. In the various gateways, the UTF-8 encoding is enforced. The UTF-8 encoding also has to be enforced when files are submitted. You should therefore ensure that the text editor you’re using saves the text as UTF-8 encoded. Different encoding will be filtered out by Buckaroo and replaced by the question mark (?) in order to enable further data processing. Please pay special attention when diacritics are used in the customer name, street names or other data.