1. Quick Start Guide
fmRegistration, fmPrefrences - fmQuickStartGuide
This chapter describes how to perform product installation, registration and how to setup database connection. The following topics are covered:
- Setup Database Connection
- Setup FTP Connection
IMPORTANT: Store Manager is a Windows application (not pxp extension) and should be installed on your computer.
The download link may be found in your order confirmation e-mail. If you didn't receive any, please download Store Manager at http://license.emagicone.com
You should close all Store Manager applications before starting the installation procedure.
Store Manager Setup Wizard will guide you through the following software installation steps:
- accept License Agreement
- select Destination Location (where should Store Manager be installed)
- choose which components should be installed (all - full installation is recommended; compact; or custom)
- select Start Menu folder (where to place program shortcuts)
- select additional tasks (optional)
The Wizard will inform you about successful installation. After that you will be all set to enjoy the advantages of Store Manager for osCommerce.
Once you are done with installation, you will be asked to provide license data to register application.
Specify your First Name, Last Name and your License Number (as it appears in your license account).
Setup Database Connection
In order to start working with a specific store (add products, view orders, etc) you need to setup store connection. It can be done in Preferences Window, which appears automatically on the first start-up and can be accessed later through Tools -> Preferences.
Database Connection tab in Preferences Window has three sections: Store Configuration Section, Remote Database Connection Settings Section (or PHP MY SQL Bridge and Local Database Connection Settings - see below) and Localization Section.
1. First of all, you should create Store Configuration. Preferences window allows you to create, edit or delete your store configuration (connection settings).
2. Then you have to set-up database connection. Default database installed with Store Manager is a kind of temporary database created locally for different purposes. It can be used both for testing Store Manager functionality or working with your store using PHP MySQL Bridge connection. If you use free demo version and you just want to run software to see how it works, please use embedded configuration with default database.
To use Bridge Connection while working with local (Embedded) database is usually much faster than the remote one. You can use your local database to store your remote database inside it, make changes and then just synchronize it. It means that first you make changes locally and then upload them to the website database.
- Store Manager requires direct MySQL database connection. The majority of hosting companies allow direct connections to MySQL database. However, in most cases you have to go to your control panel and add your home/office computer IP address or domain name to Access List . Access list is a list of IP addresses allowed to access MySQL port 3306 from outside. This option can be found under MySQL settings. Feel free to ask your hosting support to assist you in enabling direct MySQL access, they must help you since it is trivial task.
- If neither direct MySQL nor SSH connections are available, PHP MySQL bridge may be used.
- If for some reasons direct connection via port 3306 is not allowed, there is another way - secure SSH connection. Actually SSH is a kind of tunnel between two computers - your computer and your server. Look here for more details about SSH. See "Preferences" window, "SSH" page. You have to indicate the following information for SSH: user name, password and remote port number.
- Note: SSH settings do not override MySQL settings. To connect to your database using SSH you must specify all required MySQL parameters and SSH. Also Preferences menu includes Notification settings, which you might want to change.
3. Finally, Client charset and Font charset can be left by default or you can choose your region from the drop-down.
Setup FTP connection
In order to be able to manage, view or upload images using Store Manager you should configure FTP connection.