Category Archives: magento

11.06.19
by

Magento export categories list using sql

SELECT DISTINCT cc.entity_id as id, cc.value as path, cc1.value as name FROM catalog_category_entity_varchar cc JOIN catalog_category_entity_varchar cc1 ON cc.entity_id=cc1.entity_id JOIN eav_entity_type ee ON cc.entity_type_id=ee.entity_type_id JOIN catalog_category_entity cce ON cc.entity_id=cce.entity_id WHERE cc.attribute_id = ’57’ AND cc1.attribute_id = ’41’ AND ee.entity_model = ‘catalog/category’

08.02.17
by

Product image upload not appear in Magento

Check these files

/public_html/js/mage/adminhtml/uploader/instance.js

 /public_html/js/lib/uploader/flow.min.js

 /public_html/js/lib/uploader/fusty-flow-factory.js

 /public_html/js/lib/uploader/fusty-flow.js

then allow flash for your web site 
in chrome
  • Go chrome settings,
  • chrome://settings/content
  • Content settings flash
  • Choose Allow sites
09.15.16
by

Magento Admin Login Page “Error 404 Not Found”

Open PhpMyAdmin and run the following query in your database:-

SET FOREIGN_KEY_CHECKS=0;
UPDATE `core_store` SET store_id = 0 WHERE code='admin';
UPDATE `core_store_group` SET group_id = 0 WHERE name='Default';
UPDATE `core_website` SET website_id = 0 WHERE code='admin';
UPDATE `customer_group` SET customer_group_id = 0 WHERE customer_group_code='NOT LOGGED IN';
SET FOREIGN_KEY_CHECKS=1;