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

Manual Image Insert - [solved]
 
andreladocruz
Guru
 
Total Posts:  322
Joined:  2008-05-07
Brazil
 

Friends,

I´m tring to configure product images by SQL Scripts.

here follows one exemple:

INSERT INTO catalog_product_entity_media_gallery (value_id ,attribute_id,entity_id,value) VALUES (1,62,1,’/1640530/img_prod/0876CCA3-15C5-5D3E-F9593E670BE7F4BF.JPG’);

INSERT INTO catalog_product_entity_media_gallery_value (value_id,store_id,label,position,disabled) VALUES (1,0,’Zyplo Xarope 6mg/mL 120mL levodropropizina’,1,0);

Even this there is no image on product detail.

What more I have to do?

Regards,

 
Magento Community Magento Community
Magento Community
Magento Community
 
andreladocruz
Guru
 
Total Posts:  322
Joined:  2008-05-07
Brazil
 

Well,

Tring to have my problem solved, I decided to put some images here and help you on helping me.

image1.png shows the product image configuration. As you can see all types of image are selected.

image2.png shows that the thumbnail image is working fine.

image3.png show that all the others images types are not functioning!

This product where manually edited by me using the admin panel.

image4.png shows the fields that I wonder to manipulate directly by SQL Query on phpMyAdmin.

Please can any one help me?

I´m setting up 6015 product images.

It´s almost impossible to do it one product a time.

Regards,

Image Attachments
image1.pngimage2.pngimage3.pngimage4.png
 
Magento Community Magento Community
Magento Community
Magento Community
 
andreladocruz
Guru
 
Total Posts:  322
Joined:  2008-05-07
Brazil
 

OK!

I got it by my self!

let´s explain how do you have to do to manualy insert image information directly on MySQL:

To Insert Base Image Information Exemple:
INSERT INTO catalog_product_entity_varchar (entity_type_id,attribute_id,store_id,entity_id,value) VALUES (4,59,0,3966,’/1735913/img_prod/313C029D-1422-B0BC-6220E87EAA7CDF29.JPG’);

To insert Small Image Information:
INSERT INTO catalog_product_entity_varchar (entity_type_id,attribute_id,store_id,entity_id,value) VALUES (4,60,0,3966,’/1735913/img_prod/313C029D-1422-B0BC-6220E87EAA7CDF29.JPG’);

To insert Tumbnail Image Information:
INSERT INTO catalog_product_entity_varchar (entity_type_id,attribute_id,store_id,entity_id,value) VALUES (4,61,0,3966,’/1735913/img_prod/313C029D-1422-B0BC-6220E87EAA7CDF29.JPG’);

Knowing:
entity_id is the product id in magento data base

Know the only problem is that the images are not showing on product detail view or search view.

to see the live store go to http://novafarmadelivery.com

Regards,

 
Magento Community Magento Community
Magento Community
Magento Community
 
andreladocruz
Guru
 
Total Posts:  322
Joined:  2008-05-07
Brazil
 

Any one knows how to start the product image cache update?

the tumbnail images are working well but the other ones no!

Regards,

 
Magento Community Magento Community
Magento Community
Magento Community
 
andreladocruz
Guru
 
Total Posts:  322
Joined:  2008-05-07
Brazil
 

Friends,

PLEASE HELP ME!

I put all information about the imagens on the data base but only thumbnail images are shonw! what more I have to do?

please help Me!

 
Magento Community Magento Community
Magento Community
Magento Community
 
andreladocruz
Guru
 
Total Posts:  322
Joined:  2008-05-07
Brazil
 

I tried to upload a image through admin panel and it isnot working too..

does any one know what is happenning?

Regards

 
Magento Community Magento Community
Magento Community
Magento Community
 
Suzy
Jr. Member
 
Total Posts:  6
Joined:  2008-07-10
 

Did you ever figure this out?  I want to do the same thing.  BTW, did you insert products programatically too? 

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
andreladocruz
Guru
 
Total Posts:  322
Joined:  2008-05-07
Brazil
 

Suzy,

I inserted products trough import function.

I exported as Excel XML first than I used the Model to import ALL the 6015 products.

The images insert worked well. The problem was in cache dir. It was without write permission.

Regards,

 
Magento Community Magento Community
Magento Community
Magento Community
 
malbiniak
Member
 
Avatar
Total Posts:  34
Joined:  2008-07-26
Saint Paul, MN
 

I’d like to add, my problem (as described by everyone else’s posts) was solved by properly setting my permissions. I had moved the site from a dev to prod environment and forgot to reset the permissions recursively:

chmod -R 0777 app/etc/ var/ media/

I believe var/tmp was the problem, but it could have also been the media/ folder. I hope this helps some of you!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top