Technology Insights

Create Zen Cart MySQL Database And MySQL User

I always forget specific MySQL syntax including creating a MySQL user and granting that user specific access only via localhost to a specific database. So when I install Zen Cart I always end up looking how to do this via the MySQL documentation. Below are simple instructions on how to create a MySQL database using mysqladmin, create a MySQL user, and grant permission to the created database to the created MySQL user.

Technology Insights

How To Easily Install ZenCart Design Templates

Installing ZenCart design templates is easy. I ended up installing one tonight and wanted to note the location of some ZenCart templates as well as how easy it is to install the templates. ZenCart provides a great foundation for an ecommerce store which will allow you to customize any way you like. One thing that is very important from the beginning is the way you should go about customizing ZenCart. If done properly you will be able to keep your software up to date however if you start modifying any file in any location without proper notes then upgrading in the future will be near impossible. Instead of modifying the default ZenCart template you should copy all of the template files into another directory and modify this new group of files so you always have a solid ZenCart base.

Install a ZenCart Template:

Technology Insights

How to Add a New Define Pages Page to the Information SideBox in ZenCart

This article describes how to add a link to the Information sidebox that links to a new page in the defined pages section. You will be required to create files, modify files, and insert SQL code into the MySQL database.

In the instructions below yourpage or YOURPAGE is the title of the page you are adding. For instance if you wanted to add one called technology you would replace YOURPAGE and yourpage with technology and TECHNOLOGY. The actual file would be technology.php.

1. Modify File:

Modify the following file <zencart-root>/includes/filenames.php by adding the following two lines of code:


  1. define('FILENAME_DEFINE_YOURPAGE', 'define_yourpage');
  2. define('FILENAME_YOURPAGE', 'yourpage');



  1. define('FILENAME_DEFINE_PRIVACY', 'define_privacy');
  2. define('FILENAME_PRIVACY, 'privacy');