Common Errors and Troubleshooting (WooCommerce)

This guide covers the WooCommerce import errors and failure patterns that appear most often in Import WP support tickets. See the WooCommerce importer.

Not enough permissions to create / update record

Meaning: Import WP found (or did not find) a matching product based on your unique identifier, but the Permissions step does not allow that action.

Situation	Fix
New SKU in file, Create disabled	Enable Create, or remove new rows from an update-only feed
Existing SKU matched, Update disabled	Enable Update
Unique identifier wrong so every row looks “new”	Fix unique identifier (usually Product SKU) so updates match
Field restrictions block the whole write	Relax Update field allow/deny lists

Full guide: Update Existing WooCommerce Products and Permissions.

No Unique fields present

Meaning: Permissions is set to use a template field as the unique identifier, but that field is empty/unmapped for the row (or not available).

Fix:

1. Map Product SKU (or GTIN) on every row that should match.
2. On Permissions, select Product SKU / GTIN only after those fields are mapped.
3. Ensure the SKU column is not blank for update rows.

Duplicate products

Usual causes:

• Unique identifier not set, or changed after the first import
• Matching by name/title instead of SKU
• Create enabled while identifier never matches (different SKU formatting, spaces, case, prefixes)
• Parents and variations incorrectly sharing identifiers

Fix: pick one stable key (SKU or GTIN), normalise values if needed with a snippet, and re-run with Update enabled.

Variation / attribute errors

“Please, provide an attribute name.”

Attribute Name is empty on a Product Attributes row. Map the name or remove the empty row.

“Variation cannot be imported: Missing parent ID or parent does not exist yet.”

• Parent not imported yet
• Advanced → Parent not mapped
• Parent Field Type does not match the value (e.g. using Sku type with a name value)

Variations import but options missing in WooCommerce

• Parent missing Used for variations? = Yes
• Parent does not list all terms
• Is Global? mismatch between parent and variation
• Attribute name spelling differs between rows

See Import Variable Products and Variations and Import Product Attributes.

Invalid or duplicate SKU

WooCommerce requires unique SKUs. If the feed reuses a SKU already on another product (or another variation), saving fails.

Fix:

• Ensure each simple product, variable parent, and variation has a distinct SKU
• Search Products for the conflicting SKU
• Do not reuse a parent SKU on variation rows

Images not importing

Check in order:

1. Can the server download the URL? (browser success is not enough — firewall/SSL may block the server)
2. Is the field mapped under Product Gallery (or Images & Attachments)?
3. Is Is Featured? set when you expect a main image?
4. Do Update permissions allow gallery fields?
5. Are timeouts occurring on large image sets?

See Import Product Images and Galleries.

Categories not importing or wrong hierarchy

• Taxonomy row uses the correct taxonomy (product_cat)
• Hierarchy enabled with the correct character (>)
• Delimiter for multiple categories is correct
• Update permissions allow taxonomy fields

See Import Product Categories and Taxonomies.

Sale price or stock not updating

1. Unique identifier matches existing products.
2. Update is enabled.
3. Price/stock fields are mapped and not excluded by field restrictions.
4. For stock quantities, Manage Stock? = Yes.
5. For variations, price/stock are mapped on variation rows, not only the parent.

Import stuck, timeout, memory, or 524

WooCommerce + images is resource-heavy.

• Raise PHP memory_limit and max_execution_time
• Reduce concurrent image downloads / avoid re-downloading every run
• Split parents and variations into separate importers
• Check host/proxy 524 gateway timeouts on long requests
• Review import history for the last successful record

Scheduled import fails but manual works

Almost always cron / server runtime related — see Schedule WooCommerce Product Imports.

CSV preview / inconsistent number of fields

Error similar to: Inconsistent num of fields, header: X, this line: Y

• A row has unescaped commas inside quoted fields
• Wrong delimiter / enclosure in file settings
• Mixed line endings or truncated downloads from URL/Sheets

Fix the CSV structure or adjust importer file settings (delimiter, enclosure, encoding).

Customer import issues

• Duplicate customers — unique identifier is not Email (or Username), or the identifier changed after the first run.
• Role is shop manager / subscriber — map Role to customer, or leave Role unmapped (the template defaults new accounts to customer).
• Addresses missing in WooCommerce — map Billing Address / Shipping Address on the WooCommerce Customers template, not only First Name on Customer Fields. Country must be a two-letter code (GB, not United Kingdom).
• Customers received new-account emails — Enable customer notification emails was on. Leave it off for migrations.

See Import WooCommerce Customers.

Order import issues

• No unique identifier value present — map Order Key (preferred) or enable Order ID for existing store orders. Order ID cannot be used to create an order with a chosen number.
• Line items missing — product SKU does not exist yet (import products first), Product Field Type does not match the value, or you used one CSV row per line item. Line items must live on the same order row; later rows with the same order key replace items.
• Guest orders / no customer on the order — Customer lookup (email / username / ID) did not match a user. Import customers first, or accept guest orders and still map billing email.
• Customers emailed about imported orders — Enable order notification emails was on. Leave it off for historical imports.
• Totals look wrong — map Order Total from the source if you must preserve the paid amount; otherwise leave it empty so WooCommerce calculates from line items.

See Import WooCommerce Orders.

Quick diagnostic checklist

1. Template is WooCommerce Products, WooCommerce Customers, or WooCommerce Orders (not a generic Post or User template).
2. Product Type values are correct (simple, variable, variation, …).
3. SKU mapped and selected as unique identifier for product updates.
4. Customers: Email mapped as unique identifier.
5. Orders: Order Key mapped as unique identifier; products and customers imported first.
6. Permissions Create/Update match your intention.
7. Variations: parent exists, Parent mapped, attributes named, Used for variations = Yes.
8. Images: reachable URLs + Product Gallery mapping.
9. Categories: taxonomy row + hierarchy settings.
10. Manual run works before enabling schedule.