i've been using Store Manager (Prestashop) trial version and although there were some bugs (duplicate on sql data base) the software worked pretty well.
But i've bee trying to use it with a colleague (on 2 differents computers), and there were a lot more duplicate bugs and mixing problems. Here's one, if I try to add specific prices on a product and upload them (works fine online), and my colleague try to add other specific prices on another product, since he has an older version of the database, he will upload specific prices with - I guess - the same specific prices ID i used (sql ID). Consequently I have now my product with HIS specific prices.
What is the solution to this problem ? He can still download new database each time he wants to make changes, and so can I, but it takes many minutes to do so. Are there any options that can maintain an updated local database at all time ? Meaning each time a change is made on the prestashop database, all users will be notified and given the good newest version of the database ?
Sep 16, 2014
You see, the identification method used by PrestaShop (itself) and Store Manager is product ID's.
For example, you are modifying products form category A that contains 100 products with ID's from 1 to 100 and your employee is working on the separate PC with category B that contains about 100 products as well and the product ID's of the second category are from 101 to 200.
In this case you can work using bridge connection, it should not bring to the duplication issue and Post Changes to Web process will go successfully.
However in case you create a new product in the category A (which product ID will be 201) and your employee has created a product in category B (it will be created with ID 201 as well), then the Post Changes to Web will not proceed without duplication error.
You can use bridge connection in case you will work alternately (not a the same time). For example you're working with the database from the Store Manager from 11:00 AM to 14:00 PM then Post Changes to Web and the other employee will start working (Get Data from Web is required for the synchronization purpose) at 14:00 PM.
The PHP MySQL Bridge connection has been created for the customers which hosting plan does not allow direct connection through port 3306.
In case there is a need to work with the database from a few PC's at the same time - the best way to do that is a direct MySQL connection.
Sep 16, 2014
thanks for your reply, I understand the ID system and the problem I had was that there are IDs on specific prices too. So with 2 existing different products, if we try to add specific prices they will overlap.
Are you saying that if I use a direct MySQL connection the local database of every computer using the software will be synchronised ? If so, what is the interval of synchronization ?
Sep 17, 2014
You may configure a direct connection to the remote MySQL database.
You have to contact your hosting provider and ask them if you hosting plan allows you to connect to your MySQL database from the external IP addresses through port 3306 (or any other port allowed by your provider).
Sep 18, 2014
Does the direct connection synchronise in real time the local database on many computers ? Or do I still need to take turn with my colleague ?
Sep 19, 2014
Direct connection does not work with a local database. Using a direct connection Store Manager works with the remote database directly and all changes are applied right away.