Modelo CSV de avaliações do WooCommerce

CSVWorks Docs

Modelo CSV de avaliações do WooCommerce

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.

Reviews CSV headers and sample rows for WooCommerce import

Required Columns

Copy these column names exactly to reduce mapping issues during import. Use either product_id or product_sku for each row.

  • autor_do_comentário – Reviewer name
  • e-mail do autor do comentário – Reviewer email
  • data_do_comentário – Date in YYYY-MM-DD
  • conteúdo_do_comentário – Review text
  • avaliação – 1–5
  • verificado – yes/no
  • product_id or product_sku – link to the product
  • status – approve/hold/spam (optional)

Tip: Prefer product_id (numeric) for reliability. Use SKUs only when IDs aren’t available.

Sample Reviews CSV

comment_author,comment_author_email,comment_date,comment_content,rating,verified,product_id,product_sku,status
Alex Chen,[email protected],2025-01-10,"Great fit and fast shipping.",5,yes,1234,,approve
Samira B,[email protected],2025-01-12,"Color was exactly as pictured.",4,no,,TEE-XL,approve

Use UTF-8 CSV. Keep a small 10–20 row file for testing before you run the full import.

How to Import with WebToffee

  1. Go to WooCommerce → Import/Export → Import → Reviews/Comments.
  2. Upload your CSV and proceed to the Mapping step.
  3. Confirm author, content, rating, and product fields auto-map correctly.
  4. Run a small test import; verify results; then import your full file.

Official plugin page: WebToffee – WooCommerce Product Import Export. For general CSV handling in WordPress, see WordPress.org Documentation.

Troubleshooting

  • Reviews not attached to products: confirm IDs/SKUs exist and match active products.
  • Dates fail to parse: use YYYY-MM-DD; avoid locale formats.
  • All reviews pending: set status to approve to publish immediately.
  • Encoding problems: export as UTF-8; remove stray tabs and smart quotes.

Related Resources