README EN
Readme Synchronisation module CyberOffice
Last updated
Readme Synchronisation module CyberOffice
Last updated
Available module on Prestashop addons and on Dolistore
Awarded by Prestashop Addons Team as Contributor of the Year 2016.
Expertise level statut SuperHero & Developed by a Top Developer, + 4000 downloads and modules installed, rate reviews 5/5. (Sources PrestaShop Addons) Best sellers in its category. Best sellers in its category on Prestashop Addons Third-party Data Integration (CRM, ERP).
The module CyberOffice for Prestashop and Dolibarr ERP/CRM synchronizes automatically with webservices (automatics flows) data from your Prestashop store to Dolibarr ERP/CRM. It synchronizes in real time via webservices all the events carried out on Prestashop to Dolibarr . (Categories, products, combinations, prices, stocks, images, characteristics, customers, orders, invoices, payments, bank accounts ...)
CyberOffice can be installed at any time in the life of your Prestashop store. It is recommended to put it in place when you have obtained your first sales and you control the processes of use of your shop. If you are testing, consider when going into production to sync categories and products again.
Designations
Prestashop
Dolibarr
Prestashop compatibility
1.6 to 1.7.xx (1.6.2 module)
>8.xx (module version 8.x.x and Php 8)
Dolibarr and DoliCloud compatibility
10.0 to 16.x (1.6.2 module)
17.x to 20.x (module version 8.x.x and Php 8)
Compatibility mutuals servers or dedicated servers with SOAP
Webservices (automatic)
Synchronization from Prestashop to Dolibarr
Easy installation by module
Multi-stores (several shops in the same Prestashop connected to a single Dolibarr ERP/CRM)
Multi-shops (several independent Prestashop connected* to a single Dolibarr ERP/CRM)
Catégories
Prestashop synchronized specific prices (requires the Dolibarr Price List module)
References
Barcode UPC and EAN13 and ISBN for 1.7 version
Clients (historical recovery choice depending on the date)
Orders (historical recovery choice depending on the date), incremental synchronization
Invoices (historical recovery choice depending on the date)
Stocks (synchronization choice), choice of warehouse to use depending on the carrier
Payments (Association to different bank accounts)
Order and invoice statuses, payment (v8) of your choice for synchronization
Creating Shipping (modifiable wording, addition of the carrier) and Discount creation (modifiable wording), Wrapping for gift packaging (modifiable wording)
Prestashop number shop / order / cart visible in Reference customer in order & invoice
Long description Prestashop product added extrafield
Multi-currency orders and invoices synchronized in currency on Dolibarr
The second module MyCyberOffice automatic synchronization from Dolibarr to Prestashop is available on extensions marketplace Prestashop Addons and DoliStore
*Requires a license by Prestashop. CyberOffice 8 and MyCyberOffice 8 versions must work only between them in php8.
1.Video module install
2.Video module using
3.Video Multi-stores and categories (Categories are essential for product synchronization)
Id
Descriptions
Details
1
Dolibarr Webservices Key
Copy the generated key in Dolibarr ( Dolibarr / webservices )
2
Path Dolibarr
Copy entire url Dolibarr without forgetting / at the end
3
Authentification Dolibarr
This is the connection login Dolibarr (Super Admin) and the corresponding password. (Do not indicate the email address)
4
Entity
Put 1 by default, if you use multi company choose the correct id
5
Warehouse
Warehouse index used (displayed in the URL Dolibarr )
6
Default language
Language used
7
Synchronization statuses
These are the chosen statuses that trigger the synchronization of orders and invoices into Dolibarr. Those default " Payment accepted " " Shipped " " Delivery " correspond to 99% of the uses, if you do not know and let set . If you check them all , there will be permanent synchronization in Dolibarr every state of orders and invoices .
7 to
Only in Version 8
Synchronisation of invoice payment. Must be done on a state present on the other synchronisation statuses "orders" and "invoices". Example: Payment accepted
8
Shop Protocole
Choice http or https
9
Prefix
If your PrestaShop products have no references put what you want to identify your products in Dolibarr. If all of your products have a reference to PrestaShop use {ref } and will be taken and used in Dolibarr.
Your shop must not be in MAINTENANCE MODE
Id
Descriptions
Details
1
Install module in Prestashop
In the back office click to add a new module.
2
Download the module_cyberoffice.zip file and install it on Dolibarr with the installer. (Only CyberOffice version 8)
(CyberOffice Version <8 only) Click on cyberoffice.zip module unzip it and place the "cyberoffice" folder and its contents at the root of Dolibarr at the same level as Dolibarr's main directories. (Do not use custom directory)
3
Under Dolibarr : Turn the webservice and generate the key. (home-setup-modules-interfaces modules-webservices) Turn the CyberOffice module
4
Under Prestashop : Set the module. All fields are required
See point 2 above "Configure CyberOffice"
5
Everything is checked green ? Your sync is operational
You should have absolutely all green check marks for the module is functional.
6
Initialize the database "Categories" and "Products"
To process in order as indicated by the " initialization" procedure in the module. Categories are essential for product synchronization.
7
Optionnal : You can sync your existing orders and customers
In CyberOffice tool choose a start date and end to synchronize the history of clients and orders. Please note that customers are often registered before ordering.
Point 6 Initialization: Depending on the number of categories or products, the synchronization period will be shorter or longer, you must wait for the response from the server that will be of type: Response batch 1: sent (in case of timeout, perform synchronization by part). Images : When initializing products, only cover images are synchronized in Dolibarr to avoid overloading the server (timeout). To get all of them in Dolibarr product sheet: 1- Open the product in Prestashop 2- Save it 3- All images will be synchronized in Dolibarr.
Point 7 Synchronize customers according to their creation date in Prestashop. Very often the registration is done well before the order.
Synchronization of orders, if an order does not have its client synchronized it will not be synchronized in Dolibarr. In this case, check the creation date of the customer in Prestashop and make a customer synchronization on this date.
Id
Descriptions
Details
8
cUrl extension must be available on your server
cURL must be active on the server for the module to work
9
default_socket_timeout : 60
Current value for the correct functioning of the module*
10
max_execution_time : 165
Current value for the correct functioning of the module and its installation by the wizard*
11
memory_limit : 512M
Current value for the correct functioning of the module and its installation by the wizard *
12
display_error : off
Must be switched OFF for the proper functioning of the webservices.
*The value can be higher but not lower
Choose which statuses will trigger the synchronization of orders, invoices and payments* to Dolibarr. If you do not know how to leave the default values that will work in all cases.
*(Payment synchronisation status configurable only in version 8 for the other versions the payment is synchronised at the same time as the invoice.)
Supports exclusively Prestashop 8, php8, and Dolibarr 17 to Dolibarr 19
Synchronises the payment status: Synchronisation of invoice payment. Must be done on a state present on the other synchronisation statuses "orders" and "invoices". Example: Payment accepted
Allows you to manually synchronise an order to Dolibarr from the integrated button in Prestashop: Synchronisation with Dolibarr
Customers : Synchronization of client's language (pdf translation) / Force the name to uppercase
Products : Synchronisation du stock / Do not sync descriptions / UseVariant (Enable on demand )
Orders : 1 discount line per Prestashop discount / Synchronization of Prestashop ref with the order reference / Synchronization of Prestashop ref with the customer reference
Invoices : Provision of the download link on Prestashop (The Dolibarr invoice is present in the customer's backoffice)
In some countries as Canada, Brazil, Spain, Portugal, Tunisia, the USA, etc…. Products are subject to double tax. The module now manages these double taxes in combined mode and one after the other mode.
After a stop during orders synchronization, click on the "incremental synchronization" button to restart the synchronization immediately after the stop. Avoid relaunching all the orders.
If you only have CyberOffice 8, the eshop_webkey field of the store must be empty. If you have MyCyberOffice 8 the field will automatically retrieve the value of the Prestashop web key indicated in MyCyberOffice on Dolibarr (Auth Key).
Activate barcodes only if they are all present in Prestashop products
The labels can be changed according to your needs.(*see further news)
5-Check if a warehouse is open
and the VAT filled with identical Prestashop
6-Stocks synchronization and
set method of decrementing stocks
7-Link modes of payments with bank accounts after the PrestaShop database related.
Banks choice appear once the connection made with the Prestashop database
Synchronization of the language chosen by the customer (PDF translation): YES / NO
Force the customer's name in uppercase: YES / NO
Stock synchronization: YES / NO
Do not synchronize descriptions: YES / NO
Synchronization variant <-> combination: YES / NO
1 discount line by Prestashop discount : YES / NO
Synchronization of the Prestashop reference with the order reference: YES / NO
Synchronization of the Prestashop reference with the Ref.customer: YES / NO
Provision of the download link on Prestashop: YES / NO
In Prestashop, invoices must be activated on the Order States used.
The 2 platforms must have the same level of http or https in order to ensure a good connection between them.
It is possible to associate a carrier with a stock in order to decrement the stock of his choice according to the carrier
Go to Setup / Dictionaries and open cyberoffice_carrier_warehouse
Associate the IDs of Dolibarr warehouses with the IDs of Prestashop carriers
The corresponding id of the existing carriers in Prestashop
Decreases on each of the stocks
Order in $ on Prestashop synchronized in $ in Dolibarr
Order in $ on Dolibarr
Install and activate the Price List module in Dolibarr (Available on Dolistore)
The wrapping prices are now on a separate line in the Dolibarr order with the creation of a new service "PrestaWrapping"
In Prestashop : Shop Parameters / order settings
Prestashop order with wrapping + VAT
Synchronized order with wrapping in Dolibarr with the PrestaWrapping line
Advices
Precisions
Combinations without variation
In the case of variation without variation, a product=declination is created and the details of the variation are added to the product label
Product references
Product reference is automatically created with management of duplicates (increment). Using the code {ref}
Import
If you are importing and updating your products with csv, always remember to initialize your products again so that your changes are synchronized in dolibarr.
Categories
To synchronize in Dolibarr categories and products only, simply unhook module in actionOrderStatutPostUpdate.( Modules / positions )
PHP
Directive PHP allow_url_fopen must be ON on Dolibarr server so that images can be imported
Dolibarr 5
With Dolibarr 5.xx change the $ dolibarr_nocsrfcheck = 1 variable in the conf.php file if you have a message in the module on Prestashop.
https
When securing the url of the shop from http to https, it is possible to intervene in the "const" table of Dolibarr (mysql) and retrieve the value of the old shop (http) and copy it to the the value of the shop (https). This will prevent any synchronization again and have duplicates in Dolibarr. It is also possible in the module at the address of the store to add an "s" (https). Do not forget to do the same in the tree of the existing category (tags / categories).
First name / Name
*To reverse in Dolibarr the order of the civility of the contacts and to change them from Name and First Name to First Name and Last Name. Go to configuration / display / Display order name / first name
Orders invoices
*If you want this reversal First Name / Name to be reflected in the orders and invoices. In the file server_customer.php of the module CyberOffice on Dolibarr to the line 245 invert the fields. Now : $ newobject-> name_alias = ($ customer ['company']? $ customer ['lastname']. ''. $ customer ['firstname']: ''); Change like this : $ newobject-> name_alias = ($ customer ['company']? $ customer ['firstname']. ''. $ customer ['lastname']: ''); You will need to make this change during each update.
Pack of products
To correctly synchronize and decrement the product packs, you must create a standard product on Prestashop. This will contain informations and images that will indicate that it contains multiple products. (Do not use Pack of product when creating) On Dolibarr you have to add the child products to this parent product in the Kits tab, as well as the composition to decrease stocks. During sales on Prestashop the father and the sons will be decremented on Dolibarr
Fusion Cyberoffice
This new functionality makes it possible to merge customers synchronized from Prestashop and already present on Dolibarr into Dolibarr.
1-Search for your customer in the left area with the search tool. 2-Click on icon to launch the search 3-Select the customer (in blue once selected) 4-Click in the right area on the icon with +. The system will display matching clients with the same name, same email, etc... 5-Select the customer in the right area (in blue when selected) 6-Click on the merge button import_key indicates the corresponding shop: P01 = shop 01
Using the Multi-Company module
Enter the same webservices key
We have created a quality label, which guarantees a perfect compatibility of the modules with CyberOffice.
Label
Module
Description
Synchronization of information from Dolibarr to Prestashop (Control of the shop from Dolibarr)
Cashdesk software for Dolibarr (counter sale for merchants with a physical shop)
Automatic sending of responsive marketing emails with discount voucher for products seen by your customers on your site. Automatically add additional blocks to the mail (Products added and abandonned to cart, new products).
Copyright all rights reserved - CyberOffice - 2016-2024
Products and combinations,(variant activation on request, requires our MyCyberOffice module),
Watch install video
This function allows you to synchronize or not the stock
This function allows you to synchronize or not the descriptions
This feature allows you to synchronize the combinations of Prestashop in the "Product Variants" module of Dolibarr
The numbering of Prestashop orders is synchronized in Dolibarr at the level of the order number.
The numbering of Prestashop orders is synchronized in Dolibarr at the Customer Ref level.
