These instructions are valid for versions 8.7 and lower.
See separate instructions if you are have version 9 or
To change location codes to "SR" where the code is currently set
(this is for the example of moving items in location AA to
location SR. Of course, you would change the numbers location
codes below in the instructions to match your from- and to-
This also moves all items from major codes 1 to 999. If you want to
restrict that you could change the 1,999 parts to, say 95,95 for just major
code 95 or 500,510 for major codes 500 to 510
You should definitely make a data backup before running these
No other copies of the Shopkeeper/Shop-Pro may be open when you
From the Shop-Pro main menu, choose File, Miscellaneous Options,
At the dot-prompt, type these lines, pressing Enter after each:
USE INV EXCLUSIVE
SET FILT TO BETWEEN(VAL(LEFT(SKU_NO,3)),1,999)
REPLACE ALL LOC1 WITH "SR" FOR LOC1="AA"
REPLACE ALL LOC2 WITH "SR" FOR LOC2="AA"
REPLACE ALL LOC3 WITH "SR" FOR LOC3="AA"
Note where you see a double or triple space one is enough.
Note that you need to type the quote marks around the location
codes as shown above.
Note that there is an underscore in the middle of SKU_NO - not
Check some inventory numbers to verify that they moved in
accordance with your expectations.