Importing attribute not working

  • Resolved MiKeZZa

    (@mikezza)


    5 years, 9 months ago

    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

    and some this way:

    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.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Kel C. a11n

    (@kellymetal)

    5 years, 9 months ago

    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:

    attributes
    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!

    Thread Starter MiKeZZa

    (@mikezza)

    5 years, 9 months ago

    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…..

    Plugin Support Kel C. a11n

    (@kellymetal)

    5 years, 9 months ago

    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
    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!

    Thread Starter MiKeZZa

    (@mikezza)

    5 years, 9 months ago

    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

    (@kbassart)

    Automattic Happiness Engineer

    5 years, 8 months ago

    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

    (@m155y5)

    Automattic Happiness Engineer

    5 years, 8 months ago

    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.