1.1. Connection Wizard

fmPreferencesfmConnectionWizard

This section will guide you through configurations of connection(s) to your live store, using our connection utility - Connection Wizard.

Sub-pages listing:

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:

Connection Wizard option

Simple Mode

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

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 to set up the connection automatically, requiring minimal user input.

Upon first running, you will need to select [Create New Store Connection] to add new configuration of the store.

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

Choose Connection Type

You will need to choose

  • [Alternative Connection]. This option allows to connect to your shop with FTP.
  • [Connect via native Magento module] . This option allows you to connect via Store Manager Connector.

Note: Magento Store Manager Connector should be pre-installed in Admin Panel.

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.

On this step you have to specify the following information:

  • "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.").
  • "User name (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 root 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, click 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 on the [Test FTP Connection] button. If you receive the message: “FTP was connected successfully”, please proceed with the connection setup, by pressing [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. An 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 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 it, click [Finish] to close the wizard and use these settings.

Advanced Mode

If, for some reason, the connection does not configure successfully during Simple Mode, try proceeding using 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 "Connection Wizard": Menu -> Preferences (F12) -> Database Connection -> Connection Wizard

Database Connection wizard

Select Connection Mode

Press [Advanced Mode], which allows you to set up your connection manually, and follow the steps shown below.

Advanced Mode

Change Current or Create New Store Connection

Select [Create New Store Connection] to create a new connection to your store, or [Change Current Connection Settings], 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.").
  • "User name (login)", "Password". Specify your FTP username and password in these fields. 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 root 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, click 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 if the URL is valid, and can be opened, by clicking 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 if 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 on your store.
  • [HTTP tunnel] is is an alternative way to connect to your store directly and make instant changes
  • [PHP MySQL bridge connection] allows you to work with your database much more rapidly, though it requires manual synchronization.

Direct connection to remote database

Choose [Direct connection to remote database] from the list:

Database Host and Port

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, 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 need to add your port ID to the end of the base URL, separated by a semi-colon, i.e.: "www.yourwebsite.com:3306".

Note: 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

On this step, 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 it 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, 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. 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] to complet the connection setup. Click [OK] to close the "Preferences" window, and begin working with your store data.

HTTP tunnel

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.

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

On this step, you should 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.

Database Name

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 Configuration Name to save all the connection settings too. It 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], and 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.