Hello everyone,
I need some kind of ERP plugin to sync my nopdb quantity with external db quantity, or some code modification to do the following:
- Sync nopdb with external db (only quantity of products)
- Whenever there is change in external db quantity of some product, nopdb to be updated so there won't be backorders
- When customer buys product from my eShop to modify external db quantity column accordingly.
Things to note:
- I will only have username and password to access this external db and only ip address where my eShop is hosted will have access to it. (same for other eShops that use this external db)
- Products will have ISBN in external db, and that same ISBN will be under column GTIN or SKU in nopdb.
- External db its SQLEXPRESS
- I am using NopCommerce ver. 3.5
I see two scenarios how this can be done.
First with some modification in code as following:
1. On click "Add to Cart" to check for that product if its available in external db, if its okay continue else notify customer for out of stock.
2. After payment is done, in my payment plugin helper class to write code that will decrease quantity accordingly for the correct products in the external db.
Second with ERP plugin:
1. To have "Sync" button in admin panel to get initial quantity of products at start.
2. Have some kind of trigger, whenever there is change of quantity of some products in external db to update nopdb as well (if nopdb has that product)
3. When customer buys product from my eShop decrease quantity accordingly for the correct products in the external db.
Regardless of which scenario i decide to use, need to send report which products has been decreased, by how many, date and time when has been done and which store did it (ex: eShop1). This report can be send manualy once a day or automatically right away for every order.
I think i covered everything. Your opinion is welcome, which plugin can do this for me, or if someone is willing to help me on this.
Thanks