Search by attributes option!!

Quote:

---

Originally Posted by 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?