Just some info…
-
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…
-
Install Webmin on CentOS 7
INSTALL WEBMIN To get started, login your remote server and follow the steps below: First, create a new file webmin.repo in /etc/yum.repos.d/ : and paste below line: Install webmin GPG key using below command. Now, update the repositorys: Install webmin: Start the service and make it start automatically By default, Webmin will listen on port…
-
Magento orders by sku
SQL code for orders by sku SQL code for orders by sku
-
Install OpenSSL en SOAP on CentOS
Install OpenSSLyum install opensslNote: This is typically installed on CentOS by default. Install SOAPyum install php-soap apachectl restart
-
Disable paypal logo from sidebar in Magento
System > Configuration > Payment Methods > Paypal All in One Payments Solutions> Paypal Payments Advanced (Includes Express Checkout)> Basic Settings – Paypal Payments Advanced > Frontend Expereince settings> Paypal Product Logo
-
Sql query: Delete all Orders, Sales & Customer Data in Magento
Sql query: Delete all Orders, Sales & Customer Data in Magento
-
Installing OAuth for PHP clients on CentOS 6
Installing EPEL and Remi repo on CentOS 6 set : enabled=1 on the topmost repo Installing OAuth for PHP clients
-
REASON 442: FAILED TO ENABLE VIRTUAL ADAPTER
REASON 442: FAILED TO ENABLE VIRTUAL ADAPTER on Windows 8.1 If you receive this error on Windows 8 or Windows 8.1 while trying to connect with the Cisco VPN Client then the solution is a simple registry fix. To fix: Click Start and type regedit in the Search field and hit enter.Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\CVirtAFind…
-
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…
-
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…
Got any book recommendations?