Problem: The client is importing real estate properties daily from Bitrix into WordPress using WP All Import, with the main import language being English. The properties should automatically translate into Arabic, Chinese, and Russian. However, issues include some English properties not translating into all languages, some translations remaining incomplete, and when properties are deleted from the English import, their translated versions and associated images are not deleted properly. Solution: 1. Navigate to All Import -> Manage Imports in your WordPress admin. 2. Click Edit on your property import. 3. In Step 4 (Configure Advanced Settings), change the deletion setting to Delete posts that are missing from this import and were created by a previous run of this import. 4. Ensure the option Also delete Attachments is unchecked to prevent media deletion issues. 5. Save your import configuration. 6. After the next import run, verify if the translated versions and their images are also properly removed. 7. To ensure automatic deletion of translations, go to WPML > Settings, scroll to Posts and pages synchronization, and enable When deleting a post, delete translations as well.
If this solution does not resolve your issue, or if it seems outdated or irrelevant to your specific case, we recommend opening a new support ticket. We also 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. For further assistance, please visit our support forum at https://wpml.org/forums/.
Problem: You are facing an issue where Arabic, Chinese, and Russian property lists show more properties than the English list due to orphan translated properties that are not properly connected to the English originals. Solution: We recommend two methods to address this issue: 1. Manual Cleanup: - Navigate to your Properties list in the Houzez post type. - Switch to a secondary language (Arabic, Chinese, or Russian). - Identify orphan properties indicated by a + icon, which means they are not connected to any original English post. - Select these orphan properties in bulk and move them to trash. This method is safest, especially if the number of orphans is manageable. 2. Database Cleanup: (Ensure you have a full database backup and preferably test on a staging site first) - Use the following SQL query to identify orphan translated properties:
SELECT p.ID, p.post_title, p.post_status, t.language_code, t.trid FROM wp_posts p INNER JOIN wp_icl_translations t ON p.ID = t.element_id WHERE p.post_type = 'property' AND t.element_type = 'post_property' AND t.language_code IN ('ar', 'zh', 'ru') AND NOT EXISTS ( SELECT 1 FROM wp_icl_translations original INNER JOIN wp_posts op ON op.ID = original.element_id WHERE original.trid = t.trid AND original.language_code = 'en' AND original.element_type = 'post_property' AND op.post_type = 'property' AND op.post_status NOT IN ('trash', 'auto-draft') );
- If the results are correct, proceed to delete the orphan properties with this SQL command:
DELETE p FROM wp_posts p INNER JOIN wp_icl_translations t ON p.ID = t.element_id WHERE p.post_type = 'property' AND t.element_type = 'post_property' AND t.language_code IN ('ar', 'zh', 'ru') AND NOT EXISTS ( SELECT 1 FROM wp_icl_translations original INNER JOIN wp_posts op ON op.ID = original.element_id WHERE original.trid = t.trid AND original.language_code = 'en' AND original.element_type = 'post_property' AND op.post_type = 'property' AND op.post_status NOT IN ('trash', 'auto-draft') );
If these solutions do not resolve your issue or seem outdated, 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 the problem persists, please open a new support ticket at WPML support forum.
Problem: You are experiencing issues because WPML is not automatically translating all pages as expected. Solution: We recommend following the steps described in the video to automatically translate the content on your site. You can watch the video here: https://youtu.be/k5Qhmhp31jk
If this solution does not resolve your issue, or if it seems outdated or irrelevant to your case, please open a new support ticket. We also 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. For further assistance, you can contact us directly through our support forum at https://wpml.org/forums/forum/english-support/.
