[QODBC-Desktop] - How to rename some of my bulk items (i.e., inventory items) and their related child items (i.e., assemblies)

Problem Description:

I would like to rename some of my bulk items (i.e., inventory items) and their related child items (i.e., assemblies) in QuickBooks Desktop.

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

I had assumed that the item name was only in the items table, but obviously, I was 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.

Solution:

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'

or

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

or

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