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
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.
Column | Description |
---|---|
sku | The Configurable Product's SKU |
_super_products_sku | Your Variation (Simple Product) SKU |
_super_attribute_code | The Attribute Code you are using for this variation such as size or color. Please check your Attributes for the appropriate code. |
_super_attribute_option | The 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.
Updated over 1 year ago