CSV Import Variation Products Won’t Import

Do you have the Parent field? Tells the importer the SKU of the product they are variables of

I do have the “parent” column. The ID’s in that column are the same as the SKU’s, do you think that’s ok or do they have to be unique? Here are the columns I have:

sku parent name type Attribute 1 name Attribute 1 value(s) Attribute 1 Global Attribute 1 Visible post_content ID published menu_order stock regular_price weight tax_class sold_individually visibility in catalog reviews_allowed purchase_note stock_status backorders manage_stock tax_status upsell_ids Cross-sells featured images categories tags

Thanks for answering!!

Just to make it easier to read I’ll put commas between the values, it had tabs before I entered it ??

sku, parent, name, type, Attribute 1 name, Attribute 1 value(s), Attribute 1 Global, Attribute 1 Visible, post_content, ID, published, menu_order, stock, regular_price, weight, tax_class, sold_individually, visibility in catalog, reviews_allowed, purchase_note, stock_status, backorders, manage_stock, tax_status, upsell_ids, Cross-sells, featured, images, categories, tags

This is what I use:

Type,SKU,Parent,Position,Name,Categories,Description,Short description,Attribute 1 name,Attribute 1 value(s),Attribute 1 global,tax status,Tax class,Regular price,weight,In stock?,Tags,Images
variable,team201,,1,TEAMNAME CC Velocity L/S Shirt,Cricket Teamwear->TEAMNAME CC,,,size,”xxs, xs, s, m, l, xl, 2xl”,1,taxable,standard,40.5,0.75,1,teamwear-name-initials,
variation,team201-xs,team201,,TEAMNAME CC Velocity L/S Shirt – XS,,,,size,xs,1,taxable,standard,40.5,,1,,
variation,team201-s,team201,,TEAMNAME CC Velocity L/S Shirt – S,,,,size,s,1,taxable,standard,40.5,,1,,
variation,team201-m,team201,,TEAMNAME CC Velocity L/S Shirt – M,,,,size,m,1,taxable,standard,40.5,,1,,
variation,team201-l,team201,,TEAMNAME CC Velocity L/S Shirt – L,,,,size,l,1,taxable,standard,40.5,,1,,
variation,team201-xl,team201,,TEAMNAME CC Velocity L/S Shirt – XL,,,,size,xl,1,taxable,standard,40.5,,1,,
variation,team201-2xl,team201,,TEAMNAME CC Velocity L/S Shirt – 2XL,,,,size,2xl,1,taxable,standard,40.5,,1,,

So you have each variation of a product on a different line? I had it like that when I was trying out a different importer, but when I tried the one built into WordPress I thought the info I read was that it could all be on one line. For instance this would be the data in the type, attribute name and attribute value fields, all in one row:

variation
Size
Small,Large

This is based on the sample data in the WooCommerce plugin folder.

You are using the Import button in the All Products page aren’t you?

Actually I’m using the Import link under Tools. I believe it’s the import that is packaged with WordPress. Maybe it’s the same import, just another way to get to it?

No – the one under All Products is WooCommerce specific.

I just went there, and it ends up being the same importer. When you go through Tools, you then have to choose “Import products to your store via a csv file”. It gets to the same place. But, I didn’t realize that the variations need to be on different lines, I think that’s what I’m doing wrong. I will fix it for my test file and let you know! Thanks!!

Ok, so let’s say I have two variations, one small and one large. Would I have a main row with the name and description and all the base info, and then two more rows with SKU-S and SKU-L, for instance? And have the same parent ID for them? So three rows total for a product with two variations? Or just two rows total, repeating the name, description, etc?

Yes that’s right 3 lines – also make sure that you have TYPE field correct:

variable for the main product
variation for the two sizes

Each size will also need a price even if they are all the same

Ah, ok! This explains a lot! And I can just repeat the name and description and all that?

Yes, you can just repeat the name – but I usually add the size after it to make it easier to read when I’m bulk editing products.
You only need to repeat the description if you want it to change when the variation is selected – otherwise leave it blank and the main product description will be used.

I also repeat the tax details and stock status.

Woohoo, it’s working, thanks so much! At first it was just importing the products and not actually showing the variations, but it’s because in the parent product I didn’t put “Small, Large” in the Attribute Name. I fixed that and the options are now showing! Thank you soooooo much! I can finally move on to stocking my store ??

Glad you got it sorted!