Common approach to working locally then pushing to live / WP Options issue

[ad_1]

I’m struggling to find a development setup that suits my situation, wondering what everyone else’s set up is…

I have my live site, with Memberpress set up. The Stripe payment gateway for Memberpress is stored in WP Options. This Stripe Gateay cannot be deleted, or it will cause issues with existing recurring subscriptions.

I would like to work on the site locally then transfer it over to a staging site, then push to live.

However, I cannot connect the Stripe Gateway on my localhost. This isn’t possible with Memberpress. So if I push my local site to live, the Gateway is overwritten and is blank on the live site.

If I change any theme settings during development, these are stored in WP Options, so I can’t just exclude that table from the export.

Whats the standard approach for these kind of situations? WP Options is often changed during development, but if we have API/webhook connection data in there on the live site that can’t be overwritten that makes this impossible to push those changes.

Perhaps someone actually sing Memberpress could let me know their setup for development?

[ad_2]