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
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:
Again, that only if you change all images and upload the new ones in the same place (fast trough a ftp client).
Code: Select all
UPDATE product SET image = REPLACE(image,.jpg','.png');
Depends on the situation. If you are looking for a bulk image change extension I havent seen one yet.
Who is online
Users browsing this forum: No registered users and 3 guests