Store Manger Connection and Setup

Store Manger Connection and Setup

Why do I have to setup FTP connection?

FTP connection is not required, you may skip it. FTP used for images – downloading and uploading images for products, categories and manufacturers. Also, FTP is used to manage downloadable products. If there is no valid FTP connection specified you will not be able to view images and upload them to your server as well as manage downloadable products.

Am I using the database I set up on my website or the one I set up with Store Manager? Are they one and the same?

Database installed with Store Manager is a kind of temporary database. It can be used for various purposes one of most valuable of them is PHP MySQL bridge. Working with local (Embedded) database is much faster than working with remote one. Local database and remote (website) database are not the same. However, you can use your local database to store your remote database inside it, make changes and then just synchronize your local and remote – make changes locally and then upload them to the w...

How to Solve Connection Issue if You Have Cloudflare ?

If you use Cloudflare service with your online store, it may block access to the PHP bridge file. If this happens, Store Manager won’t be able to connect to your store database and display it in the grid. The solution is to set bypass settings in Cloudflare: Log into your Cloudflare account, go to “Page Rules”, and click the [Create Page Rules] option: If you use PHP-MySQL Bridge connection, paste the link to the bridge file in the format <site URL>/<bridge filename> and pres...

How To Exclude Store Manager From Scanning By Antivirus

There are cases, when our users upload a new release of Store Manager and face a situation, that their antivirus software blocks the application and doesn’t allow to continue the downloading process due to security reasons. As antivirus programs are developed for protection from computer threats in general, they are carefully scanning the incoming files and preventing from their access to the system and causing harm to your PC. Since every release of Store Manager software contains new improvem...

Where is Store Manager Connecting to and Why?

Store Manager for Magento allows you to work with your site from your local PC. For that you need to specify some connection settings that allow you to transfer data from your PC to your server. None of those settings are sent to eMagicOne. None of private information is transferred to our site or server. All data and settings are stored on your local PC and your server. So let's find out what types of connections from your local PC to your server you may use. /optional/ means that if you use ...

Database Connection General Information: Selecting Connection Variants

Store Manager requires direct MySQL database connection. Most of hosting companies allow direct connections to MySQL database. However in most cases you have to go to your control panel and add your home/office computer IP address or domain name to Access List - list of IP addresses allowed to access MySQL port 3306 from outside. This option can be found under MySQL settings. Feel free to ask your hosting support to assist you in enabling direct MySQL access, they must help you since it is triv...

What is PHP-MySQL Bridge?

PHP-MySQL Bridge is a type of connection to your shopping cart to work via Store Manager application. In most cases it is used as alternative connection when MySQL connection to your database is restricted by your server. Basically Bridge is a php file that is uploaded to your server automatically and that retrieves your shopping cart data to work in Store Manager application. This type of connection requires synchronization and is good for import, mass upload or mass changes. While working t...

Bridge Connection - Duplicate Entry Error, Duplicated Data, also it may look like "Error: #23000 Duplicate entry '7650' for key 'PRIMARY' "

While working via PHP-MySQL Bridge type of connection, you need to sync your data very often. For this, use Get Data from web (CTRL + G) before you make any changes and Post Changes to Web (CTRL + P) once you're done. In case you have made changes in Store Manager and forgot to sync them or made changes from admin simultaneously, you will receive the Duplicate entry error. What does it mean? This error message means that while adding any data in Store Manager, item with exactly same ID was ...

What Is Store Root Directory And Where Can I Find It?

Store FTP-directory - This is the relative 'root' folder, that contains the files of your store (shopping cart) accessing via FTP, or HTTP. To select your shopping cart root folder, click on the [browse] button of Connection Wizard. In most cases, it is ...\public_html or httpdocs or www. To make sure that you have selected the correct folder, check if there are app, tmp and media folders, as well as the other pertinent files and folders that your shopping cart specifies.

Unable To Connect To Remote Database. What Do I Have To Do?

Very short description of key items to check: 1. Hostname is correct. It is better to use IP address rather than domain name. 2. Your hosting allows direct MySQL connections. As for example GoDaddy does not. 3. You have specified correct MySQL port. In most cases it should be 3306. 4. Username and password are correct. 5. User has enough permissions for used database. It should be configured in website management panel or in phpMyAdmin. 6. Database name is correct. 7. Your IP address is a...

