{"id":36617,"date":"2026-02-09T01:29:50","date_gmt":"2026-02-08T18:29:50","guid":{"rendered":"https:\/\/dps.media\/huong-dan-xoa-ban-dich-translatepress-cho-mot-bai-viet-cu-the-reset-translation\/"},"modified":"2026-02-09T01:29:50","modified_gmt":"2026-02-08T18:29:50","slug":"translationsguide-to-delete-translatepress-translation-for-a-specific-post-reset-translation","status":"publish","type":"post","link":"https:\/\/dps.media\/en\/translationsguide-to-delete-translatepress-translation-for-a-specific-post-reset-translation\/","title":{"rendered":"Guide to Delete TranslatePress Translation for a Specific Post (Reset Translation)"},"content":{"rendered":"

\"Guide<\/p>\n

Issue: Translation is faulty or not updated<\/h2>\n

During the operation of a multilingual website with TranslatePress, sometimes you will encounter cases where the translation is faulty (for example: Chinese is displayed as Vietnamese) or you want to reset the entire translation of a specific post so that the AI translates it again from scratch.<\/p>\n

This post will guide you through 2 ways to completely delete the translation of any post (Post, Page, Product\u2026) without affecting other posts.<\/p>\n

Method 1: Delete using SQL (Most Accurate)<\/h2>\n

This is the safest and most accurate method, helping you thoroughly delete data in the database.<\/p>\n

Step 1: Find the Post ID<\/h3>\n

Access the WordPress admin page, go to the section Posts<\/strong> or Pages<\/strong>. Hover the mouse over the title of the post you want to process, look down at the browser's status bar, you will see the number ID<\/code> (e.g.: post=123<\/code>).<\/p>\n

Step 2: Determine the post code and language table<\/h3>\n
    \n
  • Post ID:<\/strong> For example, it is 123<\/code><\/li>\n
  • Language code to delete:<\/strong> For example, Chinese (China) is usually zh_cn<\/code>, English is en_us<\/code>. The table name in the database will be in the form wp_trp_dictionary_vi_zh_cn<\/code> (if translating from Vietnamese to Chinese).<\/li>\n<\/ul>\n

    Step 3: Run the SQL command<\/h3>\n

    Open phpMyAdmin<\/strong> (or similar database management tool), find the website's database and run the following command:<\/p>\n

    \n-- Replace '123' with your post ID\n-- Replace 'wp_trp_dictionary_vi_zh_cn' with the language table name you want to delete\nDELETE FROM `wp_trp_dictionary_vi_zh_cn` \nWHERE `original_id` IN (\n    SELECT `original_id` \n    FROM `wp_trp_original_meta` \n    WHERE `meta_key` = 'post_parent_id' \n    AND `meta_value` = '123'\n);\n<\/code><\/pre>\n
    After running, the entire translation of that post will be deleted. You just need to go to the homepage and reload the page, the system will automatically translate it anew.<\/p>\n
    \n
    Method 2: Use PHP Code (Quick and Simple)<\/h2>\n
    If you are not familiar with the database or do not want to touch phpMyAdmin, you can use the following small code snippet.<\/p>\n
    Step 1: Add code to functions.php<\/h3>\n
    Open file functions.php<\/code> of the active theme (Appearance -> Theme Editor), and add this code to the end of the file:<\/p>\n
    \nadd_action('init', function() {\n    \/\/ Change the number 123 to the ID of the post you want to delete\n    $TP4Tpost_id_to_clean = 123; \n    \n    \/\/ Change to the language code you want to delete (e.g., vi_zh_cn, vi_en_us)\n    $TP4Tlang_pair = 'vi_zh_cn'; \n    \n    if (isset($_GET['clean_post_id']) && $_GET['clean_post_id'] == $TP4Tpost_id_to_clean) {\n        global $wpdb;\n        $TP4Tmeta_table = $wpdb->prefix . 'trp_original_meta';\n        $TP4Tdict_table = $wpdb->prefix . 'trp_dictionary_' . $TP4Tlang_pair;\n        \n        \/\/ Check if the table exists\n        if ($wpdb->get_var(\"SHOW TABLES LIKE '$TP4Tdict_table'\") != $TP4Tdict_table) {\n            wp_die(\"Table $TP4Tdict_table does not exist. Please check the language code again.\");\n        }\n\n        \/\/ Get the list of string IDs belonging to this post\n        $TP4Toriginal_ids = $wpdb->get_col($wpdb->prepare(\n            \"SELECT original_id FROM $TP4Tmeta_table WHERE meta_key = 'post_parent_id' AND meta_value = %d\",\n            $TP4Tpost_id_to_clean\n        ));\n        \n        if (!empty($TP4Toriginal_ids)) {\n            $TP4Tids_placeholder = implode(',', array_fill(0, count($TP4Toriginal_ids), '%d'));\n            $wpdb->query($wpdb->prepare(\n                \"DELETE FROM $TP4Tdict_table WHERE original_id IN ($TP4Tids_placeholder)\",\n                $TP4Toriginal_ids\n            ));\n            echo \"Successfully deleted translation for post ID: \" . $TP4Tpost_id_to_clean;\n        } else {\n            echo \"No strings found to delete or the post has not been translated yet.\";\n        }\n        exit;\n    }\n});\n<\/code><\/pre>\n
    Step 2: Run the delete command<\/h3>\n
    After saving the file, access the following URL in your browser (log in as admin first):<\/p>\n
    https:\/\/website-cua-ban.com\/?clean_post_id=123<\/code><\/p>\n
    (Remember to replace 123<\/code> with the post ID you entered in the code).<\/p>\n
    Step 3: Delete the code<\/h3>\n
    After seeing the message \u201cSuccessfully deleted translation\u2026\u201d, go back to the file functions.php<\/code> and delete the code snippet just added<\/strong> for security and to keep the website lightweight.<\/p>\n
    \n
    Conclusion<\/h2>\n
    Above are 2 methods to help you reset the translation for a specific post in TranslatePress. This is very useful when you change the original content too much or when the automatic translation is faulty.<\/p>\n
    Wish you success!<\/p>\n