Importing attribute not working

Hi there,

The difference between your two attributes is that one is using a global attribute (added under Products > Attributes) which can be added to multiple products, and the other is using a custom product attribute (added to just that one product).

If you want it to work like in this example, then you should re-add the attribute to the product by selecting it from the list:

Link to image: https://d.pr/i/Hk2zoY

If you wanted to try importing it, you would need to make sure your CSV file follows the schema described here:
https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting

https://docs.woocommerce.com/document/product-csv-importer-exporter/

It would need at least 2 lines: one for the column headers, and one for the product/values.

I hope that helps!

I’m sorry @kellymetal. I really don’t understand what to do. How do I make 2 rows of it? https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting is talking about ‘column name’ but when a column name is given to the second column it can’t hold name and value I guess?

So how do I have to split my file when I have this:

ID Attribute 1 Name Waarde eigenschap 1
3874 Aantal spelers 2

I can’t imagine and way to have it working with 2 columns. Maybe it’s a little dumb, but I can’t find any example and the URL gives nice documentation for what you can do when you are started. But when you don’t know where to start…..

Hi there,

When I say it would need at least 2 lines (rows), I am referring to something like shown below, so that the headers are all in one row, and then products are on rows below… As you mention, it wouldn’t have the name and value in a single cell — they would be on separate rows:

Link to image: https://d.pr/i/PWafps

There’s an example sample_products.csv file here that you can take a look at:
https://github.com/woocommerce/woocommerce/tree/master/sample-data

I hope that helps!

But in the example file they are doing this:

Id …….. Attribute 1 name Attribute 1 value(s)

So that is 1 line per product. And with an header it makes 2, indeed. But then you have this, right?

ID;Attribute 1 name;Attribute 1 value(s)
4109;Aantal spelers;1

That is what I’ve tried, but doesn’t work…

Am I wrong?

Hi there,

You’ll want to follow the example provided above by the previous agent. If that isn’t working for you, I’d recommend creating the product manually, then exporting it into a CSV. Then you can see exactly how the multiple attributes are added on each sheet and the replicate that for your remaining imports.

We haven’t heard back from you in a while, so I’m going to go ahead and mark this thread as resolved. If you have any other questions please feel free to start a new thread.