Remove product thumbnails?

Hey guys,

I need some help. I currently just migrated from pinnacle cart to cs cart and imported all product images using the cart 2 cart online software. But the way that it was done is causing an issue (I think). I want to change the thumbnail dimensions for my product images on the details page using the settings under “settings > thumbnails” … but my images do not resize. I did some research and found out how to regenerate the images, but it only seems to resize my product detail secondary images, not the main image thumbnail. But what I also found was my products have a “thumbnail” image and a “popup larger” image that are separate from one another. So what I need to do is remove the “thumbnail” image and just leave the “popup larger image” in place… because if I do that and then regenerate the images, everything works fine.



So my question is, how can I remove all the thumbnail images from the cart at once? (I have over 1000 products to do) I tried doing it through my cPanel, which it will allow me to remove the image, but then I get an “x” for the image because the cart is still “looking” for it. Please see attached image for reference. Any help would be greatly appreciated.



Thanks!

image.jpg

Try the " clear thumbnails" command.

in the browser address bar, ad “?ct” after you admin.php

So should look like: http://yourstore.com/adminstore.php?ct

Clear also the cache with “?cc”.

[quote name='colortone' timestamp='1318453849' post='123565']

Try the " clear thumbnails" command.

in the browser address bar, ad “?ct” after you admin.php

So should look like: http://yourstore.com/adminstore.php?ct

Clear also the cache with “?cc”.

[/quote]



I tried both commands and neither will work. Like I said, the only way it works is if I delete the “thumbnail” image from the product first (but keeping the “popup larger” image in place) and then run those commands to regenerate. Then everything works fine. But it doesnt work if both images are within the product as show in my attached file above.

[quote name='hptmotor' timestamp='1318457078' post='123571']

I tried both commands and neither will work. Like I said, the only way it works is if I delete the “thumbnail” image from the product first (but keeping the “popup larger” image in place) and then run those commands to regenerate. Then everything works fine. But it doesnt work if both images are within the product as show in my attached file above.

[/quote]

how about you try export all details for just 1 product,then delete that product then re import all the info for that 1 product WITHOUT the thumbnail_image field,just use the detailed_image field, make sure you set what size you want the thumb in the admin. if it works ok just do that for all 1000 products in 1 go.

cs cart will generate the thumb itself from the detailed image.





John

remember to keep the same seo url and back up first.

[quote name='johnbol1' timestamp='1318458282' post='123572']

how about you try export all details for just 1 product,then delete that product then re import all the info for that 1 product WITHOUT the thumbnail_image field,just use the detailed_image field, make sure you set what size you want the thumb in the admin. if it works ok just do that for all 1000 products in 1 go.

cs cart will generate the thumb itself from the detailed image.





John

remember to keep the same seo url and back up first.

[/quote]



Thanks for the reply john. What do you think about just going into the mysql database and deleting the thumbnails? I wonder if I can do that and then run the admin.php?cc or admin.php?ct command to regenerate the images?

dont see any problem doing it that way, then re generate.

Same old story…backup backup backup





John

I wasnt able to find the thumbnails in the database yet to try that method, however, I was playing with the images sizes and found out something else. If you go into “settings > thumbnails” and completely remove the numbers in the fields labeled “Product details page thumbnail width” and “Product details page thumbnail height” and click save, then regenerate… the thumbnails for the product detail page will automatically size to 120px. So, there must be a default setting somewhere thats telling the cart to do this?? And this is where my problem lies. I want to change those images to 220px and they wont resize. The images will stay at 120px but show an outer dimension of 220px if you right click them and click properties (if that makes sense. its all white space around the image)



Anyone know about this default image setting of 120px for the product detail page? Thanks in advance!

you sure your images are large enough and dont have white space around them anyway?



john

[quote name=‘johnbol1’ timestamp=‘1318470878’ post=‘123588’]

you sure your images are large enough and dont have white space around them anyway?



john

[/quote]



I’m 100% positive they are large enough. The “popup larger” image is typically around 600px for my products. But like I said before though, if I “edit” a product and delete the “thumbnail” image but keep the “popup larger” image in place, click save, then regenerate… the image will resize accordingly. Its very strange and increasingly fustrating. haha. But I appreciate your help & time thus far B)



P.S. I’m basically trying to avoid having to go back to every single product to do this process of removing the 1 thumbnail image and then regenerating afterwards.

It just sounds perhaps that when you used c2c it brought over thumbs and did the sizes. If you export your Detailed images then delete the thumbs images folder then just re import the detailed images it should do the trick…try it with one and see if it works its quite painless.



can you post your url?

Hello



You can do this via MySql



Go to your database and find table cscart_images. Click to browse this table. Check all rows that include the word thumbnail and hit delete. All thumbnails will be gone and you will just leave the larger image.



:)

[quote name=‘Hetha’ timestamp=‘1321758423’ post=‘126329’]

Hello



You can do this via MySql



Go to your database and find table cscart_images. Click to browse this table. Check all rows that include the word thumbnail and hit delete. All thumbnails will be gone and you will just leave the larger image.





[/quote]



That’s what I had to do also. To see the records invloved I ran the following SQL:

select * from cscart_images where image_path LIKE ‘%thumbnail%’

and then to delete them I ran

delete from cscart_images where image_path LIKE ‘%thumbnail%’



This removed everything except the thumbs that over time I had manually uploaded on the product detail page in the admin. For those I had to go through the Products screen in the admin and look for those that weren’t showing a thumb. I believe I did use ct and cc after this for good measure. :)