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! 

---