Announcement

Collapse
No announcement yet.

Volume Pricing on Variants?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Volume Pricing on Variants?

    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
    Need to offer Shipping Insurance?
    Interactive Design Solutions https://www.myids.net
    MivaMerchant Business Partner | Certified MivaMerchant Web Developer
    Competitive Rates, Custom Modules and Integrations, Store Integration
    AutoBaskets|Advanced Waitlist Integration|Ask about Shipping Insurance Integration
    My T-shirt Collection is mostly MivaCon T-shirts!!

    #2
    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
    Brennan Heyde
    VP Product
    Miva, Inc.
    [email protected]
    https://www.miva.com

    Comment


      #3
      Originally posted by Brennan View Post
      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.
      Leslie Kirk
      Miva Certified Developer
      Miva Merchant Specialist since 1997
      Previously of Webs Your Way
      (aka Leslie Nord leslienord)

      Email me: [email protected]
      www.lesliekirk.com

      Follow me: Twitter | Facebook | FourSquare | Pinterest | Flickr

      Comment


        #4
        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?

        Comment


          #5
          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.

          Comment


            #6
            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.
            Colin Puttick
            Miva Web Developer @ Glendale Designs

            Comment


              #7
              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?

              Comment


                #8
                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!
                Ron Frigon
                Jedi Webmaster Obi-Ron Kenobi

                Comment


                  #9
                  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?

                  Comment


                    #10
                    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.

                    Comment


                      #11
                      Originally posted by afiumano View Post
                      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?
                      Leslie Kirk
                      Miva Certified Developer
                      Miva Merchant Specialist since 1997
                      Previously of Webs Your Way
                      (aka Leslie Nord leslienord)

                      Email me: [email protected]
                      www.lesliekirk.com

                      Follow me: Twitter | Facebook | FourSquare | Pinterest | Flickr

                      Comment


                        #12
                        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.

                        Comment


                          #13
                          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
                          Ron Frigon
                          Jedi Webmaster Obi-Ron Kenobi

                          Comment


                            #14
                            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?

                            Comment

                            Working...
                            X