{"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> 5px 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
    N\u1ebfu b\u1ea1n kh\u00f4ng r\u00e0nh v\u1ec1 database ho\u1eb7c kh\u00f4ng mu\u1ed1n \u0111\u1ee5ng v\u00e0o phpMyAdmin, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng \u0111o\u1ea1n code nh\u1ecf sau \u0111\u00e2y.<\/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    \/\/ Thay \u0111\u1ed5i s\u1ed1 123 th\u00e0nh ID b\u00e0i vi\u1ebft b\u1ea1n mu\u1ed1n x\u00f3a\n    $post_id_to_clean = 123; \n    \n    \/\/ Thay \u0111\u1ed5i th\u00e0nh m\u00e3 ng\u00f4n ng\u1eef b\u1ea1n mu\u1ed1n x\u00f3a (v\u00ed d\u1ee5: vi_zh_cn, vi_en_us)\n    $lang_pair = 'vi_zh_cn'; \n    \n    if (isset($_GET['clean_post_id']) && $_GET['clean_post_id'] == $post_id_to_clean) {\n        global $wpdb;\n        $meta_table = $wpdb->prefix . 'trp_original_meta';\n        $dict_table = $wpdb->prefix . 'trp_dictionary_' . $lang_pair;\n        \n        \/\/ Ki\u1ec3m tra xem b\u1ea3ng c\u00f3 t\u1ed3n t\u1ea1i kh\u00f4ng\n        if ($wpdb->get_var(\"SHOW TABLES LIKE '$dict_table'\") != $dict_table) {\n            wp_die(\"B\u1ea3ng $dict_table kh\u00f4ng t\u1ed3n t\u1ea1i. H\u00e3y ki\u1ec3m tra l\u1ea1i m\u00e3 ng\u00f4n ng\u1eef.\");\n        }\n\n        \/\/ L\u1ea5y danh s\u00e1ch ID chu\u1ed7i thu\u1ed9c v\u1ec1 b\u00e0i vi\u1ebft n\u00e0y\n        $original_ids = $wpdb->get_col($wpdb->prepare(\n            \"SELECT original_id FROM $meta_table WHERE meta_key = 'post_parent_id' AND meta_value = %s\",\n            $post_id_to_clean\n        ));\n        \n        if (!empty($original_ids)) {\n            $ids_placeholder = implode(',', array_fill(0, count($original_ids), '%d'));\n            $wpdb->query($wpdb->prepare(\n                \"DELETE FROM $dict_table WHERE original_id IN ($ids_placeholder)\",\n                $original_ids\n            ));\n            echo \"\u0110\u00e3 x\u00f3a s\u1ea1ch b\u1ea3n d\u1ecbch cho b\u00e0i vi\u1ebft ID: \" . $post_id_to_clean;\n        } else {\n            echo \"Kh\u00f4ng t\u00ecm th\u1ea5y chu\u1ed7i n\u00e0o c\u1ea7n x\u00f3a ho\u1eb7c b\u00e0i vi\u1ebft ch\u01b0a \u0111\u01b0\u1ee3c d\u1ecbch.\";\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