I have a problem. I need to do some updates for a client and the website use Woocommerce, the hosting platform is Siteground. Someone told me that I need to use stages for updates/ development. But I don't know how to manage the situation because I have an example..
I'm making the stage using the Siteground tools, and now I have a copy of the entire shop. I'm working on updates for 5 days for example. After this 5 days, everything looks great and I want to do "Push to live" but surprise, in this time the production got another 50 orders. What can I do to not override this orders, new users, etc.
I know that I can use the the Advanced Push and to check the tables that I want to update, but we all know how wordpress works, that all the things are actually stored in wp_posts. How to deal with that?
A strange thing is that I've made the stage and right after I've checked if are some updates to do using Advanced Push and got to do update for this tables
wp_termmeta
wp_redirection_logs
wp_posts
wp_redirection_404
wp_term_relationships
wp_terms
wp_commentmeta
wp_options
wp_comments
wp_users
wp_redirection_items
wp_term_taxonomy
wp_usermeta
wpk_postmeta