Posted - 02/02/2019 : 15:51:31
The process would go like this, or at least this is how I would do it.
Download the folder with the images from your website, or perhaps you already have them stored on your local computer. It's best if the image filenames are related to the product id somehow, or at least they are named in a way that they are related to each product somehow.
To keep things organized, you will create three new image folders. GT (for giant) LG (for large) SM (for small)
If the 500 x 500 images are good resolution, you might be able to upsize them to 700 x 700. I would test one in the program you will use to size your images. If it's good, then batch process your images through the program and set the output location to your "GT" folder, keeping the filenames the same. Then I would use the 500 x 500 as my large images. So if they are high resolution, you might want to batch process them the same way, but keep the 500 x 500 size, and reduce the quality to get a smaller file size. Those will output to the "LG" folder using the same filenames. Next, batch process the same original images to (maybe) 150 x 150 and output them to the "SM" folder keeping the same file names.
Now you will have three sets of files for all of your images, in three separate folders. SM LG GT
Those three folders will need to be uploaded to your server. Drop them in an images folder, or maybe prodimages folder.
Now that the images are all created, and loaded on to your website server, you can work with the csv files to point your products to the small, large, and giant images.
Details here - https://www.ecommercetemplates.com/help/ecommplus/help.asp#csv
The thing to do is start by taking a backup of the database before you do anything. Next, in your admin, download the image csv file from your website. Save a copy to your computer that you will not edit. append the filename with the word "original". These two critical steps will cover any issue that arise, by allowing you to roll back any changes.
Now, open your csv file and make the changes. I don't know how your store is currently setup (other than posted here), so lets just say all products just have one small and one large image assigned.
When you open the csv file you will see 4 columns. The first being product ID and the last being image number. These two, you should not make any changes. It's the imageSrc (source column) and imageType column you will work with. The thing to do is highlight the entire spreadsheet and "sort" the sheet by the "C" column (image type) and be sure to keep the header row in place (you can specify that when sorting). Now you will have two sets of product images. Lets say hypothetically you 100 products with a small and large image for each. You would have 201 rows in your csv file. After sorting, you will have the header row up top, and the next 100 rows will be your small images (0 in the C column) and the last 100 rows will be the large images (1 in the C column)
Now, drag over that last 100 rows in the file, "copy" and then move to the 1st empty row at line 202 and "paste" those 100 rows. Next, in that "C" column for those newly pasted rows, highlight the "C" column for those 100 rows only, and use find/replace to change the "1" to a "2". That will specify those as a giant image.
The last step is to all the new image path to the filenames in column "B".
Basically you need to add the new location in front of the filenames. If they look like below images/WIDGETA.jpg images/WIDGETB.jpg images/WIDGETC.jpg
You might need to change them to something like images/SM/WIDGETA.jpg images/SM/WIDGETB.jpg images/SM/WIDGETC.jpg
Assuming you dropped your new SM LG GT folders in the images folder. You could just highlight those first 100 rows (after the header row) in the B column and use find/replace to locate "images" and replace with "images/SM" and then the next 100 rows would be replace with "images/LG" and the last 100 rows replace with "images/GT"
At this point upload the CSV file and it should all be done.
Of course, again, my instructions make several assumptions and if you are not comfortable with this, after my tutorial, then get some help. Click my username to send me an email and I could take a closer look at your setup and see if I might be able to do this.
|