Filter products by “custom attribute”

  • Resolved alexisprr

    (@alexisprr)


    4 years, 5 months ago

    Hi guys,

    I imported my products from a CSV I made, where I have my product name, description, etc. + two columns for “Attribute name” and “Attribute value”.

    The import is doing great, no problem, but the value of my attributes don’t show in my product filter.
    Screenshot here: https://tinyurl.com/yaljy5eq

    It’s showing the few attributes values I manually added in the back-office (“Products >> Attributes”) but not the attributes value imported from the CSV.

    The imported attributes appear in the product page (screenshot: https://tinyurl.com/yb77p3qh) and in the “Additional information” tab but not in the product filter.

    Could you help me? Maybe it is because the values of the attributes are “custom/unknown”?

    Thanks for your help!

Viewing 7 replies - 1 through 7 (of 7 total)
  • Luminus Alabi

    (@luminus)

    Automattic Happiness Engineer

    Hi @alexisprr,

    Product filters will only work with Global Attributes i.e. attributes created at Product → Attributes. They will not work with custom attributes.

    I’d recommend following these steps:

    • Create the attributes you need
    • Assign them to some of the products
    • Export all of your products to a CSV document
    • Update all of your other products by following the format laid out in the ones you already assigned attributes to
    • Import your products, making sure to select Update existing products

    You can learn more about product attributes here – https://docs.woocommerce.com/document/managing-product-taxonomies/#section-6.

    The relevant information concerning updating existing products is here – https://docs.woocommerce.com/document/product-csv-importer-exporter/#section-6

    Thread Starter alexisprr

    (@alexisprr)

    Hi,
    Thanks for your answer!

    Import your products, making sure to select Update existing products

    Does it mean that I have to create each product manually before importing my CSV? If yes, what the point of using a CSV? I have hundreds of products so I’m afraid I have to deal with the CSV, I can’t do it manually.
    Thank you again

    Plugin Support RK a11n

    (@riaanknoetze)

    Does it mean that I have to create each product manually before importing my CSV?

    No – That checkbox only means that it will check for and *update* products that are already on the site (whether those were loaded in a previous CSV import or created manually). That settings checks for matching IDs or SKUs, if it’s found then the product is updated. If it’s not found, it’ll create a new product.

    Thread Starter alexisprr

    (@alexisprr)

    Alright, thanks for your answer! But I’m not sure if I get the point.
    I already did this export to find the way to make the perfect “CSV” and import it correctly.
    The problem is that my “individual attributes” are not showing in my product filter, since I didn’t write it in my “global attributes”.

    Thread Starter alexisprr

    (@alexisprr)

    Hello,
    I tried but I still can’t figure out why it doesn’t work.
    Any help?
    Thank you very much in advance!

    Luminus Alabi

    (@luminus)

    Automattic Happiness Engineer

    @alexisprr,

    The product filter ONLY shows global attributes. That’s expected behaviour.

    If you want to be able to filter by a specific attribute, you MUST make sure that it is a global attribute.

    AJ a11n

    (@amandasjackson)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Filter products by “custom attribute”’ is closed to new replies.

Tags