Upgrade Magento 1 Via SSH

Upgrading Magento via SSH is usually much simpler than via the magento downloader. To upgrade follow these simple steps. 1. First backup. Download a copy of your database, and backup your files. You can make a zip of them. 2. Set the permissions for mage: chmod +x mage 3. Run mage-setup and sync: ./mage mage-setup […]

Continue reading

MySQL query caching for ex. Magento

Login Plesk MySQL On server with Parallels Plesk Panel versions 8.x, 9.x and above admin password is stored in file /etc/psa/.psa.shadow. Use the following command to get the password: Since version 10 admin password stored in file /etc/psa/.psa.shadow is encrypted. Use the following command to get admin password in plain text: Despite version of Parallels […]

Continue reading

Bulk edit price in Magento with SQL query

Select Prices Update Prices with Value (catalog_product_entity_decimal.attribute_id=75 = price) Empty Value Update Prices with % 1.19 is 19% tax Id=75 is the price Id = 76 is the special price (see table eav_attribute table for codes) Update Prices with Rounded Value Run this if you want all your prices to be also rounded e..g 25.00 […]

Continue reading

Magento Import Products

Go to Magento Admin > Catalog > Manage Categories Add your Product categories here but do note your category ids, you can make a list of your category ids in a notepad file. There might be a possibility that you need to define extra attributes for your products so for that go to Catalog >Attributes […]

Continue reading

Magento Admin menu werkt niet meer

Zojuist een upgrade gedaan van een magento installatie naar een nieuwe versie via Magento Connect Na de upgrade bleek de admin menu niet meer te werken in de backend. De oplossing bij mij was het Head.php bestandje te vervangen. Bestand staat in app/code/core/Mage/Page/Block/Html/ Download hier het  Head.php bestand voor de oplossing : Head.php

Continue reading