Custom Field Filtering Not Finding Products

  • Resolved rosstrottier

    (@rosstrottier)


    2 years, 4 months ago

    Hello!

    So, after updated a few thousand products with custom fields, I installed the plugin. The filters show up on the shop browsing page without issue, and the filters also show the number of products found in parenthesis. So, the filter plugin is certainly working until that point.

    The problem is, when I click or activate the filter, it just says products not found in the product grid.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter rosstrottier

    (@rosstrottier)

    Ok, update!

    If I go in to each product, and MANUALLY hit update, the filter now works for them…

    however I have like 1500 posts to do this for.

    Is there some way to automate this? Do you all know why this behavior is happening?

    Thread Starter rosstrottier

    (@rosstrottier)

    UPDATE #2:

    It appears as if my issue is the following:

    When updating ACF field data via the wordpress rest API, the lookup table for the product is not regenerated. So, by going to WooCommerce Status -> Tools -> Lookup Tables and clicking Regenerate, the issue should be resolved.

    I will post here later on the results.

    I’m very interested in a solution here since I have the same problem.
    Thanks for posting

    Thread Starter rosstrottier

    (@rosstrottier)

    Ok I have solved the issue.

    The lookup tables are not updated until you update the product in the admin. This is a HUGE PAIN, but has nothing to do with the actual sorting filter. It is more of an issue with ACF.

    So, what I did was did bulk updates on all the products, 20 at a time, without changing any information. After doing this, the filters work great!

    Hope this helps anyone with the same issue!

    Plugin Author stepasyuk

    (@stepasyuk)

    Hello @rosstrottier

    Thank you for using Filter Everything plugin.

    Indeed, a filter gets all its values (terms) directly from products, but not from ACF field options. So if you update your ACF for example Select field with new options, you will not see them, until you set them in appropriate products. I hope this also will be useful for users.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Custom Field Filtering Not Finding Products’ is closed to new replies.