PREFLIGHT CHECK

WooCommerce variation Parent and SKU checker

Check WooCommerce variation rows for duplicate SKUs, missing Parent references and missing attribute values before import.

Check file

＋Choose CSV fileTap/click to choose. Drag and drop also works on desktop.

Analysis stays in your browser; the file itself is not sent to BlueprintLab.

What this tool checks

Check WooCommerce variation rows for duplicate SKUs, missing Parent references and missing attribute values before import.

What it cannot verify

Live service-side state, account-specific settings, remote server reachability and current master data are not asserted. Always prefer the latest official service information.

How to use this tool

Check WooCommerce variation rows for duplicate SKUs, missing Parent references and missing attribute values before import.

Use Try sample to inspect the included sample.
Set ＋ Choose CSV file Tap/click to choose. Drag and drop also works on desktop..
Use Check CSV to process the input.
Compare the result with your source data and return to the input to make corrections.

＋ Choose CSV file Tap/click to choose. Drag and drop also works on desktop.: .csv,text/csv

Input and settings example

Type,SKU,Name,Parent,Attribute 1 name,Attribute 1 value(s)
variable,tshirt,T-Shirt,,Size,"S, M"

When variations do not appear, start with Parent and SKU

A WooCommerce variation row attaches to its parent through `Parent`. A blank Parent, duplicated variation SKU, or missing attribute value can leave you with a CSV that parses but does not create the variants you expected.

This checker focuses on variation rows and reviews Parent, SKU, Name, and Attribute 1 together.

Parent can be a SKU or `id:100`

The core WooCommerce CSV accepts the parent product SKU or a product ID prefixed with `id:`. If you mean an ID, using `id:100` avoids ambiguity with a numeric SKU.

The checker can catch malformed `id:` syntax, but it cannot prove that the referenced parent exists in your live store.

A blank variation SKU is not always an import failure

WooCommerce can generate an SKU when omitted, but unique SKUs make updates and troubleshooting much safer. The checker therefore warns on a blank variation SKU and errors on duplicates.

Name is part of the required core schema, so a blank variation Name is treated as an error.

Parent and variation rows use attributes differently

The variable parent can list values such as `S, M`, while each variation row carries its specific value such as `S`. A variation with an attribute name but no value cannot identify the intended variant cleanly.

Test one parent and a few variations before scaling the same pattern to the whole catalog.

Go one step deeper

Five checks before a bulk CSV import →