Store Manager for PrestaShop is oftentimes installed on several workstations and used by employees who are responsible for various business tasks. Having one Primary License and several Additional License you can easily share the responsibilities and fulfill them via Store Manager copies.
Oftentimes users that are handling PrestaShop store from different places, report on PrestaShop order management issues. The thing is, order creation via POS results in duplicate entry error, as it is shown at the screenshot below.
As a result, data post fails and all created orders are lost. It can really be frustrating, since you need to re-create orders and input necessary details (customer info, payment method). The situation might be worse if you created the customer right from POS system in Store Manager. In this case you lose all customer details and volume of work to be done increases.
Why Duplicate Entry Error Happens
If several people access one and the same store from different computers and use Bridge Connection, they are likely to face this inconvenience. When accessing database through Bridge Connection, you are working with local copy of store database. Respectively, each of administrators, that manage store via this connection type from different places, works with own local copy (that might be outdated).
While working via Bridge Connection you need to synchronize changes with live database. 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.
When some of users launches PrestaShop POS to create order, Store Manager reserves order ID. In case several people create PrestaShop orders on Bridge Connection simultaneously, reserved ID coincides and posting changes to web returns the error message.
If your online store is handled from various locations, you’d better use direct connection between Store Manager and PrestaShop live database on all PCs. Changes, implemented in Store Manager will immediately apply, since direct connection does not require synchronization and PrestaShop orders, inserted by all employees will be saved instantly.
Follow this link to access instructions on direct connection setup – Direct Connection to MySQL Database
We recommend to set up both direct and bridge connections within one configuration and switch between them depending on what changes you are about to implement. If you are sure that store administrators are working at the same time and make some changes, it is better to use direct to get them applied and not to overwrite each other’s data. Contrariwise, if you need to fulfil bulk updates and rest of employees are not working with store at the moment, you can change connection to bridge.