With pixi* you can import PayPal payments by using the PayPal live import. But before you can do this, you have to set the PayPal API access data in pixi* Control Center. You can also export a CSV file from your PayPal Account and import it into pixi* by using the bank file import.
SSL/TLS 1.2 Certificate Change 2015/2016
The desktop pixi* Payments application uses the PayPal API to import payments through PayPal Live. That works over SSL (Secure Sockets Layer). PayPal decided to upgrade security features of their side of SSL in 2015 and 2016. This includes upgrading SHA-1 to the more robust SHA-256 algorithm.
To be able to use the PayPal-Live-Import also after the last change took effect (17 June 2016), your database need to be updated to at least pixi* LOU Update 40 Hotfix 1, AVA Update 6 Hotfix 4 or AVA Update 17. Please use the full installer of each update to install all pixi* applications and in case of AVA Update 6 Hotfix 4 use the auto update.
Furthermore, in case you didn't check this after the first security upgrade at the end of 2015, it is necessary to check, whether your computer fulfills the requirements. Because of this, please follow these steps to make sure, that your computer is prepared for the change. If you need help, please ask your system administrator.
Run the Microsoft Management Console by searching for and starting mmc.exe
Choose menu File > "Add/Remove Snap-In" or press Ctrl-M
Find "Certificates" Snap-In and add it. When asked, what kind of storage you want the Snap-In to display, choose "Computer Account"
Go to Certificates\Trusted Root Certification Authorities\Certificates
Examine the list on the right. It should contain the "VeriSign Class 3 Public Primary Certification Authority - G5" certificate
You can find more information here: 2015-2016 SSL Certificate Change Microsite
Check this article in case of problems: FAQ - pixi Payments (German)
PayPal live import
Set PayPal API access data
You can find the API signature after logging in to your PayPal account here: https://www.paypal.com/en/cgi-bin/webscr?cmd=_profile-api-signature
API access parameters can be set in pixi* Control Center > Database Settings tab > Payments folder > Import folder:
PayPal Live Endpoint (URL: https://api-3t.paypal.com/nvp)
PayPal Live Password
PayPal Live Signature
PayPal Live User Name
How to import PayPal payments
To be able to import PayPal payments into pixi* and to use them for releasing customer orders, follow these steps:
Open pixi* Payments application.
On Payment Matching tab, click Import to start Bank Import Wizard.
Select PayPal live import option. Click Next.
Choose date and time range (From – To) for importing PayPal transactions. If the same date range is used more than once, the same payments can be downloaded. These payments can be imported again to pixi* but do not overwrite existing payments.
Recommendation: Perform imports regularly and import data for the last couple of hours (Set From date to few hours ago and leave To date on current time). It takes some time for PayPal system to process the transactions so you might not get any data to import if you set the From date to less than an hour ago.Select the checkbox Import more than 100 records, if you want to import more than 100 records. When this option is not active, the wizard will show a message, that the number of PayPal payments was truncated. To import all available payments, please re-adjust the time range
You can also get more information about the used parameters and the result by clicking on Show import details.Click Get Transaction to connect to PayPal and start downloading transactions. Only payments in status “Completed” will be imported to pixi*. Currency is imported with each payment.
Click Next to start importing downloaded transactions.
After the import process is done, the import log is displayed. You can use right-click menu to save, copy or clear the log.
Info: You can directly refund PayPal payments from pixi* Customer Account if the payments were imported using the PayPal Live Import.
FAQ/Troubleshooting
PayPal Payments cannot be imported
Error "-1"
If you get an error „-1“ when trying to do the import, it is most likely connected to a temporary unavailability of the PayPal API. In this case, please try the import again a few minutes later. Also check, whether all necessary DLL files such as libeay32.dll and ssleay32.dll are located in C:\pixi\
Status "Processing" for a long Period
If this status is shown for a longer period of time it indicates that there are no payments to import. Define a bigger time period in this case and try importing payments again.
Import failed
In case the import failed it can be that a wrong decimal separator is configured in Windows itself. Change the separator from dot (.) to comma (,) and try importing payments again.