Feature request: Pull missing translations from another translation

You might want to take a look at https://www.ads-software.com/plugins/gp-translation-propagation/, it may do what you want.

Thank you!

Hm, is there any documentation on how that plugin works?

Just what’s there or on the GitHub page, it’s still in development.

Unfortunately the scripts don’t do what I want. The are for propagation across projects. I’d like to propagate from one translation to another within the same project.

Here is a golden bullet SQL query that does the mentioned trick:

INSERT INTO wp_gp_translations (original_id,translation_set_id,translation_0,user_id,status,date_added)
SELECT u.original_id,<dest>,u.translation_0,u.user_id,'fuzzy',NOW()
FROM wp_gp_originals o
INNER JOIN wp_gp_translations u ON u.original_id=o.id
WHERE o.status IN ('+active') AND project_id=2 AND o.id NOT IN (
SELECT original_id
FROM wp_gp_translations t
WHERE translation_set_id=<dest> AND (t.status='current' or t.status='fuzzy')) AND u.translation_set_id=<src> AND u.status='current'

Replace <dest> with your destination translation ID, and <src> with your source translation ID.
All copied translations are marked as fuzzy. Translation will not be copied if there is a fuzzy translation already.

This may come up again when we tackle variants (https://github.com/GlotPress/GlotPress-WP/issues/226) but for the time being it would have to be handled through a plugin.