Magmi Base Image Getting Excluded

[soamjena]

We are using Magmi to import 500 products to our Magento 1.9 store.

Right now, everything works, except one single thing.

The base image is not getting included in the media gallery. We need this to show in media gallery too.

Everytime we import it, its excluded in the backend. And doesnt get listed on the media gallery too.

How do we fix this ? Is there a one line SQL code to run on the phpmyadmin, so all the EXCLUDE selection is removed from all the products in the store ?

Or any Magmi fix for this ?

As per Magmi documentation, we need to put + in front, but that doesnt work with remote images. It shows warning.

[dweeves]

This is normal, since magento base image import would do the same. So if you wand to explicitely include , put a + before image URL (ie: before the http, not before the image name) for remote images as described in the manual. what are the warnings that appear ?

[soamjena]

Tried the same way , putting + in front of the 1st image on media_gallery, but it failed.

Then tried placing the + in image column too, it failed.

Both ways, it fails.

On Thursday, 29 May 2014 at 11:00 pm, Sebastien Bracquemont wrote:

This is normal, since magento base image import would do the same. So if you wand to explicitely include , put a + before image URL (ie: before the http, not before the image name) for remote images as described in the manual. what are the warnings that appear ?

—
Reply to this email directly or view it on GitHub (#40 (comment)).

[soamjena]

Shall I post a excel with one record ?

There is some problem, which we are not able to find out.
We have defined multiple images on the media gallery, but only 1 image shows up.

This is happening for one particular record and we are not able to find out, what exactly is going wrong, as Magmi debug says nothing. It says, imported.

[dweeves]

Yes, put a csv with one record so that i can see what goes wrong

[soamjena]

Okay, will send one CSV file with one record today.

Another question, how do we get such description imported,
http://cl.ly/image/3y1a0Z2K224

[soamjena]

And here is the csv file,
http://cl.ly/3L352m2Q3f2X

[soamjena]

here is another csv too with another record, which has same problem.

The media gallery images doesnt import at all,
http://cl.ly/170K3w460h11

[soamjena]

any update ?

Is there a way we can remove the EXCLUDE from all the products at once, by running some SQL command or something ?

[YorickH]

Any news on this issue, I'm having the same problem. I tested it once by adding the + for the first image in my image gallery column. This one time, it worked. Afterwards when changing the path for the small file it crashed on me and did not showed the first image (which is the base image).

I use the following for the image, thumbnail, small_image and media_gallery columns:

"+22/1821-n.jpg","22/1821-n.jpg","22/1821-n.jpg","+22/1821-n.jpg;22/1821-n_open.jpg"

[bialy7]

After importing product with images. I try edit one off the imported product when i change images order and push save:
All images disappear

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (demo.catalog_product_entity_media_gallery_value, CONSTRAINT FK_CAT_PRD_ENTT_MDA_GLR_VAL_VAL_ID_CAT_PRD_ENTT_MDA_GLR_VAL_ID FOREIGN KEY (value_id) REFERENCES catalog_product_en), query was: INSERT INTOcatalog_product_entity_media_gallery_value(value_id,store_id,label,position,disabled`) VALUES (?, ?, ?, ?, ?)

[inpresif]

Same here, any word on this yet?

[mrk741]

Same error also base image can't show in product page

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (nxemvwyhwr.catalog_product_entity_media_gallery_value, CONSTRAINT FK_CAT_PRD_ENTT_MDA_GLR_VAL_VAL_ID_CAT_PRD_ENTT_MDA_GLR_VAL_ID FOREIGN KEY (value_id) REFERENCES catalog_product_enti), query was: INSERT INTO catalog_product_entity_media_gallery_value (value_id, store_id, label, position, disabled`) VALUES (?, ?, ?, ?, ?)