On WordPress Woocommerce PayPal Checkout plugin 1- FIRST problem everyone will encounter: When entering a valid certificate from Paypal, you will have a error saying “the API certificate is not valid” You try to re-upload. renew and try again to From there you will spend time try to see what wrong. So then you will want to go for the SIGNATURE instead of the CERTIFICATE. Which leads to the seconds problem 2- SECOND problem everyone will encounter: You now generate on Paypal your signature API and enter the signature in the plugin and do not select any certificate as you need one method or the other. You save and… even though you will put a signature you and NO CERTIFICATE then you still end up with the error: “API certificate is not valid” 3- Now how to fix it? The problem is the certificate is saved in the database and not erased when you put a signature. Stupid bug right? So go to your mysql phpmyadmin (or directly download your SQL DB and work from there if you know what you do), then 1- search for TABLE wp_options 2- locate the woocommerce_ppec_paypal_settings value 3- locate the characters that starts and ends like that: …s:15:\”api_certificate\”;s:4552:\”LS0tificate\”;s:4552:\”LS0tLS1CRUdJTiBQUklWQVRFIS1CRUdJTiBQUklWQV…………………….S1CRUdJTiBQUklWQVEtFWBDRVJUSUZJQ0FURS0tLS0tCg==\”;s:11:\”api_subject\”;s:0:\”\”;s:20:\”sandbox_api_username\… 4- remove everything that is between s:15:\”api_certificate\”;s:4552:\”LS0tificate\”;s:4552:\” and “;s:11:\”api_subject\”;s: that is you delete the key: …s:15:\”api_certificate\”;s:4552:\”LS0tificate\”;s:4552:\”LS0tLS1CRUdJTiBQUklWQVRFIS1CRUdJTiBQUklWQV…………………….S1CRUdJTiBQUklWQVEtFWBDRVJUSUZJQ0FURS0tLS0tCg==\“;s:11:\”api_subject\”;s:0:\”\”;s:20:\”sandbox_api_username\… 5- you end up with …s:15:\”api_certificate\”;s:4552:\”LS0tificate\”;s:4552:\””;s:11:\”api_subject\”;s:0:\”\”;s:20:\”sandbox_api_username\… 6- save your line (note you may receive a syntax error and will fix by itself) 7- go to Worpress Paypal login; put your SIGNATURE; save your page; NO MORE ERRORS and you are done Hope it helps
... View more