Announcement

Collapse
No announcement yet.

Convert from Weiland to built-in Volume Price

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

    Convert from Weiland to built-in Volume Price

    Does anyone have any tips on a way to convert the volume price file from Weiland to built-in? Our challenge is that we have tiers that are not consistent across all products. If they were, I figured I could just do text to columns in Excel. Any ideas?

    #2
    It's been a while since I've done this but I think you're on the right track with exporting the Vol Pricing and manipulating the spreadsheet to match the import format for the Miva volume pricing price groups.

    I don't I have enough info on your "tier" scenario. I think you'll be able to configure the price groups to handle this, however.
    Each product can have their own tiers once you set up the volume price group, ( the interfaces are a bit confusing ) but in each product, you can define the different price breaks. One product can have breaks 1, 3, 12, etc and another could 1, 10, 20, etc.

    If I recall, the trick in the spreadsheet is to identify the columns correctly so they correspond to appropriate quantity breaks. This could result in many columns. It's more detail-oriented but the technique allows for using a single spreadsheet if you desire.

    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!!

    Comment


      #3
      Thanks for the insight Scott. Always appreciated.

      Comment


        #4
        Originally posted by ids View Post
        It's been a while since I've done this but I think you're on the right track with exporting the Vol Pricing and manipulating the spreadsheet to match the import format for the Miva volume pricing price groups.

        I don't I have enough info on your "tier" scenario. I think you'll be able to configure the price groups to handle this, however.
        Each product can have their own tiers once you set up the volume price group, ( the interfaces are a bit confusing ) but in each product, you can define the different price breaks. One product can have breaks 1, 3, 12, etc and another could 1, 10, 20, etc.

        If I recall, the trick in the spreadsheet is to identify the columns correctly so they correspond to appropriate quantity breaks. This could result in many columns. It's more detail-oriented but the technique allows for using a single spreadsheet if you desire.

        Scott
        Old post but even more relevant now. Did you manage to create spreadsheet/file that can be used to update the Volume Pricing?
        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


          #5
          I ended up doing a SQL query to export the table and then we simplified it by making all tiers consistent across the board. KISS (Keep it Simple Silly) method is the best approach. I think I saw Kent chime in at one time that he has a module that can safely export the data, but don't quote me on this.

          Comment


            #6
            Coming back to an old post for help with converting the EmporiumPlus Volume Discount to the Price Group Volume Price. I need to be able to display the percentage

            This is the display created with the EP module
            9paN6o.png

            This is all I can get from the Marketing Group Price Group

            oRnIhU.png
            Took me a minute to figure out the ranges> I still need to figure out how to do that in a file for import. Bill's module's had such fine nuisances that are not in the default configurations. Makes it difficult to convert for so many reasons.
            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

            Working...
            X