Gatemi Order Import CSV Format

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.
Shopping Cart
Scroll to Top