Synchronize products and images

Example of using the MyCyberOffice and CyberOffice modules to synchronize products and images on Prestashop and Dolibarr ERP / CRM

Example of using the MyCyberOffice and CyberOffice modules to synchronize products and images on Prestashop and Dolibarr ERP / CRM

What do we want to do in this customer case ?

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)

Dolibarr ERP/CRM

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.

How to proceed ?

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

Prestashop

The 1700 products are now on Prestashop,

How to add Images on Prestashop ?

Recover the CSV file

• 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