Things could become tricky when you move inventory locations, because you have to update the location info in your database as well.  If you need to move them often, as was the case in my old job, you really need a flexible system that allows you to make those changes efficiently.  So it's important to set up the right system from the onset.

One strategy is to use "categories" as "locations."  Instead of using "Office," "Bookcase 3, "Shelf 2," etc., as location identifiers, use "fiction," "history," "tech," etc., instead, so that you don't need to update their "locations" whenever you move items.  Fiction items will always be fiction, nonfiction will always be that, etc.  This is how public libraries do it.  When they move anything, they only need to change where each category, not every single item, has gone to.  And that may require updating just one record in your database.  Hence, a location system could just be as simple as the following:

Category       Floor     Location
Biography      2         2A
Children       1         1A
Encyclopedia   3         3A
History        3         3B
Nonfiction     3         3C
Romance        1         1B
Poetry         2         2B
Young Adult    1         1C
Etc.