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.
- Create a excel sheet with name of your product / service & other details like (Rate, Income Account, Description)
- Click on Modify menu and upload the file
- Map the name and other fields in Field mapping screen
- Review and Upload
If you want to change the NAME,Please follow below steps
- Click on Export Menu
- Search for particular date and download the file.
- Make changes to the name
- Click on MODIFY Menu
- Upload the File
- Review & Upload
Sample File Image
This modify operation does not alter any other details of product / service apart from mapped information in the excel file.