Link to home
Start Free TrialLog in
Avatar of sharingsunshine
sharingsunshineFlag for United States of America

asked on

Need List Of Woo Commerce Image Dimensions Stored On DB?

I have over 2,000 images in a Woo Commerce installation.  I need to know where the image dimensions are stored on the Maria db for the single product image or main image that Woo Commerce uses for each product and how to retrieve the list of them.

I plan to replace all of the images that aren't at least 300x300.  Because on the cart they are showing up blurry.

Doing it through the db will be much quicker than going through each product on the cart.

Thanks,
Avatar of Adrian Thompson
Adrian Thompson
Flag of United Kingdom of Great Britain and Northern Ireland image

You just need to specify the correct image dimensions in your WordPress dashboard here:
WooCommerce > Settings > Products > Display > Product Images

Then after you have set the correct image dimensions, you need to "Regenerate Thumbnails". Everything is automatic.

Here is a screenshot for you:

User generated image
Avatar of sharingsunshine

ASKER

The actual images are 112x132 so when Woo Commerce shows the single product page it is blurry.  Here is an example:
https://www.theherbsplace.com/product/licorice_root_100_capsules_p_418/

So the blurriness in my opinion comes from the image size being blown up to the 600x600 size.  So my idea was to find which images are 112x132 and re-download the larger image size of 300x300 and get this kind of look - https://www.theherbsplace.com/product/focus_attention_90_capsules_p_2011/

I was taught you couldn't blow up an image if the pixels aren't there in the first place.  So that's why I wanted to redo the downloads from the manufacturer's site.  Am I wrong in my thinking?

Thanks,
ASKER CERTIFIED SOLUTION
Avatar of Adrian Thompson
Adrian Thompson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
By the way, your website seems to be unresponsive (not loading):
https://www.theherbsplace.com

Did you add HTTPS? If so, remember to open port 443 on your firewall ;-)
HTTP uses port 80 so when you switch to HTTPS it will "time-out" unless you have port 443 open.

This could be completely irrelevant as maybe you are doing something else but I have seen this happen many times before so thought it worthwhile mentioning just in case. Maybe it is useful...
Ignore my last post - I can see your website is now back online. Although please respond to my original post. Thanks
I had some bots overload the server.  Yes that would be great to expand the plugin.

Here's the first one: https://gyazo.com/4873e8e0341bffff6e92104f00527266

Here's the second one: https://gyazo.com/ceb141ff47c27e175df9c950f762e4eb
Always a pleasure! I'll give you an update tomorrow on the plugin. Thanks
Great, sounds good