Allow to import csv with id/fs_id to update large amount of records
It would be very useful to me to have automatic updates of the product prices with the price lists. This is meant in that way:
I import a price list from a supplier (sometimes it has about 150.000 items.
This price list has various data for example as follows:
product code; part nr; replacement nr; description; net weight; gross sale price;
Now when the period of validity of this price list expires I receive a new price list from my supplier with the same data, but now there can be some new items in it (completely new lines) and the old products existing already in the previous version now has an updated price.
Would be good that when I do an import of the price list the products already existing in the database would be just updated. This means that if during import
there already is an item in the database only the fields which differs would be updated.
This would keep my database minimised as now I need every time to import the products as new group and disable the old unupdated ones.