Problem with Volume Price Display - changes with basket contents

[edco]

Trying to get volume pricing to display correctly on the prod page.

Problem: Volume pricing seems to display correctly until you add the product to the basket. After you add the product to the basket, the volume price on the product page appears to be calculated from the discounted price based on the volume of products in the basket and not the base price. This results in prices being displayed that are too low. The correct price is always shown in the basket. The displayed discount also seems incorrect (see below) as the numbers don't seem to make much sense.

I am guessing/hoping we are missing something simple but just don't know where to look. Any help is appreciated.

Background and information:

Current Miva 9 store using a ReadyTheme and the built in Volume Pricing through Price Groups.

After much frustration and searching, finally found this thread "http://extranet.miva.com/forums/showthread.php?114658-Marketing-gt-Specific-Sale-Price/page2&highlight=checkbox+price" which give some information on how to do the display.

Added the following code to the prod display (taken directly from other thread).

< h3>
Price:
<span id="price-value-additional" style="text-decoration: line-through">
<mvt:if expr="l.settings:product:base_price GT l.settings:product:price">
&mvt:product:formatted_base_price;
</mvt:if>
</span>
&nbsp; &nbsp;
<span id="price-value" class="bold">&mvt:product:formatted_price;</span>
<div id="product-discounts"></div>
< /h3>

< div id="product-discounts">
<mvt:foreach iterator="discount" array="product:discounts">
<div class="product-discount">&mvt:discount:descrip;:&nbsp; &mvt:discount:formatted_discount;</div>
</mvt:foreach>
< /div>

Example with Actual Results:

Price Group Name: Test Volume Discount
Pricing Table in Price group:
Quantity Type Amount
5 Fixed 2.00
10 Fixed 4.00
15 Fixed 6.00

--Product display with 0 of this product in basket:
Price: $10.00
Quantity Price
1-4 $10.00
5-9 $8.00
10-14 $6.00
15+ $4.00


--Product display with 4 of this product in basket:
(base price of $10.00 is struck through)
Price: $10.00 $8.00
Test Volume Discount: $10.00
Quantity Price
1-4 $8.00
5-9 $6.00
10-14 $4.00
15+ $2.00


--Product display with 5 of this product in basket:
(base price of $10.00 is struck through)
Price: $10.00 $8.00
Test Volume Discount: $2.00
Quantity Price
1-4 $8.00
5-9 $6.00
10-14 $4.00
15+ $2.00


--Product display with 14 of this product in basket:
(base price of $10.00 is struck through)
Price: $10.00 $4.00
Test Volume Discount: $34.00
Quantity Price
1-4 $4.00
5-9 $2.00
10+ $0.00


--Product display with 15 of this product in basket:
(base price of $10.00 is struck through)
Price: $10.00 $4.00
Test Volume Discount: $6.00
Quantity Price
1-4 $4.00
5-9 $2.00
10+ $0.00

[Eric Foresman]

Re: Problem with Volume Price Display - changes with basket contents

Do you have the “Display Predicted Discounts” checkbox checked for the prod page?

[edco]

Re: Problem with Volume Price Display - changes with basket contents

Do you have the “Display Predicted Discounts” checkbox checked for the prod page?

Thanks for the reply,

Display Predicted Discounts is checked. We had to turn this on the get discounts to show on the product page so assumed it need to be on.

Went back and tested turning it off and the volume pricing seems to work correctly now; however we do not get the discounted price or the discounts to display.

We would really like to get the discounted price to display with volume pricing as we often apply discounts to products with volume pricing. It seems that we can use multiple price groups to achieve what we want and get the correct price in the basket, we just can't get the display to work correctly on the product page.

[edco]

Re: Problem with Volume Price Display - changes with basket contents

Do you have the “Display Predicted Discounts” checkbox checked for the prod page?

Thanks for the reply and sorry if this ends up being a double post, forum logged me out when I clicked the submit button.

Display Predicted Discounts is checked. We had to do this to get discounted prices and discounts to display on the product page. We assumed it needed to be on. Went back and tested with it turned off and the volume pricing appears to work correctly; however now we don't get the discounted price or discounts displayed.

We often apply discounts to products with volume pricing so would like to get this working. It seems that we can get what we want using multiple price groups and it works correctly for price in the basket, we just can't get the display write on the product page.

[Brennan]

Re: Problem with Volume Price Display - changes with basket contents

See response #20 on this thread:

http://extranet.miva.com/forums/show...amically/page2

[edco]

Re: Problem with Volume Price Display - changes with basket contents

See response #20 on this thread:

http://extranet.miva.com/forums/show...amically/page2

Thank you for pointing out this post. This does fix the problem with the volume price table.

I still do have the problem with the displayed discounts not being correct. Look back at the original post with the displayed discount for 4 items in basket ($10.00) and 5 items in basket ($2.00). It seems to calculate correct for all cases except where the volume in the basket is one less than the next volume break. When the volume in the basket is one less than the next volume price break - the displayed discount make no sense to me at all.

Thanks again for the help

[Eric Foresman]

Re: Problem with Volume Price Display - changes with basket contents

Hi edco

In those cases what you are seeing is the accumulated total discount from re-pricing all of that item in the basket.

Example:
Product1 has a price of $2.00 and a volume price table with a 10% discount starting when 5 of product1 is in the basket.
Adding product1 to the basket 1-4 times will not display any predicted discount, but once you have 4 in the basket the predicted discount will be displayed showing you that if you add one more of prodcut1 to the basket you will save $1.00. [ (10% of $2.00) x5 =$1.00 ]

Now that you have the $1.00 discount applied to your basket when you go to add #6 of product1 you will only see the predicted discount of $0.20 because that’s all the more discount you will qualify for by adding 1 more to the basket.

Hope this helps

-Eric