Announcement

Collapse
No announcement yet.

Any way to convert attribute type drop-down to type swatch via XML or other import?

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

    Any way to convert attribute type drop-down to type swatch via XML or other import?

    Just checking to see if this is at all possible. We have all the attributes currently setup at just drop-down but want to convert them all to swatch-dropdown. Is there an "easy" way to do this via XML import or other csv file? XML seems to either only add or remove/add, which also orphans any inventory variants already existing. Is there an "update" mechanism for XML to change the type <Type>swatch-select</Type> and also add images to the options without removing everything first?

    Thanks,
    Joe
    Joe McDonald
    patrickwebby.com

    #2
    Do you use attribute templates? I have a module that lets you export attribute templates in a CSV file, edit it with a spreadsheet, and then import the changes back into the store. But it only works for templates, not for attributes that are directly assigned to a product.
    Kent Multer
    Magic Metal Productions
    http://TheMagicM.com
    * Web developer/designer
    * E-commerce and Miva
    * Author, The Official Miva Web Scripting Book -- available on-line:
    http://www.amazon.com/exec/obidos/IS...icmetalproducA

    Comment


      #3
      Hi Kent, thanks for the reply. Not using templates.
      Joe McDonald
      patrickwebby.com

      Comment


        #4
        Just do an XML export and change one already the way you need it. Check the one you changed and use find & replace to change all the others. Then import and make sure the setting is replace existing attributes,

        It should look like this in the XML file

        <ProductAttribute_Delete_All product_code="Energy-Booster" />
        <ProductAttribute_Add product_code="Energy-Booster">
        ...
        Andreas Toman
        PCINET, LLC

        Miva Merchant Design, Development, Integration & Support
        We built over 200 Miva Merchant stores!
        Miva shopping cart design & integration service and see our Portfolio!


        e-mail: [email protected]
        web: www.pcinet.com
        LinkedIn: Andreas Toman
        phone: (786) 250-2056 (Miami, FL)

        Comment


          #5
          That deletes the attribute set and then recreates it and in the process removes any inventory variants that are already setup. We have variants all setup correctly with images and pricing and custom skus, so that's a show stopper for us. I was hoping maybe there was something like <ProductAttribute_Update> instead.
          Joe McDonald
          patrickwebby.com

          Comment


            #6
            There is no ProductAttribute_Update XML tag. If you're trying to do this for all products you can probably do it via a SQL UPDATE on the s01_Attributes table for the type column. Definitely test it on a few products first, but that should be the only value you need to updated to make the change.
            Brennan Heyde
            VP Product
            Miva, Inc.
            [email protected]
            https://www.miva.com

            Comment


              #7
              Ok cool. Makes sense. Thanks Brennan.
              Joe McDonald
              patrickwebby.com

              Comment

              Working...
              X