{"id":2072,"date":"2025-09-07T06:20:57","date_gmt":"2025-09-07T06:20:57","guid":{"rendered":"https:\/\/csvworks.com\/?page_id=2072"},"modified":"2025-09-07T13:53:38","modified_gmt":"2025-09-07T13:53:38","slug":"import-woocommerce-reviews","status":"publish","type":"page","link":"https:\/\/csvworks.com\/zh\/import-woocommerce-reviews\/","title":{"rendered":"\u4ece CSV \u5bfc\u5165 WooCommerce \u8bc4\u8bba"},"content":{"rendered":"<!-- =============== HERO =============== -->\r\n\r\n\r\n<div class=\"wp-block-group alignfull has-white-color has-black-background-color has-text-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top: 48px; padding-bottom: 36px;\">\r\n<div class=\"wp-block-group alignwide\">\r\n<p class=\"is-style-caption\">CSVWorks Docs<\/p>\r\n<h1>\u4ece CSV \u5bfc\u5165 WooCommerce \u8bc4\u8bba<\/h1>\r\n<p>Follow this step-by-step guide to <strong>import woocommerce reviews from csv<\/strong> using WebToffee Import\/Export. You\u2019ll confirm headers, map product IDs\/SKUs, run a small test, and then scale safely without mapping errors.<\/p>\r\n<\/div>\r\n<\/div>\r\n<!-- =============== INTRO IMAGE =============== -->\r\n\r\n\r\n<figure class=\"wp-block-image aligncenter size-large\" style=\"margin-top: 18px; margin-bottom: 18px;\"><img decoding=\"async\" src=\"https:\/\/via.placeholder.com\/960x420.png?text=Import+WooCommerce+Reviews+from+CSV\" alt=\"Import WooCommerce reviews from CSV using WebToffee Import Export plugin\" \/><\/figure>\r\n<!-- =============== BEFORE YOU START =============== -->\r\n\r\n\r\n<div class=\"wp-block-group alignfull is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top: 26px; padding-bottom: 26px;\">\r\n<div class=\"wp-block-group alignwide\">\r\n<h2>Before You Start<\/h2>\r\n<ul>\r\n<li>Use the exact headers from our <a href=\"\/zh\/docs\/reviews-csv-template\/\">WooCommerce \u8bc4\u8bba CSV \u6a21\u677f<\/a>.<\/li>\r\n<li>Prefer <strong>product_id<\/strong> mapping; use <strong>product_sku<\/strong> only when IDs aren\u2019t available.<\/li>\r\n<li>Dates must be <code>YYYY-MM-DD<\/code>.<\/li>\r\n<li>Export files as UTF-8 (no smart quotes or stray tabs).<\/li>\r\n<\/ul>\r\n<p class=\"is-style-subtext\">Need to generate reviews first? Try the <a href=\"\/zh\/woocommerce-product-reviews-generator\/#reviews-generator\">\u8bc4\u8bba\u751f\u6210\u5668<\/a> (AI or CSV).<\/p>\r\n<\/div>\r\n<\/div>\r\n<!-- =============== REQUIRED COLUMNS =============== -->\r\n\r\n\r\n<div class=\"wp-block-group alignfull has-border-color has-light-gray-border-color is-layout-flow wp-block-group-is-layout-flow\" style=\"border-top-width: 1px; padding-top: 24px; padding-bottom: 24px;\">\r\n<div class=\"wp-block-group alignwide\">\r\n<h2>Required Columns<\/h2>\r\n<p>Copy these column names exactly to reduce mapping issues during import.<\/p>\r\n<ul>\r\n<li><code>\u8bc4\u8bba\u4f5c\u8005<\/code>, <code>\u8bc4\u8bba\u4f5c\u8005\u90ae\u7bb1<\/code>, <code>\u8bc4\u8bba\u65e5\u671f<\/code><\/li>\r\n<li><code>\u8bc4\u8bba\u5185\u5bb9<\/code>, <code>\u7b49\u7ea7<\/code> (1\u20135), <code>\u5df2\u9a8c\u8bc1<\/code> (yes\/no)<\/li>\r\n<li><code>product_id<\/code> <em>or<\/em> <code>product_sku<\/code> (choose one per row)<\/li>\r\n<li><code>status<\/code> (approve\/hold\/spam) \u2013 optional<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<!-- =============== STEP-BY-STEP IMPORT =============== -->\r\n\r\n\r\n<div class=\"wp-block-group alignfull is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top: 26px; padding-bottom: 26px;\">\r\n<div class=\"wp-block-group alignwide\">\r\n<h2>How to Import Reviews with WebToffee<\/h2>\r\n<ol>\r\n<li><strong>Open the importer:<\/strong> WooCommerce \u2192 Import\/Export \u2192 <strong>Import<\/strong> \u2192 Reviews\/Comments.<\/li>\r\n<li><strong>Upload CSV:<\/strong> Select your file (UTF-8). Continue.<\/li>\r\n<li><strong>Mapping step:<\/strong> Check that author, email, content, rating, and product fields auto-map to the correct columns. If not, map them manually.<\/li>\r\n<li><strong>Test run:<\/strong> Import 10\u201320 rows first. Review results in <em>Comments \u2192 Product reviews<\/em>.<\/li>\r\n<li><strong>Full import:<\/strong> Once validated, import the full CSV.<\/li>\r\n<\/ol>\r\n<p>Plugin reference: <a href=\"https:\/\/wordpress.org\/plugins\/product-import-export-for-woo\/\" target=\"_blank\" rel=\"noopener\">WebToffee \u2013 WooCommerce Product Import Export<\/a>. General guidance: <a href=\"https:\/\/wordpress.org\/documentation\/\" target=\"_blank\" rel=\"noopener\">WordPress.org Documentation<\/a>.<\/p>\r\n<\/div>\r\n<\/div>\r\n<!-- =============== SAMPLE CSV =============== -->\r\n\r\n\r\n<div class=\"wp-block-group alignfull has-border-color has-light-gray-border-color is-layout-flow wp-block-group-is-layout-flow\" style=\"border-top-width: 1px; padding-top: 22px; padding-bottom: 22px;\">\r\n<div class=\"wp-block-group alignwide\">\r\n<h2>Sample CSV<\/h2>\r\n<pre>comment_author,comment_author_email,comment_date,comment_content,rating,verified,product_id,product_sku,status\r\nAlex Chen,alex@example.com,2025-01-10,\"Great fit and fast shipping.\",5,yes,1234,,approve\r\nSamira B,samira@example.com,2025-01-12,\"Color exactly as pictured.\",4,no,,TEE-XL,approve<\/pre>\r\n<p class=\"is-style-subtext\">If you use <code>product_sku<\/code>, leave <code>product_id<\/code> empty for that row (and vice-versa).<\/p>\r\n<\/div>\r\n<\/div>\r\n<!-- =============== TROUBLESHOOTING =============== -->\r\n\r\n\r\n<div class=\"wp-block-group alignfull is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top: 24px; padding-bottom: 26px;\">\r\n<div class=\"wp-block-group alignwide\">\r\n<h2>Troubleshooting<\/h2>\r\n<ul>\r\n<li><strong>Reviews not attached to products:<\/strong> confirm the product IDs\/SKUs exist and are published.<\/li>\r\n<li><strong>Dates fail to parse:<\/strong> use <code>YYYY-MM-DD<\/code> with leading zeros; avoid locale formats.<\/li>\r\n<li><strong>All reviews pending:<\/strong> set <code>status<\/code> to <code>approve<\/code> or bulk-approve after import.<\/li>\r\n<li><strong>Encoding issues:<\/strong> export as UTF-8; remove smart quotes and stray tabs.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<!-- =============== RELATED RESOURCES =============== -->\r\n\r\n\r\n<div class=\"wp-block-group alignfull has-border-color has-light-gray-border-color is-layout-flow wp-block-group-is-layout-flow\" style=\"border-top-width: 1px; padding-top: 20px; padding-bottom: 36px;\">\r\n<div class=\"wp-block-group alignwide\">\r\n<h2>Related Resources<\/h2>\r\n<ul>\r\n<li><a href=\"\/zh\/docs\/reviews-csv-template\/\">WooCommerce \u8bc4\u8bba CSV \u6a21\u677f<\/a><\/li>\r\n<li><a href=\"\/zh\/woocommerce-product-reviews-generator\/#reviews-generator\">Open the Reviews Generator Tool<\/a><\/li>\r\n<li><a href=\"\/zh\/csv-templates\/#reviews-template\">Download CSV Templates<\/a><\/li>\r\n<li><a href=\"\/zh\/contact-csvworks\/\">Contact CSVWorks<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n\r\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>CSVWorks Docs Import WooCommerce Reviews from CSV Follow this step-by-step guide to import woocommerce reviews from csv using WebToffee Import\/Export. You\u2019ll confirm headers, map product IDs\/SKUs, run a small test, and then scale safely without mapping errors. Before You Start Use the exact headers from our WooCommerce Reviews CSV Template. Prefer product_id mapping; use product_sku [&hellip;]<\/p>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2072","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Import WooCommerce Reviews from CSV | CSVWorks Docs<\/title>\n<meta name=\"description\" content=\"How to import WooCommerce reviews from CSV with WebToffee. Exact headers, mapping tips, sample CSV, and fixes for common errors.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/csvworks.com\/zh\/import-woocommerce-reviews\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import WooCommerce Reviews from CSV | CSVWorks Docs\" \/>\n<meta property=\"og:description\" content=\"How to import WooCommerce reviews from CSV with WebToffee. Exact headers, mapping tips, sample CSV, and fixes for common errors.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/csvworks.com\/zh\/import-woocommerce-reviews\/\" \/>\n<meta property=\"og:site_name\" content=\"CSVWorks \u2013 WooCommerce Generators (Reviews, Orders, Coupons)\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-07T13:53:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/via.placeholder.com\/960x420.png?text=Import+WooCommerce+Reviews+from+CSV\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/csvworks.com\/import-woocommerce-reviews\/\",\"url\":\"https:\/\/csvworks.com\/import-woocommerce-reviews\/\",\"name\":\"Import WooCommerce Reviews from CSV | CSVWorks Docs\",\"isPartOf\":{\"@id\":\"https:\/\/csvworks.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/csvworks.com\/import-woocommerce-reviews\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/csvworks.com\/import-woocommerce-reviews\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/via.placeholder.com\/960x420.png?text=Import+WooCommerce+Reviews+from+CSV\",\"datePublished\":\"2025-09-07T06:20:57+00:00\",\"dateModified\":\"2025-09-07T13:53:38+00:00\",\"description\":\"How to import WooCommerce reviews from CSV with WebToffee. Exact headers, mapping tips, sample CSV, and fixes for common errors.\",\"breadcrumb\":{\"@id\":\"https:\/\/csvworks.com\/import-woocommerce-reviews\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/csvworks.com\/import-woocommerce-reviews\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/csvworks.com\/import-woocommerce-reviews\/#primaryimage\",\"url\":\"https:\/\/via.placeholder.com\/960x420.png?text=Import+WooCommerce+Reviews+from+CSV\",\"contentUrl\":\"https:\/\/via.placeholder.com\/960x420.png?text=Import+WooCommerce+Reviews+from+CSV\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/csvworks.com\/import-woocommerce-reviews\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/csvworks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import WooCommerce Reviews from CSV\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/csvworks.com\/#website\",\"url\":\"https:\/\/csvworks.com\/\",\"name\":\"CSVWorks\",\"description\":\"Generate WooCommerce reviews, orders, and coupons in bulk with CSV.\",\"publisher\":{\"@id\":\"https:\/\/csvworks.com\/#organization\"},\"alternateName\":\"CSVWorks \u2013 WooCommerce Generators\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/csvworks.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/csvworks.com\/#organization\",\"name\":\"CSVWorks\",\"url\":\"https:\/\/csvworks.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/csvworks.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/csvworks.com\/wp-content\/uploads\/2025\/09\/LOGO-1.png\",\"contentUrl\":\"https:\/\/csvworks.com\/wp-content\/uploads\/2025\/09\/LOGO-1.png\",\"width\":1024,\"height\":1024,\"caption\":\"CSVWorks\"},\"image\":{\"@id\":\"https:\/\/csvworks.com\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import WooCommerce Reviews from CSV | CSVWorks Docs","description":"How to import WooCommerce reviews from CSV with WebToffee. Exact headers, mapping tips, sample CSV, and fixes for common errors.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/csvworks.com\/zh\/import-woocommerce-reviews\/","og_locale":"zh_CN","og_type":"article","og_title":"Import WooCommerce Reviews from CSV | CSVWorks Docs","og_description":"How to import WooCommerce reviews from CSV with WebToffee. Exact headers, mapping tips, sample CSV, and fixes for common errors.","og_url":"https:\/\/csvworks.com\/zh\/import-woocommerce-reviews\/","og_site_name":"CSVWorks \u2013 WooCommerce Generators (Reviews, Orders, Coupons)","article_modified_time":"2025-09-07T13:53:38+00:00","og_image":[{"url":"https:\/\/via.placeholder.com\/960x420.png?text=Import+WooCommerce+Reviews+from+CSV","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"2 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/csvworks.com\/import-woocommerce-reviews\/","url":"https:\/\/csvworks.com\/import-woocommerce-reviews\/","name":"Import WooCommerce Reviews from CSV | CSVWorks Docs","isPartOf":{"@id":"https:\/\/csvworks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/csvworks.com\/import-woocommerce-reviews\/#primaryimage"},"image":{"@id":"https:\/\/csvworks.com\/import-woocommerce-reviews\/#primaryimage"},"thumbnailUrl":"https:\/\/via.placeholder.com\/960x420.png?text=Import+WooCommerce+Reviews+from+CSV","datePublished":"2025-09-07T06:20:57+00:00","dateModified":"2025-09-07T13:53:38+00:00","description":"How to import WooCommerce reviews from CSV with WebToffee. Exact headers, mapping tips, sample CSV, and fixes for common errors.","breadcrumb":{"@id":"https:\/\/csvworks.com\/import-woocommerce-reviews\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/csvworks.com\/import-woocommerce-reviews\/"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/csvworks.com\/import-woocommerce-reviews\/#primaryimage","url":"https:\/\/via.placeholder.com\/960x420.png?text=Import+WooCommerce+Reviews+from+CSV","contentUrl":"https:\/\/via.placeholder.com\/960x420.png?text=Import+WooCommerce+Reviews+from+CSV"},{"@type":"BreadcrumbList","@id":"https:\/\/csvworks.com\/import-woocommerce-reviews\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/csvworks.com\/"},{"@type":"ListItem","position":2,"name":"Import WooCommerce Reviews from CSV"}]},{"@type":"WebSite","@id":"https:\/\/csvworks.com\/#website","url":"https:\/\/csvworks.com\/","name":"CSVWorks","description":"\u4f7f\u7528 CSV \u6279\u91cf\u751f\u6210 WooCommerce \u8bc4\u8bba\u3001\u8ba2\u5355\u548c\u4f18\u60e0\u5238\u3002","publisher":{"@id":"https:\/\/csvworks.com\/#organization"},"alternateName":"CSVWorks \u2013 WooCommerce Generators","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/csvworks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":"Organization","@id":"https:\/\/csvworks.com\/#organization","name":"CSVWorks","url":"https:\/\/csvworks.com\/","logo":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/csvworks.com\/#\/schema\/logo\/image\/","url":"https:\/\/csvworks.com\/wp-content\/uploads\/2025\/09\/LOGO-1.png","contentUrl":"https:\/\/csvworks.com\/wp-content\/uploads\/2025\/09\/LOGO-1.png","width":1024,"height":1024,"caption":"CSVWorks"},"image":{"@id":"https:\/\/csvworks.com\/#\/schema\/logo\/image\/"}}]}},"_hostinger_reach_plugin_has_subscription_block":false,"_hostinger_reach_plugin_is_elementor":false,"_links":{"self":[{"href":"https:\/\/csvworks.com\/zh\/wp-json\/wp\/v2\/pages\/2072","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csvworks.com\/zh\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/csvworks.com\/zh\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/csvworks.com\/zh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/csvworks.com\/zh\/wp-json\/wp\/v2\/comments?post=2072"}],"version-history":[{"count":2,"href":"https:\/\/csvworks.com\/zh\/wp-json\/wp\/v2\/pages\/2072\/revisions"}],"predecessor-version":[{"id":2113,"href":"https:\/\/csvworks.com\/zh\/wp-json\/wp\/v2\/pages\/2072\/revisions\/2113"}],"wp:attachment":[{"href":"https:\/\/csvworks.com\/zh\/wp-json\/wp\/v2\/media?parent=2072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}