CSV-Vorlagen

CSVWorks

CSV Templates for WooCommerce

Looking for reliable WooCommerce CSV templates? Copy ready-made headers and sample rows for reviews, orders, and coupons. Each template is designed to auto-map with WebToffee Import/Export so you can import faster and avoid mapping errors.

Reviews CSV
Orders CSV
Coupons CSV

WooCommerce Reviews CSV-Vorlage

WooCommerce CSV templates for product reviews import with WebToffee

Use this when importing product reviews. Map to product ID oder SKU. Works with WebToffee’s Import (Reviews/Comments) flow.

Columns

  • Kommentarautor – Name des Gutachters
  • Kommentar-Autoren-E-Mail – Email
  • Kommentardatum – YYYY-MM-DD
  • Kommentarinhalt – Rezensionstext
  • Bewertung – 1–5
  • verifiziert – ja/nein
  • Produkt-ID oder Produkt-SKU – one is required
  • Status – genehmigen/zurückhalten/Spam (optional)

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,"Tolle Passform und schnelle Lieferung.",5,ja,1234,,genehmigen Samira B,[email protected],2025-01-12,"Farbe war genau wie abgebildet.",4,nein,,TEE-XL,genehmigen

Tip: If you use Produkt-SKU, leave Produkt-ID blank and vice-versa.

Download Reviews CSV Sample
Open Reviews Generator

WooCommerce Orders CSV Template

WooCommerce CSV templates for orders import with line items IDs or SKUs

Seed staging with realistic orders. Supports line items by product ID oder SKU, taxes, shipping, totals, and dates. Built for WebToffee’s Orders import.

Columns (core)

  • order_id (optional for updates)
  • order_date (YYYY-MM-DD)
  • Status (processing, completed, etc.)
  • billing_first_name, billing_last_name, billing_email
  • shipping_first_name, shipping_last_name, … (address fields)
  • payment_method, shipping_method
  • line_items (ID:QTY|ID:QTY …) or line_items_sku (SKU:QTY|SKU:QTY …)
  • coupon_codes (comma-separated, optional)
  • order_total (optional; usually auto-calculated)

Sample CSV

order_id,order_date,status,billing_first_name,billing_last_name,billing_email,shipping_first_name,shipping_last_name,payment_method,shipping_method,line_items,line_items_sku,coupon_codes
,2025-02-14,processing,Jamie,Wu,[email protected],Jamie,Wu,cod,flat_rate,1234:1|5678:2,,BFCM25
,2025-02-15,completed,Ana,Ramos,[email protected],Ana,Ramos,cheque,local_pickup,,TEE-XL:1|HAT-BLK:1,

Use either line_items (IDs) or line_items_sku (SKUs). Separate items with a pipe | and quantity with a colon :.

Download Orders CSV Sample
Open Orders Generator

WooCommerce Coupons CSV Template

WooCommerce CSV templates for bulk coupons with product and category restrictions

Generate coupon codes in bulk and import with WebToffee. The template includes the ID column (for updates) and product/category restriction columns that auto-map.

Columns

  • ID (blank for new; set to update existing)
  • Coupon code, Description, Status, Post date
  • Discount type (percent|fixed_cart|fixed_product), Coupon amount
  • Individual use only (yes/no), Allow free shipping (yes/no), Exclude sale items (yes/no)
  • Usage limit per coupon, Usage limit per user, Limit usage to X items
  • Expiry date (YYYY-MM-DD), Minimum amount, Maximum amount
  • Product categories, Exclude categories
  • _wt_sc_coupon_product_ids, _wt_sc_coupon_exclude_product_ids (IDs only)
  • Allowed emails (comma/semicolon separated)

Sample CSV

ID,Coupon code,Description,Status,Post date,Discount type,Coupon amount,Individual use only,_wt_sc_coupon_product_ids,_wt_sc_coupon_exclude_product_ids,No of times used,Usage limit per coupon,Usage limit per user,Limit usage to X items,Expiry date,Allow free shipping,Exclude sale items,Product categories,Exclude categories,Minimum amount,Maximum amount,Allowed emails
,SPRING-25,Spring Sale, publish,2025-03-01,percent,25,yes,123;456,,0,100,1,,2025-03-31,no,yes,12;14,,50,,*@example.com
,SAVE10,Welcome Code, publish,2025-02-01,fixed_cart,10,no,,89,0,0,,1,,2025-04-30,no,no,,,"","[email protected]"

For product/category restrictions, use IDs (semicolon-separated) to match WebToffee’s auto-mapping.

Download Coupons CSV Sample
Open Coupons Generator

FAQs

Which delimiter should I use?

Default is a comma (,). If a column accepts multiple IDs (e.g., product/category restrictions), use a semicolon (;) inside the cell as shown above.

What date format do imports expect?

Use ISO format JJJJ-MM-TT for dates to prevent parsing errors.

Why do some columns have blanks?

Blank cells mean “leave unchanged” or “use default” on import. Delete optional columns you don’t use to avoid mapping noise.

How do I avoid mapping issues?

Keep headers exactly as shown. For product/category restrictions, prefer IDs. Test a small file first, then scale.

These WooCommerce CSV templates mirror WebToffee’s expected headers. Start with a small sample, confirm mapping, and then expand confidently.