ERP: product stock quantity real time sync and updates with external db

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

Hello,

PM Sent, Please check and let me know.

Can assist you very emphatically with your requirements.

Please join me on Skype: aaron.cis or send me a mail: aaron.cis10 at gmail.com so that we can have further discussion.

Looking forward to having a discussion with you soon.

Best Regards
Aaron Lennon

Dear Sir,

Thank you for sharing your requirements. We offer best nopCommerce development services. And, we'll be happy to work closely with you to help you with your requirements.

Moreover, Please check your PM, we are waiting for your valuable reply.

Best Regards,
Ashvin
Skype : nopaccelerate.sales2