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 nowI 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! Go to Solution.
@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!
@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!
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.