We are happy to publish an updated Prestashop inventory module to synchronise products and orders between Erply and Prestashop (version 220.127.116.11). As the module is still in beta, please contact us at firstname.lastname@example.org and we’ll give you the access and setup instructions.
This module allows two way synchronization of categories, products and customer groups. Also one way (from Prestashop to Erply) synchronization of customers, customer addresses, orders and order history. This guide details the setup and use of the Erply module.
1. Erply – Prestashop Inventory Connector setup
To start using the module, follow the steps listed below:
1.1. Erply module installation
Copy the Erply module to the Prestashop ‘Modules’ folder. Log in to Prestashop
administration panel and go to the ‘Modules’ page.
Choose Migration Tools module category from categories list.
Click the Erply Synchronizer “Install” button, a „successful installation“ message appears on the Erply Synchronizer module.
1.2. Erply module setup
Click „Configure“ on Erply Synchronizer module.
On the module page type in your Erply user credentials and save them using the “Save” button.
Before synchronising the products some settings can be made and saved.
Priority – Select which system has higher priority when same object (product, customer etc.) has been changed in both systems since last synchronization.
Default Tax – If tax value is not found in product data this value is used.
Export orders from – Initial order export will be made starting from this date.
To begin the synchronisation choose the synchronisation direction (from Presta to ERPLY, from ERPLY to Presta or both ways) and click the ‘Start’ button.
After the initial synchronisation use the ‘Start’ button if you wish to update existing data.
Keep in mind that Erply allows 500 API requests in an hour. If that number is exceeded, an
error message will show. In this case, return to the module page, wait for an hour and try to continue the synchronisation by clicking the ‘Start’ button.
To enable automatic synchronisation cron_all.php from modul folder should be added to server’s crontab.
1.3. Erply module synchronisation details
This module performs a two-way synchronisation of the Erply – Prestashop product categories, Erply – Prestashop customer groups and Erply – Prestashop product, so all Erply products and customers appear in Prestashop and all Prestashop products and customers appear in Erply.
In case of Erply -> Prestashop synchronisation the fields are mapped as:
1.3.1. Category/product group synchronisation
1.3.2. Product synchronisation
|vatrate||id_tax_rules_group (local id is matched by vatrate value)|
|vatrate||id_tax (local id is matched by vatrate value)|
|brandName||id_manufacturer (New manufacturer is added if not found)|
|supplierName||id_supplier (New supplier is added if missing)|
|warehouses (sum of “free” field for all warehouses)||Quantity is added to product|
|images||Images are added to product|
1.3.3. Customer groups synchronisation
The module also imports product images only from Erply to Prestashop.
Also the synchronisation module allows you to perform a one-way synchronisation of the Prestashop -> Erply customers, customer address, orders and order history, so all Prestashop customers, customer addresses, orders and order histories appear in Erply.
In case of Prestashop -> Erply synchronisation the fields are mapped as:
1.3.4. Customers synchronisation
1.3.5. Customer address synchronisation
|typeID||id from Erply API getAddressTypes response|
1.3.6. Orders synchronisation
|id||Order id if order is synced before, null otherwise|
|type||“INVWAYBILL” is sent by default|
|customerID||Customer id if customer is synced before, null otherwise|
|payerID||Customer id if customer is synced before, null otherwise|
|addressID||Address id if address is synced before, null otherwise|
|payerAddressID||Address id if address is synced before, null otherwise|
|internalNotes||Prestashop Invoice Number: “invoice_number”|
|#productID||Product id if product is synced before, null otherwise|
*Shipping is sent as last product.
1.3.7. Order history synchronisation
All updated orders are synchronized with Erply. If order is deleted from Prestashop it is deleted from Erply also. If order is paid invoiceState is updated to “READY” with saveSalesDocument update method.
If order is paid new payment is synced to Erply with field mapping:
|customerID||clientID from Erply API getSalesDocuments response|
|documentID||“READY” or “PENDING” depending on status|
|sum||Total from Erply API getSalesDocuments response|
|currencyCode||currencyCode from Erply API getSalesDocuments response|