Erpnext Database Linked with Excel

Integration
1

In our business scenario, Price of products change frequently, based on several factors - mainly increase in price of Steel.

We already have pricing dashboard developed in excel, in which if we change price of factors, price of all products get updated automatically.

If we can link this excel to ErpNext, lot of repetitive work can be minimized.

Is it possible to do that currently?

2

There is a so called “Import Tool” that could be utilized. You’d need to get the prices from your excel onto the format required for mass importing that into ERPNnext though, but I guess you can find a work flow better then manually updating prices