Invent Item Location table warehouse update

I need to add several warehouses to the InventItemLocation table for several thousand items.

The Invent Table was exported at first but then it looked like I only needed to export the Invent Item Location table and update the Dimension No field. I have done this in test and it seems to work well but, after reading the comments in the “Invent Table Import” post, I am concerned that there may be some linked tables I am overlooking.

After exporting the InventItemLocation table to Excel I am adding 9 lines to each item and putting the warehouse numbers in the Dimension No field.

Am I going about this the right way? Is there an easier way to add 9 warehouses to 20,000+ items?