Categorie: Tutorials

  • Available qyt on the cart page in Magento 1

    Available qyt on the cart page in Magento 1

    For the available qyt on the cart page use below code;

  • Magento orders by sku

    Magento orders by sku

    SQL code for orders by sku SQL code for orders by sku

  • 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  

  • 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 […]

  • Password Reset for Joomla , WordPress and Joomla (new password = NEWPASS)

    Reset password with Navicat Lite Joomla: Wordpress: Drupal: If you had the following message: Sorry, there have been more than 5 failed login attempts for this account. It is temporarily blocked. Try again later or request a new password. You can :

  • Here are three methods for importing large SQL files

    Method 1: Bigdump http://www.ozerov.de/bigdump.php I used a script called BigDump.php, a staggered SQL dump importer. It executes only a small part of the huge dump and restarts itself. The next session starts where the last was stopped to keep you from running into your server’s limits. Instructions for using it are on the BigDump website. […]

  • @font -face example

    @font -face is supported by the top browsers using various font types, for example Safari, Opera, Firefox and Chrome handle .TTF and .OTF, Internet Explorer can handle .EOT, and what’s probably worth a mention, Firefox 3.6 now handles .WOFF, and Opera supports .SVG. @font-face implementation: CSS: @font-face { font-family: “Museo 300”; src: url(“fonts/Museo300-Regular.eot”); src: local(“Museo […]

  • Show module positions of any Joomla! website?

    You would like to put some Module at your site but don’t know where to put it…. Or “Nice site, is it Joomla! ?”… Or “How did they use some area at that Joomla! site? Is it a Module?”… You can easily find out yourself, without being logged in! Add the parameter ?tp=1 behind the URL, […]