Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
4230 Zobrazení

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.


Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
1
čvn 22
4694
0
úno 21
2079
2
srp 25
1626
1
čvn 25
719
2
kvě 25
1320