i imported thousands of items using RR import utility that had wrong look up codes. i can tell becuase those items are never sold. i can re imort all those items and put them in a same department or supplier called delete. how can i delete all the items in a department or supplier. i dont want to mess up my db. please help
query to delete all items in a department
Dec 31, 2007
4 Replies
hi Manos, before you do so backup your database
Then go to SO Admin | File Connect the Db | Then go to Query and click New: run the below query one by one
delete from supplierlist from department,item where item.departmentidÞpartment.id and item.id=supplierlist.itemid and department.code='xx'
delete from alias from department,item where item.departmentidÞpartment.id and item.id=alias.itemid and department.code='xx'
delete from item from department where item.departmentidÞpartment.id and department.code='xx'
onces work rate me,or if need more help feel free to ask.
Akber
"manoj" wrote:
hi manoj
yes > Hello Akber, Thanks for the replay. just to make sure that this if if i
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required