So, after literally weeks going round and round with PayPal, it has been finally admitted that you can't easily (deliberately) use a single PayPal account to handle multiple stores. The "PayPal Payments Standard" became "PayPal Pro", which became "PayPal Express", which became "PayPal E-Commerce Platform", which is now "PayPal Checkout Integration". All of the older methods still work, and all of them except PayPal Payments Standard prohibit you from "CONNECTING" more than one website to their API.
So, if you have 10 different sites as a corporation and want to use a single corporate PayPal account, you can't. PayPal wants every single site to have an individual business license and federal tax ID, even if those are simple sub-companies or DBA's. However, you can still use the dumbed down PayPal Payments Standard, which just uses the PayPal email address for processing the payment. You have no ability to do nice things like have buttons and such controlled by PayPal, split payments, etc.
After some real bitching on this subject with Paypal I was informed by their division that handles the API side of PayPal that it is possible, but a secret. The secret apparently is to "use the API credentials of your existing PayPal account to link your second website, So that payments processed on second website will be credited to your existing PayPal account". That's all they would say... I have the credential info, that is readily available on the PayPal developer site. The question I have is WHERE is that data stored on the Opencart side? I did a search in the database for the token being used on my main website (which has great PayPal integration), but I could not find any reference to PayPal data. I guess it could be encrypted. I don't know the database side of Opencart ( 3.0.3.8 ) well enough to just parse through it and know exactly what everything is
Does anyone know where this information is stored after the connection is successful with PayPal the first time?
Thanks!
Sounds about right for PayPal.
In the oc_setting table, look for keys payment_paypal_client_id, payment_paypal_secret, payment_paypal_merchant_id and possibly payment_paypal_webhook_id.
In the oc_setting table, look for keys payment_paypal_client_id, payment_paypal_secret, payment_paypal_merchant_id and possibly payment_paypal_webhook_id.
Check out Viva Wallet instead.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Guru Member
Thanks! I will look for these entries in the working database and copy them into the other store to see if that really does work.ADD Creative wrote: ↑Mon May 29, 2023 8:38 pmSounds about right for PayPal.
In the oc_setting table, look for keys payment_paypal_client_id, payment_paypal_secret, payment_paypal_merchant_id and possibly payment_paypal_webhook_id.
I just wanted to confirm that what the API folks at PayPal told me is true... the secret is to use the exact same credentials in your database for each website. I just exported ALL of the relevant PayPal database entries from oc_Settings to a file from our main store, and then imported that into the database of the other store. Everything worked instantly.
Thank you for pointing out what database entries were needed!
Thank you for pointing out what database entries were needed!
Who is online
Users browsing this forum: Google [Bot], niagato, Semrush [Bot] and 649 guests