2014-04-28
Rating 0 stars - 0 votes

How to Connect Store Manager to PrestaShop Database

Store Manager for PrestaShop is a desktop solution using which PrestaShop store owners can efficiently handle web store data. Correspondingly, to access and modify database, disposed at the web server, you should connect Store Manager application to it. After you install and register the application (or simply download free trial version to seize Store Manager) you are supposed to connect to PrestaShop database you will work with.


You can choose between three database connection types: direct connection, direct connection through HTTP tunnel or bridge connection. In case you use direct connection, any change you implement to store data will be immediately applied. When you set up bridge connection, you have to proceed with Get Data From Web operation before adding new information or modifying existing. In such a way local copy of PrestaShop database is being created. Respectively, to get modifications displayed at the front-end you should carry out Post Changes to Web operation.


Connection to web shop database can be configured in two ways: either you input necessary details manually for type of connection you’ve selected or automate this procedure with Connection Wizard.

Looking For and Inputting Details Manually

If you want to manually input connection details, open Preferences (F12) -> Database Connection. Here you should select connection type and designate settings it requires.

Direct Connection

To access store database via direct connection, you are supposed to input the following details:

  • Host address – this fields stands for name of your website, without http://www. prefix (IP address can also be used)
  • Port – commonly 3306 should be indicated in this field
  • Username, password, database name – these credentials, necessary to get connected to database are available in settings.inc.php file. To reach it you have to connect to the server via FTP client and find config folder. There you will find settings.inc.php file with database name, username and password.

Direct Connection Through HTTP Tunnel

If you want to access database using this type of connection, check corresponding radio and proceed with the following:

  1. Open C:Program FileseMagicOneStore Manager for PrestashopService, where sm_tunnel.php file is disposed
  2. Copy sm_tunnel.php to PrestaShop store root via FTP client.

Input necessary settings, namely

  • Tunnel address – here you must provide tunnel address like http://www.mystore.com/sm_tunnel.php where http://www.mystore.com is your store URL.
  • Host address, password, database name – these details you can find in settings.inc.php file (config directory)

Bridge Connection

Once you have decided to set up bridge connection, you should first of all download the latest version of PHP MySQL Bridge or find bridge.php in C:Program FileseMagicOneStore Manager for PrestashopService. Afterwards you are supposed to edit it, namely, change default username and password to make bridge connection protected. Then the file should be copied to store root via FTP client.

Respectively, choose PHP bridge connection in Preferences (F12) -> Database Connection and input settings required:

  • Bridge URL – provide bridge URL accordingly, that looks like http://www.mystore.com/bridge.php where http://www.mystore.com is your PrestaShop shop URL
  • Login, Password – input login and password you provided in the bridge file before.
  • Database – input name of local database

Setting Connection to Database With the Help of Wizard

Connection wizard makes database connection setup more mechanized. It is accessible below in the same window and after you click on it, the wizard will ask you to choose between simple and advanced mode. Depending on the method you select you are expected to proceed with definite settings.



At the start you should add new configuration name, launch the wizard and opt for necessary mode. After you opt for simple mode, you will be carried to the next step where action is to be selected – new configuration creation or existing configuration modifying.


Once the action is selected, you will be carried to the next step, where FTP details (server address, login, password and store root) must be provided.

Move to the succeeding step and specify your store URL in case it has not been disclosed. If details you provided are valid and connection to PrestaShop database is established, you will get connection details in the last wizard window.

Advanced mode of connection wizard allows you to indicate what type of connection (direct, bridge or HTTP tunnel) you want to work with. This window appears after you specify FTP details and input store URL.

Depending on connection type selected you will be guided through upcoming steps of connection wizard.

In order to access your live store data and manage information with Store Manager for PrestaShop, you have to set database connection. It can be done manually or with the help of connection wizard, that is partially described above. More information on connection wizard is accessible at http://store-manager-for-prestashop-documentation.emagicone.com/home/quick-start-guide/connection-wizard


Tags: PrestaShop database, connect to PrestaShop