Community Add-Ons
Add file to this packageHide products from groups of customers
for osCommerce Online Merchant v2.2
This contribution allows to hide products from different customer groups. It's written for B2BSuite and work on B2BSuite0.92
Currently it's in beta status as there are some issues.
Originally this contribution was developed by Stonez Chen, so all credits goes to him. I only made some small changes to code to make it work.
Original code can be found here:
http://forums.oscommerce.com/index.php?showtopic=104149&hl=
Currently there are two issues with this code:
1. The code works good with existing products but generates error when you create new product as it requires product_id which is not yet set for new product.
2. Once you set any product invisible for any groups - it becomes invisible for not logged in users forever. Even if you make it visible for all groups for not logged in users it still be invisible, you may make it visible for not logged-in user only through editing directly the database. Making visible/invisible for groups - there is no problems.
For detailed descriptions of issues please see todo.txt in archive.
Support thread is: http://forums.oscommerce.com/index.php?showtopic=119927
Alexander
Download 
Report
Help needed, i think this should be the SQL file.
But there are a few problems. Can someone please CORRECT this if its wrong.
There is also no other contribution to hide product for NON-logged users. This is the only solution at this time. If someone can correct the ID problem this module will work correctly.
Credits goes to originall author