Skip to main content
A
AccountingPro1
July 16, 2021
Solved

Change Item Codes QB Desktop

  • July 16, 2021
  • 1 reply
  • 0 views

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! 

Best answer by Rustler
@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! 

 

1 reply

Rustler
RustlerAnswer
July 16, 2021
@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! 

 

Terms & ConditionsAccessibility statement