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
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
