Linking Existing Variations To Configurable Products

Step 1: Define Variation Attributes and Click "Link Products"

The Variations section of the Configurable Product Edit Screen has a "Link Products" button.

📘

You must define Variation Attributes before simple products can be linked.

Step 2: Find and Select Products To Link

Clicking the "Link Products" button will open a window and load any simple products from your catalog that have values set for the custom attributes assigned to the configurable product.

From here, you can select, or multi-select and add these products to your Configurable Product as Variations.

Step 3: Save the Configurable Product

Products will not be linked until you click "Save" on the Configurable Product.


Verify Your Products Exist And Have The Correct Attributes

Both your Configurable Product and the Variation Product (Invisible Simple Product) must exist prior to linking via CSV.

Note in the screenshot below how each Variation already has the appropriate Size & Color

Variation Link Import Template

This file will contain 2 guides and 2 templates. The Variations Guide will let you import new Simple Products You only need to use Link Template if your variations already exist as simple products.

  • Link Guide - This tab will provide requirements and tips for each column in the template.
  • Link Template - This tab will contain the column headers for you to copy/paste your data into.

👍

Click Here to Save A Copy of This Template to your Google Drive

Or click here to download the Link Template as CSV

🚧

Variation Attribute Options Must Exist

In order for the import of variation options (i.e. Size = S,M,L etc...) the options themselves must exist in your Zoey Store prior to running the import.

Verify the options exist in Products>Attributes

Columns

As this CSV is only dealing with the association of simple to configurable products, you will only need the following columns in your CSV.

ColumnDescription
skuThe Configurable Product's SKU
_super_products_skuYour Variation (Simple Product) SKU
_super_attribute_codeThe Attribute Code you are using for this variation such as size or color. Please check your Attributes for the appropriate code.
_super_attribute_optionThe Attribute Option (i.e. Small, Medium, Large, or Red, Blue, Black)

Import

From your Zoey Admin, go to Import & Export > Import Products

Use the following settings:

  • Entity Type = Products
  • Import Behavior = Append Complex Data

Then select your import file, click "Check Data" then run the import.

If you have followed these steps correctly, your Configurable Product's Variation Section will look something like this (see below).

🚧

Re-Index & Refresh Required

Often after running imports you may need to Flush Cache and Re-Index (from the "Refresh" menu in the blue sidebar) to see your changes live. to see your changes live.