CSV-шаблоны

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 so you can import faster and avoid mapping errors.

Reviews CSV
Orders CSV
Coupons CSV

CSV-шаблон отзывов WooCommerce

WooCommerce CSV templates for product reviews import with WebToffee

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

Columns

  • comment_author – Reviewer name
  • comment_author_email – Email
  • comment_date – YYYY-MM-DD
  • comment_content – Review text
  • рейтинг – 1–5
  • проверено – yes/no
  • product_id or product_sku – one is required
  • status – approve/hold/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,"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

Tip: If you use product_sku, leave product_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 or 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 YYYY-MM-DD 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.