Gatemi Order Import FAQ and Troubleshooting

I ran the same file twice. Do I now have two of everything?

No. A coupon is recognised by its code and an order by its reference, so the second run updated what the first run created. The report says so: "… 0 created, 120 updated". If Let an import update … that already exist is switched off, the second run skips those rows instead and lists each one. See How it works.

The report says "The file has no "code" column". It does.

Usually the header is spelled differently, or the file uses a delimiter the first line does not show. Check that:

  • The first line of the file is the header row. The importer always reads line 1 as the header.
  • One of the headers comes out as code once lower-cased with spaces and punctuation turned into _. Coupon code becomes coupon_code, which is not a column. Rename it to code.

The These columns were not recognised line in the report shows exactly how each unknown header was read.

A column I included was "not recognised and left alone".

Its name is not one of the importer's columns. The plugin never guesses — Price is not read as amount, and Allowed emails (which becomes allowed_emails) is not read as email_restrictions. Rename the header to the column name in the CSV format table.

The first column of my file is always ignored.

That used to be the classic sign of a byte-order mark glued to the first header. The importer removes one, so if this still happens, open the file in a text editor and check the first header has no hidden characters or stray quotes.

My amounts came in a hundred times too small, or too big.

Check how the spreadsheet wrote them. The importer reads 1.250,00 and 1,250.00 both as 1250, and 12,50 as 12.50. A cell like 1,25 (one comma, two digits) is 1.25. If your file uses commas as decimal points, make sure the cells are quoted or the file is semicolon-separated, so the comma is not taken as a column break.

Only part of my file was imported.

A run stops after a fixed number of rows: 500 in the free edition, or the How many rows one run may read setting (default 5,000) in the full edition. When it stops with rows left, the report says so first and names the first line that was not read. Split the file there and run the rest. Rows already imported are recognised, so overlapping parts do no harm.

Line numbers in the report don't match my spreadsheet.

Line 1 is the header. The numbers count CSV records, so a cell containing line breaks moves later numbers down compared with a plain text editor. A spreadsheet program shows the same numbering as the report, apart from that.

Why does an order row say "the rows … are not together in the file"?

Full edition. All rows for one reference must be next to each other. Sort the file by the reference column and run it again.

Will importing orders email my customers?

Full edition. It can. Setting an order's status is an ordinary WooCommerce status change, so WooCommerce sends whatever emails it would normally send for that status, and may reduce stock. To avoid that, switch off the relevant emails under WooCommerce → Settings → Emails for the length of the import, or import onto a staging copy first.

My imported orders have no product lines after an update.

Full edition. On an update, a file with an item_sku or item_id column replaces an order's lines with the lines in the file — so an order whose rows in that file have no product is left with none. Re-run a file that includes every order's item rows. A file with neither column leaves the lines alone. (Versions before this fix also emptied the lines when the file had no item columns at all.) Totals are not affected; they stay what the file said.

Why doesn't the order total match the lines?

Full edition. Because the importer never recalculates totals. The total is the order_total from the file — what the customer actually paid at the time. That is deliberate: an old order recalculated from today's prices and tax rates would no longer be the order that happened.

Does it work with HPOS?

Yes. Both editions declare compatibility with High-Performance Order Storage, and orders are read and written through WooCommerce's own order functions, so it works with either order storage.

Does it change my storefront or checkout?

No. Nothing is added to the shop, the cart or either checkout. The plugin is one admin screen.

I have both editions installed.

The free edition stands down while the full edition is active and says so in a row under its entry on the Plugins screen. Deactivate the free edition. Your settings are kept — both editions use the same gmoi_settings option, and the same coupon columns, so a file that works in one works in the other.

Is my uploaded file stored anywhere?

No. The file is read from PHP's temporary upload location during the request and is never copied into uploads/. Nothing is kept after the run.

What does uninstalling remove?

  • Full edition: its settings, its licence state and its update cache.
  • Free edition: its settings, but only if the full edition has never been set up on the site; otherwise it leaves them for the full edition.
  • Neither removes a coupon or an order it imported, or the reference saved on an order. Imported coupons are ordinary WooCommerce coupons.
Shopping Cart
Scroll to Top