CODEWITHSUNDEEP
wordpresscsvimportwoocommerceattributes
Michael Elliott
Michael Elliott

Reputation: 33

Import attributes using CSV with woocommerce

I am importing bulk products via Woocommerce using a .csv file.

Everything works as it should apart from the attribute I am trying to upload.

I am uploading the brand name as an attribute. I currently have the following on my .csv:

Header = attribute:brand

Value = "brand name"

I am not sure if this correct, but even if it is, I'm unsure which fields to map them to?

Thanks in advance.

Upvotes: 3

Views: 15275

Answers (3)

ttt
ttt

Reputation: 6809

The essential columns for importing products with attributes via WooCommerce product importer from CSV:

  • ID (or SKU if you want to update existing products by SKU)
  • Name
  • Attribute 1 name, Attribute 1 value(s), Attribute 1 visible, Attribute 1 global
  • Attribute 2 name, Attribute 2 value(s), Attribute 2 visible, Attribute 2 global

You have to add 4 "columns" for each attribute.

Example of woocommerce-product-import.csv file with empty ID:

ID,Name,SKU,Regular price,Stock,Published,Attribute 1 name,Attribute 1 value(s),Attribute 1 visible,Attribute 1 global,Attribute 2 name,Attribute 2 value(s),Attribute 2 visible,Attribute 2 global,Attribute 3 name,Attribute 3 value(s),Attribute 3 visible,Attribute 3 global
,Audi R8 car metallic black,audibk,271000,21,-1,Soft start,yes,1,0,Bluetooth,yes,1,0,Color,metallic black,1,0

Example of woocommerce-product-import.csv file without ID, just SKU:

Name,SKU,Regular price,Stock,Published,Attribute 1 name,Attribute 1 value(s),Attribute 1 visible,Attribute 1 global,Attribute 2 name,Attribute 2 value(s),Attribute 2 visible,Attribute 2 global,Attribute 3 name,Attribute 3 value(s),Attribute 3 visible,Attribute 3 global
Audi R8 car metallic black,audibk,271000,21,-1,Soft start,yes,1,0,Bluetooth,yes,1,0,Color,metallic black,1,0

Couldn't find an example in the official documentation:

Upvotes: 0

Kenny Hammerlund
Kenny Hammerlund

Reputation: 506

I am assuming you are using WooCommerce import that comes with the default install.

All the documentation is old on this so some of the column headers are bad. At least from my experience. I exported a variable product I made to get the correct column headers.

For attributes you need these columns:
Attribute 1 name | Attribute 1 value(s) | Attribute 1 visible | Attribute 1 global
size | Small, Medium | 0 or 1 | 0 or 1|

You also need to import the parent items first with the column header "type" and the value as "variable"

The next import is the variations which have a "type" of variation

these are two .csv files that I used. if you copy the row headers I believe they have all the values currently used by the importer
http://www.midnighthtml.com/uploads/Final_Swim_225.csv
http://www.midnighthtml.com/uploads/Final_Swim_Child_225.csv

Upvotes: 5

osherez
osherez

Reputation: 99

Not Sure how you are importing via Woocommerce its self?

1.maybe you need a specific keyword rather the "attribute:brand" ( or you can define a different reference)

2.check that all the ranges in the csv are readable by woo-commerce

otherwise try looking for a plugin called 'all Import' works fantastic

Upvotes: -1

Related Questions