Hi,
I'm after some guidance on what would be the best way to go about changing the category of multiple items at one time. I'll assume there is a query of some sort that could help me out but I have little to no experience with queries in RMS/SQL specifically (I do have some experience with MySQL databases though).
A nod in the right direction would be much appreciated, cheers!
*This post is locked for comments
Hi,
If you are not familiar with SQL commands/scripts, I strongly recommend you seek a professional’s help.
Hi, unfortunately I'm not familiar with application of the proposed answer, would you mind expanding on how to facilitate same?
This worked perfectly for my purposes. Thank you!
Hi,
If you want to change category for multiple items in batch, then try the below script
UPDATE item
SET categoryid='B'
WHERE categoryid='A' AND itemlookupcode IN ( 'code1', 'code2', 'code3' )
Above script will change the category from 'A' to 'B' only for item codes ( 'code1', 'code2', 'code3' )
retail realm utility has a wizard which can enable you change bulk item properties at once or else you can use a query like
update item set categoryid='X' where itemid='Y'
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,867 Super User 2024 Season 2
Martin Dráb 229,173 Most Valuable Professional
nmaenpaa 101,156