{"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":"huong-dan-xoa-ban-dich-translatepress-cho-mot-bai-viet-cu-the-reset-translation-2","status":"publish","type":"post","link":"https:\/\/dps.media\/en\/huong-dan-xoa-ban-dich-translatepress-cho-mot-bai-viet-cu-the-reset-translation-2\/","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> ho\u1eb7c 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-- Thay '123' b\u1eb1ng ID b\u00e0i vi\u1ebft c\u1ee7a b\u1ea1n\n-- Thay 'wp_trp_dictionary_vi_zh_cn' b\u1eb1ng t\u00ean b\u1ea3ng ng\u00f4n ng\u1eef b\u1ea1n mu\u1ed1n x\u00f3a\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 databases or do not want to touch phpMyAdmin, you can use the following small piece of code.<\/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> v\u00e0 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>","protected":false},"excerpt":{"rendered":"
    Issue: Translation is corrupted or not updated During the operation of a multilingual website with TranslatePress, sometimes you will encounter cases where the translation is corrupted (e.g., Chinese is displayed as Vietnamese) or you want to reset the entire translation of an article [\u2026]<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-36617","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"acf":[],"rankmath_keywords":{"primary":"","secondary":[""]},"yoast_keywords":{"primary":"","secondary":[]},"yoast_focuskw":"","rankmath_focuskw":"","seo_keywords":{"primary":"","secondary":[""]},"_links":{"self":[{"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/posts\/36617","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/comments?post=36617"}],"version-history":[{"count":0,"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/posts\/36617\/revisions"}],"wp:attachment":[{"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/media?parent=36617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/categories?post=36617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dps.media\/en\/wp-json\/wp\/v2\/tags?post=36617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}