I'm using one SQL database for a retail site and a wholesale/trade site, both selling the same products for the same business. The problem I have is that I don't want all my retail products to show in the wholesale/trade store as I don't get enough discount on some products to sell them to the trade. I know you can put products in a separate category and set login levels so retail customers can't see the trade prices, but this isn't good for trade customers as the products are all in one category and it doesn't look great.

I would like to suggest that store products have two "Display Product" tick boxes, one for retail and the other for wholesale/trade. If this is possible, it would enable a product to be visible or hidden for both retail and wholesale/trade customers.

This would make it easier to run both types of store with neat and tidy category and product pages.

Regards

Mike

Using ECT since 2003.