I am using WP All Import from property from bitrix with WPML for property listings.
Default language: English
Translations created automatically via WPML
WP All Import is set to delete properties missing from the XML feed
Issue:
When a property is removed from the XML feed, it is deleted only in English. Translated versions (Arabic, Russian, etc.) remain in the database.
I need translations to be deleted automatically when the original post is deleted.
Could you please confirm that you had the option "When deleting a post, delete translations as well" enabled when you imported your content? (in WPML > Settings > Posts and pages synchronization)
I've tried to reproduce your issue locally without success. There are so many options in WP All Import and WP All Export that it's easy to miss an issue that has a limited scope.
Could you please record and share a quick screencast showing the full import process with WP All Import?
Could you please also share your XML feed for the import?
Currently, the properties are still not being imported via WP All Import, and this is seriously affecting our business since our listings depend entirely on this feed.
We kindly ask you to please prioritize this issue and investigate immediately.
We would really appreciate an urgent resolution.
Could you please respond faster or assign me to another support agent? This issue is extremely important to our business, and I’ve been waiting for more than a day without any response, which is very frustrating.
At the moment, all our properties have disappeared from our website. Could you please clarify what has happened and whether any action has been taken on your side?
I would appreciate your urgent response, or kindly transfer me to an agent who can assist more promptly.
I am working on your issue, but the hardest part is to replicate and isolate the problem. Your site is quite big with a number of specific configuration.
First of all, as a curative action, I can help you to delete all existing translated properties that are not attached to an original English one anymore (means the English source has been removed).
To do that, you can run the following SQL request:
DELETE p, pm, t
FROM wp_icl_translations t
LEFT JOIN wp_icl_translations src_t
ON src_t.trid = t.trid
AND src_t.language_code = t.source_language_code
LEFT JOIN wp_posts src_p
ON src_p.ID = src_t.element_id
LEFT JOIN wp_posts p
ON p.ID = t.element_id
LEFT JOIN wp_postmeta pm
ON pm.post_id = t.element_id
WHERE t.element_type = 'post_property'
AND t.language_code <> 'en'
AND t.source_language_code IS NOT NULL
AND src_t.language_code IS NULL
Before running this request, please take a full backup of your site.
If you need help to run this request, let me know and I will apply it on your site.
Once this is fixed, and if you still need help, we can monitor and check if new imports are working as expected or not.
