Merge Categories

Mar 18, 2006 2 Replies
R

Hello -



We bought out a company and updated its systems from QuckSell to RMS. The problem is that there is 10 years of hacked-up departments, and no categories at all, that we need to clean up before going online.



I've seen posts on solutions for changing the actual wording of a department or category. We'll use the SQL query suggested by Glenn.



Is there a solution for merging items in two categories? Leaving one that we can 'hide' as empty and obsolete? We'd like to narrow down the enormous number of departments into major product areas. Then use categories to define them further.



Thanks for any help,



Ryan Marshall


Vote
Twitter Facebook LinkedIn
T

Ryan,

To merge categories 'C' and 'D' into 'C', you would use a query like this: UPDATE Item SET CategoryID = 'C' WHERE CategoryID = 'D'

To merge 'C' & 'D' into 'E', I believe the query would be: UPDATE Item SET CategoryID = 'E' WHERE CategoryID = 'C' OR CategoryID = 'D'

You would need to run a query to get the proper Category IDs: SELECT * FROM Category

You could always rename the unused categories with something like 'OldCategory'.

HTH, Tom

Vote
Twitter Facebook LinkedIn
G

C, D and E in that example would all be numeric values in this case, and you would not need the quotes around the values. To find the IDs use:

SELECT ID, CODE, Name FROM Category

ID is the value you would want to use...

Glenn Adams Tiber Creek C> Ryan,

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required