Sync a Woocommerce site with an external ERP

Hi,

I need a custom work to integrate, and sync, a Woocommerce site with an external ERP.

Environment :

*ERP is custom built, and can be accessible only with an odbc pilot, installed by the ERP developers. It is setup on server A.

*ERP is accesible in reading mode only, not in writing. (This is a restriction from the ERP developers. There might be an exception to send orders and other updates to the ERP, but this is not confirmed yet)

*ERP uses HyperfileSQL.

*The website is obviously a Wordpress site, using Woocommerce to handle ecommerce operations. The site is installed on server B.

What needs to be done :

1 - Mass import of products and clients

_Mass import about 5,000 products from the ERP to the website, with their description, photo, price. (+ maybe some products charateristics like color, format etc. I'm awaiting information on this matter)

_Mass import of existing clients, with their adresses, contacts, and negociated discounts. Discounts can be in the form of a % discount on a product, or category or product basis. Discounts are different from a client to another, and are stored in ERP's database.

2 - Regular updates from ERP to website

_Product information (new products, pricing, stock) and clients information (adresses, contacts, discounts) must be updated at least once a day.

3 - Stock management

_In the spirit of updates described above, stocks on the website need to be sync to the ERP. I need suggestions as the best way to proceed here, about when to retrieve the information : when user loads a given product page ? When he checks out ?

MISC.

_The project is to be started in less than a month from now, I.E, before the end of january.

_I'm looking for someone with prior experience in making Wordpress communicate with external database, as well as experience with Woocommerce. (Portfolio mandatory)

_Code is needed, but also suggestions, for best overall results.

_Communication needs to be top notch.

_It is preferred if you speak french, as a conversation between the ERP developers and the contractor will be needed at some point, to discuss database queries. (how does their database work, where to get what, etc.) HOWEVER, speaking french is not mandatory : skills are preferred over language : I can still act as a layer between the ERP developers and the chosen contractor, if you tell me exactly what you need to know.

_2 other integrations with the same ERP will follow if collaboration is successful.

Please don't hesitate to ask whatever details you might need.

Thanks

Database Administration WooCommerce WordPress

Project ID: #9175873

About the project