Renaming 1000 items at once


D

DenoxiS

Hi,

There are 1000+ products in the inventory of this company file. Item
names are the company-specific SKU numbers. The company is leaving the
current SKU numbering system. So they will use new SKU numbers for the
same items. They want to keep all the transactions and inventory
information.

Is there any fast way to rename inventory items, by using an IIF file
for example, so we don't have to do it from QuickBooks one by one?

I appreciate your help.

~Den
 
Ad

Advertisements

A

Allan Martin

DenoxiS said:
Hi,

There are 1000+ products in the inventory of this company file. Item
names are the company-specific SKU numbers. The company is leaving the
current SKU numbering system. So they will use new SKU numbers for the
same items. They want to keep all the transactions and inventory
information.

Is there any fast way to rename inventory items, by using an IIF file
for example, so we don't have to do it from QuickBooks one by one?

I appreciate your help.

~Den

You can always export the item list to an iff file, open the file in Excel,
edit and save, then import the iff file back.
 
G

Gary

I'm not sure you can use an IIF file to rename items.

If you export the items, open them in another program, like Excel. Rename
them, and then import the file, you will create new items. So then you will
have the old items and new items. You could make all the old items inactive
from an IIF file, but that may not be satisfactory.

Gary
 
A

Allan Martin

Gary said:
I'm not sure you can use an IIF file to rename items.

If you export the items, open them in another program, like Excel. Rename
them, and then import the file, you will create new items. So then you will
have the old items and new items. You could make all the old items inactive
from an IIF file, but that may not be satisfactory.
If you only edit the description the item is updated not added. I can see
after looking at the post again it will not help the OP who wants to change
the part number/name.
 
D

DenoxiS

When you import back, there are new items with different names.
Transactions wouldn't refer to these items, so that's not what I
wanted.

But I found the trick. In the export file, there is a USEID field.
When you change it to "Y", QuickBooks will use the ID (REFERENCE
field) instead of item name during the import, so you can rename
anything you want as long as you keep the ID.

Thank you all.
 
G

Gary

WTG

DenoxiS said:
When you import back, there are new items with different names.
Transactions wouldn't refer to these items, so that's not what I
wanted.

But I found the trick. In the export file, there is a USEID field.
When you change it to "Y", QuickBooks will use the ID (REFERENCE
field) instead of item name during the import, so you can rename
anything you want as long as you keep the ID.

Thank you all.

"Allan Martin" <Intuit_Man@CPA.com> wrote in message
 
Joined
Feb 9, 2017
Messages
1
Reaction score
1
Country
United States
But I found the trick. In the export file, there is a USEID field.
When you change it to "Y", QuickBooks will use the ID (REFERENCE
field) instead of item name during the import, so you can rename
anything you want as long as you keep the ID.
Where can I get an export with that ID column included, I can't see the option to get this column expoerted along with my Item export!??
 
Ad

Advertisements

Joined
Mar 8, 2017
Messages
1
Reaction score
0
Country
United States
Where can I get an export with that ID column included, I can't see the option to get this column expoerted along with my Item export!??
it make sense but where is the useid field?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Categorize multiple items at once? 1
investment with £1000 7
etouch 1000 2
event ID 1000 1
scan the same item more than once 3
Applying a tax rate to multiple items at once 4
Renaming Reports 7
Renaming rules 6

Top