1.0 Connection Wizard

This section helps you configure the connection to your live store and start working with your data.



When you open the Store Manager for the first time the Connection Wizard is launched automatically in order to help you connect to your live store database and start working with your store.

In case it is not shown, in order to make the process of connection setup easier you may find the Connection Wizard in Settings Tab -> Connection Wizard:


Connection Wizard in Preferences

Simple Mode 


Connection wizard allows you to configure connection to your store data automatically using Simple mode.

Connection Wizard  - Simple Mode


On the first step, you’ll be suggested to choose the way of connection setup between Simple Mode and Advanced Mode. Let’s start from the Simple one - it allows you to set up connection automatically with no efforts.

If you run this wizard for the first time you’ll be taken to the third step. If you run it manually, you need to select “Add new configuration” in order  to create a new configuration.


FTP Settings


At this step of Connection Wizard, you’ll be asked to specify your FTP details so the Store Manager could proceed automatically. Please, contact your hosting company so they could provide you with FTP details:

FTP Settings page in Simple Mode


Server address - Usually it is your website name like "mywebsite.com" (do not include http://www. prefix); you may use IP address as well.

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

Store root (FTP)-directory - This is the catalog that contains the files of your store (shopping cart) that you can find/see via FTP. Click on browse button to select your shopping cart root folder. To make sure that you have selected the correct folder, check if there are the admin, system and images folders as well as all other files and folders of your shopping cart inside. 

FTP browser

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

FTP connected sucessfully


If you got this message when you use test connection button:

Access denied error


you have to add your IP address to the Access list. It means that the host computer is behind a firewall you may not be able to access it from your home computer. In such cases, you should add your IP to the whitelist (Access Hosts) using your store control panel in order to allow FTP connections from specified IP address. In case you need assistance, you’re welcome to contact your hosting provider and they will gladly help you with the process. 

Click Next to continue.

Store URL 


Please, specify your store URL at this step of Connection Wizard. Please, check this URL in your browser, whether it can be opened.

Store URL step of Wizard

Connection Preview

The next step of Connection Wizard will show you the list of your connection settings. Click 'Finish' to close the wizard and use those settings.


Advanced Mode


In the case for some reasons connection was not configured successfully using Simple Mode, let’s try the Advanced Mode.

To open Connection Wizard, find it in tab Settings -> Connection Wizard:


Once it is shown, please follow few steps below:

Select Connection Mode

Advanced Mode


Create or Select Store Connection Name

Please, select “Add new configuration” to create a new connection to your store or Change current configuration in case you have added some connection settings earlier. 

Advanced Mode actions


FTP Settings


At this step of Connection Wizard you’ll be asked to specify your FTP details so the Store manager could find all the further required information automatically:

Server address - Usually it is your website name like "mywebsite.com" (do not include http://www. prefix); you may use IP address as well.

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

Store FTP-directory
 - This is the catalog that contains the files of your store (shopping cart) that you can find/see via FTP. Click on browse button to select your shopping cart root folder. 

Advanced Mode FTP settings


To make sure that you have selected the correct folder, check if there are admin and images folders as well as all the other files and folders of your shopping cart inside. Use for this browse button:

Browse button on FTP


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


Store URL


Please, specify your store URL at this step of Connection Wizard and click 'Test...' option to verify it. 

Store URL in Advanced Mode


In case the URL is not accepted, please try to open the store URL using any Browser to make sure it is correct. In case you see your store, copy the URL and paste it in Store Manager. 

Pressing the Next button you thereby continue setting procedure.


Select connection type.


On the next step you’ll be asked to choose store connection that you’d like to set up:

Store connection types


Direct connection to remote database allows you to make changes which will be immediately reflected at your store

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

Please, note that we 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;

Benefits:

 - this type of connection is useful if you don't have direct access to MySQL database, it works the same way as an ordinary web browser;

 - you don't need to do POST \ GET operations to synchronize data with your store, all changes are made in real-time.

Disadvantages:

 - .php file is used by HTTP -tunnel, that's why the speed of work depends on your channel speed capacity.  

If you have unstable connection, it is better for you to use bridge connection because it  works with the cached database.  We don’t recommend importing products if HTTP tunnel is set up. We are working on the improvement of 

connection and we’re planning to implement caching import  in the next releases.


6. Let’s check step-by-step instruction how to set-up Direct connection to remote database, HTTP tunnel, and PHP MySQL bridge connection.


Direct connection to remote database


Please, choose a Direct connection to the remote database 
from the list of all available operations in the Select Type Connection step.

- the next step of the Connection Wizard requires you to specify your Host address. 

Port checking OK


Usually, this is your website name, such as "mystore.com" (do not include the 'http://www.' prefix). You can enter IP address or domain name as well. 

In most cases, the database port is 3306, but it can be different. Contact your hosting company to precise this information.

Click 'Test Host Address' to verify the data correctness and  press Next to proceed.

- on the next step, you have to configure your database login and password. You can specify manually the appropriate details or use Autodetect option to automatically determine them.

Database login step


Test Database Login  button helps identify the accuracy of the specified data on this step.

- to select the appropriate database name you may use the 'Get databases' option on the following step of connection wizard.  

Database Name


To facilitate the definition of the prefix database press 'Autodetect' button.

If after clicking 'Test Database' button you get the following message: 

 
Database checking 'OK'

specified data are correct, and you may continue to set up Direct connection.

- configuration name step.

Check configuration name

 
Use the name associated with the name of your store for which you are setting this connection. 

Click 'Next' to see the summary of your connection details. If all settings are correct, press Finish to complete the connection setup. Click OK to close the Preferences window, and begin working with your store data.


HTTP tunnel 


Choose HTTP tunnel store connection you would like to configure  from the list

Tunnel Connection Type


and you’ll be redirected to the following page to confirm Tunnel URL. Make sure the link includes http:// prefix. To verify specified Tunnel URL link press 'Test...' button.

You have to get such message to be able to proceed:

Tunnel Test is Sucessful


The next step requires configuring the database login (username) and appropriate password.

Database login step


Test button helps you check the correctness of your entries and gives a possibility to proceed. 

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

Database check Name


You should specify the name of your tunnel configuration to which all connection settings will be saved. Type the name associated with the name of your store which you are connecting to.

Tunnel Confoguration Name step


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


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

bridge connection type


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.

Bridge login and password


Click Next so the Connection Wizard could verify the connection and proceed with uploading the bridge file. 

The next step displays the generated bridge URL link which you can verify by helping with 'Test PHP Bridge connection ' button. 

Bridge configuration complete


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

By pressing the Next button you move to the following step of the setup process. Specify the appropriate configuration name, that, for convenience, should be associated with the store to which it is used.

Bridge configuration name

Press 'Check Configuration Name' option in order to make sure that this name is acceptable for use (see an illustration above).


The late step of bridge configuration wizard displays the summary of connection settings:

Bridge finish page


Click Finish to close the wizard and use these settings.


Comments