Connecting PrestaShop with external MySQL database
Budget: €250 – €750 EUR
Hello
I am looking for a way to connect PrestaShop to an external MySQL server on which all our products are placed. In our case are that machines. Now we use a local SQL server on which all the products are put through a MS Access program. Since we want to modernise our existing website (vebim.com), but don’t lose our good working inventory system, we are looking for a way to have PrestaShop automatically synchronise the products with the SQL server or MySQL. This is because the company works internally on this database/server. (Quotations, inventory ...)
Is it possible to develop a module to automatically place products from a local SQL via a MySQL into a PrestaShop? So, the products are placed on the database via Access and thereby automatically on the website. From PS, quotations (not orders) can then be requested to be entered into Access. Can you develop a module for this? The website design itself we will do inhouse.
Our workflow:
We enter the products in our existing Access program -> it goes to our SQL local server -> to MySQL server -> X -> our website**
Visitors ask for a quotation on the website ** -> X -> list of requested products and customer information goes back to the local server -> accessible data prefilled in in Access
**= problem errors that must be resolved with a custom made PrestaShop module
Our current website is: Vebim.com and it works the way we want, and I describe. But we want to make it a PrestaShop with the same workflow.
Module will be performing the following tasks:
1. One way Sync with Prestashop
- Import data from the external MySQL server database to the PrestaShop database. Here data is referred to Product & categories.
- This would be a one-way sync i.e. from MySQL to PrestaShop database.
- Script will check if product or categories from MySQL server are available on PrestaShop or not.
- If not available, data from MySQL server will be added to the PrestaShop database
- If available, data on PrestaShop store will be updated as per the data received from MySQL Server.
- Adding/Deleting, changing data on PrestaShop won't have any inpact on the data of MySQL server.
- Data coming from external MySQL server will overwrite data of Prestashop if already available.
- Cron would be integrated which will execute the script on set interval of time e.g. once every night.
2. Sending Request for Quote details back to MySQl server.
- Script will send details of request for quote section from Prestahshopt to MySQl server.
- Assuming request for quote fucntionality is available on the website already.
I am looking for a way to connect PrestaShop to an external MySQL server on which all our products are placed. In our case are that machines. Now we use a local SQL server on which all the products are put through a MS Access program. Since we want to modernise our existing website (vebim.com), but don’t lose our good working inventory system, we are looking for a way to have PrestaShop automatically synchronise the products with the SQL server or MySQL. This is because the company works internally on this database/server. (Quotations, inventory ...)
Is it possible to develop a module to automatically place products from a local SQL via a MySQL into a PrestaShop? So, the products are placed on the database via Access and thereby automatically on the website. From PS, quotations (not orders) can then be requested to be entered into Access. Can you develop a module for this? The website design itself we will do inhouse.
Our workflow:
We enter the products in our existing Access program -> it goes to our SQL local server -> to MySQL server -> X -> our website**
Visitors ask for a quotation on the website ** -> X -> list of requested products and customer information goes back to the local server -> accessible data prefilled in in Access
**= problem errors that must be resolved with a custom made PrestaShop module
Our current website is: Vebim.com and it works the way we want, and I describe. But we want to make it a PrestaShop with the same workflow.
Module will be performing the following tasks:
1. One way Sync with Prestashop
- Import data from the external MySQL server database to the PrestaShop database. Here data is referred to Product & categories.
- This would be a one-way sync i.e. from MySQL to PrestaShop database.
- Script will check if product or categories from MySQL server are available on PrestaShop or not.
- If not available, data from MySQL server will be added to the PrestaShop database
- If available, data on PrestaShop store will be updated as per the data received from MySQL Server.
- Adding/Deleting, changing data on PrestaShop won't have any inpact on the data of MySQL server.
- Data coming from external MySQL server will overwrite data of Prestashop if already available.
- Cron would be integrated which will execute the script on set interval of time e.g. once every night.
2. Sending Request for Quote details back to MySQl server.
- Script will send details of request for quote section from Prestahshopt to MySQl server.
- Assuming request for quote fucntionality is available on the website already.