This page lists every column the importer reads, exactly as it reads them. The same list is printed on the import screen, under Columns in a coupon file (both editions) and Columns in an order file (full edition).
The file
- One header row, then one record per row. The first line is always read as the header.
- Delimiter: comma, semicolon, tab or pipe (
|). The importer looks at the header line and picks whichever splits it into the most columns, so a file saved by a French or German spreadsheet (semicolons) or exported by a warehouse system (tabs) reads without changes. - Encoding: UTF-8. A byte-order mark at the start of the file is removed, so the first column is not lost.
- Blank lines in the middle of the file are skipped and not reported.
- Every cell is trimmed of spaces at both ends.
Headers
Headers are matched loosely: the header is lower-cased and every run of characters that is not a letter, digit or underscore becomes _. So Usage Limit, usage_limit and USAGE LIMIT are all the usage_limit column. Column order does not matter.
The header has to come out as one of the names below. Allowed emails becomes allowed_emails, which is not a column; use email_restrictions. Unknown headers are listed in the report and their cells are ignored. If the same column appears twice, the first one is read.
Leaving a column out
A column that is not in the file is not touched on an update. To change only usage limits, a file with code and usage_limit is enough.
Values
| Kind | How it is read |
|---|---|
| Money | Currency symbols and spaces are ignored. With both , and ., the right-most one is the decimal point: 1.250,00 and 1,250.00 are both 1250. A lone comma with exactly two digits after it is a decimal point (12,50 is 12.50); with three it is a thousands separator (1,250 is 1250). A leading - makes it negative. An empty cell is 0. |
| Yes / no | 1, yes, y, true and on (any case) are yes. Anything else, including an empty cell, is no. |
| Lists | Separated by commas, semicolons, spaces or ` |
| Whole numbers | An empty cell is 0, which for a usage limit means "no limit". |
| Dates | Passed to WooCommerce as written. 2026-12-31 and 2026-12-31 18:00:00 both work. |
Coupon columns — both editions
| Column | Meaning | Notes |
|---|---|---|
code |
Code | Required. The coupon's identity. A file without this column imports nothing. A row with an empty code is skipped. |
discount_type |
Discount type | percent, fixed_cart or fixed_product, or a type another plugin adds. A type the shop does not have skips the row. |
amount |
Amount | Money. |
description |
Description | Text. |
date_expires |
Expires | A date. An empty cell removes the expiry. |
individual_use |
Individual use only | Yes / no. |
usage_limit |
Usage limit | Whole number. 0 or empty is no limit. |
usage_limit_per_user |
Usage limit per customer | Whole number. 0 or empty is no limit. |
minimum_amount |
Minimum spend | Money. |
maximum_amount |
Maximum spend | Money. |
free_shipping |
Allow free shipping | Yes / no. |
exclude_sale_items |
Exclude sale items | Yes / no. |
email_restrictions |
Allowed emails | List of email addresses. |
product_ids |
Products | List of product ids (not SKUs). |
excluded_product_ids |
Excluded products | List of product ids. |
An empty cell in a column that is present sets that field to empty, no or zero — the file is taken at its word.
Sample coupon file
code,discount_type,amount,date_expires,usage_limit,individual_use,minimum_amount,email_restrictions
SPRING10,percent,10,2026-05-31,500,yes,25,
VIP-ANNA,fixed_cart,"15,00",,1,no,,anna@example.com
FREESHIP,fixed_cart,0,,,no,40,
VIP-ANNA gets €15 ("15,00" is quoted because the file uses commas), no expiry, one use, and only for anna@example.com.
The quickest way to get a correct file is Download coupons.csv on the import screen: it uses exactly these columns, in this order, with yes/no written as yes and no, dates as YYYY-MM-DD and lists separated by , .
Order columns — Full edition
One row per product line. Rows sharing a reference are one order, and must be next to each other in the file. The order's own fields are read from the first row of its group; later rows only add product lines.
The order
| Column | Meaning | Notes |
|---|---|---|
reference |
Your own id for this order | Required. The order's identity, stored as _gmoi_ref. A file without this column imports nothing. |
status |
Status | processing, completed, on-hold and so on, or a custom status the shop has. A wc- prefix is removed. An unknown status is reported and the order stays in WooCommerce's default status. |
date_created |
Date placed | A date and time, as WooCommerce reads it. |
currency |
Currency | A three-letter code such as EUR. |
customer_email |
Customer email | Saved as the billing email. A Billing Email header is read as this column too. |
payment_method |
Payment method | The gateway id, such as bacs or cod. |
customer_note |
Customer note | Text. |
shipping_total |
Shipping total | Money, set exactly as written. |
order_total |
Order total | Money, set exactly as written. Totals are never recalculated. |
Addresses
| Column | Meaning |
|---|---|
billing_first_name |
Billing first name |
billing_last_name |
Billing last name |
billing_address_1 |
Billing address |
billing_city |
Billing town |
billing_postcode |
Billing postcode |
billing_country |
Billing country (two-letter code, such as GB) |
billing_phone |
Billing telephone |
shipping_first_name |
Shipping first name |
shipping_last_name |
Shipping last name |
shipping_address_1 |
Shipping address |
shipping_city |
Shipping town |
shipping_postcode |
Shipping postcode |
shipping_country |
Shipping country |
For order fields, an empty cell is skipped rather than clearing the field.
Product lines
| Column | Meaning | Notes |
|---|---|---|
item_id |
Item product id | The product or variation id. Used first when present. |
item_sku |
Item SKU | Used when there is no item_id. |
item_name |
Item name | Recognised; the line takes the product's own name. |
item_quantity |
Item quantity | At least 1. |
item_total |
Item total | Money. The line's total and subtotal. Empty means the product's own price. |
A row with neither item_id nor item_sku adds no line — that is normal for an order's first row. A product that cannot be found is reported and left off; the rest of the order is still imported.
On an update, when the file has an item_sku or item_id column, all existing lines are removed and the file's lines are added. A file with neither column leaves the lines exactly as they are, so a file that only corrects addresses is safe to run. An order number is not a column: the order keeps the number WooCommerce gives it, and a file carrying order_number has it listed as not recognised. See How it works.
Sample order file
reference,status,date_created,currency,customer_email,billing_first_name,billing_last_name,billing_country,shipping_total,order_total,item_sku,item_quantity,item_total
SHOP-1001,completed,2025-11-03 10:14:00,EUR,anna@example.com,Anna,Weber,DE,4.95,64.85,MUG-B,2,29.90
SHOP-1001,,,,,,,,,,TEE-M,1,30.00
SHOP-1002,processing,2025-11-04 09:02:00,EUR,li@example.com,Li,Chen,NL,0,19.00,MUG-B,1,19.00
SHOP-1001 is one order with two lines and a total of €64.85. SHOP-1002 is a second order.
Limits
- Rows per run: 500 in the free edition; the How many rows one run may read setting (default 5,000, up to 100,000) in the full edition. Every row counts, including an order's extra product rows.
- Problems listed: at most 200 per run.
