I want to update item names in Quickbooks Desktop Enterprise. I don't see an option to upload from excel using the internal item ID. Anyone know how to do this please?

Thanks for reaching out to the Community, @jacob12.

How's you're day been so far? I hope it's been wonderful. At the moment, Item List imports only support the following fields:

• Item Name
• Item Type
• Description of the Item
• Income Account
• Inventory Asset Account
• Name of the COGS Account
• On Hand Quantity
• Cost of Item
• Sales Price
• Total Value
• As Of Date
• Is Passed Thru

For now, you'll need to manually edit these items inside of QuickBooks Desktop. I see how this could be a useful feature for you and your business, so I'll submit this idea to our Product Development Team. We take your feedback seriously, as it's how we grow. 

In the meantime, you can check out this article for more information: Import or export MS Excel files

Shoot me a reply if you have any other questions. Hope you have a wonderful week ahead!

So, just to be clear, there is no way to update item names in bulk?

Are there any third party tools that can help with that?

We have a way to update Item names by bulk, jacob12. 

Is the internal item ID you referred to is the Item Name? If so, we can import multiple items and modify it from there. I'll show you how:

1. Go to the Lists menu and click Add/Edit Multiple List Entries. 
2. From the List drop-down, let's select what type of item we'll import first. 
3. Click the Customize Column at the upper-right of the window to add or remove columns. 
4. Manage the columns and click OK. 
5. In our Excel file, copy the cells that have the inventory item types and then copy and paste it within QuickBooks. 
6. Edit them before clicking Save Changes. 

Do the same steps by selecting the other item type from the List drop-down. For more details, we can check out this article: Add and edit multiple customers, vendors, and items. 

I'm here if there's anything else that you need help with. Thanks!

Catherine - this seems like an extremely risky way to update item names since you are just relying on the items being the same order in the excel worksheet as they are in this list. 

Yes, you can sort the list, but if one item is missing from the excel worksheet or anything like that - then instead of getting an error on one item, you have now completely messed up all of your item names.

All other item attributes can be updated using the import from excel functionality.  This is infinitely safer - can I update the item names in that type of way?

Hey there, jacob12.

Thanks for reaching out. I hope your day is going great. 

You can import the excel file in QuickBooks once your changes have been made. Below I've included the steps on how you can do this. 

1. Open QuickBooks and sign in to the company file. 
2. Once you're signed in to the company file, open the File menu. 
3. Choose Utilities then Import. 
4. Then choose Excel Files. 

5. On the message that appears, select No. 

6. Hit Advanced Import on the right side. 

7. Browse to your Excel worksheet. 

8. Add a mapping.

9. Import when ready. 

Check out: Import or export MS Excel files for more details. 

Please let me know there is anything else that I can assist you with today, Jacob. I'll sure be happy to lend a helping hand in getting you back to business. You can always reach out to the Community or me anytime you find you need help. Take care and have a good one! 

I am very sorry to be rude but this is getting ridiculous.  I'm pretty sure these are bot responses that just pick up on a keyword....

I know how to import from Excel.  But I would like to change the ITEM NAME.

When you import from Excel, Quickbooks uses the item name that you entered to try to find the item and modify other attributes.  If I put in a different item name, then Quickbooks won't find the item and will just create a new item.

I would like to use the Quickbooks Internal ID for the item so that Quickbooks has something else to lookup the item by, and then can change the Item Name.  Is this possible?

Hi there, @jacob12.

QuickBooks Desktop (QBDT) lets you edit multiple item list entries. However, it'll sort the list by item type.

To edit multiple item list in your QBDT, you can follow these steps:

1. Go to the Lists menu.
2. Select Add/Edit Multiple List Entries.
3. Click the drop-down arrow under List and select an item type.
4. Then type in the internal ID in the Find field to search item by ID. 

For more details, you can check this great article for reference:Add and edit multiple customers, vendors, and items.

Then, in case you want to delete an item in your QBDT software, you can refer to this article for the details: Add, edit, and delete items.

Let me know in the comment section if you have other concerns. We'll be around to help.

---

I would like to use the Quickbooks Internal ID for the item so that Quickbooks has something else to lookup the item by, and then can change the Item Name.  Is this possible?

---

Utilize the trial period of these 3rd party importer tools to modify the data in bulk.

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

Hope it helps.

Thank you very much for answering my question.  I have been trying with Saasant but I will try the other tool, and follow up with Saasant support.