1. Home
  2. Point-Of-Sale Software
  3. Change Item Lookup Code to Uppercase

Change Item Lookup Code to Uppercase

Having issues scanning barcodes that are generated from RMS when the Item Lookup Code is in lowercase. I have changed a few items in HQ manager that had lowercase Lookup Codes to uppercase and after I synced the SO Database and printed off a new Label and the barcode scans fine. So now I am wondering if I can just generate a SQL Query with the Item lookup Code and Item ID and export it to Excel. Use Excels UPPER Formula to change all Item Lookup Codes to Uppercase and then export the data into the HQ Database. This seems a little far-fetched but it seems like it could work. Just would like anyone?s help or input before I try this. And if the is something I can do in HQ to make the Lookup Code all Uppercase I would not be opposed to doing that. I always backup before doing anything.

Reply to
nt8378
Loading thread data ...

make sure you back up your DB before running the query below or any other sql queries against it

you can accomplish this without first exporting to excel, just run this query:

UPDATE Item SET ItemLookupCode = UPPER(ItemLookupCode)

and this will accomplish what you need. you could run this against your HQ database, then use a worksheet to send the changes in the itemlookupcode to all your stores

hth kevin

"nt8378" wrote:

Reply to
kskinne

I guess I got it. I used this command:

UPDATE "Item" SET ItemLookupCode = upper( ItemLookupCode )

And it updated all of my lookup codes to uppercase.

"nt8378" wrote:

Reply to
nt8378

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.