I do not see an option to update, change or add product to vendor price list in procurement module.
Vendor price lists are created by system with data taken from vendor quotations. Normally vendor will provide a quotation in response to your RFQ or inquiry. When you record this quotation in the system, Tuhund will automatically update the products in the quotation in vendor price list for the respective vendor. Vendor quotation has the option of CSV upload. If the number of items in the quotation is large, please upload in one go with CSV upload. Instructions for CSV upload for vendor quotation are right in the upload form along with some additional options for selection.
Thank you for the reply.
Our principals send us updated price list in excel format from time to time. Some of these lists contain thousands of line items out of which some items have new rates and some are unchanged since last time. Rarely some products are removed and some new products are added. It is a nightmare when we get a new price list particularly from bigger companies. So I believe you are suggesting to upload this as quotation? 2. How can we convert excel file to csv file?
This is precisely why we have given the option of CSV upload. Please upload entire list as a vendor quotation in one go. This will update the price of existing items as well as insert new items. However, this will not remove old items. This looks like a special case where items missing in the new file need to be removed from the existing price list. This can be managed by reopening and deleting old quotation, which anyway becomes irrelevant in this case. Normally you do not delete any record. Even if a product is present in hundreds of quotations from a specific vendor, system considers the latest one for price list. This case can be an exception.
You just need to save excel file as CSV. In Excel click on "save as" and select format CSV and save.