Common Errors and Troubleshooting (WooCommerce)

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

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.

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).

Quick diagnostic checklist

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