Thanks for your reply. I actually not need an API, only manually ad currence exchance when fluctuating to much. I am not sure I understand the part with CSV. Lets say I have 1000 calculators that all have the field "Buy in cost". Based on that value, the selling price are calculated. Lets say those 1000 products has an price update and I recieve new prices in an Excel sheet. Can that be used in order to update the Buy In cost for all 1000 calculators without doing it manually?
You can do all 1,000 at one time if "Buy in cost" is a dynamic field based on a lookup record and all calculators use the same lookup record. If you don't do it that way, you could do it in PHPMyAdmin with SQL, or export in CSV, delete all records, then import after making changes. Those are your options.
Please login or Register to submit your answer