Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Add-On for a filter navigation menu


Stefany

Recommended Posts

I am looking for an add-on that will be able to "create" sort of a filter navigation menu on the left side of the website which lists the products' attributes as parameters for the user to search.

The store is selling kids' clothes.

Please note that the store has over 15,000 products, so the add-on must be able to somehow "fetch" the data that is already written, i.e. adding attribute data somewhere will be impossible.

 

Here is an example of what I want - http://i61.tinypic.com/2njlpn9.jpg

 

 

 

 

I searched and searched the web and could not find what I wanted, please fellows, help!

 

Thank you!

Edited by Stefany
Link to comment
Share on other sites

product specifications can re-use product database fields, perhaps you can trick it even more with database views.

I use it on my site

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

Product Specifications will handle the filters, but it isn't designed to take the data directly from the product attributes. That would require some custom code, or maybe just some SQL to copy the values over to the specifications.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

On one of my sites I have added a view for the products table to only select a subset of products on the catalog side ie TABLE_PRODUCTS is v_products which is defined in the database as a (readonly) view

create view v_products as select * from products where manufacturers_id in (1,2,3)

I wonder if the same could be applied to products_specifications

so that TABLE_PRODUCTS_SPECIFICATIONS maps to v_products_specifications with a view like this pseudo code, or even join in additional columns to have the specification name etc

create view v_products_specifications
as select products_id, specification_id, language_id, value
from products_specifications
union
select products_id, attributes_id, language_id, attribute_value
from products_attributes

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

You'll need a bit more SQL to select the correct specifications. I don't see any reason why that would not work.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

Thank you for the recommendations, guys. I installed Product Spesifications, but this error appears now in the product listing:

1146 - Table 'oscom.table_products_to_documents' doesn't exist
select count(*) as total from TABLE_PRODUCTS_TO_DOCUMENTS where products_id = '27'
[TEP STOP]

 

Please help!

Link to comment
Share on other sites

Thank you for the recommendations, guys. I installed Product Spesifications, but this error appears now in the product listing:

1146 - Table 'oscom.table_products_to_documents' doesn't exist
select count(*) as total from TABLE_PRODUCTS_TO_DOCUMENTS where products_id = '27'
[TEP STOP]

 

Please help!

 

Error was fixed, I just disabled the " Show Documents Tab " in the add-on's admin panel option.

 

Now can you please tell me how to show the filter menu in my store using this add-on? Thank you !

Edited by Stefany
Link to comment
Share on other sites

This add-on comes with a very complete user manual, read that doc, and then come back if you still have questions !

and I'm a user, so you can see it working eg pots and pans on keukenlust dot be site

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

This add-on comes with a very complete user manual, read that doc, and then come back if you still have questions !

and I'm a user, so you can see it working eg pots and pans on keukenlust dot be site

 

 

Does it work with attributes as well? Like 2 red shirts, 2 blue shirts?

Link to comment
Share on other sites

As kymation said in post 6 , it does not by default, the point I made is that I think you can fit it in if you wanted to but it does need work to do that.

Why not ask in the product specification development thread this question, some more people might notice and perhaps someone has made this extension, or is interested enough to join forces ...

I personally don't use attributes, so this is not on the top of my todo list ...

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

@@Stefany

 

Unfortunately, I don't think there is any drop-in solution available for what you need.

 

I have coded something like this up a while back where the filters were created based on what attributes were available on the currently being viewed items. Reviews and price were also included as filters. The nice thing was that we didn't have to do any extra database work or backend work. The sql code does get really in depth though on the listing.

 

The product specifications mod will probably work as well if you want to deal with a more complex / robust system and can figure out how to tweak it to your needs. Either way it will probably take some trial and error to sort it out.

Matt

Link to comment
Share on other sites

Thank you guys for the help, I installed http://addons.oscommerce.com/info/5997 because it is for attributes, and now I will tweak to become a filter, in a way.

If the store didn't have so many attributes, Product Specifications would have helped.

Good catch, didn't know it existed

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...