Skip to main content
T
TXHockey2
February 24, 2023
Question

Importing an item list in Desktop Enterprise

  • February 24, 2023
  • 1 reply
  • 0 views

My client has a huge item list (over 15,000 items) and about a third of them have incorrect Income and Expense accounts.  He has exported his list, fixed all of the errors in an Excel sheet is is ready to import his list back into QB.  When he does this, what happens to the exiting item list?  Does the new one overwrite what is in there, or will his item list now double in size?

1 reply

J
JamesAndrewM
February 24, 2023

We're particularly excited to have you as part of our Community, @TXHockey2. We look forward to a successful journey with you! 

 

Let me share some thoughts on importing your item list. When you import the Excel sheet, the existing item list will not be overwritten by the new ones. However, if the items in your file already exist in QuickBooks, you may encounter an error and the process may fail. Unless they are new items, they will pass through to QuickBooks despite encountering the same error.

 

For the items that were not able to go through while importing, I suggest manually adding them to your QuickBooks Desktop. You can refer to this article for the detailed process: Add, edit, and delete items.

 

You can visit the link below to guide you in modifying items and importing inventory files in QuickBooks Desktop: Import or export MS Excel files.

 

For additional QuickBooks-related concerns, don't hesitate to post them here in the Community. We're always available and willing to lend a hand to your queries. Have a great day ahead.

Terms & ConditionsAccessibility statement