I am trying to straighten out a mess on a client sites images AND adding giant images for the MagicTools Hover script.

The issue is that some images have only the small image field in the admin area filled in. Others have only the large image field and some have both the small and large fields filled in. Only a 2-3 products have the giant images field filled in.

I have created 3 sets of images ready for upload with matching filename_small.jpg, filename_large.jpg and filename_giant.jpg.

My question is regarding the CSV import function. I tested a small sample CSV upload and the "update database" selection only seems to change the data in the fields if there is already something in the field to start with. To add images in empty fields I had to use the "add to database" selection.

My problem is that I have a mixture of "update" and "add" in my list of 500+ images. How do I use the CSV upload system in my situation?

My thought was to take the full list of all three sets of images CSV and run a "add to database" to add data in all the blank fields then rerun the CSV upload as "update the database" and that would then edit all 3 of the image fields to match my files list.

This is a live active website and I don't want to totally screw it up. Someone please give me "expert" advice.

Thanks in advance.

Ray Cramblit

Ray Cramblit

Hi Ray

It sounds like that may be the solution but if it's a live and bust site I would look at setting up a second test site. Make a copy of the site and database and set it up on the same server - you can then use that to test changes before going live.

Andy

Please feel free to review / rate our software

Thanks for the suggestion. Good idea!

Just to clarify...

1) if I run the "add to database" function it will only populate empty fields in the admin area image fields.
2) Running the "update database" function will only change fields that already have data in them

True?

Ray Cramblit

That sounds correct to me.

Andy

Please feel free to review / rate our software