Tech Blog

How to use the Item updater by Excel cloud app to update the item temporary location

Before using this blog it is recommended to first see the blog How to activate and use the Item updater by Excel cloud app.  We will assume here that the reader has already seen the blog How to activate and use the Item updater by Excel cloud app.

In the example below we will move an item into and out of a temporary location.

ONE

We have an item, barcode 202212131530, which is not in a temporary location.

TWO

We want to move this item (barcode 202212131530) to a temporary location which will be in library “Art Library” and in location “Theses”.

The code for library “Art Library” is UARCV and the code the location “Theses” is THES.

Our input file  therefore looks like this:

THREE

We use the Item updater by Excel cloud app to input the above file.

FOUR

The item is changed and now in the temporary location:

FIVE

To remove the temporary location we have an input file like this:

SIX

We use the Item updater by Excel cloud app to input the above file.

SEVEN

The item is no longer in a temporary location: