0. Connection Wizard

This section will guide, and assist you, in configuring the connection(s) to your live store, using our helpful connection utility.



When you open Store Manager for the first time, the Connection Wizard is automatically launched, to assist in connecting you to your live store database, so that you can begin working with your store data.

If it does not start automatically, you may access the Connection Wizard by navigating to Preferences (F12) -> Database Connection -> Connection Wizard
:

Database Connection wizard


You may also open the Connection Wizard via the Preferences tab:


Simple Mode

In Simple Mode, the Connection wizard will allow you to configure the connection automatically to your store data.



Select Connection Mode


The first step asks you to choose the desired connection setup method, Simple, or Advanced Mode. Let’s start by selecting Simple Mode, which allows setting up the connection automatically, requiring minimal user input.




Upon first running, if Simple, rather than Advanced Mode is chosen, you will next need to select “Add new configuration”,  in order to create the new configuration with the store. 

This will subsequently allow you to specify custom settings for some the configuration options.



FTP Settings


The Connection Wizard will now ask you to specify your FTP details so that Store Manager can proceed with automatic configuration. Please, contact your hosting company if you require assistance with your specific FTP details:

Server address - Usually this is your website name, such as "mywebsite.com" (do not include the 'http://www.' prefix); you may use your IP address as well (also be sure NOT to preface the IP address with 'http://www.').

Username (login), Password - Specify your FTP username and password. Please make sure that the specified user has all privileges (to your particular store) and can view, edit and create files in your shopping cart folder.

Store FTP-directory - This is the relative 'root' folder, which contains the data of your store (shopping cart) upon accessing via FTP, or HTTP. To select your shopping cart root folder, c
lick on the [browse] button. In most cases, 

it is ...\public_html or \httpdocs or \www. To make sure that you have selected the correct folder if there are an app, tmp and media folders, as well as the other pertinent files and folders that your shopping cart specifies. 


Click the Test FTP connection button. If you receive the message “FTP was connected successfully”, please proceed with the connection setup, by clicking Next.


If you get this message instead (when you use the test connection button):


you will have to add your IP address to the Access list in the 'CPanel' provided by your Internet Hosting Provider. The error indicates that the host computer is behind a firewall, and you may not be able to access it from your

home computer, without explicit permission.To resolve this issue, add your IP address to the 'white list'  (allowable Access Hosts) using your designated store control panel. 

This will allow FTP connections from your specified IP address or range of IP addresses. If you need assistance, contact your hosting provider and they will gladly help you with the process.

Please, check this article for specific details and further information: How to add my IP address to Access List and allow direct MySQL connections?

Click Next to proceed:

Store URL 


In the next step 
of the Connection Wizard, specify your store URL. Be sure and check that the URL is valid, and can be opened, by clicking on the Test Store URL button.



Connection Preview


The next step of the Connection Wizard will show you a list of your connection settings. After reviewing, click Finish to close the wizard and use these settings.


Advanced Mode


In for some reason, the connection does not configure successfully during Simple Mode, try proceeding using the Advanced Mode. 

It is another method of connection setup which allows you to configure one of the three possible types of the configuration:

Store Connection Types

To choose Advanced Mode open the Connection Wizard firstly, using the Menu, navigate to Preferences (F12) -> Database Connection -> Connection Wizard:

Database Connection wizard


In the selected mode, please follow the steps shown below

Advanced Mode


Select Connection Mode

The first step asks you to choose your desired connection setup method, Simple, or Advanced Mode. Selecting Advanced Mode allows you to set up your connection, manually specifying your choices for most of the configuration options.


Create or Select Store Connection Name

Please, select “Add new configuration” to create a new connection to your store, or "Change current configuration" if you have to add, or need to change, previously specified connection settings.


FTP Settings

The Connection Wizard will now ask you to specify your FTP details so that Store Manager can proceed with automatic configuration. Please, contact your hosting company if you require assistance with your specific FTP details:

Server address - Usually this is your website name, such as "mywebsite.com" (do not include the 'http://www.' prefix); you may use your IP address as well (also be sure to NOT preface the IP address with 'http://www.').

Username (login), Password - Specify your FTP username and password. Please make sure that the specified user has all privileges (to your particular store) and can view, edit and create files in your shopping cart folder.

Store FTP-directory - This is the relative 'root' folder, which contains the files of your store (shopping cart) upon accessing via FTP, or HTTP. To select your shopping cart root folder, c
lick on the [browse] button. 

In most cases, it is ...\public_html or \httpdocs or \www. To make sure that you have selected the correct folder, check for admin and images folders, as well as the other pertinent files and folders that your shopping cart specifies. 




Click the Test FTP connection button. If you receive the message “FTP was connected successfully”, please proceed with connection setup, by clicking Next.

Store URL


In the next step of the Connection Wizard, specify your store URL. Be sure and check that the URL is valid, and can be opened, by clicking on the Test Store URL button.


Store URL step
 Once verified, click Next to proceed. If the URL is not accepted, try to open the store URL using a Web Browser, to verify it is correct. If you see your store, copy the URL and paste it in Store Manager.


