OScommerce 2.3 Image size

[Guest]

Hi all

 

pulling me hair out here.

 

I have over 3000 images for my website and everyone is viewing at 100x100 even though the image sizes are 400x400 is there any way to get my images to load at the size that they are suppose to be.

 

I know that you have to load a duplicate image to get the bigger image but with 3000 files it will take a long time..

 

any suggestions would be appreciated I have tried everything in admin images but no joy just getting frustrated now..

 

Thanks in advance

 

Liam

[♥joli1811]

Hi Liam,

 

I used this SQL to upload the second image but backup your database before doing any changes in case something goes wrong!!

 

For use with for 2.3 version

 

 

(In phpmyadmin) With an empty products_images table run this query and it will add the data as if you've uploaded the image twice saving hours of time!

 

 

INSERT INTO `products_images` (`products_id`, `image`) SELECT `products_id`, `products_image` FROM `products`

 

Regards

Joli

[Guest]

HI Joli

 

OK have done that but just to be sure how would I implement or use it after the database insert as I can not see any difference..

 

Also Many thanks for that bit of information..

 

Regards

 

Liam

[♥joli1811]

Hi Sligoman,

 

well basically the query pulls the small images from :)

 

Table: products which I understood you had ( these would be the images size 400 x 400 but resized 100 x 100 because of your admin settings)

 

and inserts the same image in

 

Table: products_images

 

which will then give you the pop up effect using the original 400 x 400 images

 

the idea is just to save you uploading the images twice

 

You run this query in phpmyadmin

 

Maybe I have understood you wrong and you want the 400 x 400 directly on the product page this takes a bit of tweaking but can be done ??

 

Regards

Joli

[♥toyicebear]

Install an thumbnailer, then you only need to add 1 image per product and it will be automatically resized. http://addons.oscommerce.com/info/8492

[Guest]

Hi Joli

 

Sorry I failed to mention it is oscommerce 2.3.3 but I don't think that should make any difference only thing is in this version is that fancypics is all ready coded in this version wish they had just left it alone I tried your method but still getting the same result and just to be sure it was working I ran it with the table populated and it shows two images the same on the products page.

 

My images are downloaded from a product feed from an xml file so are uploaded automatically.

 

Looks like I will have to perceiver on this one.

 

Thanks again

 

Liam

[♥joli1811]

Hi liam,

 

Not sure about that I would believe fancy pics has changed the data base so the code will not work as it is for a standard install

 

never seen fancy pics before working on 2.3 nice to know it is possible :)

 

Think then the easiest would be to do what Jim said and install a thumbnailer if you look at the fancy pics link

 

http://addons.oscommerce.com/info/6979

 

You will see that there are a few thumbnailer's recommended think that could maybe solve your problem.

 

Regards

Joli

 

 

.

[Guest]

Hi Joli

 

Thank you for all your help much appreciated..

 

After exhausting all efforts to show a large image my last check was to have a look at the product_feed_class file I have for updating the products I had a good search through the file and found that it was putting small images in for the products page.. I have now rectified that and all is working as to be expected..

 

Once again many thanks for your time.

 

Regard

 

Liam