Hello, I need to display different product availability based on customer's pricelist:

I have these entries in my DB:

Products:

• P1 (Default price: 1€)

• P2 (Default price: 2€)

• P3 (Default price: 3€)

Pricelists:

• PL1 containing P1 at 3€ and P2 at 5€

• PL2 containing P3 at 10€

Customers:

• 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.