How can I Upload External Images to my FTP?

You can upload external images for products using Import Wizard. In order to do it you need to make sure that: 1. You have set up your FTP connection correctly. It can be configured and checked in FTP tab in Preferences (F12) window. 2. You have specified correct path to your images folder on your FTP sever (it must be default shopping cart Images folder). Note: some of Store Managers requires specifying only base directory (store root). 3. You have checked Upload Images option during i...

How Can I Upload Images to my FTP?

You can upload images for products using Import Wizard. To do it, you need to make sure that: 1. You have set up the FTP connection correctly. 2. You have specified correct path to your images folder on the FTP (It must be default shopping cart Images folder). Please note: Some of Store Managers require specifying only base directory (store root). 3. You have checked Upload Images option during Import. 4. You have specified correct path to folder on your PC where you have all Images...

Bridge.php, how to install and configure it?

To setup Bridge you have to do following: 1. Open your application main directory - usually it is "C:\Program Files\eMagicone\Store Manager for ... " and find directory "Service" there. Inside this directory you can find bridge.php file. 2. Important. Edit bridge - change user name and password to keep your store protected. There are two lines inside this file - $username = "1"; $password = "1"; Put some other values instead of "1" in both lines. Please also read PHP MySQL bridge: How to ...

How to add my IP address to Access List and allow direct MySQL connections?

Why you may need to add your IP to the list of allowed hosts? Once configuring Database connection, you may see the following error: SQL error "access denied for user '....." @'........" (using password YES) You will see username that you're trying to insert while connecting to your database and your local IP (the IP of your computer that you have Store Managerr installed). The error says that user that we have specified cannot connect to our database from our local IP. If you're absolute...

PHP MySQL bridge: How to make connection more secure

This article provides suggestions on how to make your connection via PHP MySQL Bridge more secure. * Internal PHP MySQL Bridge login/password system At the top of bridge.php there are login/password pair - you need to change them right when installing PHP MySQL Bridge * Limit access to bridge.php from your IP/subnet only Create a file and name it .htaccess with the content below <Files bridge.php> order deny,allow deny from all allow from 888.888.888.888 </Files>Please change 88...

How to make Store Manager to work on a dynamic IP, assigned by my isp?

Multiple options available 1. You can add your isp subnet (not exact ip address) For CPanel it is done by adding ip's like %.%.%.% or 192.168.1.% where you should replace "192.168.1." with ip assigned by your isp's. Please go to your Control Panel, find Database connection sections and specify the above IP to the list of allowed IPs. 2. You can work via PHP MySQL Bridge It doesn't have ip blocking, but little different behavior - at least give it a try. 3. Work via SSH tunnel This is ...

PHP MySQL Bridge: Can't Create Temporary File Error or Can't Open Temporary File Error

This error means that bridge.php cannot write to temporary directory specified. By default temporary directory detected automatically and this autodetect works in 9 of 10 situations. If for some reason autodetected temporary directory does not work (access denied or so) you can set it manually.Edit bridge.php file. There's a line: //$temporary_dir = "./tmp"; // on some systems if you get output with 0 size, try to use some local temporary folder 1. uncomment this line - remove two slashes ...

What is field expression, what can I specify here when importing products?

Expression is a set of SQL statements returning single value. To create an Expression use: [FIELD_VALUE], representing the current field value from your database [CSV_COL(INDEX)] , retrieving value from .csv file from the specified column in the INDEX parameter CONCAT([CSV_COL(INDEX1)], '|', [CSV_COL(INDEX2)], '|' , ... , [CSV_COL(INDEXN)]) , merging values from .csv file from the specified column in the INDEX parameter, can be used to specify full category tree required for import Exa...

How can I edit/customize reports in Store Manager?

This article contains general information on how to customize reports with Store Manager for Prestashop as an example. All reports in Store Manager can be customized, you can change report layout, insert pictures (logos), add and remove fields etc. Every report consists of two major parts: - Report template - Report queries Report templates are stored in .fr3 files they contain report layout information. Report queries are stored in .sql files, they contain SQL queries to retrieve da...