Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 4 of 4
Images not showing up after import
 
videohead
Jr. Member
 
Total Posts:  22
Joined:  2010-10-14
 

I wrote a quick lil’ script that brings the image locations into the database directly for the more images.
I set all of my images to SKU.png (I’m using configurable products, so I just need images for the configurables.

First I look up the configurable products, and get those as a parentID.

SELECT *
FROM `mage_catalog_product_entity`
WHERE type 'configurable'
Next
"INSERT INTO mage_catalog_product_entity_media_gallery (attribute_id, entity_id, value) VALUES ('73','" $this->parentId "', '/1/0/" $this->parentSku ".png');";
AND
"INSERT INTO mage_catalog_product_entity_media_gallery_value (value_id, store_id, position, disabled) VALUES (LAST_INSERT_ID(),'0','1', '0');";
Loop through all the configurables, and then upload the images.

Contact me and I’ll share the whole script with you.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Wired Studios
Jr. Member
 
Total Posts:  3
Joined:  2010-10-18
 

Thx AnnaM

Saved me a day or 2. smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
Lenster
Jr. Member
 
Total Posts:  16
Joined:  2011-11-24
 

Thanks AnnaM, this resolved my headache quicker than painkillers!

 
Magento Community Magento Community
Magento Community
Magento Community
 
magento123
Member
 
Avatar
Total Posts:  64
Joined:  2010-12-30
 

Hi all,

I am sorry coz i know i am being bit out of topic.

But please if anybody can help.

My site is having one domain but two stores

And the images are not coming up in second store. I tried changing base url /media paths but it didnt worked as well

Thanks in advance

 
Magento Community Magento Community
Magento Community
Magento Community
 
tortora
Member
 
Total Posts:  31
Joined:  2014-01-18
 

We have an application that offers an easier way to upload images and addresses some of these issues.  You can get more info on it at www.ClaraStream.com and feel free to email me at info@clarastream.com if you have any questions.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 4 of 4