sharingsunshine
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,
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,
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,
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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...
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
ASKER
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
Here's the first one: https://gyazo.com/4873e8e0341bffff6e92104f00527266
Here's the second one: https://gyazo.com/ceb141ff47c27e175df9c950f762e4eb
ASKER
Thanks for answering this question. My follow-on to this question is https://www.experts-exchange.com/questions/29110626/Need-Plugin-To-See-Wordpress-Product-Image-Details.html#questionAdd
Always a pleasure! I'll give you an update tomorrow on the plugin. Thanks
ASKER
Great, sounds good
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: