Table of Contents

Update Item IDs Using an Import

Updating Item IDs allows users to change existing item IDs in bulk using the import function while preserving all existing item data such as locations, min/max levels, and item settings. This process saves time and prevents duplicate work when item numbers need to be corrected or standardized.

Also known as: Item ID Change, Item ID Import, Update Item Numbers

Overview

The Item ID Change Import enables users to upload a spreadsheet that replaces old item IDs with new ones without recreating items.
Only the Item ID is changed—all other data remains intact, including locations, min/max values, and purchasing details.

How to Update Item IDs

1. Prepare Ahead (Important)

Before starting the import:

  • Confirm all items already exist in the system
  • Identify the current (old) Item ID
  • Obtain the new Item ID to be applied

Preparing accurate data ahead of time ensures a smooth import and avoids repeated work.

2. Navigate to the Import Page

  1. From the Dashboard, click the Items module
  2. Select the cloud upload icon on the right side
  3. You will be redirected to the Import page
  4. Locate Item ID Change Import
  5. Click the “here” link to take you to the page to download the template
  6. Click the here link again to donwload the template

3. Complete the Import Template

  1. Open the downloaded Excel template
  2. Enter:
    • Old Item ID
    • New Item ID
  3. Save the file with a recognizable name
  4. Remember the file location for uploading

Only the Item ID will be updated—no other item data is affected.

4. Upload and Process the Import

  1. Return to the Item ID Change Import page
  2. Upload your completed template
  3. Review the uploaded data:
    • Enable “Show Errors Only” to quickly identify problems
    • If no errors exist, the page may appear blank—this is normal
  4. Click Update to apply the changes

5. Import Confirmation

  • A notification will confirm the import completed successfully
  • Return to the Item List page once finished

After importing, it is best practice to:

  • Spot-check several updated items
  • Confirm:
  • Suppliers
Edit this page