No products for attributes

  • Hello.

    My problem:
    Filters by attributes have no products, although they are exist.

    I had no problems, but then I updated WooCommerce to the latest version and found this error. Then I tried to downgrade to WooCommerce 3.4.2 (“tested up to”) and 3.1 (my previous version), but no result – problem still exists.

    I read about it:
    https://products-filter.com/filtering-by-product-attribute-doesn-work/
    and i can confirm, that all points from there is fulfilled:
    1. Archieves are enabled.
    2. Types is ‘Select’
    3. Names of terms use only ‘_’, no ‘-‘
    4. Tried to press again – nothing changed.

    Note: When I enable “Try to ajaxify the shop” to “Yes”, then after first AJAX dynamic recount works right, but when reloading page – then again zeros for all attributes.

    My settings:

    Set filter automatically: No
    Autosubmit: No
    Show count: Yes
    Dynamic recount: Yes
    Hide empty terms: No
    Try to ajaxify the shop: No
    Hide childs in checkboxes and radio: No
    Hide woof top panel buttons: No

    The page I need help with: [log in to see the link]

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

  • Hello

    You use paid(very old) version. Please write on envato support( use contact form ) – https://codecanyon.net/item/woof-woocommerce-products-filter/11498469/support

    Thread Starter Iks Menu Support

    (@iksent)

    Sorry, I had install this version only to check if problem exist with it. Just take a look again at site, I am using the latest free version.

    You will see zeros for categories, then try to change for example price range, and dynamic recount will change values to non-zeros.

    Hello

    Clear all cache.

    Thread Starter Iks Menu Support

    (@iksent)

    I have no caching plugin. Where should i clear cache?

    I tried to clear cache in “Advanced” > “Options”, but it didn’t work for me also.

    Thread Starter Iks Menu Support

    (@iksent)

    I enable debug mode: Here it is:

    [Unknown column 'price_query.price' in 'order clause']SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (16,631,632,633,634,635,638) AND tt1.term_taxonomy_id IN (1644) ) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY price_query.price > 0 DESC, wp_posts.post_date DESC

    Thread Starter Iks Menu Support

    (@iksent)

    Just understand, that it is my filter code ruins your plugin:

    add_filter('posts_clauses', 'order_by_stock_status', 50, 2);
function order_by_stock_status($posts_clauses) {
    global $wpdb;
    // only change query on WooCommerce loops
    if (!is_admin() && is_woocommerce() && (is_shop() || is_product_category() || is_product_tag() || is_product_taxonomy())) {
        $posts_clauses['orderby'] = "price_query.price > 0 DESC, " . $posts_clauses['orderby'];
    }
    return $posts_clauses;
}

    Excuse for troubling.

    Hello

    Ok

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘No products for attributes’ is closed to new replies.