Staging Sites: expand options to sync Production > Staging

[liviopv]

What

We should allow for partial Production > Staging syncs as we offer when syncing in the other direction.

Why

One use-case is when the user started building a new version in staging, but kept publishing content in production. If they want to see their content in staging, they need to move it manually via XML.

Feedback from 8182390-zd-a8c

They run a newspaper and are redesigning it on a staging site but they needed to sync their posts before posting the new design. This can be done manually by exporting an XML file from the live site and reimporting it on the staging site but it is not intuitive or convenient. Could we enhance our Staging site by offering a ""Sync Pages, Posts, Commentst & Media"" option?"

How

Expand Production > Stating options to look similar to this:

[github-actions[bot]]

Support References

This comment is automatically generated. Please do not edit it.

• [ ] 8182390-zen

[mgozdis]

+1 for allowing syncing by post_type and more advanced options to choose specific tables. This is a feature we really need here as staging sites with Woo installed can't sync the database at all. Many interactions I've had, the users didn't want to sync any Woo data and leave it immutable. They wanted to sync theme/plugin settings and other content stored in the database but can't. Most of the time they don't find this out until ready to sync the site.

WP Engine allows selecting specific tables: https://wpengine.com/support/copy-site/