Select connection type


The next step asks you to choose the type of store connection that you’d like to set up:

Direct connection to remote database, allows you to make direct changes to your underlying data, which are immediately reflected in your store

PHP MySQL bridge connection allows you to work with your database much more rapidly, though it requires manual synchronization.

Please, note that we've added a new type of connection -  HTTP tunnel, which is an alternative way to connect to your store directly and make instant changes.

It possesses the advantages of both direct and bridge connection, and has a number of additional benefits:

 - this type of connection is useful if you don't have direct access to your MySQL database, as it works the same way as if you are using an ordinary web browser
 
- you don't need to perform specific POST\GET operations to synchronize data with your store, all changes are made in real-time

It's disadvantages:

 - a .php file is used by HTTP tunnel, and the speed of your work largely depends on your connection speed and capacity.  If you have an unstable connection, it is better to use a bridge connection, because it works with a

cached database, which is more connection state tolerant.  We don’t recommend importing products if HTTP tunnel is configured. We are working on improvements to this connection type, including a plan, in a future release, 

to implement caching import.


Direct connection to remote database


Choose Direct connection to remote database
from the list


The next step of the Connection Wizard asks you to specify your Host address. Usually, this is your website name, such as "mywebsite.com" (do not include the 'http://www.' prefix); 

you may use your IP address as well (also be sure to NOT preface the IP address with 'http://www.'). Alternately, you may press Autodetect.




Next, you must enter the address of the computer you want to connect to. This computer must run MySQL server and contain your store database.

Usually, the database server address is the same as your store address. You simply need to add your port id to the end of the base URL, separated by a semi-colon, i.e... 'www.yourwebsite.com:3306'.

* We recommend connecting to the database through port 3306. If it doesn’t connect successfully, contact your hosting provider, to determine your correct port for connecting to your instance of MySQL.

Click Test Host Address to verify the host address' port and Next to proceed.


Database Login. Please, specify the username and password of your database connection.

To determine your settings, follow these steps:

      1. Open your store using any FTP Client (such as FileZilla, WinSCP, etc.)
      2. Open your store root directory via FTP and then locate the local.XML file for your store. You can find in the folder 'your_store_root/app/etc/local.xml'.
      3. Open the local.XML file and you will find your username and password (see below)
      4. Copy these settings to Store Manager
                                    <username><![CDATA[name]]></username>              
                                    <password><![CDATA[pass]]></password>                  

Press Test Database Login to check the credentials and then Next to proceed if a successful connection is verified.




The next step of the Connection Wizard asks for your database name. Press Autodetect to get the database name and Next to proceed to the last step.

Configuration Name. Specify a Configuration Name to save all the connection settings, should you desire to do so. It might be a good idea to use a name related to your store. Click Next to see the summary of your connection settings. If all settings are correct, press Finish completing the connection setup. Click OK to close the Preferences window, and begin working with your store data.

HTTP tunnel

Please, choose HTTP tunnel store connection and you’ll be redirected to the following page to confirm your Tunnel URL. Make sure the link includes an 'http://' prefix. Check a successful link connection by clicking Test HTTP Tunnel.



The next step is to enter your database server address, which is usually the same as your store address, e.g. if your store URL is “http://www.mystore.com” then your server address should be “mystore.com”. Please, do not enter “http://” and “www” prefixes. You may also press Autodetect,  for the Wizard to automatically determine your store address.


Database Login. Specify the username and password to your database.

          To determine your settings, follow these steps:
  1. Open your store using any FTP Client (such as FileZilla, WinSCP, etc.)
  2. Open your store root directory via FTP and then locate the local.XML file for your store. You can find in the folder 'your_store_root/app/etc/local.xml'.
  3. Open the local.xml file and you will find your username and password (see below)
  4. Copy these setttings to Store Manager
                                       <username><![CDATA[name]]></username>               
                                       <password><![CDATA[pass]]></password>                  

Press Test Database Login to check your database access credentials. If the login test is successful, press Next to proceed.


The next step of the Connection Wizard asks for your database name. Press Autodetect to get the database name and Next to proceed to the last step. 


Click Next to proceed.

Configuration Name. Specify Configuration Name to save all the connection settings too. I might be a good idea to use the name related to your store. Click Next to see the summary of connection settings and Finish to complete the connection setup. Close the preferences window by clicking OK to start working with your data.



PHP MySQL bridge connection


If neither direct MySQL nor HTTP tunnel connection is possible, try PHP-MySQL bridge connection,
as an alternative. The bridge is just another way to connect to your database.


Choose PHP MySQL bridge connection, then click Next.

The Connection Wizard will then display the login and password for your bridge connection. 

The username and passwords are generated by the software in order to facilitate a connection secure and are different from the database access username and password of your store.


Click Next, for the Connection Wizard to verify the connection and proceed with uploading the bridge file. Be sure to record your credentials and click Finish to close the wizard and proceed, using these settings.

Please, make sure you select the type of database you need if you chose to use the bridge connection.

By eMagicOne Inc.

Comments