Hey guys I am looking for a way to make bulk changes to items in RMS HQ.
I just started working for a company that has used RMS for quite a few years now and I have been asked to find out if there is a way to update department/categories on about 30k items that do not have any department or category. I have done a little searching for some add-ins that might help with this process but have yet to find anything.
I am kind of familiar with SQL but not completely. Can I just export the SQL DB and change it all using Excel? I know this would still take some time but it would be much faster than trying to do it in RMS.
Also all these items are inactive items. I have gone through and changed all the active items but they still would like all the inactive items changed for reporting purposes.
Anyways any help would be greatly appreciated.
Jay