Bulk changing of departments?

Posted by Jay on November 12, 2009, 7:12 pm

Please log in for more thread options

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

Posted by Afshin on November 13, 2009, 12:41 am

Please log in for more thread options

Hi Jay,

Drop me a note with your contact info

Afshin Alikhani - afshin@rrdisti.com
Retail Realm
= = = = = = = = =

> 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