Volume Pricing on Variants?

[ids]

I'll take the blame if I thought there was a function for this. I finally have a case scenario to roll this out and I don't see it addressed in the docs. I am hoping I missed it.
( I didn't see a result in a forum search. )

I have a few products that each have different pricing per option. Simple Example: a mattress product where size is the option; a Twin mattress is differently priced from the King size mattress.

If there isn't a way, it looks like I'll need to use CTGY and product list display. This is fine and the work is simple enough. But it looks like there will be plenty of extra work. These current 3 products with an average of 10 options per will turn into needing to create roughly 30 products where I can configure the volume pricing for each of those products separately.

Thanks,

Scott

[Brennan]

Volume pricing works at the variant level. You just need to make sure you assign the variants to the price group then enter in the volume pricing data for each variant.

The missing piece is going to be showing the updated volume pricing table as the customer changes the variant. You're going to need to create your own javascript call to pull in the volume pricing table for each variant using something like this:

https://docs.miva.com/code-samples/l...variant-change

[lesliekirk]

Volume pricing works at the variant level. You just need to make sure you assign the variants to the price group then enter in the volume pricing data for each variant.

The missing piece is going to be showing the updated volume pricing table as the customer changes the variant. You're going to need to create your own javascript call to pull in the volume pricing table for each variant using something like this:

https://docs.miva.com/code-samples/l...variant-change

I'm wondering why this javascript isn't something already included. Inventory Variants have been around for a while now. Built-in Volume Pricing isn't all that new anymore either. This could frustrate the Average Joe Storeowner.

[afiumano]

I am really struggling with getting this to work properly. We have a product setup that has 2 variants. I assigned each variant to the volume price group and setup a volume discount based on a flat price. But the math just isn't working properly.

Price of master product: $4.23, price of variant 1: $4.58. I have the volume pricing chart set on variant 1 to have a flat discount of .29 at 50 quantity.

So if I add 50 to the cart of that variant price should be 50 x 4.29 or $214.50 but price is showing $197 or $211.50 depending on the option selected when I generate the variants (variant price set by master product and its attributes or variant price is set by the inventory product). Neither prices are correct. What am I missing?

[afiumano]

I finally got this to work. I am not sure if the below is 100% correct as I couldn't find the exact info in the reference docs but below are the steps that finally worked. I had to do trial an error on all of the settings.

1. I had to make sure to remove the product from the category that was tied to the Volume Price by Category module I was using.
2. Setup master product and put in base price of that product.
3. Generate the variants on master product using Variant Price is set by the Inventory Product
4. Setup the Volume Pricing Price Group:

Eligibility: All Shoppers
Type: Volume Pricing
Grouping: Same Product Variant
Pricing Method: Apply Single Pricing table Entry Using Total Quantity

Do NOT enter any values in the volume pricing chart here.
5. Assign the master product and variants to Discounted and Qualifying Products
6. Go to each variant and enter the quantities and amounts into the volume discount chart for each variant, as well as set the price of the variant. Make sure to set type to Absolute and put total price of each one of that particular variant into the amount field.

[dreamingdigital]

afiumano I'm glad those settings in your prev comment work for your situation. That is not always the case. There are a lot of 'gotchas' in the Volume Price type of price group.

[afiumano]

Is it possible to get more direction in terms of how to get the volume pricing table to display when using variants. I am using the "Load Variant Data On Variant Change" code to display a variant custom field on the PROD page already - how do we use the same code to display the volume table info?

[Ron Frigon]

Wondering if anyone has a working solution for this? We are also already using the load variant data json for other things. I've poked at this for an hour or so and haven't gotten anywhere with it.

Cheers!

[jbart]

Also looking for a solution for this. Trying to get a volume pricing table to adjust in real time based on variant from selected attributes - 2 required options ( size, finish) - any updates in M10 for this?

[heatherwebdev]

I have a set up to show volume table price updates based on attribute changes, using JavaScript to update the pricing. Might not be ideal for some stores. I have a custom field on each product with a 'base price' and then I load in price adjustments when attributes are updated.

[lesliekirk]

I finally got this to work. I am not sure if the below is 100% correct as I couldn't find the exact info in the reference docs but below are the steps that finally worked. I had to do trial an error on all of the settings.

1. I had to make sure to remove the product from the category that was tied to the Volume Price by Category module I was using.
2. Setup master product and put in base price of that product.
3. Generate the variants on master product using Variant Price is set by the Inventory Product
4. Setup the Volume Pricing Price Group:

Eligibility: All Shoppers
Type: Volume Pricing
Grouping: Same Product Variant
Pricing Method: Apply Single Pricing table Entry Using Total Quantity

Do NOT enter any values in the volume pricing chart here.
5. Assign the master product and variants to Discounted and Qualifying Products
6. Go to each variant and enter the quantities and amounts into the volume discount chart for each variant, as well as set the price of the variant. Make sure to set type to Absolute and put total price of each one of that particular variant into the amount field.

I am going to tag in on this. My first question - are you having to make all of these changes manually???

Which type of discount are you using? Percent, Fixed, or Absolute?

Did you have to tweak the code? (You know that stuff the average storeowner doesn't want to touch).

Have you been able to figure out how to update the pricing with an import file?

[afiumano]

1. I made all of the changes manually.
2. I am using 'Absolute' discount
3. Since this was so long ago - I don't remember if I tweaked the code. But I don't believe so - although I never go the volume discount chart working.
4. Sorry, I have never tried doing an import file.

[Ron Frigon]

From the latest update a few days ago. Haven't implemented this myself yet...

New Features & Improvements:

Volume discount table is now automatically refreshed when selected variant is changed

https://github.com/mivaecommerce/rea...dows/issues/83

[afiumano]

I got this working - however, the head of the table (Quantity Price) is showing on ALL products, not just those with volume discounts. Any way to only have it appear on eligible products?