Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowThanks 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:
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:
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.
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.