Filter Specifications

As regular readers will know, I made a couple of addons recently that do a good job, namely “Product Specifications” and “Manufacturers Filter“.

Both of these work well, and so I wanted to take the next step and combine the two ideas together, so that a shopowner can;

1. Add specifications to products
2. Filter product listings by specifications

So, I set out to do that. In the following examples, assume that there are two Specifications per product; Spec 1 and Spec 2. A product could be both of these, none of these or one of these. There is no real limit to the number of specifications per product, other than usability for the shop owner and the potential buyer.

When a user is on a category listing and that listing has any products with specifications, this box shows;

This box only appears if any of the products in the category being viewed has at least 1 specification.

Next up was to build some SQL that gets the result of the filtering and outputs the filtered list;

With those two smallish changes in place, the system seems to work really well. This is a good way for the customer to be able to filter product listings to better get the product they are looking for.

Also, the codebase was written so that the usual osCommerce sorting mechanism still works (eg, sort by price, name and so on).

In action

For the future

A way to filter based on multiple specifications; show me products within category X that have both Specification 1 and Specification 3, but not Specification 2.

4 Replies to “Filter Specifications”

  1. Hello Gary,
    I’m trying to achieve the same searching way (type->brand->cubics, …)as this website:http://sifam.fr/product.php
    I think what you’ve done is something really interesting to achieve that.
    Can you by chance tell me if it could be actually working for what I want to do?
    Thanks in advance and keep it up !

  2. Hi Sebastien – the filter is based on specifications that the shopwoner can add to products. It’s very good for example adding “good for” things to a product, eg; this product is good for rabbits, guinea pigs. Now the buyer can filter products in the category if they own a guinea pig. Hope it makes sense?

  3. Thanks to this post I finally got what I was looking for…. I wanted to use this addon on oscommerce 2.3.4 for dividing my products under selected categories into casual and formal section- Can you give me the link to the addon that accomplishes the above you explained.. Thank you in advance!!

Leave a Reply

Your email address will not be published. Required fields are marked *