从 CSV 导入 WooCommerce 评论

CSVWorks Docs

从 CSV 导入 WooCommerce 评论

Follow this step-by-step guide to import woocommerce reviews from csv using WebToffee Import/Export. You’ll confirm headers, map product IDs/SKUs, run a small test, and then scale safely without mapping errors.

Import WooCommerce reviews from CSV using WebToffee Import Export plugin

Before You Start

  • Use the exact headers from our WooCommerce 评论 CSV 模板.
  • Prefer product_id mapping; use product_sku only when IDs aren’t available.
  • Dates must be YYYY-MM-DD.
  • Export files as UTF-8 (no smart quotes or stray tabs).

Need to generate reviews first? Try the 评论生成器 (AI or CSV).

Required Columns

Copy these column names exactly to reduce mapping issues during import.

  • 评论作者, 评论作者邮箱, 评论日期
  • 评论内容, 等级 (1–5), 已验证 (yes/no)
  • product_id or product_sku (choose one per row)
  • status (approve/hold/spam) – optional

How to Import Reviews with WebToffee

  1. Open the importer: WooCommerce → Import/Export → Import → Reviews/Comments.
  2. Upload CSV: Select your file (UTF-8). Continue.
  3. Mapping step: Check that author, email, content, rating, and product fields auto-map to the correct columns. If not, map them manually.
  4. Test run: Import 10–20 rows first. Review results in Comments → Product reviews.
  5. Full import: Once validated, import the full CSV.

Plugin reference: WebToffee – WooCommerce Product Import Export. General guidance: WordPress.org Documentation.

Sample CSV

comment_author,comment_author_email,comment_date,comment_content,rating,verified,product_id,product_sku,status
Alex Chen,alex@example.com,2025-01-10,"Great fit and fast shipping.",5,yes,1234,,approve
Samira B,samira@example.com,2025-01-12,"Color exactly as pictured.",4,no,,TEE-XL,approve

If you use product_sku, leave product_id empty for that row (and vice-versa).

Troubleshooting

  • Reviews not attached to products: confirm the product IDs/SKUs exist and are published.
  • Dates fail to parse: use YYYY-MM-DD with leading zeros; avoid locale formats.
  • All reviews pending: set status to approve or bulk-approve after import.
  • Encoding issues: export as UTF-8; remove smart quotes and stray tabs.

Related Resources