Search Attributes for WooCommerce
This plugin allows you to extend wordpress search feature by searching into Woocommerce product attributes.
Overview
Compatibility
Installation instructions
Customer support & learning resources
Changelog
Main benefits
Search by attribute names
Supports color and brand
Requires WooCommerce installed
May affect search speed
About this plugin
Author: Aslam Doctor
Categories: E-commerce
Version: 1.3.4
Last updated: 29-12-2023
WordPress version: 4.6
Tested up to: 6.4.5
PHP version required: 7.4.0
Languages:
Tags:
Learning resources: View resources
Overview
Search Attributes for WooCommerce is a versatile WordPress plugin designed to enhance the product search functionality in WooCommerce by allowing searches based on product attribute names. For example, users can effortlessly find products by searching for specific color names or brand names if those attributes are assigned. This plugin ensures a more dynamic and refined shopping experience by providing attribute-based search capabilities. It is essential to have WooCommerce installed and activated to utilize this plugin. Users are advised to select attributes judiciously, as the inclusion of numerous attributes may impact search speed. Additionally, developers are encouraged to contribute by fixing bugs or adding new features through the plugin’s GitHub repository, adhering to the provided CONTRIBUTING.md guidelines.
Enhanced Product Search
- Allows searching products using attribute names like color or brand.
- Improves user experience by making it easier to find specific products.
Compatibility with WooCommerce
- Requires WooCommerce to be installed and activated.
- Seamlessly integrates with existing WooCommerce setups.
Customizable Attributes
- Enables selection of specific attributes for search functionality.
- Allows for tailored search experiences based on chosen attributes.
Open Source Contribution
- Encourages community contributions via GitHub.
- Provides guidelines for fixing bugs or adding new features.
Features list
Feature
Premium version
Unlimited site
Access to an unlimited number of websites.
Lifetime Updates
Receive updates for the product for its entire lifetime.
Lifetime Support
Get support for the product for its entire lifetime.
Pricing
In some cases companies have different prices based on various components like a location. As a result the prices displayed here can differ from the ones you see on their websites.
See all pricing optionsRating and reviews
denizutku
23 Mar, 2024
Its Cool…
tanduf
27 Nov, 2023
Great plugin !
Very easy to configure and use.
Allows searching on hidden attributes of products. Exactly what i was looking for.
Long life to this plugin.
linascp
04 Jan, 2023
Very good, does the job.
Danny
01 Jul, 2022
I use PolyLang for translation. With this plugin, search result shows product with all different languages.
sajetek
31 Dec, 2021
Great and straightforward plugin.
It does what I needed mostly so I just modified it a bit to exclude products where variation of the searched attribute is out of stock.
e.g. If I search for Medium in a shirt, the product must NOT show if medium of that product is out of stock.
function wsatt_brands_where( $where = '' ) {
global $wpdb;
$product_ids = get_in_stock_IDS();
if($product_ids != "")
$where .= " OR $wpdb->posts.ID IN (".get_in_stock_IDS().")";
return $where;
}
function get_in_stock_IDS() {
global $wpdb;
$parent_ids = array();
$wsatt_attributes = @get_option('wsatt_attributes');
if(is_array($wsatt_attributes) && count($wsatt_attributes)>0){
foreach($wsatt_attributes as $attribute){
$parent_id_objects = $wpdb->get_results("SELECT $wpdb->posts.ID
FROM $wpdb->posts
LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
LEFT JOIN $wpdb->terms ON($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id)
WHERE $wpdb->posts.post_type = 'product'
AND $wpdb->posts.post_status = 'publish'
AND $wpdb->term_taxonomy.taxonomy = '$attribute'
AND $wpdb->terms.name LIKE '%".esc_attr( $_GET['s'] )."%'");
if(count($parent_id_objects) == 0) continue;
foreach($parent_id_objects as $parent_id_object) {
$children = get_option("_transient_wc_product_children_".$parent_id_object->ID);
if(is_array($children) && count($children['all']) > 0) {
$instock = $wpdb->get_var("SELECT s.meta_value as stock from $wpdb->postmeta LEFT JOIN $wpdb->postmeta as s ON s.post_id = $wpdb->postmeta.post_id AND s.meta_key = '_stock' WHERE $wpdb->postmeta.post_id IN (".implode(",", $children['all']).") AND $wpdb->postmeta.meta_key like '%".$attribute."' AND $wpdb->postmeta.meta_value LIKE '%".esc_attr( $_GET['s'] )."%' AND s.meta_value > 0");
if($instock != NULL) {
//Child is matched based on query string and stock is NOT zero so we add that parent id to be displayed
$parent_ids[] = $parent_id_object->ID;
}
}else {
$parent_ids[] = $parent_id_object->ID;
}
}
}
return implode(",", $parent_ids);
}
}
This topic was modified 2 years, 7 months ago by sajetek.
This topic was modified 2 years, 7 months ago by sajetek.
This topic was modified 2 years, 7 months ago by sajetek.
This topic was modified 2 years, 7 months ago by sajetek.
