I'm exporting an inventory file out of RMS.
I've got accumulated aliases - some items have 2,3,or more aliases.
When I run:
"Select * from Alias"
It returns just 3 columns: ID, ItemID, and Alias - but I need a query that returns ALL aliases.
*This post is locked for comments
If you only need to look up alias for each item that you enter. The quickest way to is to use RPS Item Manager Addon from retailpossolutions.com Let me know if this helps
Rad - you're right - i had completely failed to notice that the item ID repeats in that list - I kept expecting to see multiple entries tied to the master Item record...
On to a little excel wizarding i guess.
Click on the Item ID column title and you will notice the sorted list shows a line entry for each alias. The Item ID will appear multiple times if an item has more than one alias. This is more obvious if you run Store Operations Manager, Reports, Items, Alias List and sort the report by Item Lookup Code. To export data from the report, click the Export icon in the report toolbar, set Destination to File and File Format to CSV or Tab Delimited.
This doesn't fix my issue.
My problem isn't that I am missing the rest of the item properties.
My problem is that when I look at an item within RMS - many of them have multiple aliases listed: UPC, EAN, internal item code, etc.
I would assume that running " select * from alias " would generate a list of ALL of those aliases - but instead, it appears to only return ONE alias per record.
Where are the rest of the aliases stored?? How do I run a query to return them all?
That table only holds the aliases, no item properties. What you need to do is join the item table to the alias table.
Try this:
select * from alias
left join [item] on [item].id = alias.ItemID
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156