Change multiple item categories

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (5)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Change multiple item categories

Hi,

If you are not familiar with SQL commands/scripts, I strongly recommend you seek a professional’s help.
extel 370 on at

Like (1)

Report

RE: Change multiple item categories

Hi, unfortunately I'm not familiar with application of the proposed answer, would you mind expanding on how to facilitate same?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Change multiple item categories

This worked perfectly for my purposes. Thank you!
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Change multiple item categories

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' )
Suggested answer

eliud mugo 1,440 on at

Like (0)

Report

RE: Change multiple item categories

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'