You know we can easily fetch the product names using the Model object. But what if you want to list out all the product names via SQL code? Don’t worry here is the SQL code for you: SELECT `value` AS product_name FROM catalog_product_entity_varchar WHERE entity_type_id = (SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code = ‘catalog_product’) AND …
It’s really a tedious task when you have to copy all the cms pages/static blocks from your development server to the live server. If you are importing the whole database then you are lucky enough but if you are updating in already installed Magento server then :(, luckily you can use the following commands via …
Dear All I am trying to share my knowledge gained so far in web development fields from now onwards via this blog. I will be sharing stuffs related to PHP/Mysql, Magento & more. Well nothing more to say, just stay tuned with my blog 🙂 Lastly, your suggestion/feedback is always valuable and will make my …