Change multiple item categories

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

eliud mugo 1,444 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'

Was this reply helpful? Yes No
Verified answer

Community Member 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' )

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Change multiple item categories

This worked perfectly for my purposes. Thank you!

Was this reply helpful? Yes No
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?

Was this reply helpful? Yes No
Community Member 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.

Was this reply helpful? Yes No