Get different product prices for each client out of our ERP software into woocommerce
€80-200 EUR
Opravljeno
Objavljeno pred več kot 3 leti
€80-200 EUR
Plačilo ob dostavi
Hello,
We have our own ERP software in which our clients do their administrative tasks, accounting and stock management. We also have a link with Woocommerce, using the standard woocommerce API. With our link we can send the productcategories, articles, images, prices, stock to the webshop.
Now we need some sort of connector so woocommerce can take client specific prices out of our software and put them into the webshop. So when the client is logged in on the webshop he can see his own product prices.
For example: Product X cost €100 for client A. But for client B the price for product X is €120. So on our webshop we don't want to display prices unless logged in, and then when you log in, client A will see €100 while client B will see €120 for product X.
All these different article prices per client are definied in our software. We just need something that can take this data from our software and put it into woocommerce.
User A logs into the webshop
He goes to the product of article X
The webshop sends a request to our ERP software with article ID and client ID
Our ERP software sends back the price for that article ID and client ID
The client sees on the product page his price
A multirequest will also need to available for the product list page (let's say maybe limited to 20 product/page) so when client A goes to the productgroup XYZ, it shows 20 products on that page, the webshop sends a multirequest to our ERP software with the 20 article ID's and the client ID.
We don't want to work with uploading actual import files we want an API. Also working with cache is not possible in this case, because the client changes prices regulary, so maybe a user has price 100 at noon but by evening it might be 95 for him, if the 100 is still in the cache then he'll have the wrong price. Working with a webhook is also not something we want, with the number of clients, products, product groups and discounts there are too many different combinations.
We're using REST. We'll take care of the answer to the request that the webshop asks.
I read ur requirement very carefully - can u tell me is ur woocommerce and ur ERP is using same database or how u are using it ? I read u want to connect with API - is ur erp have any api or we have to develop that?