Announcement

Collapse
No announcement yet.

Replace Legacy Images

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

    Replace Legacy Images

    I need to replace ~ 32,000 Legacy images. They will reside in the 'graphics/00000002' folder and have the same file name as the product code. Is there a batch process to replace the Legacy 'full-size' & 'thumbnail' image? The website uses the 'image machine' were possible, but these are 105px ( thumbnail ) as that is all the manufacturer has provided. I will increase the product image to 150px; any bigger and it looks grainy.

    Thanks,
    Doak Heggeness
    Web Developer | Certified Miva Merchant Developer

    #2
    Our images are named the same way. ca1234.jpg and ca1234s.jpg would be the thumbnail. We actually had code written in our templates many years ago that pulled the images in that way and our image fields weren't even populated. That became an issue for certain exports so many years ago we had to populate those fields. Its pretty easy actually.

    I might break this up from 32,000 images to a few smaller chunks. That's up to you.

    Export your products. All you need is the product code. Open is Excel. In column B, type .jpg 32,000 times. :) Or use the auto feature.

    In column C enter the formula =(A1&B1)

    Drag that down 32,000 rows.

    Save as tab delimited text file

    Do the same type of thing for the other image you'll use with a different name. Import into Miva skipping column B.

    Column A will be the product code, column C will be the image.

    PM me if I did a poor job of explaining.

    Comment


      #3
      For performance reasons you may want to spread those 32,000 images across several folders or use a CDN.
      http://www.alphabetsigns.com/

      Comment


        #4
        Thanks Mikel, I'll see how it goes. The images are in 10 folders.
        Doak Heggeness
        Web Developer | Certified Miva Merchant Developer

        Comment


          #5
          I hope this not too lame a question..

          I exported the products from a category using the 'Export Products to Flat File' module. I am updating some of the products, but not all. I assume I use the 'Add/Update Products from CSV' product import module to import the changes and the products not changed will not be affected?

          Thanks
          Doak Heggeness
          Web Developer | Certified Miva Merchant Developer

          Comment


            #6
            Doak,

            Yes, you would want to use Add/Update Products from CSV. Before you import it though, I would recommend that you click into Import Settings and check out the settings for that import utility to make sure it's setup how you want it. You can even select 'Manually Assign' next to fields and upload your file to manually map your fields for import.

            Jim McCormick
            Miva Merchant Support
            866-284-9812

            https://www.miva.com

            Comment


              #7
              Doak,

              You might also want to take a look at this video:

              http://www.miva.com/videos/store_own...-via-flat-file

              Jim McCormick
              Miva Merchant Support
              866-284-9812

              https://www.miva.com

              Comment


                #8
                Thanks, Jim, the video was helpful. If I do a mass upload and some of the images do not have products yet ( I do not know which ones ), will that affect anything? The products have the same names as the images (12345 & 12345.jpg).
                Doak Heggeness
                Web Developer | Certified Miva Merchant Developer

                Comment


                  #9
                  Originally posted by doakh View Post
                  Thanks, Jim, the video was helpful. If I do a mass upload and some of the images do not have products yet ( I do not know which ones ), will that affect anything?
                  This depends on the import utility settings and what's in your flat file. If you have the product code in the file AND you have the utility set to 'Add New and Update Existing Products', the product will get created. If you have the utility set to 'Update Existing Products Only' the product will not get created even if it's included in the import file.



                  Jim McCormick
                  Miva Merchant Support
                  866-284-9812

                  https://www.miva.com

                  Comment


                    #10
                    Thanks, successfully imported a test file.
                    Last edited by doakh; 10-12-16, 07:48 AM.
                    Doak Heggeness
                    Web Developer | Certified Miva Merchant Developer

                    Comment

                    Working...
                    X