Variable products need a parent listing and a clear relationship to each available option. A shirt in five sizes and three colors may have many combinations, but each variation must use consistent attributes, SKU, price and stock details. If the source sheet treats every combination as an unrelated simple product, customers may not get a usable selector.
Define attributes first
Choose attribute names and values that are consistent across the catalogue. Decide whether an attribute is visible on the product page and whether it is used for variation selection. Confirm which combinations actually exist; do not create an option just because a spreadsheet cell is blank.
Map parent and child rows
Use the importer’s expected parent reference and unique identifiers. Check that each child variation points to the correct parent and that images, prices and stock are assigned to the intended combination. Test representative products with different numbers of options.
Review the sample in the storefront on mobile and desktop before importing everything. Check out-of-stock behavior, variation images and price changes. If the catalogue data is inconsistent, clean it first. A test import and backup are safer than repeatedly importing into production and trying to remove duplicates afterward.
Written by Code Papa, an independent WordPress developer based in the UAE with 15 years of experience.