Magento Delete All ‘Url Rewrite Management’ URLs in the Database

To delete all the URL rewrites from the Magento admin backend, you can do the following:

      1. Using your favourite database browser, connect to your Magento database
      2. Go to the table named ‘core_url_rewrite’
      3. Empty this table
      4. Log back in to the Magento backend and reindex all
This action will clear out all manually and system created rewrites and recreate only the needed ones.

Magento Community Edition 1.9.2 is Now Available

The latest stable release of the Magento Community Edition 1.9.2 is now ready to download. This will be a great opportunity to built more secure site with best quality.

Features of Magento CE 1.9.2

Updates technology and improves quality

Latest versions of the Zend 1 Framework and Redis integration comes with the new release. Over 105 quality improvements will be provided throughout the product.

Automated functional testing framework

The new release will provide almost 170 automated functional tests for merchants with in house development teams. This will help to maximise the quality. At the time of marketing, it is easier to do basic acceptance testing when adding extensions, making customizations, or upgrading.

Continuous security enhancements

The recent security patches like SUPEE-5344, SUPEE-5994, and SUPEE-6285 provides better security for the sites.

So its time to download Magento Community Edition 1.9.2 and experience the change.

Get Base Url , Skin Url , Media Url , Js Url , Store Url and Current Url

Get Url in CMS and Static Blocks

To get SKIN URL

{{skin url='images/testimage.jpg '}}

To get Media URL

{{media url='/testimage.jpg'}}

To get Store URL

{{store url='mypage.html'}}

To get Base URL

{{base url='mystore/mypage.html'}}

Get Url in Phtml

Not secure Skin URL

echo $this->getSkinUrl('images/sampleimage.jpg')

Secure Skin URL

echo getSkinUrl('images/ sampleimage.gif', array('_secure'=>true))

Get Current URL

$current_url = Mage::helper('core/url')->getCurrentUrl();

Get Home URL

$home_url = Mage::helper('core/url')->getHomeUrl();

Get Magento Media URL

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA);

Magento Skin URL

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_SKIN);

Get Magento Store URL

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_WEB);

Get Magento Js URL

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_JS);

Marketz – Useful free marketplace magento extension

If you are looking to convert your existing Magento store to a cutting-edge market place platform, here is Marketz, a super cool Multi-Vendor extension from cartin24 Team.

Using Marketz multi-Vendor magento extension, magento store owners are able to transform their existing store to a fantastic marketplace. Every website owner can now sell his/her products and allow others to sell their products too. Also, with this plug-in, the owners can easily earn additional revenue by setting up commission fee for every purchase of vendor products.

Download Marketz

Bitnami Magento Development

SSH Connection using Putty:

Windows does not come with a bundled SSH client by default. It is recommended that you use the freely available Putty utility, which can be downloaded from:

http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

You will need to get your SSH key in PPK format

Once you have your key in PPK format, you can connect following these steps:

  • Start Putty ( Start Menu -> Programs -> Putty -> Putty ).
  • Enter your machine IP address or public domain name in the Session section. You can find out the hostname of a server by going to the Servers page, selecting the server and clicking ‘Manage Server’. The hostname will appear next to Public DNS and it will be similar to ‘xyz.bitnamiapp.com. Of course a server needs to be running so you can connect to it.
  • Putty Config
  • Add your private SSH PPK key path.
  • Putty Config
  • Click “Open” to start the SSH session.
  • Click “yes” to accept SSH key.
  • Enter your login: bitnami
  • ssh

You can also simplify the above procedure and add your key to the special SSH agent. This way you will not have to provide your ssh key every time you connect.

  • Start “Pageant” ( Start Menu -> Programs -> Putty -> Pageant ).
  • Click “Add key” and choose the PPK file.
  • Open “Putty” application ( Start Menu -> Programs -> Putty -> Putty ).
  • Go to Connection -> Data using the left menu.
  • Enter “bitnami” as the “Auto-login username”.
  • Go to “Session”.
  • Insert your server Public DNS (ec2-xyz.compute-1.amazonaws.com / xyz.bitnamiapp.com) in the “Host Name” field. You can find this in Server Management for BitNami Cloud Hosting servers or in the instance properties in Amazon console.
  • Click “Open” to start the SSH session.

If you prefer to use putty from the command line you should include ‘-i’ and ‘-l’ options as follows:

> putty -i “C:\Path\To\bitnami-hosting.ppk” -l bitnami example.com

Upload Files ( Using FTP)

You should follow these steps to upload files using FileZilla:

  1. Get your SSH Key in PPK format
  2. Start FileZilla
  3. Go to edit -> preferences
  4. Select SFTP
  5. Click “Add keyfile”
  6. Select the PPK file
  7. Save the settings (click OK in settings window)
  8. In the connection toolbar, enter:
    1. Host: the Public DNS ( xyz.bitnamiapp.com / ec2-xwz.compute-1.amazonaws.com)
    2. User: ‘bitnami’
    3. Password: leave it blank
    4. Port: 22
  9. Click “Quickconnect”
  10. If you get a message “The server’s host key is unknown”, click “ok” button
ftp

Connect Database Using Phpmyadmin

By default phpMyAdmin and phpPgAdmin are not accessible from the outside for security reasons. In order to access them, you can create an SSH tunnel to Apache, sending your requests to your webserver from 127.0.0.1 (localhost).

You should follow these steps to create the tunnel:

  1. Get your SSH private key if you don’t have it already.
  2. Create the tunnel (Use Putty).
    • Follow the steps described SSH Connection using Putty above
    • Before opening the connection. Go to Connection -> SSH -> Tunnels, enter the values below and click “Add” button:
      • Source port: “8888”
      • Destination: “localhost:80”
    • Click Open
  3. While the tunnel is active you can connect to the web application at http://127.0.0.1:8888/phpmyadmin or http://127.0.0.1:8888/phppgadmin in your browser.
    The default login is:
    • username: root (“administrator” for legacy versions) for MySQL or postgres for PostgreSQL database.
    • password: bitnami (for BitNami AMIs), <application password> (for BitNami Cloud Hosting)