Official Staging to Live procedure

  • Resolved HAYWOOD Digital Tools

    (@haywoodtools)


    9 months ago

    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:

    1. 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?
    2. 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?
    3. 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?
    4. Or is there a third better way?
    5. 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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Krystian from Syde

    (@inpsydekrystian)

    Hello @haywoodtools

    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?

    Plugin’s configuration, including both live and sandbox credentials, is stored within the woocommerce-ppcp-settings option in the wp_options table. If your staging environment is set to sandbox mode and your production environment is using live credentials, both sets of credentials are maintained separately within this single option. This design means that when you push updates from staging to production, the plugin settings will migrate as part of the wp_options table. I don’t see the need to exclude anything from the plugin point of view.

    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?

    The key step is to verify that the live PayPal account is correctly connected and active. You should also Resubscribe and Simulate the webhooks from the Connection tab within the plugin’s settings.

    Kind regards,
    Krystian

    Thread Starter HAYWOOD Digital Tools

    (@haywoodtools)

    Hi Krystian, thanks for the quick answer. And it sounds good to me: paypal live works well on production. So after pushing staging I will double check if it still is connected and then resubscribe and simulate the webhooks on the connection tab as you said. Thanks a lot!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Official Staging to Live procedure’ is closed to new replies.