I am using Newestech's Web Integrator pro wi 2.4 along with Kosmos and I have ran into an image problem. Based upon previous input from this forum, we save all of our images in HQ using the sku.jpg and then save product images using the skew as jpegs. We have two problems:
- We have thousands of items in our dbase and it is tedious calling up each item and adding the image path.
- Some of my employees have saved the image files with a jpg suffix in uppercase. The Unix server does not recognize these images on our web server and so does not assign them to the products. This leaves us with a lot of our online products without images. The did not notice a problem due to the fact that the Windows O.S. doesn't care if the suffix is upper or lower case.
Would it be possible to use SQL command or a script to set the image path of each item to the sku.jpg ?
Thanks
Bill
Hobby Central