All product images set to hidden

After migration, all of my product images are set to hidden on the product page.  How do I fix this?

10 answers

Profile photo of Mall Staff 184060.00 $tone May 9, 2017
Public

Hi there,
That because your images has marked to excluded in back-end of your site.
If you want to enable with mass images, you can run bellow sql:

Update `catalog_product_entity_media_gallery` set `disabled` = 0;
Update `catalog_product_entity_media_gallery_value` set `disabled` = 0;

And clean the Magento2 cache. And tell me know how it goes.
Regards,
Mall.
 

#1
Profile photo of sharmstr 240.00 $tone May 9, 2017
Public

I checked catalog_product_entity_media_gallery and all entries were set to disabled=0.  
On my magento 1 site, each product had 3 images: Base, small and thumbnail.  Only the base image was set to show on the product page.  After running the migration all of my base images are set to hide from the product page.  This seems like an issue with the migration script.

#2
Profile photo of sharmstr 240.00 $tone May 10, 2017
Public

I didnt run the first statement because as I said, everything in that table was already set to disabled=’0′.  I didnt run the second statement because I was afraid that it would set my thumbnails and small images to unhidden when all I want is the base images to show.  I just ran it and sure enough, it set everything to unhidden which I didnt want.  Not happy about that.
I’m going to start over.  I’ll let you know what happens.

#4
Profile photo of Mall Staff 184060.00 $tone May 10, 2017
Public

Hi there,

let’s provide me the php credentials of your databases (M1 vs M2 databases) and admin credentials of your Magento1, Magento2
And specify me the product’s SKU with the issue as you mentioned. I will check further and show you root of that issue.

So, let’s provide me your information as my suggesting. I will check further and reply you more later.
Regards,
Mall.

#5
Profile photo of sharmstr 240.00 $tone May 10, 2017
Public

Perhaps M2 handles images differently.  As I’ve explained, in M1 I had to “exclude” all the images so that thumbnails wouldnt show up under the main product image on the product page.  It appears in M2, I have to unhide the base image in order for it to show up at all.  Is this correct?

#9
Profile photo of Mall Staff 184060.00 $tone May 11, 2017
Public

Hi there,

Perhaps M2 handles images differently.

Yes that is right. 

I have to unhide the base image in order for it to show up at all.  Is this correct?

Yes, kindly do that.
Regards,
Mall.

#10

Please login or Register to Submit Answer

Written By

Comments