Variation groups are a way to represent relationships between products within your catalog, and you can bulk import them!
In order to create a variation group, each product must already be assigned to the same category (browse node). Additionally, each product must also have at least one common attribute assigned, each with a unique value. The common attribute is what will be varied on, and is required by Jet in order to create a list of options to display to the end user. Again, the category and attribute values must be assigned to each product prior to importing variation groups.
This method isn't as easy as using the GUI due to having to reference Jet's taxonomy spreadsheet. to pull their internal category Id and attribute values.
You can download an example csv here: Example Import Variations CSV
|1||SKU||An identifier from your catalog which represents the product. This sku will become the master of the variation group.|
|2||Relationship||The relationship type. Please set this value to: "Variation" for every row.|
|3||Variation Refinements||A comma-delimited list of attribute id's that are shared between all sku's within the variation group. Be sure to encapsulate this column within double quotes when using multiple values.(").|
|4||Children Skus||A comma-delimited list of product sku's within your catalog. The listed product will become members of the variation group. Please remember that each
of the listed products must have the same category id, at least one common attribute id and a unique value for the defined attribute. For example, if you are varying on the color attribute, each
listed product must have the color attribute listed with a different color value.
Be sure to encapsulate this column within double quotes when using multiple values.(")
|5||Group Title||The name of the variation group. For example, if this group is varying on the color attribute, set the group title to "Color"|
How to find variation refinement Ids
- Go here: Jet's taxonomy spreadsheet
- On the spreadsheet tab "Categories", find the category you want to put your product in by referencing the columns "L0 Node Name", "L1 Node Name" and "L2 Node Name". L2 Node Name is the bottom category that the product will appear within.
- Write down or copy the value from the "L2 Node ID" Category to your clipboard. This is your Browse Node Id (Category Id) that tells Jet which category you want your product to appear within.
- Next, click the "Category-Attribute Mapping" tab. Using Ctrl (or command) + F in your web browser, search for the selected category id. If this is one of the attributes assigned to your product, copy the value from the "AttributeID" column. This value is used within the "variation refinements" column in the bulk import spreadsheet.
Main Window & Dashboard