Hi all, I have a design based company and need a solution to managing products. We have 100 product sku's and this may be organized into 5 sample books, that we sell. Owning a sample book, upgrades your pricelist based on all the SKU's within the sample book.

- Some SKU's may be in book 1 & 2 & 3

We also have customer classes / Pricelists called Silver, Gold and Platinum.

If you're in silver and purchase Book 1, then any SKU purchases from Book 1 automatically gives you the Gold pricelist. If you're gold, then you get platinum. If you haven't purchased book 2, then anything from book 2 (apart from SKU's that also is in book 1) you'll get the rate according to your own pricelist (if you're gold, you get gold rates)

How can this be done?