Hello, I need to display different product availability based on customer's pricelist:
I have these entries in my DB:
P1 (Default price: 1€)
P2 (Default price: 2€)
P3 (Default price: 3€)
PL1 containing P1 at 3€ and P2 at 5€
PL2 containing P3 at 10€
C1 associated with PL1
C2 associated with PL2
What I need to have is:
When C1 log and navigate to the store, he must see P1 at 3€ and P2 at 5€, with P3 hidden/unavailable.
When C2 log and navigate to the store, he must see P3 at 10€, with P1 and P2 hidden/unavailable.
What actually happens:
When C1 log and navigate to the store, he sees P1 at 3€, P2 at 5€ and P3 at 3€.
When C2 log and navigate to the store, he sees P1 at 1€, P2 at 2€ and P3 at 10€.
I was thinking about a custom field (override available in website) into my pricelist model in the databse, but this means that every product must be inserted into every pricelist, instead, what I need is that every customer would be able to see only product in his pricelist, with every other product hidden/unavailable.
Thanks for the help.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 8/12/15, 7:47 AM|
|Seen: 340 times|
|Last updated: 8/12/15, 7:47 AM|