Does anyone know weather it is possible to change the item department and category for several items at a time??
Changing Department and Category info for bulk items
Sep 19, 2006
4 Replies
Thank you for your responses.
is it possible you can give me an example of this SQL statments.
I basically need to change the category e.g. skirt, and department of hundreds of items in DB, and obviously dont want to sit there and change all Individually!
"Nashat" wrote:
This is an example of how to assign items belonging to 3 department (Dep1,dep2,dep3) to only one department (New) dep
*********************** update item set departmentidÞpartment.id from department where department.name ='New Dep' and item.departmentid in (select id from department where name='dep1' or name='dep2' or name='dep3') ************************ u can replace the name with the code of course, the sql statement is smililar to assign items to a new category, u must take care of assigning all categories to their correspongin departments In other words, if u already defined the departments & categories to be assigned to items, u'll need to run 2 sql statements, one to reassign items to their new departments, and one to reassign items to their new categories. plz let me know if u need further detailsNashat
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required