chiefwes Posted December 29, 2004 Posted December 29, 2004 I would like to add the following: A drop down box that allows a customer to sort my products by either TYPE or SEASON. After selecting one of the options, a list of categories would then be displayed. TYPE would have all the types (cards, books, decorations, etc.) of products I sell. SEASON would have all the products I sell sorted into their season (Valentine, Easter, etc). Basically, the drop down would reference separate tables in the database. I would need to have a new category table and a new products to category table. All the other tables could remain the same (I think). Any ideas on how to create these two views? I can create the drop down and the tables without a problem, but the function calls for each is where I am stumped. Check out my store at: www.shackman.com to get an idea of what I would like. I have the current site set for product types and would like to add the season view. Wes
Guest Posted December 31, 2004 Posted December 31, 2004 I have products appearing in multiple categories. It is the same product, but the setup will allow you to copy the item to several categories from the admin panel. You could set up subcategories split by type and season. The items remain the same and inventory is tracked accurately for the item since you're not making new items. In my case it is to offer some of my vines by a status of Native instead of the usual genus and species categories. I hope this helps!
dblake Posted December 31, 2004 Posted December 31, 2004 You can modify your search feature to add in those two new fields, season and type. Then take it a step further and sort that listing by the type or season, by books or christmas. Which ever you want. You could then sort it by christmas books. I think you see what I am getting at.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.