How to Setup Zen Cart on local server

  • Download XAMPP for Windows by clicking here.
  • Install XAMPP and then make sure that you have both Apache and MySql modules running.xampp
  • Then go to http://zen-cart.com/ to download the latest version of Zen Cart.
  • Extract the Zip file using Winrar or Winzip
  • Rename the extracted folder zen-cart-v1.5.1-full-fileset-09182012 to shop/catalog and then copy the folder to C:/XAMPP/htdocs folder
  • Then type http://localhost/phpmyadmin in your browser and click on Databases and then type the name of the database you want to create for your zen cart installation.database
  • By now you have created a database for your zen cart installation, username for this database in xampp by default is root and password is blank.
  • Now navigate to http://localhost/shop in your browser and you will see the following page install1
  • Simply click on "Click here" to begin installation and on the next page click Continue.
  • Accept the license agreement by choosing the radio button " I have read and agree to abide by the Terms and Conditions as stated above."
  • On the next page scroll down and at the bottom click Install.
  • On the next page it will ask you to provide the database information. Database host will be localhost, database username will be root, password will be blank and for the database name, enter the name of the database that you created and then click Save Database Settings.install2
  • On the next page click Save System settings at the bottom.
  • Now you will come to the Store Setup page, here enter the name of the store, store owner, store owner email, country, zone, address and click Yes if you want to install the demo categories/products and then click Save Store Settingsstore_setup
  • Finally the admin setup, enter administrator username, password, confirm password and email and then click Save Admin Settingsadmin_setup
  • You have now installed Zen Cart on your local server. Delete the zc_install folder inside the shop folder and also rename your admin folder to a secret admin folder name.

WordPress Plugins that I used in my blog

The following plugins I have installed on my blog.

  1. AddThis Social Bookmarking Widget
  2. Contact Form 7
  3. Contextual Related Posts
  4. Exclude Pages from Navigation
  5. FD Feedburner Plugin
  6. GD Star Rating
  7. Google XML Sitemaps
  8. Jetpack by WordPress.com
  9. Platinum SEO Pack
  10. Simple Social Icons
  11. Ultimate Google Analytics
  12. WP-Cumulus
  13. WP-Polls
  14. WP-reCAPTCHA
  15. WP-SpamFree

I have added links of the plugins so you can follow the link for each plugin’s description. If you can recommend me few plugins for my blog or share your list of plugins, feel free to leave comments below.

How to migrate Joomla 1.5 to Joomla 2.5

The following steps will help you to migrate your Joomla 1.5 website to Joomla 2.5

  1. Make sure that your Joomla 1.5 is upgraded to the latest stable version of Joomla (1.5.26)
  2. Backup your Joomla 1.5 website using a free component Akeeba Backup from https://www.akeebabackup.com/ or you may also manually backup your Joomla website by going to phpmyadmin and export the dump of your mysql database and then create a backup of Joomla files by going to Cpanel > File Manager, select all files/folders and click compress to create a zip file.
  3. Download JUpgrade Component by going to Joomla Extensions Directory or by following this direct link here. This component requires registration to download. (Latest Version Available is 2.5.2).
  4. Go to your Joomla 1.5 Administrator  and go to Extension >Install/Uninstall  and then install JUpgrade component.
  5. Go to Components > JUpgrade and click Start Upgrade Button.
  6. jUpgrade component will download the latest version of Joomla 2.5, decompress it and install it. After that, it will migrate all of your data from old Joomla 1.5 to the new Joomla 2.5 installation.
  7. jUpgrade will install the new website in a sub folder jupgrade e.g yourdomain.com/jupgrade
  8. The new site should have all the content, users and other core components data.
  9. Move the existing Joomla 1.5 website from root to another subfolder(e.g /oldsite).
  10. Finally move your Joomla 2.5 website from jUpgrade folder to root to make it live.

How to transfer magento to a new host

  • Go to your Cpanel > File Manager and then select all your magento files and then click compress to create a zip file of the magento files.
  • Download the zip file by going to http://yourdomainname.com/backup.zip (Replace youdomainname.com with your domain name and backup.zip with the name of your zip file)
  • Then go to phpmyadmin and on your left click on the database name and then click Export. Select Custom Export Method and choose Output “Save output to a file “ and then choose Compression “zipped or gzipped” and click Go. This will download the compressed database/mysql dump file.
  • On your new host, upload the zip file using ftp (Filezilla) and then go to Cpanel > File Manager and select the zip file that you uploaded and click extract.
  • Create a new database on the new host and add the database user to it.
  • Magento database makes use of foreign key constraints to ensure database integrity. So if you attempt to import the mysql file that you exported using phpmyadmin you will get errors like
Cannot add or update a child row: a foreign key constraint fails
  • So to import the sql file without constraint checking add the following statements at the beginning of the sql file.
SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8;
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';
SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0;
  • At the end of the mysql file add the following statements to enable constraint checking again.
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT;
SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS;
SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION;
SET SQL_NOTES=@OLD_SQL_NOTES;
  • Now you will be able to import the mysql database without getting any errors.
  • Update the database details by going  to aap > etc >local.xml  and update the database name, host, database user and password.
  • Finally change the nameservers of your domain to point your domain to the new host and you are done with transferring magento to a new host.
If you need help in transferring/moving your magento website to a new host,  hire me on odesk.

How to bulk import products into Zencart 1.5

If you want to import products in bulk into Zen cart then follow the steps below

  1. Download EasyPopulate 4.0 (EP4) module for Zencart by going to https://github.com/chaddro/EasyPopulate-4.0
  2. Change the name of the admin directory to match your Zen Cart Installation.
  3. Using Filezilla (ftp), upload all the files in admin directory to your site maintaining the directory structure.
  4. Upload the additional file in zencart 1.5 extra files folder.
  5. Create a folder ‘temp’ in the root of your zencart store. You may edit the uploads folder by going to Configuration -> Easy Populate 4
  6. Add 2-3 categories and products manually.
  7. Then go to Tools >Easy Populate 4
  8. Click on Complete Products (with Metatags) to export the csv. This will save the csv to the uploads directory (temp folder)
  9. Download this csv file and open it with Open Office Calc or Microsoft Excel.
  10. Populate this csv file with your products data.
    • v_products_model has to be unique, any record with blank v_products_model will be skipped
    • Upload all your images in your zencart images folder and add the name of the image with extension to v_products_image column in the csv.
  11. When your csv is ready, go to Tools > Easy Populate 4 and Upload EP File (Choose File and then click Import File)
  12. When the file is imported, click “Import” against that file and your products will be imported into your zencart store.
  13. After the import is complete, you can have a look at Import Results for the no of records inserted and updated
  14. For more details visit Easy Populate 4 Support Thread.
If you need help in importing products with images in bulk to your zen cart site, hire me on odesk.