Post by rzgurski » Sat Jun 16, 2012 12:47 am

Is there a way to update the file names of multiple products at once? I am in the process of re-saving all my .jpg files to .png. I want to take advantage of the transparency background when the images are resized.

I know I can bulk upload them, but my problem is actually defining each product image file. Right now, I'm having to go into each product, navigate to the Data tab, then find the new image and Save it.

I really hope there is an easier way since I have a TON of products to update. Thanks in advance!

I am using the latest version of OC 1.5.2.1

Newbie

Posts

Joined
Sat Jun 16, 2012 12:42 am

Post by inactiveaccount9912 » Sat Jun 16, 2012 5:53 pm

Considering that you will place all the new files in the same place as the old ones (ex: if an image is in image/data/demo/demo.jpg and you upload the png like image/data/demo/demo.png) and you are going to change the images for all products, you could just chage the extension of all files directly in the database with the query:

Code: Select all

UPDATE product SET image = REPLACE(image,.jpg','.png');
Again, that only if you change all images and upload the new ones in the same place (fast trough a ftp client).

Expert Member

Posts

Joined
Fri May 14, 2010 2:36 am

Post by nivek8613 » Fri Dec 07, 2012 7:55 am

So is it possible to update a number of product images at one time or do you have to go into each product and update manually?

Newbie

Posts

Joined
Fri Dec 07, 2012 7:52 am

Post by inactiveaccount9912 » Fri Dec 21, 2012 1:46 am

Depends on the situation. If you are looking for a bulk image change extension I havent seen one yet.

Expert Member

Posts

Joined
Fri May 14, 2010 2:36 am
Who is online

Users browsing this forum: No registered users and 1 guest