Schedule a call with our team and discuss how can we, not only help you technically but help in increasing your ecommerce’s conversion rate.
Find the base image attribute id from eav_attribute.
|
1 |
attr_id = SELECT `attribute_id` FROM `eav_attribute` WHERE `attribute_code` = "image" AND `frontend_label` = "Base" LIMIT 1; |
Find all images which having a Base image role.
|
1 |
value = SELECT `value` FROM `catalog_product_entity_varchar` WHERE `attribute_id` = (attr_id); |
Find all ids from the media gallery.
|
1 |
gallery = SELECT `value_id` FROM `catalog_product_entity_media_gallery` WHERE `value` IN (value); |
Update the media gallery value to 0.
|
1 |
UPDATE `catalog_product_entity_media_gallery_value` SET `disabled` = 0 WHERE `value_id` IN (gallery); |
Final query:
|
1 2 3 4 |
UPDATE `catalog_product_entity_media_gallery_value` SET `disabled` = 0 WHERE `value_id` IN ( SELECT `value_id` FROM `catalog_product_entity_media_gallery` WHERE `value` IN ( SELECT `value` FROM `catalog_product_entity_varchar` WHERE `attribute_id` = ( SELECT `attribute_id` FROM `eav_attribute` WHERE `attribute_code` = "image" AND `frontend_label` = "Base" LIMIT 1 ) ) ); |
create the event.xml on your module under the Vendor/Module/etc/event.xml and...
If you need a custom meta tag for a specific...
Generally, if you load font as preload, it will load...
Step 1: First you need to add di.xml in the...
Override the vendor/magento/module-sales/view/frontend/templates/email/items/order/default.phtml file on your theme and add the...
