My client has about 250 schools that all need to buy products from his online store. Each school has specific items from the store that they purchase. Not every school has the same products available.
I want to create a database of all the products and then have the ability to add a new school and simply check off which products they can see when they login. When the school goes to login the shopping cart will only show those products that have been granted access too.
Unless you have a better way to do this, please let me know.
Also all schools will have a sales rep in charge of them. When orders are placed from a specific school I will also need to run reports based on the schools that a sales rep is in charge of.
