I need to develop/ change something so that each customer logs in and see's their own prices for each product. We are talking about 250 products and 250 customer base, so nothing too huge. Can anyone please advise me on the approach I need --- I was going to have a new table customprice with customers_id, products_id, customdiscount(%), customprice . In admin have an area that you can select the customer and product show the default price (as set up when setting new products) and then discount (customdiscount % from default price) show the new customprice (discount range would be from 0-30%).
The customprice table would be updated. The prices would be hidden until a customer logs in and at this point they would see their customprices, they would then go through the placing of an order seeing their customprices per product.
I realise that there is lot of work in this, but would appreciate any guidance apart from forget it I need to do this. Thanks
Bookmarks