Volume Discount and product attributes with Price

[Ron Frigon]

I'm seeing some really strange behavior in my testing. Maybe a bug in Suivant or V9?

I have an item with volume pricing and 2 attribute options with a price. If only the volume price or the option price comes into play it works fine. But when you combine the 2 it seems to break.

http://dts2172.mivamerchantdev.com/p...ponent_01.html

I have an item for $100, 10+ is $90. 2 options are $1 each, 2 options are $2 each.

If I choose 10 the price should be $900, add Option A +$2 and Option B +$2. The price should be $900, + $20, + $20; $940 right?

In the cart it's showing Volume Discount of $140, should be $100. Subtotal is $860, should be $900. One of the options is listed in the sutotal column, the other is not. It's just not calculation correctly at all...

basket.jpg

If anyone from Miva needs a closer look I'll pm you access to the dev site.

[Ron Frigon]

Re: Volume Discount and product attributes with Price

Seems to be an issue with Priorities and Eligable Discounted Products. I'm seeing different results depending what the settings are. I must have something that overlaps.

[Ron Frigon]

Re: Volume Discount and product attributes with Price

I've removed all other discounts, price groups, so only the one price group is assigned to this one item. Still seeing broken results. I won't touch anything until someone has a chance to look at it...

[hmendenhall]

Re: Volume Discount and product attributes with Price

I've removed all other discounts, price groups, so only the one price group is assigned to this one item. Still seeing broken results. I won't touch anything until someone has a chance to look at it...

Hey Ron

I select opt 3 for option A and opt 6 for option B
and added 10 to my cart
Here are screenshots of my results

Screen Shot 2014-12-30 at 2.12.37 PM.jpg

Screen Shot 2014-12-30 at 2.12.12 PM.jpg

[Ron Frigon]

Re: Volume Discount and product attributes with Price

That looks like the same results that I got, but it's not right.

The $860 subtotal should be $900, Volume discount should be $100 not $140. Opt3 and opt6 should be subtotal $20 each.

Cart Subtotal should be $940.

Something is amiss... Unless I just can't see the forest through the trees?

[Ron Frigon]

Re: Volume Discount and product attributes with Price

I've tried many different scenarios, even switched frameworks. This has to be a bug.

Create an item with a volume price and add attributes with a price. It does not calculate correctly once you hit the volume discount quantity.

If I buy 10+ @ $90 each ($900) and choose 2 different item options at $2.00 each 10 x $2.00 = $20, $20 x 2 = $40. The price should be $940, This calculates to $936.

http://dts2172.mivamerchantdev.com/p...ponent_01.html

Edit: I think I just stumbled accross a scenario that works... I got it to calculate correctly once.

[Ron Frigon]

Re: Volume Discount and product attributes with Price

It seems like if you choose Percentage or Absolute as the volume price type, the attribute price is included with the base price in the the volume discount calculation. Is this the intended behavior? It seems like the discount should be applied to only the base price and the item options would be additional, as in the EP module.

This is why I was seeing a $140 volume discount when I thought it should have been $100. Having the volume price set to $90 absolute for 10+ is including the options of $40. This doesn't seem like intended behavior to me...

This is not true if I choose Fixed as the volume price type. The volume discount does not include the item options and only applies to the base price. The option price is applied after the discount.

Maybe I'm just going crazy...

Edit: Maybe I just need to Let my Giggles Out!

[Eric Foresman]

Re: Volume Discount and product attributes with Price

Hi Ron

What you have described is the intended behavior for the volume discount module. When using the Percentage mode you are getting a percentage off of the cost of that line item, attributes included. When doing Absolute price you are selling that item and any of the options on it for the specified Absolute price.

The Fixed discount, simply takes the discount amount off the item total regardless of how many or which attributes get applied to it.

Hope this helps

-Eric

[Ron Frigon]

Re: Volume Discount and product attributes with Price

Thanks for the reply Eric.

Then can we have a Fixed Volume Price that works like the EP module does currently? I have a lot of products that volume pricing and attributes with a price, which is why I've been testing this new module. My volume prices are an absolute price, not a percent off or fixed discount.

I guess what I need is an Absolute Volume Price that does not include item options.

[Eric Foresman]

Re: Volume Discount and product attributes with Price

Not currently with the built in volume pricing discount module, however we have discussed internally adding an option to have the discounts ignore attributes.

Out of curiosity, is there a scenario where using the fixed discount function of the volume pricing module at the product level wouldn't work for what you are wanting to accomplish?

[Ron Frigon]

Re: Volume Discount and product attributes with Price

Out of curiosity, is there a scenario where using the fixed discount function of the volume pricing module at the product level wouldn't work for what you are wanting to accomplish?

I suppose it would work, but all of our products have absolute prices at different quantities. We would need to calculate what the difference is between all price levels and add that as a fixed discount for each level, instead of entering what the price actually is. It adds an extra level of complexity, more likely errors will be made, etc. Doesn't make sense to do it this way really.

For example we have:

2 - 3 @ $43.20
4 - 6 @ $29.75
7 - 19 @ $27.10
20 - 34 @ $24.46
35 - 69 @ $18.51...

Or: http://www.gpencil.com/product/PM300.php
http://www.gpencil.com/product/P428-PT.php
http://www.gpencil.com/product/2294.php
http://www.giggletimetoys.com/licens...ckers/9362.php
http://www.giggletimetoys.com/balls/1056.php


All volume pricing for our entire company, and our competetors, is this way. We have a fixed price, not a fixed discount. Item options are not discounted for any volume.

[crozon]

We would be interested in this as well. We have products where the main item is volume priced and there is a single attribute to include the add on item but we do not want the add on item volume priced or discounted.
Here is an example of the item: http://www.weddingfavours.ca/persona...-9oz-4282.html

The first 6 attributes pertain to personalizing the item but the last attribute is the option to add boxes that are $0.65 each no matter how many glasses you purchase. Currently it gives a discount to the boxes as well and this is not correct. The boxes themselves should not be volume priced in this case, just the main item (the stemless wine glasses).

Thanks,
Christine

[Ron Frigon]

Hey Christine,

Although I had to reverse engineer the way we do our pricing on the websites for volume pricing, I do currently have all of our volume pricing set up with a "Fixed" discount using the new volume pricing "price groups". It was a little counter intuitive for us to do it this way, but it works well. And the Attribute Option Prices don't have any effect on the Volume Pricing and they're not discounted. Sorry this isn't much help, but it works...

Ron

[Kent Multer]

Hi folks, I may have a solution for some of you.

I've recently completed a custom-pricing module that can do just about any kind of price calculation. Each product has a Store Morph template where you enter code to do the math. There are no fixed prices for products, attributes, or options; all the numbers are managed by the template. So it will handle complex cases such as applying a discount to the product, but not to the attributes.

Anyone who's interested in this can contact me by email. Thanks --

[lesliekirk]

Hey Christine,

Although I had to reverse engineer the way we do our pricing on the websites for volume pricing, I do currently have all of our volume pricing set up with a "Fixed" discount using the new volume pricing "price groups". It was a little counter intuitive for us to do it this way, but it works well. And the Attribute Option Prices don't have any effect on the Volume Pricing and they're not discounted. Sorry this isn't much help, but it works...

Ron

While searching for a solution I discovered this post and I need to tag in too. Why must a store owner have to use a discount method other than the one they want to use? I have a store that is just now trying to convert from the EP Volume Pricing and we are discovering all sorts of little things that are lacking in the built-in module.