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 settings.inc.php file. To view them 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 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. 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 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 http://store-manager-for-prestashop-documentation.emagicone.com/home/quick-start-guide/connection-wizard

Tags: PrestaShop database, connect to PrestaShop