How to Connect Store Manager to PrestaShop - Configuration Guide
2019-04-09 2014-04-28
Rating 0 stars - 0 votes

How to Connect Store Manager to PrestaShop Database

Store Manager for PrestaShop is a desktop solution helping online merchants handle web store data more efficiently. 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 perform PrestaShop database you will work with.

You can choose between three PrestaShop database connection types:

  • direct connection
  • direct connection through HTTP tunnel
  • 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 one. In such a way local copy of PrestaShop database can be created. Respectively, to get modifications displayed at the front-end you should carry out Post Changes to Web operation.

PrestaShop database connection can be configured in two ways: either you input necessary details manually for the 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 data directly, you are supposed to input the following details:

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

Direct Connection Through HTTP Tunnel

If you decided to use this type of connection, check corresponding ratio 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.

Provide necessary information, namely

  • Tunnel address – here you have to specify tunnel address, e.g. where is your store URL.
  • Host address, password, database name – these details you can find in 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 where 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 PrestaShop Database Connection With the Help of Wizard

Connection wizard makes the process more mechanized and simple. 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 corresponding steps comprised by the wizard.

In order to access your live store data and manage it with Store Manager for PrestaShop, you have to first connect these two destinations. You can accomplish this manually or using the assistant. More details concerning connection wizard are accessible at

Tags: PrestaShop database, connect to PrestaShop

Related Articles:

Card image
How to Connect Store Manager to PrestaShop Database via Bridge Connector

Install Store Manager Bridge Connector and use this tips to connect your store to the program with this module. Read More…

Card image
Basic Operations over PrestaShop Products

Discover the ways to perform basic actions over your products including adding new items, modifying or removing them, assigning them to categories etc. Read More…

Card image
Import Products to PrestaShop using Store Manager

Get insight into main PrestaShop import options including import method, handling products not included in imported file, category options etc. Read More…

Card image
PrestaShop Import – Supported Formats

Discover what import file formats are supported by PrestaShop admin and what import solutions are offered by Store Manager for PrestaShop. Read More…

Erikah • 09/06/2018

i’m receiving Cannt retrieve bridge data 500 internal server error. what is the issue, could you explain?

PrestaShop Store ManagerMod Erikah • 09/06/2018

Thank you for your question.
Most likely, the issue is related to server settings. Please, make sure the FTP details are correct and you can connect with them via FTP-client program (like FileZilla). If the details are correct and you can connect successfully – kindly contact our support with your store configuration file, so we could check your case.