X-Cart forums

[mzadorian]

I purchased the store manager for only view reports of product sales and for marketing purposes. How do i set it up. I created an embedded connection and inputed my FTP info, what else do i need to do.

[savajr]

Hi,
You need to setup direct or bridge.php connection to your database.

Direct connection:
Firstly, you need to ask your hosting company in enabling direct MySQL access.

To configure direct connection to your remote database, follow few steps:

1. Open Settings -> Preferences -> Database Connection Tab (F12)
2. Enable Direct connection to remote database check-box
3. Uncheck Use local (embedded) database
4. Specify the following Remote Database Connection Settings:
-- Host (Server address) - Usually it is your website name like "mywebsite.com"
-- Port - 3306
-- User name (login)
-- Password
-- Database (name)

Most likely, you can find these details at your store root - see configure.php or config.php

5. Click Ok to save this entry

PHP MySQL Bridge Connection:

To configure PHP MySQL bridge connection, follow few steps:

1. Download the latest version of PHP MySQL Bridge. You can download it here:
http://support.magneticone.com/index...p-mysql-bridge

2. Edit bridge.php file - change default user name (default username is 1) and password (default password is 1) to keep your store protected.
In order to do it you need to open bridge.php file using NotePad or WordPad and find the following rows there:

$username = "1";
$password = "1";

You need to put your own values instead of "1" in both lines.

3. Copy bridge to your online store root (catalog) directory. Bridge should be accessible as http://www.mywebsite.com/bridge.php

4. Open Store Manager -> Settings -> Preferences (F12) and enable PHP MySQL bridge connection check-box.

5. Specify the following PHP MySQL Bridge and Local Database Connection Settings

-- Bridge URL - Specify Bridge URL
-- Username and Password - Specify those you used to specify in bridge.php file (see step 2)
-- Database Name - Specify local database name (type name manually)

6. Click Ok to save this entry.

If you have issues with connection to your database you can contact us via ticket at: contact[at]magneticone[dot]com and our technical engineers will help you to setup connection.

Feel free to contact us if you have any other questions.