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
- PHP-MySQL bridge connection
- Bridge Connector module
In case you use direct connection, any change you implement to store data will be immediately applied. When you set up bridge connection or bridge connector module, 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.
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.
PHP-MySQL 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
Bridge Connector (also used for PrestaShop Cloud stores)
In case you decide to work with the native PrestaShop Bridge Connector module, you will need to install it from the admin side first. Full guide how to make it can be checked here – How to Connect Store Manager to PrestaShop Database via Bridge Connector.
After it has been successfully installed in the admin, you have to specify the following details in Store Manager, selecting the corresponding type of connection in Preferences window:
- Store address – insert the link to your website;
- Login – fill in the same login you’ve previously specified in the module settings in backend;
- Password – should be the same as you’ve setup in the module in admin.
Setting PrestaShop Database Connection With the Help of Wizard
Connection Wizard makes the process more mechanized and simple. It is accessible above in the same Preferences window and after you click on it, the Wizard will offer you to choose between “Create New Store Connection” and “Change Current Connection Settings” options.
Once you select the first button, you will receive the new window asking to specify store URL (hit “Test Store URL” to proceed).
Once the action is selected, you will be carried to the next step, you need to select among the available types of connection.
Move to the FTP Settings step and specify the FTP server credentials – server address, login, password and specify store root directory via the browse button.
After you test the connection, hit “Next”. Next steps usually require to press “Next” button. If details you provided are valid and connection to PrestaShop database is established, you will get connection details in the last Wizard window.
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
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…
i’m receiving Cannt retrieve bridge data 500 internal server error. what is the issue, could you explain?
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.