I started cleaning up merchants a couple of days ago as well. Basically, my method is to use the PEQ Editor and only show the merchants in PoK. Then, I compare their lists to EQTraders/my own knowledge and find any item that don't belong on that list. I then use Allah to identify any item on that list that doesn't belong on ANY vendor. Finally, I add those ids to a growing .sql query to remove them. Since PEQ is still down, I haven't been cleaning up individual lists (I'd rather do that directly to the Live database) but after I am done, each merchant won't have any item that shouldn't be vendor sold, which imho is a HUGE improvement. Many will still have extra items, but the benefit is no legit item will be removed and the extra items are vendor sold anyway.
|