Category: Magento 2 : Operations using SQL

cat update_product_attributes_using_sql.sql update catalog_product_entity_int — select * from catalog_product_entity_int set catalog_product_entity_int.value = 1 where (catalog_product_entity_int.attribute_id = 97) and catalog_product_entity_int.entity_id = ( select entity_id from ( SELECT product.entity_id as entity_id FROM bitnami_magento.catalog_product_entity product inner join catalog_product_entity_decimal price on price.entity_id = product.entity_id and (price.attribute_id in (78)) inner join catalog_product_entity_int status_t on (status_t.entity_id = product.entity_id) and (status_t.attribute_id=97) where …

Continue reading

truncate table bitnami_magento.catalog_product_entity_gallery; truncate table bitnami_magento.catalog_product_entity_media_gallery_value; truncate table bitnami_magento.catalog_product_entity_media_gallery_value_to_entity; truncate table bitnami_magento.catalog_product_entity_media_gallery_value_video; no warranty given as is

use bitnami_magento; SELECT * FROM bitnami_magento.catalog_product_entity_varcharwhere ( attribute_id = 73 ) — and (value = ”)limit 10 replace into bitnami_magento.catalog_product_entity_varchar (attribute_id, store_id, entity_id, value )SELECT 181, 0, product.entity_id, left(concat(“https://www.amazon.com/s?k=”, product.value),255)FROM bitnami_magento.catalog_product_entity_varchar productinner join catalog_product_entity_int status_t on ( status_t.entity_id = product.entity_id ) and ( status_t.attribute_id = 97 and status_t.value = 1 )where (product.attribute_id=73) — and (value …

Continue reading

select * from bitnami_magento.catalog_product_entity_media_gallery_value_to_entity where value_id in (232574, 242521) — 232574, 242521 select * from bitnami_magento.catalog_product_entity_media_gallery_value_to_entity where value_id in (232574, 242521) — where value like ‘%ud6vtf2a_5ezdxueqvnr%’ –select * from bitnami_magento.catalog_product_entity_media_gallery_value_to_entity select * from bitnami_magento.catalog_product_entity_media_gallery — where value_id in (237733, 237734) where value like ‘%ud6vtf2a_5ezdxueqvnr%’ update bitnami_magento.catalog_product_entity_media_gallery set value = ‘/u/d/ud6vtf2a_5ezdxueqvnr1dyny_1.jpeg’ where value = ‘/u/d/ud6vtf2a_5ezdxueqvnr1dyny.jpeg’ and …

Continue reading

update catalog_product_entity_int — select * from catalog_product_entity_int set catalog_product_entity_int.value = 2 where (catalog_product_entity_int.attribute_id = 97) and catalog_product_entity_int.entity_id in ( select entity_id from ( Select distinct(product.entity_id) FROM bitnami_magento.catalog_product_entity product left join catalog_product_entity_media_gallery_value_to_entity valentity on valentity.entity_id = product.entity_id left join catalog_product_entity_media_gallery image on image.value_id = valentity.value_id and (image.attribute_id in (90)) inner join catalog_product_entity_int status_t on (status_t.entity_id = …

Continue reading