We have an online gifting portal where there are specific gifts that can be delivered to cities/countries . We want to model our zencart interface just like hotel booking portals where products can be seen depending on the location chosen . Making specific categories for each city is not possible as there are many cities and overlapping products(like couriered products can be delivered all over but each city has specific hand delivered products etc) . We plan to add this information in a seperate fact table or can be discussed . Once a location is selected the user can narrow down the choices by category name or some attribute . Please choose "study options" on [url removed, login to view] or see [url removed, login to view] .
Zencart experts preffered and please pm your portfolio / any similar work done before .