Creating Variation Listings on WooCommerce Using a Spreadsheet

cruz galvez

May 10, 2022 19:41

This article shows how to create a variation listing for WooCommerce.

What we'll cover:

Creating Parent and Child Products in Solid Commerce

Creating WooCommerce variations is similar to making eBay variations. You will need to create parent and child items inside of Solid Commerce.

Variation Fields	Field Descriptions and Valid Values
mystore parent sku	The Parent SKU ties the all of the variation items together into one listing. Assign the Parent SKU to every item in the variation.
mystore options template	The name of the product attribute(s) to create variations for. Attribute names are separated with two colons (::). This field isn't case sensitive. You only are only required to enter the option template name for the parent item. However, populating the option template name for your child items too is fine. EXAMPLE: Size::Color
Variation Product Attributes	For the actual variation attributes such as Size and Color fill out each skus row with its attribute. For the parent sku row make sure to include all the possible variations options and separate each option with double colon. Ex. In the screenshot below there are to types of variations and two variation types per variation. For size there is two sizes medium “M” and large “L” and for color “Orange” and “Black”. The top row is the parent sku row.