Skip to main content

How to import configurable products

Import configurable products into Elovate by mapping variation attributes and linking simples to their parent in one file.

Updated over a week ago

Elovate supports importing configurable products with one compact file. You list the simple products (the variations) and a single parent row. During mapping, you tell Elovate which attributes build the configuration and which parent each simple belongs to.

You can use our templates to get started quickly:


1) Prepare your file

Include at least the following columns:

  • sku

  • name

  • price

  • config_attributes (sometimes shown as config_attr)

  • parent_product

  • Variation attributes (e.g., size, color)

  • qty

  • stock_status

Example

sku

name

price

config_attributes

parent_product

size

color

qty

stock_status

simple-001

Simple product 1

99.95

config-001

M

Green

99

1

simple-002

Simple product 2

99.95

config-001

L

Green

99

1

simple-003

Simple product 3

99.95

config-001

M

Blue

99

1

simple-004

Simple product 4

99.95

config-001

L

Blue

99

1

config-001

Configurable prod

99.95

size,color

What the columns do

  • config_attributes (parent row only): Lists the variation attributes (e.g., size,color) used to build the configurable.

  • parent_product (simple rows only): Tells Magento which configurable the simple SKU belongs to (e.g., config-001).

  • Variation attributes (size, color): Provide the actual option values for each simple.


2) Create the import job

  1. Go to Apps → Import → Add new import job.

  2. Upload your file (CSV/Excel) or select your Google Sheet.

  3. Choose the target store view and other job settings as needed.


3) Map your columns

In the mapping step:

  • Map config_attributesConfigurable Option (in Elovate).

  • Map parent_productParent Product.

  • Map your variation attribute columns (e.g., size, color) to the corresponding Magento attributes.

  • Map remaining fields such as name, price, qty, stock_status, etc.

Ensure the attributes you list in config_attributes (e.g., size, color) exist in Magento and are connected to the attribute set used for these products.


4) Validate, then import

  1. Click Validate to let Elovate check the file and mappings.

  2. If validation passes, open the job, review the preview, and click Run Import.

  3. Monitor progress in Import Status and confirm in Magento when done.


Notes and tips

  • config_attributes defines which attributes build the configurable. These must be present on the products’ attribute set.

  • If an option value is missing (e.g., a new size or color), add it first or use Elovate’s “add attribute option with import” flow.

  • If the file uses supplier-specific headers, align them via mapping so they land on the correct Magento attributes.

Did this answer your question?