This article covers how to add a new pivot attribute to a product group that already exists — for example, a group that currently only varies by Size, where you now also want it to vary by Color.

If you haven't created the product group yet, start with How to Create and Manage Product Groups instead. For background on what a pivot attribute is, see the glossary in Product Group Management on Zentail.

To add a pivot attribute to SKUs that are already grouped, import using the special field Add Pivot Attribute. The value you enter is the attribute's database name — all lowercase, with underscores instead of spaces.

Example import file:

Every SKU in the same product group should get the same value in this column, since a pivot attribute applies to the group as a whole, not to one SKU individually.

If the SKU doesn't already have a value for that attribute, include it in the same import as its own column (for example, a separate Color column with each SKU's actual color) so Zentail has a value to pivot on.

This is the most common mistake: the column header is Add Pivot Attribute, written normally, but the value you put under it must be the lowercase, underscore-separated database name of the attribute (color, size, display_height, etc.), not the human-readable label you see elsewhere in Zentail (Color, Size). You can look up the exact database name for any attribute in the Zentail Data Dictionary.

You can also set pivot attributes without an import: