Update existing products and services

Summary

How to update existing products and services using a CSV file in Sage Accounting.

Description

To update existing products and service records, you must include a unique ID in your CSV file. The unique ID allows the system to identify existing records and update them.

You get the unique ID by exporting your current product and service records first. Follow out article to export all products and services, before completing the steps below.

Resolution

Prepare your CSV file

Open the downloaded CSV file, which includes the unique IDs, and make the changes you need.

TIP:

To add a new record, create a new row and leave the unique IDs blank. 

Save your file once you're happy with the changes.

Import your changes

  1. Go to Products and Services.
  2. Under the New Item dropdown, select Update Items.
  3. Choose or drop the file and select Upload file.
  4. Select how you want to handle empty cells and select Continue.
  5. Review the summary page and select Start import.

After the import completes, the summary shows how many records the import created and updated.

Related Solutions

Solution Properties

Solution ID
260513083812947
Last Modified Date
Tue Aug 18 09:52:25 UTC 2026
Views
0