1
vote
1answer
353 views

How to make a table structure for products to be available for both wholesale and retail? [closed]

Ignoring the different column details like colors, shapes, and sizes, I already have an idea of dealing with that, I'm more interested in dealing with retail pricing, whole pricing (with or without a ...
3
votes
3answers
219 views

What is an efficient way to retrieve product counts at multiple levels of a hierarchy?

I'm working on an e-business website to sell books and also want to display the number of available books in the category list. The category list contains the genre and the format (pocket, ebook, ...