I would like to rename some of my bulk items (i.e. inventory items) and their related child-items (i.e. assemblies) in QB2008 using QODBC v9.

I found several item related tables, item, iteminventory, iteminventoryassembly and all of them seem to have the item number in the name field, as well as full name.

I had assumed that the item name is only in the items table, but obviously i am wrong.

So, do i have to change the name and full name in all item related tables or just the item table? I guess, it would have to be all tables.

Is there anything else I would need to do?

I am fairly new to QODBC and don't want to screw up the database.

The ITEM table is a combined (read only view) list of all Item tables in QuickBooks: ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, and ItemGroup; with minimum common fields.

Inserts and updates are actually done using the ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, or ItemGroup tables.

To update a part name we would do:

Update ItemInventory Set Name = 'New Name' where Name = 'Old Name'

See: How do I add a Inventory Item using QODBC? 
        How do I insert data into ItemService? 
        How do I insert data into ItemNonInventory? 
        How do I create a Item Assembly (ItemInventoryAssembly)? for more.

Thanks for your reply, Tom.

What about the full name field? Is that automatically updated when i update the name field?

And thanks for posting that MS Access script. Not being familiar with Access I was not sure what it does.

I still was wondering if I could ask if anybody would be willing to post a script for item table update using Excel. I am getting closer to year end and would like to have everything sorted out in time to rename my items and update the sales price.