2016-10-07
Rating 0 stars - 0 votes

PrestaShop Order Management on Several Workstations Returns Error

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).


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.


The main reason why duplicate entry error has been generated is already an existing value for PrestaShop order ID. Most likely another administrator has posted changes, order with this ID has been created and MySQL issues ‘Duplicate Entry ‘ ’ for key ‘Primary’ error.


Solution

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.