Find and resolve duplicate item code errors in Pricebook

Overview

Every Pricebook item, materials, services, equipment, and other direct costs, must have a unique code. If an item code already exists anywhere in your Pricebook, whether the item is active or inactive, ServiceTitan will block adding that same code and display a duplicate-code error. Find the duplicate and free the code so you can add or import the new item.

Find and resolve duplicate item code error in Pricebook

1. Go to the navigation bar and click Pricebook . 

2. Add a service, material, or equipment item using the desired code.

3. If the code is duplicate, you’ll see the Fix Duplicates error message.
   

4. Click View Duplicates in the error message.

5. The Code Duplicates pop-up shows all items with that code, active or inactive.

6. Resolve the duplicate:

   1. Click Autofix to automatically change the existing duplicate codes. This adds a number to the code, for example, code A changes to A 1.
      

   2. Click an item name to open it in a new tab and manually edit its code. Save your changes.
      

7. After the old item’s code is changed, finish creating the new item with the original code and click Save.
   

Bulk resolve duplicates when importing a Pricebook

If you’re importing the Pricebook using Excel and the import shows duplicate-code errors, here are common scenarios where you might find the duplicate item and how to fix it:  

• Scenario 1: The same code appears in different sheets, for example, the code used in both Materials and Equipment sheets.

  • Fix: Open the Excel file, use Ctrl+F to find the code across all sheets and change one of the items’ codes so they differ.

• Scenario 2: Duplicate is an inactive item.

  • Fix: Export your pricebook with Include inactive selected, find the code, edit the old item’s code, save, then re-import.
    

• Scenario 3: Removing a code from one item and assigning it to another in the same import can fail. These are two distinct actions.

  • Fix: Break into two imports: first update the original item’s code (import 1), then import the new item with the desired code (import 2).

• Scenario 4: If you still can’t find the code in question:

  • Find the item’s Item ID in the Excel export row.
    

  • In ServiceTitan, edit the item and check the numeric ID in the URL.
    

  • If the ID on the edit page doesn’t match the Excel ID, another item still has the code. Find and update that item first.

If you have any further questions or issues, please contact ServiceTitan support.

Want to learn more?

• See Pricebook troubleshooting