[Resolved] Orphan translated properties not deleting after WP All Import

Hi there!

This is Paola and I hope you are well!

In this case, there are two safe ways to proceed: a manual cleanup and a database cleanup.

1. Manual method (safe and recommended first):

You can identify orphan translations directly from the Properties list:

Go to your Properties (Houzez post type).
Switch to a secondary language (Arabic, Chinese, or Russian).
Check the language icons:
+ plus icon → this means the property is not connected to any original English post (orphan)
pencil icon → this is a valid translation

The properties showing the + icon are the orphan ones.

You can:
- Select them in bulk
- Move them to trash

This is the safest way, especially if the number is manageable.

2. Database method (please make sure to create a full database backup and ideally test this on a staging site first)
- Review 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')
  );

This will show all translated properties that do not have a valid English original.

- Delete orphan translated properties

If the results above look correct, you can proceed with:

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')
  );

Are they now showing the same number of properties? Please let me know if you still see any orphan properties.

I can see that my colleague Carlos has already taken care of that ticket.

Since this is a different issue, please continue the conversation there so everything stays in the same thread.

If the original problem has already been resolved, you can also mark this ticket as resolved.