When is a lot too much?

Lot of options for database

[lZakl]

I am building a front end in PHP for a client of mine to:

1) dynamically change the "current stock" page

2) help this person be a little more organized, and be able to electronically track their merchandise.

Now there is not a lot of merchandise moving through this company, maybe 300-400 items per year at most. So the MYSQL database will not be very large. The kicker is building the forms to query the database. I am coming up with a ton of different ways to filter results. By item category, creator, date created, size, sub category ... this list goes on and is getting longer.

My question: Do customers actually use filtering to that extent? I mean at any given time there could be anywhere from 300 - 600 unique items for sale on this site, so to filter them is a good thing, but when does it reach the point where it is too much?

Looking forward to your opinions!

-- Zak

[gettopreacherman]

I don't think there can be too much...usually when you get a lot of choices, make default selections, or a wizard builder, idea being they can choose building blocks for the queries to query what they are looking for.