Price Displayed From EcomProducts (instead of EcomPrices)

E-mail notifications

Lora Vigil

Posted on 15/08/2022 18:55:42

Example 1 (good): When product variant prices differ in EcomPrices (e.g. one variant = $123.23 and other variants = $159.99), the correct price range is shown on the PLP/Product List page & on the initial load of the PDP/Product Detail page. This is driven by EcomPrices.PriceAmount records and works as expected.
- PLP:
- PDP:
Example 2 (bad): However when all product variant prices are the same in EcomPrices (e.g. all variant prices = $159.99), the price shown is the variant parent record EcomProducts.ProductPrice (e.g. $1 for this example), which is not correct. We need the value to be driven by EcomPrices and should display $159.99 in this example.
- PLP:
- PDP:
Our solution must support different prices for customers and price records for different customer groups exist in EcomPrices. Therefore we cannot display the price from the singular EcomProducts parent record as there will not be a singular price for all customers, even if all variants are priced the same as described in the second example.
How can we consistently display values from EcomPrices, whether variants have different or same price?

Replies

Morten Snedker

Posted on 16/08/2022 10:51:29

Hi Lora,

Please see my walk-through-example here: https://www.screencast.com/t/tVIoxDVe. So, in my example it works just fine. Maybe I have some different settings than you.

BR
Snedker

Lora Vigil

Posted on 16/08/2022 21:58:27

Hi Snedker,

Thank you for sending, I believe you are seeing the same behavior - your parent product is showing $100 from EcomProducts and your three color variants (red, blue, yellow) all have the same price and show $150 from EcomPrices. Our customer has many variants and will only show the parent product, not individual variants, on the list page. However the problem is that the parent product pulls prices from EcomPrices conditionally and we need to always display pricing from EcomPrices (not from EcomProducts).

I hope this screencast helps, along with my walkthrough below!

https://www.screencast.com/t/mh7Itso4hUP

1) The parent product and 3 variants all have a $1.23 price in EcomProducts. (This value should not be displayed in our solution because our user groups have different pricing)

2) The variants have price records in EcomPrices - EcomPrices maintains the correct pricing for our solution. We have several EcomPrices records for each variant that are associated to different User Groups (please note: the backend UI does not currently display the group name, but I am checking the 3 price records in the video that are applicable to my user: $69.99, $69.99, & $60.00)

3) On the front end I correctly see a range of $60.00-$69.99 on list & detail pages from EcomPrices. (GOOD!)

4) I change the $60.00 price to $69.99, so all three variant prices are $69.99 in EcomPrices.

5) Now on the front end, list & detail pages show $1.23 from the EcomProducts table. (BAD - pages should show $69.99 from EcomPrices which is what we need to resolve. Why would the EcomProducts price display when variant EcomPrices are the same?)

6) I show data from EcomProducts & EcomPrices in SSMS, so you can see $1.23 is only in EcomProducts (not in EcomPrices).

7) Change one of the variant $69.99 prices to $69.98 so the three variant prices are different again in EcomPrices.

8) Now the list & detail pages show the range of 69.98-$69.99 from EcomPrices (GOOD)

Morten Snedker

Posted on 17/08/2022 08:29:54

Hi Lora,

Can I please have you send me an email, so I have your email-address. Then I will reply and give you access to my test solution, from where I would like for you to reproduce the problem.

You can reach me at msn@dynamicweb.dk.

BR
Snedker

You must be logged in to post in the forum

Developer forum

Price Displayed From EcomProducts (instead of EcomPrices)

Replies