Item/Alias problem (concerning UPC Codes)

Mark,

The ItemID in both the Items tables and the Alias table need to match each other. That is the link between the two. Your UPC code needs to be in the Alias field of the Alias table, along with a unique Alias ID #.

ItemID in the alias table is linked to the ID field of the Item table. This is an auto-generated, 'primary key' field. It cannot be changed. The ID of an item and the ILC are practically never identical. I guess that if the

9999th item you created had an ILC of 9999, they'd be the same but this would be so extremely coincidential that a claim of divine intervention might be appropriate.

To solve your problem... In HQ or SO Administrator, Query and export the result. Open the CSV with MS Word--this is critical if ANY of your ILCs are numeric and start with a zero--and do a Select All|Copy then Paste into Excel. Use Excel's Data|Text to Columns... function to separate the two columns. Make sure that you tell the Text to Columns wizard to format the ILC column as Text or your ILCs will change (in the spreadsheet only).

Once you have your table in Excel, Column A will be ID and Column B will be ILC. Enter your UPC codes in Column C then put the following formula into Column D: ="INSERT INTO Alias (ItemID, Alias) VALUES ("&A2&", '"&C2&"')"

You can then copy and paste the resulting Query(s) into Administrator.

To check your progress, open another query window and SELECT * from Alias

HTH, Tom

"Mark" wrote:

Jeff, that solved the problem, Thanks!

BUT RMS is not scanning items at the register like I thought it would: when scanning a barcode RMS does not, apparently,autonatically check the alias table (Which I would have assumed it would).

Noting that I have an Item number in the ILC and the UPC in the alias table, when I test scan items upc codes they are not found and I must go into the F2 window and check off the alias field and look up that way. The items are then correctly found.

This would be hugely > Mark,

Mark,

Scan a questionable barcode into Notepad and compare it to the alias to make sure that they match exactly. With some formats an extra "0" could be tacked onto the front.

Good luck, Matt

I just ran some sql and switched the ILC to the UPC code and the Alias.alias to the item number.

I still have the same problem!!!!

When I scan an item at the POS it does not "find" the item (the description and price are not populated).

BUT when I press F2 and select the ItemLookUp field (which has the upc code) it finds the item and populates the data I need at checkout.

This has to be someth> ItemID in the alias table is linked to the ID field of the Item table. This

Mark,

2 things to try.

SO Admin, connect to the database, backup, run a check and then re-index.

Like Matt mentioned, you may have dropped a leading 0 if you imported from a .CSV file. Try adding the same UPC to the same item as an alias in RMS manually, its either going to accept it (bad) or tell you its duped (good), and then try scanning it at POS.