cancel
Showing results for 
Search instead for 
Did you mean: 
AccountingPro1
Level 1

Change Item Codes QB Desktop

I am going through a huge overhaul on all of my non-inventory items. We have created new codes to lay over the old/existing ones. Instead of going into each item one by one; is there a way for me to import the Excel file and have it replace the item code automatically? 

 

Alternatively, the other option I could see would be to make each item inactive than import my new codes through File > Utilities > Import > Excel File. The problem with this is we have over 1,000 codes and that would be extremely time-consuming. 

 

Thank you for your help! 

Solved
Best answer July 16, 2021

Best Answers
Rustler
Level 15

Change Item Codes QB Desktop


@AccountingPro1 wrote:

I am going through a huge overhaul on all of my non-inventory items. We have created new codes to lay over the old/existing ones. Instead of going into each item one by one; is there a way for me to import the Excel file and have it replace the item code automatically? 

No there is no replace, a new item is just that, new.

 

Alternatively, the other option I could see would be to make each item inactive than import my new codes through File > Utilities > Import > Excel File. The problem with this is we have over 1,000 codes and that would be extremely time-consuming. 

Either do that or edit and change the name, one by one

 

Thank you for your help! 


 

View solution in original post

1 Comment 1
Rustler
Level 15

Change Item Codes QB Desktop


@AccountingPro1 wrote:

I am going through a huge overhaul on all of my non-inventory items. We have created new codes to lay over the old/existing ones. Instead of going into each item one by one; is there a way for me to import the Excel file and have it replace the item code automatically? 

No there is no replace, a new item is just that, new.

 

Alternatively, the other option I could see would be to make each item inactive than import my new codes through File > Utilities > Import > Excel File. The problem with this is we have over 1,000 codes and that would be extremely time-consuming. 

Either do that or edit and change the name, one by one

 

Thank you for your help! 


 

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up