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 while pressing the 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.

If 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 a 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 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 a list and you’ll be redirected to the following page to confirm Tunnel URL.

Tunnel Connection Type

Make sure the link includes http:// prefix. To verify the specified Tunnel URL link press 'Test...' button.

You have to get a 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 to 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.

These values are generated by the software automatically in order to ensure the security of the connection and, as usual, are different from the database access username and password of the 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 which it is used to.

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 last step of bridge wizard displays the summary of connection settings:

Bridge finish page

Click 'Finish' to close the wizard and use current configuration.

By eMagicOne Inc.