CSVWorks Docs
WooCommerce AI 评论生成器指南
This guide explains how to use the woocommerce ai reviews generator in CSVWorks to draft realistic product review text at scale, keep tight editorial control, export a clean CSV, and import it to WooCommerce with accurate product mapping.

How the AI Reviews Workflow Works
- Select products by ID or SKU and choose the number of reviews to generate.
- Set style controls: tone (concise, friendly, expert), length (short, medium, long), and optional pros/cons hints.
- Generate drafts for each product and review them inside the queue.
- Approve or discard each draft. You stay in control—only approved text goes to CSV.
- Export CSV, then import to WooCommerce using WebToffee’s mapping.
Heads-up: Only publish reviews that are genuine and visible to users. Keep AI content as draft data until vetted.
CSV Columns for Import
When you export from the generator, your CSV includes the standard review fields expected by importers:
评论作者
,评论作者邮箱
(选修的)评论日期
(YYYY-MM-DD
)评论内容
(the AI-generated and approved review text)等级
(1–5),已验证
(yes/no)product_id
orproduct_sku
(link the review to a product)status
(approve/hold/spam) — optional
Prefer product_id
for reliability; SKUs are fine when IDs aren’t available.
Best Practices for AI-Generated Reviews
- Use realistic prompts: provide product context (material, use case) and typical pros/cons to steer outputs.
- Keep it truthful: never fabricate attributes, availability, or results. Remove sensitive claims.
- Moderate every draft: approve only text that meets your content standards and store policy.
- Vary tone and length: mix short/long reviews to avoid repetition.
- Respect guidelines: add structured data only for real, visible reviews. Do not mark up placeholder content.
Import with WebToffee
- WooCommerce → Import/Export → Import → Reviews/Comments.
- Upload your CSV (UTF-8). Continue to Mapping.
- Confirm author, rating, content, and product fields auto-map.
- Run a small test (10–20 rows); verify results; then import the full file.
Plugin reference: WebToffee – WooCommerce Product Import Export. General platform info: WordPress.org Documentation.
Sample CSV (From the AI Reviews Export)
comment_author,comment_author_email,comment_date,comment_content,rating,verified,product_id,product_sku,status CSVWorks Reviewer,[email protected],2025-02-10,"Lightweight, comfy, and true to size. After two weeks, still looks new.",5,yes,1234,,approve CSVWorks Reviewer,,2025-02-11,"Nice color and stitching. Runs slightly small—order half size up.",4,yes,,TEE-XL,hold
If you populate product_sku
, leave product_id
blank for that row, and vice-versa.
Troubleshooting
- Reviews not linked: confirm IDs/SKUs exist and products are published.
- Pending moderation: set
status
toapprove
or bulk-approve in Comments. - Date errors: stick to
YYYY-MM-DD
(no locale formats). - Encoding issues: save CSV as UTF-8; remove smart quotes or stray tabs.