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 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

    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

     Sql query: Delete all Orders, Sales & Customer Data in Magento  

  • Installing OAuth for PHP clients on CentOS 6

    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

    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?

Get In Touch