woocommerce product csv attribute import question

  • Resolved tdemelle

    (@tdemelle)


    8 months, 3 weeks ago

    I’m running into an issue importing product data in using the basic import function at the top of the product page.

    I’m trying to import a google sheets csv the fields of which were created from labels in a product export.

    After import, I see the attributes show up in my product data looking like this…

    Which looks correct, but these are not the same as the existing attributes of the same name as you can see from this pulldown.

    I am able to add and populate the existing attribute which looks like this alongside the imported attribute of the same name:

    Is there a way to format the CSV to ensure that the attribute data comes in correctly using the existing attribute instead of creating an alternate of the same name?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @tdemelle,

    There could be a few reasons why the import function does not match the attributes correctly. One common issue is the formatting difference between the CSV file and the existing attributes in WooCommerce.

    To ensure that the attribute data comes in correctly using the existing attribute instead of creating an alternate of the same name, you need to match the column names in your CSV file with the exact slug of the attribute in WooCommerce. For example, if the slug in WooCommerce is “color”, the column name in your CSV should also be “color”.

    This should ensure that the imported data matches the existing attributes correctly. If you’re still facing issues, please let us know, and we’ll be happy to assist you further.

    Are your Attributes Global or Custom? https://woo.com/document/managing-product-taxonomies/#product-attributes

    If you are importing them as Custom attributes then they are applied only to that product – Global attributes are the same for every product and should be updated when you import mew products.

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘woocommerce product csv attribute import question’ is closed to new replies.