Creating Variation Listings on WooCommerce Using a Spreadsheet

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

What we'll cover:

  1. Creating Parent and Child Products in Solid Commerce
  2. Sample Template
  3. Related Articles


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.

See Listing Variations on eBay for more information.

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.


Sample Template


Related Articles


Back to top

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request



Article is closed for comments.