Title: Importing attribute not working
Last modified: July 26, 2020

---

# Importing attribute not working

 *  Resolved [MiKeZZa](https://wordpress.org/support/users/mikezza/)
 * (@mikezza)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/importing-attribute-not-working/)
 * I have an attribute at my products. The strange thing is that I have some of 
   the products displayed this way:
 * [https://ibb.co/dbj8Nqq](https://ibb.co/dbj8Nqq)
 * and some this way:
 * [https://ibb.co/fMG1FKn](https://ibb.co/fMG1FKn)
 * I’ve tried to import a file to solve this, but I can’t get it working. What I’ve
   done now is made a CSV with 1 line:
 * ID;Naam eigenschap 1;Waarde eigenschap 1
    4109;Aantal spelers;1
 * I was expecting that this is good, but it isn’t because of that the value stays
   like on the first image. The import wizard does recognize the correct fields,
   but nothing changes. What can I do to make this work?
    -  This topic was modified 5 years, 9 months ago by [MiKeZZa](https://wordpress.org/support/users/mikezza/).

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Plugin Support [Kel C. a11n](https://wordpress.org/support/users/kellymetal/)
 * (@kellymetal)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/importing-attribute-not-working/#post-13173499)
 * 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](https://ibb.co/fMG1FKn), then you
   should re-add the attribute to the product by selecting it from the list:
 * ⌊attributes⌉⌊attributes⌉
    Link to image: [https://d.pr/i/Hk2zoY](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://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting)
 * [https://docs.woocommerce.com/document/product-csv-importer-exporter/](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!
 *  Thread Starter [MiKeZZa](https://wordpress.org/support/users/mikezza/)
 * (@mikezza)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/importing-attribute-not-working/#post-13177122)
 * I’m sorry [@kellymetal](https://wordpress.org/support/users/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](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…..
 *  Plugin Support [Kel C. a11n](https://wordpress.org/support/users/kellymetal/)
 * (@kellymetal)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/importing-attribute-not-working/#post-13179057)
 * 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:
 * ⌊CSV⌉⌊CSV⌉
    Link to image: [https://d.pr/i/PWafps](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](https://github.com/woocommerce/woocommerce/tree/master/sample-data)
 * I hope that helps!
 *  Thread Starter [MiKeZZa](https://wordpress.org/support/users/mikezza/)
 * (@mikezza)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/importing-attribute-not-working/#post-13179562)
 * 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?
 *  [Kenin](https://wordpress.org/support/users/kbassart/)
 * (@kbassart)
 * Automattic Happiness Engineer
 * [5 years, 8 months ago](https://wordpress.org/support/topic/importing-attribute-not-working/#post-13257757)
 * 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.
 *  [Missy a11n](https://wordpress.org/support/users/m155y5/)
 * (@m155y5)
 * Automattic Happiness Engineer
 * [5 years, 8 months ago](https://wordpress.org/support/topic/importing-attribute-not-working/#post-13305401)
 * 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.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Importing attribute not working’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

 * 6 replies
 * 4 participants
 * Last reply from: [Missy a11n](https://wordpress.org/support/users/m155y5/)
 * Last activity: [5 years, 8 months ago](https://wordpress.org/support/topic/importing-attribute-not-working/#post-13305401)
 * Status: resolved