Importing Variations Tips and Tricks

When importing from CSV (Excel), there are a few tricks to entering variations. First, the variation name goes on the first line, with each variation following on its own line. Thus, if one of your variations is color, the first line would be the variation called “color” and the following lines would be the actual colors.

Each variation (color, size) needs to be in a separate column (in the example below, we have added color and size.

One of the most important aspects is the Parent SKU. The parent SKU should not be entered in the first row where you are adding your variation values, such as color and size, but should be included in child row.

Here’s a breakdown of the above illustration.

1. These are column headers that are part of the downloadable CSV import template (hint: do not change the top row by removing any columns and don’t change the order). There are 5 variation columns. So, when you import you can have up to 5 variations (size, color, pattern, etc).
2. The variation names (size, color, patterns) do not have a “parent” SKU. The SKU for the “parent” row is entered in the SKU column of your template.
3. The first line should be your variation names (size, color, pattern, etc).
4. The child values should be entered on the lines immediately following the variations. These are the actually sizes, colors, patterns, etc.
5. There should always be a parent SKU for any of the child values.

When you are using terms like parent, child, values, variations, it can be confusing. The trick is to remember the first line you enter is the names of your variations.

When entering the additional data, the parent line (the first line) contains all the other info about your product EXCEPT fields that are different variation to variation. For example, if I was entering a different price for each variation, I would leave the parent price blank, and enter the price for each item.

I know that this might sound difficult. It’s actually one of those tasks that sound so complicated until you actually do it and then you wonder why you ever thought it was going to be hard.

If you have your items in a spreadsheet, importing them to Vendio is really very fast and easy, despite how it sounds!!

Happy Selling!!

Leave a Reply