Hi, we have installed a new theme for our website in our staging environment. When we try to import the products and data into the live environment, everything crashes.
Can you tell us what we are doing wrong and what the solution is?
I can share the credentials.
1. Staging status: The staging site is currently restored to the last stable backup. No further syncing or imports are being performed there to avoid any additional risk or data loss.
2. What was done so far:
I tested database syncing and restoration under different conditions (with WPML active and inactive) to identify where the conflict occurs. The issue appears when a full database restore/sync is involved while WPML is active, which results in removal or mismatch of theme-created pages and content.
3. Product import issue:
The import attempt on staging caused a site crash due to WPML-related database conflicts during the process (tables and translations not syncing correctly). After this, the staging site had to be restored from backup to return it to a stable state.
Maybe it helps when i give you access to our website?
We did a lot of things to import but as soon as we import the records the whole website stops working.
I would really appreciate it if you could log in and see what's going wrong.
Can I share the login details?
1. A short screencast showing the exact import steps you are following.
2. The full error message or screenshot when the site stops working.
This will help me understand the failure point more quickly.
- You can also share the login details if you prefer, and I’ll review the setup directly.
=== Please backup your database and website ===
✙ I would need your permission to deactivate and reactivate Plugins and the Theme and to change configurations on the site. This is also a reason the backup is essential.
Thank you for providing the login details. I checked the WPML settings and they seem fine. I also reviewed a few products in all languages, and they look correct at the moment.
To investigate the crash, I still need a bit more information:
1. A screenshot of the exact error message when the site stops working.
2. The backend/frontend page URL where the issue occurs.
3. The exact steps you follow to run the import, you may record a short video of the procedure using loom: hidden link
Without these details, it’s difficult to reproduce the issue on our side. Once you share them, I’ll continue checking.
Hi, i am not the one who test it several times. So i cant help you with the info. All i know is what i allready shared. Can you please try it yourself by exporting from our live enviroment and import it in the shared link? Thank so much for your help in this
Thank you for the clarification. I’m not able to run export/import operations on your live site without knowing the exact workflow being tested, as this could affect production data.
To properly test this, please ask the person who is performing the WooCommerce products import to try the official WPML supported method below:
1. Please make sure WooCommerce, WCML, WPML core, and the WPML Import & Export add-on are active on both sites.
2. For exporting products from live site:
- Go to Products >> All Products.
- Switch to All languages using the admin language switcher.
- Click Export and generate the CSV.
3. For Importing products on dev site:
- Go back to Products >> All Products and import that CSV file.
- Then go to WPML >> Export and Import and click Run WPML Import.
