Importieren Sie WooCommerce-Bewertungen aus CSV

CSVWorks-Dokumente

Importieren Sie WooCommerce-Bewertungen aus 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 WooCommerce Reviews CSV-Vorlage.
  • Prefer Produkt-ID mapping; use Produkt-SKU only when IDs aren’t available.
  • Dates must be JJJJ-MM-TT.
  • Export files as UTF-8 (no smart quotes or stray tabs).

Need to generate reviews first? Try the Bewertungsgenerator (AI or CSV).

Erforderliche Spalten

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

  • Kommentarautor, Kommentar-Autoren-E-Mail, Kommentardatum
  • Kommentarinhalt, Bewertung (1–5), verifiziert (yes/no)
  • Produkt-ID oder Produkt-SKU (choose one per row)
  • Status (approve/hold/spam) – optional

How to Import Reviews with WebToffee

  1. Open the importer: WooCommerce → Import/Export → Import → Bewertungen/Kommentare.
  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-Produktimport-Export. General guidance: WordPress.org-Dokumentation.

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 Produkt-SKU, leave Produkt-ID empty for that row (and vice-versa).

Fehlerbehebung

  • Bewertungen, die nicht an Produkte angehängt sind: confirm the product IDs/SKUs exist and are published.
  • Datumsangaben können nicht analysiert werden: verwenden JJJJ-MM-TT with leading zeros; avoid locale formats.
  • Alle ausstehenden Überprüfungen: Satz Status Zu genehmigen or bulk-approve after import.
  • Encoding issues: export as UTF-8; remove smart quotes and stray tabs.

Verwandte Ressourcen