Category: Magento

Moving Magento Catalog

The best route to migrate a catalog from one Magento store to another can be accomplished with the following procedure Take a complete database backup of the target Magento Store Now separately backup the following tables on the target Magento Store All tables beginning with catalog eav_attribute eav_attribute_group eav_attribute_label eav_attribute_option eav_attribute_option_value eav_attribute_set eav_entity_attribute eav_form_element eav_form_fieldset […]

Magento Suspected Fraud

If an order comes through Magento as Suspected Fraud and you’ve addressed the issue via your Payment Gateway, many times Magento will not recognize the change. Here’s how to manually update the order status: From the backend of magento, open the order in question. Take Note of the Order # and the number after the […]

Quick reset an admin password

To change a magento admin password, run the following query on the magento database. Replace ‘password’ with your desired password. Replace ‘admin’ with the username you wish to reset. The Letters ‘qX’ can be replaced with another two letters if desired, or you can leave them as is. UPDATE admin_user SET password=CONCAT(MD5(‘qXpassword’), ‘:qX’) WHERE username=’admin’; […]

Magento Admin 404

After transferring a database, if you get a 404 error when trying to access admin panel, run the following query on the 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 […]