Pushing changes from staging to live site

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client created a staging environment to translate their site and now wants to push these translations to the live site without overwriting new products and orders that were added to the live site after the staging environment was set up.
Solution:
We recommend using a migration plugin like Duplicator to ensure all translations are transferred correctly from the staging to the live environment. To specifically migrate only the translations without affecting the new products and orders on the live site, you can use the WPML Export Import add-on.
If you need to update translations for specific pages or products without affecting existing data, consider exporting your default language product and its translations, then re-importing them. However, be cautious as this might impact current orders. Alternatively, if using WPML's automatic translation, you could leverage the translation memory to avoid retranslation costs and ensure translations are preloaded.

Please note that this solution might be outdated or not applicable to your specific case. We highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If this does not resolve your issue, please open a new support ticket.

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Tagged: Documentation request

This topic contains 3 replies, has 1 voice.

Last updated by Dražen 2 weeks, 5 days ago.

Assisted by: Dražen.

Author	Posts
March 13, 2025 at 3:25 pm #16812680
dawoods	Background of the issue: I made a staging environment on Cloudways a month ago to translate my site. I finished translating it and now I am trying to push the translation to the live site. However, there have been changes on the live site, such as new products and orders. Symptoms: I want to push translations to the live site without overwriting new products and orders. Questions: What files or tables should I push to avoid overwriting new products and orders? How should I deal with this situation to ensure translations are updated without affecting new data?
March 13, 2025 at 10:21 pm #16813920
Mihai Apetrei Supporter Languages: English (English ) Timezone: Europe/Bucharest (GMT+03:00)	Hi there. Before this ticket gets assigned to one of my colleagues, I will try to help. I typically recommend using a plugin like "Duplicator" when migrating from a staging environment to a production environment. This plugin will ensure that everything is transferred correctly, especially since your translations are already saved in the database. If there is data in the staging environment that you do not want to transfer to production—so as not to overwrite existing information—you can utilize the WPML Export Import add-on to migrate only the translations. I hope that you will find this information helpful. Mihai Apetrei
March 14, 2025 at 1:06 pm #16816949
dawoods	I actually tried to use the WPML export import add-on, but I couldn't make it as it was kinda complicated, and I couldn't know what files exactly I should import
March 17, 2025 at 7:56 am #16823225
Dražen Supporter Languages: English (English ) Timezone: Europe/Zagreb (GMT+02:00)	Hello, thanks for getting back. It is not possible to push only translations of specific pages, at least not to of box with WPML, maybe with some custom solutions. The only way would be to export your default language product and translation product, then import both your default language product and translation to your default page, but that might affect your current existing orders for those products. - https://wpml.org/documentation/related-projects/legacy-wpml-all-import/importing-multiple-languages-with-wp-all-import-and-wpml/#:~:text=or%20manually%20created.-,Adding%20Translations%20When%20the%20Default%20Language%20Content%20Already%20Exists%20on%20the%20Site,-Because%20WP%20All Other way, would be to share translation memory if you are using WPML automatic translation and translate your products again, but this time you wont be charged for this and your translation would be preloaded from memory if you have already translated them before this way. - https://wpml.org/documentation/automatic-translation/automatic-translation-subscription-for-multiple-sites/ Regards, Drazen