I see this thread was last posted in September, but I wanted to note something I noticed. I setup a few custom vendors that sometimes did not show all the items I had in the merchantlist table. They had the slots going in number order (no gaps). I found, when I also put the items in ITEM ID order as well, then they all showed up on the vendor.
Example...
Code:
INSERT INTO merchantlist (merchantid, item, slot) VALUES
('800043', '16391', '1'),
('800043', '21636', '2'),
('800043', '21650', '3'),
('800043', '28471', '4'),
('800043', '28472', '5'),
('800043', '28473', '6'),
('800043', '28474', '7'),
('800043', '28475', '8'),
('800043', '28476', '9'),
('800043', '28477', '10');
-Djeryv