Changing Items in Quickbooks Enterprise
If you’ve ever inherited a messy item list in QuickBooks Enterprise — duplicates, inconsistent naming, old SKUs that no longer match what’s on the shelf — you’ve probably wondered whether you can just fix the item number itself instead of building a workaround. Good news: you can.
Item numbers in QuickBooks Enterprise are editable, and merging duplicates is built right in. Here’s the quick walkthrough, plus a few things worth thinking about before you start renaming things in a live company file.
How to change an item number in QuickBooks Enterprise
-
From the top menu, go to Lists > Item List.
-
Find the item you want to update. Right-click it and choose Edit Item. If you have several to clean up at once, use Lists > Add/Edit Multiple List Entries and filter to Items — it’s much faster than opening them one at a time.
-
Click into the Item Name/Number field and type the new value. The field is fully editable.
-
Save your changes. If the new name matches an item that already exists, QuickBooks will ask if you want to merge the two records. Answer based on what you actually want — merging is permanent and can’t be undone.
A few things to do before you rename or merge
-
Back up the company file first. File > Back Up Company > Create Local Backup. Merges cannot be reversed.
-
Make sure no one else is in the file when you’re cleaning up items, especially if you’re working in multi-user mode.
-
Check downstream connections. If you sync QuickBooks with a webstore, EDI, shipping system, or a reporting tool, renaming an item can break the mapping on the other side. Update those integrations at the same time.
-
Document the change. A simple spreadsheet of old name → new name saves a lot of confusion later when someone pulls a historical report.
When item cleanup is a symptom of something bigger
One-off renames and merges are perfectly normal housekeeping. But if you’re regularly fighting your item list — duplicate SKUs because two locations entered the same product differently, no real units-of-measure support, no lot or serial visibility, or item counts pushing the limits of what QuickBooks can handle — that’s usually a sign you’ve outgrown the platform rather than a sign you need to rename more items.
This is the conversation we have a lot with finance and operations leaders: QuickBooks did its job well for years, and now the workarounds are starting to cost more than the software saves. If that sounds familiar, it may be worth stepping back and evaluating whether a modern ERP — something like Microsoft Dynamics 365 Business Central — would give your team the inventory, multi-entity, and reporting capabilities QuickBooks wasn’t built for.
For today, though: yes, go ahead and fix that item number. Just back up first.