1. Home
  2. Point-Of-Sale Software
  3. Merge Categories

Merge Categories

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

Reply to
Ryan D. Marshall
Loading thread data ...

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

Reply to
Terrible Tom

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,

Reply to
Glenn Adams [MVP - Retail Mgmt]

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.