I receive regular (daily) price and stock updates from my suppliers, as I trade in price volatile items. I’m looking for a way to be able to manipulate the data I receive from the suppliers in CSV format and import it to update ERPNext.
My issue seems to be that ERPNext assigns unique IDs to items and supplier items, and the suppliers don’t know my unique IDs to populate the CSV files with on the correct line. I need a tool that will allow me to either import directly to ERPNext using the existing data provided and match using my product nos or IDs when compared to the supplier part no, or an external tool that will format the CSV for ERPNext.
Does anyone have any suggestions for where to start? I’ve been working on this for about 3 days no, without success!