Hi!
I have a woo shop and use PayPal Payments as the payment gateway. I did copy my complete shop to a staging site by using a subdomain. While in the staging site I set the paypal gateway to sandbox. I am testing different new and updated plugins and change some page and template settings. I am not actually changing the paypal configuration settings but I do a update the paypal plugin while I do not do any plugin updates on the production site.
Now I am planning to push staging to production with a staging plugin like WP staging, which takes care of the general URL search and replace and gives the option to exclude certain database tables or files.
I am working with the HPOS settings in woocommerce, so I know that I just need to exclude these tables to not overwrite new orders and new customers on production:
Orders (No test-buy orders from staging and don’t overwrite new orders in production):
{prefix}_wc_order_addresses
{prefix}_wc_order_operational_data
{prefix}_wc_orders
{prefix}_wc_orders_meta
Users (No test customers from staging and don’t overwrite new customers in production):
{prefix}_usermeta
{prefix}_users
Now my questions are:
- What do I need to exclude or what is the best procedure to get the updated paypal plugin transfered but at the same time not messing with the paypal life config and it´s credential settings?
- Is there a table just for the credential settings that I can exlude to leave the sandbox credentials on staging and keep the live credentials on production working?
- Or will I just have to overwrite it and then reconfigure the live connection on production again by disconnecting the pushed over sandbox and reconnecting the live paypal credentials?
- Or is there a third better way?
- Or are there other things realted to the paypal gateway to take care of when pushing staging to production when production was running during staging phase?
Thanks!
Sascha