Suggestion:
System provides the upload utility option for updating the multiple existing records.
User can upload the exact same data again in price list format, only with the changed rate data for the existing lot number.
System will properly update that record only for the existing lot numbers.