Search by attributes option!!

Sorry and huge apologies if other people have answered this question, but have been trawling the forum since this morning and can not find an answer :no:

I would like people to be able to search by attribute options. I have a number of colour attributes: red, green, orange etc etc and would like people to be able to search for products by JUST this option and nothing else.

I feel pretty sure it's out there somewhere, but I sure as hell can't find it, and I thought it might be easier to ask :smile:

I've seen the question asked many times, but never seen a positive answer.

Looking at the code, I wouldnt say it's impossible, but you will have to write the whole search logic for it.

I've found a copy that do a paid plugin called XAttrib search:

http://www.zencartconsulting.com/index.php?option=com_content&task=view&id=20&Itemid=32

Does anyone know anything about this?? Is it any good and does it work well???

I'm no coder, but I think there must be a way to add an &attrib=green to the search string, or whatever the variable is for attributes?

I know I've probably oversimplified it, but would adding the attribute bit on the end work?

pharqall:

I've found a copy that do a paid plugin called XAttrib search:

http://www.zencartconsulting.com/index.php?option=com_content&task=view&id=20&Itemid=32

Does anyone know anything about this?? Is it any good and does it work well???I don't have experience of this specific module, but recognize the company as that which has registered itself with SourceForge as the "Zen Cart Team" available for Zen Cart work, despite having absolutely nothing to do with the Zen Cart project. I'll let you judge for yourself how trustworthy they are. Attachment #3355

I'm looking for the same option...

Since nobody was able to help me, or even to reply me, about my multi part products, I'm planning to place different generic products as the base, and have the attributes available for them. But the search will be a problem...

pharqall:

I've found a copy that do a paid plugin called XAttrib search:

http://www.zencartconsulting.com/index.php?option=com_content&task=view&id=20&Itemid=32

Does anyone know anything about this?? Is it any good and does it work well???

I just bought and installed this mod but I have 2 problems with it. Maybe someone will be able to help me out to resolve these issues:

1: The attribute dropdowns are dynamic which means after selecting the first dropdown option, the second dropdown gets relatively populated. This causes the entire page to reload which is kind of annoying if you have a long page.

2: If you've installed any kind of "SEO URL" modules, you will get an error: "404 page not found".
Here is an example of a URL before selecting an attribute dropdown:

domain-example.com/shirts/vneck-c1.html

and here is the same URL after selecting the first attribute dropdown option which causes the error:

domain-example.com/shirts/vneck-c1.htmlindex.php?&att_name_id=4

The 2nd issue is resolved when I disable the SEO URL add-on but I for sure want to keep the SEO URL mod.

Other than that, it seems to be working fine.. Any inputs as to how resolve these issues would be grately appreciated.

Fireflyz, can I see your site with the module installed? My company is thinking about buying the same one, we are curious how it looks/works...

emptywalls:

Fireflyz, can I see your site with the module installed? My company is thinking about buying the same one, we are curious how it looks/works...

emptywalls, I uninstalled it because the same issues I mentioned above. They refunded my money quickly and said it would not work with any SEO URL mods. Here is the screenshot on the site where I bought the mod:

http://xmodules.com/index.php?main_page=product_info&cPath=16&products_id=18

I have written a module called attribute filter which let you filter the products in certain category by multi attributes (say: color, year, model, make,....)

But since it was written for someone, Im not sure if he wants me to post it ^_^

Fireflyz:

I just bought and installed this mod but I have 2 problems with it. Maybe someone will be able to help me out to resolve these issues:

1: The attribute dropdowns are dynamic which means after selecting the first dropdown option, the second dropdown gets relatively populated. This causes the entire page to reload which is kind of annoying if you have a long page.

2: If you've installed any kind of "SEO URL" modules, you will get an error: "404 page not found".
Here is an example of a URL before selecting an attribute dropdown:

domain-example.com/shirts/vneck-c1.html

and here is the same URL after selecting the first attribute dropdown option which causes the error:

domain-example.com/shirts/vneck-c1.htmlindex.php?&att_name_id=4

The 2nd issue is resolved when I disable the SEO URL add-on but I for sure want to keep the SEO URL mod.

Other than that, it seems to be working fine.. Any inputs as to how resolve these issues would be grately appreciated.

I had the same issues but i was able to fix the SEO URL problem and make it so that it doesnt have to refresh the page to populate the second box. It will just take a little javascript coding and some php but its fairly easy. If you need a hand, just PM me.

I can search the zen_products_attributes for ID's of all the size XX shoes with the following:

$query = "SELECT products_id FROM zen_products_attributes WHERE options_values_id= '$Size'";
$Size_result = @mysql_query ($query);

while ($row = @mysql_fetch_array ($Size_result)) {

print $row["products_id"];
print " - ";

How can I use these results to display the catalog items?

I am trying to integrate the search by attribute options into advanced search! I have added a new product option type just for search, the attribute's options of this type will never be showed on the front-page for use.

I you have any suggestion, please send to me or leave message on my blog.

I have had some success, in the last few days I successfully modified my Zen cart to filter by one attribute using a sidebox & modified database & index_filter page.

Currently trying to create a PHP or MySQL Function to filter by more then one attribute.

It’s messy and will take some time turn into a reliable modification to share online.

If anyone knows more about how to help let me know my challenge is as follows:

After grouping option_names using a new table, I simply created a new field in the category table linking to the option_group-id.

The side box simply shows drop down menu of the options for each category and post back into the index file.

With modification to index filters; using a left join on product attributes table you can successfully filter the contents of category using a single option.

I now need to create PHP function (if they can be exected inside an SQL Statement, which is unlikely) or MySQL Function as follows

SELECT p.products_id, pa.options_values_id FROM products AS p RIGHT JOIN products_attributes AS pa ON p.products_id = pa.products_id WHERE (((p.products_id)=24) AND ((pa.options_values_id) In (2,7,9)));

By returning the & comparing the number of attribute matches you know if it meets your search criteria.

By adding this into the normal $listing_sql statement it should work.

If anyone can help, let me know.

Success works for up to nine attributes (tested up to 3).

visit www.ogzstore.co.uk; the Gadgets -> Science to see in action.

If there enough demand will make it into a mod to download.

Phillip; I don't see your a Gadgets > Science category on your web site? Did you get this working?