Importa le recensioni di WooCommerce da CSV

CSVWorks Docs

Importa le recensioni di WooCommerce da CSV

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 Modello CSV per recensioni WooCommerce.
  • 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 Generatore di recensioni (AI or CSV).

Required Columns

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

  • commento_autore, commento_autore_email, data_del_commento
  • commento_contenuto, valutazione (1–5), verificato (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,[email protected],2025-01-10,"Great fit and fast shipping.",5,yes,1234,,approve
Samira B,[email protected],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