{"id":2067,"date":"2025-09-07T06:11:44","date_gmt":"2025-09-07T06:11:44","guid":{"rendered":"https:\/\/csvworks.com\/?page_id=2067"},"modified":"2025-09-07T13:52:38","modified_gmt":"2025-09-07T13:52:38","slug":"reviews-csv-template","status":"publish","type":"page","link":"https:\/\/csvworks.com\/zh\/reviews-csv-template\/","title":{"rendered":"WooCommerce \u8bc4\u8bba CSV \u6a21\u677f"},"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>WooCommerce \u8bc4\u8bba CSV \u6a21\u677f<\/h1>\r\n<p>If you need a dependable <strong>woocommerce reviews csv template<\/strong>, this guide shows the exact headers, a working sample CSV, and how to import reviews with WebToffee so mapping is fast and accurate.<\/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=Reviews+CSV+Headers\" alt=\"Reviews CSV headers and sample rows for WooCommerce import\" \/><\/figure>\r\n<!-- =============== REQUIRED HEADERS =============== -->\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>Required Columns<\/h2>\r\n<p>Copy these column names exactly to reduce mapping issues during import. Use either <code>product_id<\/code> or <code>product_sku<\/code> for each row.<\/p>\r\n<ul>\r\n<li><code>\u8bc4\u8bba\u4f5c\u8005<\/code> \u2013 Reviewer name<\/li>\r\n<li><code>\u8bc4\u8bba\u4f5c\u8005\u90ae\u7bb1<\/code> \u2013 Reviewer email<\/li>\r\n<li><code>\u8bc4\u8bba\u65e5\u671f<\/code> \u2013 Date in <code>YYYY-MM-DD<\/code><\/li>\r\n<li><code>\u8bc4\u8bba\u5185\u5bb9<\/code> \u2013 Review text<\/li>\r\n<li><code>\u7b49\u7ea7<\/code> \u2013 1\u20135<\/li>\r\n<li><code>\u5df2\u9a8c\u8bc1<\/code> \u2013 yes\/no<\/li>\r\n<li><code>product_id<\/code> <em>or<\/em> <code>product_sku<\/code> \u2013 link to the product<\/li>\r\n<li><code>status<\/code> \u2013 approve\/hold\/spam (optional)<\/li>\r\n<\/ul>\r\n<p class=\"is-style-subtext\">Tip: Prefer <code>product_id<\/code> (numeric) for reliability. Use SKUs only when IDs aren\u2019t available.<\/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 Reviews 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 was exactly as pictured.\",4,no,,TEE-XL,approve<\/pre>\r\n<p class=\"is-style-subtext\">Use UTF-8 CSV. Keep a small 10\u201320 row file for testing before you run the full import.<\/p>\r\n<\/div>\r\n<\/div>\r\n<!-- =============== HOW TO 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 with WebToffee<\/h2>\r\n<ol>\r\n<li>Go to WooCommerce \u2192 Import\/Export \u2192 <strong>Import<\/strong> \u2192 Reviews\/Comments.<\/li>\r\n<li>Upload your CSV and proceed to the Mapping step.<\/li>\r\n<li>Confirm author, content, rating, and product fields auto-map correctly.<\/li>\r\n<li>Run a small test import; verify results; then import your full file.<\/li>\r\n<\/ol>\r\n<p>Official plugin page: <a href=\"https:\/\/wordpress.org\/plugins\/product-import-export-for-woo\/\" target=\"_blank\" rel=\"noopener\">WebToffee \u2013 WooCommerce Product Import Export<\/a>. For general CSV handling in WordPress, see <a href=\"https:\/\/wordpress.org\/documentation\/\" target=\"_blank\" rel=\"noopener\">WordPress.org Documentation<\/a>.<\/p>\r\n<\/div>\r\n<\/div>\r\n<!-- =============== TROUBLESHOOTING =============== -->\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: 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 IDs\/SKUs exist and match active products.<\/li>\r\n<li><strong>Dates fail to parse:<\/strong> use <code>YYYY-MM-DD<\/code>; avoid locale formats.<\/li>\r\n<li><strong>All reviews pending:<\/strong> set <code>status<\/code> to <code>approve<\/code> to publish immediately.<\/li>\r\n<li><strong>Encoding problems:<\/strong> export as UTF-8; remove stray tabs and smart quotes.<\/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 is-layout-flow wp-block-group-is-layout-flow\" style=\"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\/woocommerce-product-reviews-generator\/#reviews-generator\">Open the Reviews Generator Tool<\/a><\/li>\r\n<li><a href=\"\/zh\/docs\/import-woocommerce-reviews\/\">How to Import WooCommerce Reviews from CSV<\/a><\/li>\r\n<li><a href=\"\/zh\/docs\/ai-reviews-generator-guide\/\">AI Reviews Generator Guide<\/a><\/li>\r\n<li><a href=\"\/zh\/csv-templates\/#reviews-template\">Download CSV Templates<\/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 WooCommerce Reviews CSV Template If you need a dependable woocommerce reviews csv template, this guide shows the exact headers, a working sample CSV, and how to import reviews with WebToffee so mapping is fast and accurate. Required Columns Copy these column names exactly to reduce mapping issues during import. Use either product_id or [&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-2067","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>WooCommerce Reviews CSV Template | CSVWorks Docs<\/title>\n<meta name=\"description\" content=\"Download the ultimate WooCommerce reviews CSV template to streamline your product feedback collection and management.\" \/>\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\/reviews-csv-template\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"WooCommerce Reviews CSV Template | CSVWorks Docs\" \/>\n<meta property=\"og:description\" content=\"Download the ultimate WooCommerce reviews CSV template to streamline your product feedback collection and management.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/csvworks.com\/zh\/reviews-csv-template\/\" \/>\n<meta property=\"og:site_name\" content=\"CSVWorks \u2013 WooCommerce Generators (Reviews, Orders, Coupons)\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-07T13:52:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/via.placeholder.com\/960x420.png?text=Reviews+CSV+Headers\" \/>\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\/reviews-csv-template\/\",\"url\":\"https:\/\/csvworks.com\/reviews-csv-template\/\",\"name\":\"WooCommerce Reviews CSV Template | CSVWorks Docs\",\"isPartOf\":{\"@id\":\"https:\/\/csvworks.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/csvworks.com\/reviews-csv-template\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/csvworks.com\/reviews-csv-template\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/via.placeholder.com\/960x420.png?text=Reviews+CSV+Headers\",\"datePublished\":\"2025-09-07T06:11:44+00:00\",\"dateModified\":\"2025-09-07T13:52:38+00:00\",\"description\":\"Download the ultimate WooCommerce reviews CSV template to streamline your product feedback collection and management.\",\"breadcrumb\":{\"@id\":\"https:\/\/csvworks.com\/reviews-csv-template\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/csvworks.com\/reviews-csv-template\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/csvworks.com\/reviews-csv-template\/#primaryimage\",\"url\":\"https:\/\/via.placeholder.com\/960x420.png?text=Reviews+CSV+Headers\",\"contentUrl\":\"https:\/\/via.placeholder.com\/960x420.png?text=Reviews+CSV+Headers\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/csvworks.com\/reviews-csv-template\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/csvworks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"WooCommerce Reviews CSV Template\"}]},{\"@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":"WooCommerce Reviews CSV Template | CSVWorks Docs","description":"Download the ultimate WooCommerce reviews CSV template to streamline your product feedback collection and management.","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\/reviews-csv-template\/","og_locale":"zh_CN","og_type":"article","og_title":"WooCommerce Reviews CSV Template | CSVWorks Docs","og_description":"Download the ultimate WooCommerce reviews CSV template to streamline your product feedback collection and management.","og_url":"https:\/\/csvworks.com\/zh\/reviews-csv-template\/","og_site_name":"CSVWorks \u2013 WooCommerce Generators (Reviews, Orders, Coupons)","article_modified_time":"2025-09-07T13:52:38+00:00","og_image":[{"url":"https:\/\/via.placeholder.com\/960x420.png?text=Reviews+CSV+Headers","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\/reviews-csv-template\/","url":"https:\/\/csvworks.com\/reviews-csv-template\/","name":"WooCommerce Reviews CSV Template | CSVWorks Docs","isPartOf":{"@id":"https:\/\/csvworks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/csvworks.com\/reviews-csv-template\/#primaryimage"},"image":{"@id":"https:\/\/csvworks.com\/reviews-csv-template\/#primaryimage"},"thumbnailUrl":"https:\/\/via.placeholder.com\/960x420.png?text=Reviews+CSV+Headers","datePublished":"2025-09-07T06:11:44+00:00","dateModified":"2025-09-07T13:52:38+00:00","description":"Download the ultimate WooCommerce reviews CSV template to streamline your product feedback collection and management.","breadcrumb":{"@id":"https:\/\/csvworks.com\/reviews-csv-template\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/csvworks.com\/reviews-csv-template\/"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/csvworks.com\/reviews-csv-template\/#primaryimage","url":"https:\/\/via.placeholder.com\/960x420.png?text=Reviews+CSV+Headers","contentUrl":"https:\/\/via.placeholder.com\/960x420.png?text=Reviews+CSV+Headers"},{"@type":"BreadcrumbList","@id":"https:\/\/csvworks.com\/reviews-csv-template\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/csvworks.com\/"},{"@type":"ListItem","position":2,"name":"WooCommerce Reviews CSV Template"}]},{"@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\/2067","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=2067"}],"version-history":[{"count":2,"href":"https:\/\/csvworks.com\/zh\/wp-json\/wp\/v2\/pages\/2067\/revisions"}],"predecessor-version":[{"id":2110,"href":"https:\/\/csvworks.com\/zh\/wp-json\/wp\/v2\/pages\/2067\/revisions\/2110"}],"wp:attachment":[{"href":"https:\/\/csvworks.com\/zh\/wp-json\/wp\/v2\/media?parent=2067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}