Example of using the MyCyberOffice and CyberOffice modules to synchronize products and images on Prestashop and Dolibarr ERP / CRM
Last updated
1- Transfer products without Dolibarr image to Prestashop by synchronization (Using MyCyberOffice)
2- Add images on Prestashop products (import CSV Reference - Images)
3- Transfer images from Prestashop to Dolibarr by synchronization (Using CyberOffice)
A company owns a functional Dolibarr with over 1700 \ * products without image. The first step is to synchronize all Dolibarr products to Prestashop using the MyCyberOffice module. MyCyberOffice requires the installation of CyberOffice to work in both directions.
If no product exists in Dolibarr, it will be necessary to import them via the Dolibarr import wizard.
Synchronize the categories of Prestashop on Dolibarr ERP / CRM by using the category script of the CyberOffice module on Prestashop.
The category tree is now identical on both platforms (Prestashop and Dolibarr).
To synchronize the Dolibarr products to Prestashop, you must now use the "product initialization" script of the MyCyberOffice module by choosing the starting category of Dolibarr and the arrival category on Prestashop.
All products without images are now synced to Prestashop.
The 1700 products are now on Prestashop,
You have to export the table products (ps_product) in PHPMyAdmin to get the references.
Export the product table in csv
Add in the csv file the name of the image corresponding to the reference. Naming images is essential. The easiest way is to use the reference.jpg
Place all the images in the directory of your choice on the Prestashop server (directory img).
Import the CVS file into Prestashop
In the Prestashop back office go to Configure / Advanced Settings / import
Choose to import Product and choose the created CSV file
Once the CSV file is on the server, use it.
Ignore all CSV columns except : References and Images
Click on Import and all the images will be added to the products
The images are now present on Prestashop, it remains a last step synchronize them on Dolibarr.
Synchronize images on Dolibarr
Just use the synchronization script of the CyberOffice module which will create on Dolibarr the directory with its image on each product.
CyberOffice synchronization script on Prestashop
The images are now on Dolibarr
