There may be situations where you need to update existing products or services in QuickBooks.

It is pretty easy to update multiple products in a single click using Excel Transactions.

If your file has the NAME of the product or service, Excel Transactions will find the product and update it. 

Basic Steps

  1.  Create a excel sheet with name of your product / service & other details like (Rate, Income Account, Description) 
  2.  Click on Modify menu and upload the file 
  3.  Map the name and other fields in Field mapping screen 
  4.  Review and Upload 

Sample File Image



This modify operation does not alter any other details of product / service apart from mapped information in the excel file.


If you want to change the  NAME,Please refer this link