merchantlist table problem
 

I tried Georges Tools only to find it needs an update, so decided to go do it myself, and it worked :) but the merchant sells items not in the merchantlist table!

Created brand new item in the items table for the merchant to sell
Created Merchant NPC by copying another and gave it new unique ID
Added new Merchant ID to merchantlist with 1 slot and the ID of new item I made.

When I right click the NPC and get the merchant window it shows my new item (great) but then also all the items from the copied NPC - so i re-checked the merchantlist it only shows 1 thing against my npc ID!

I am guessing there is another table involved but could anyone point it out for me please?

It may be an issue with the tools being outdated, as I added a probability column to the merchantlist table so that you can have chance-based items on the merchant. But would you mind taking some screenshots of the information and possibly even the raw table data? Here's a nice screenshotting program.

As required
 

As required, as you can see from the first two screen shots I added item 500000 to both merchants, except merchant ID 999218 has exactly the same items as 155013 in game!
Sorry could find a way of either copying or exporting the table using Heidi

my merchant in the merchantlist
http://prntscr.com/5re9dp

copied merchant in the merchantlist
http://prntscr.com/5re9ww

my merchant from npctypes
http://prntscr.com/5reasn

copied merchant from npctypes
http://prntscr.com/5rea7e

From your npc_types screenshot, I don't see the merchantid column, are you setting the merchantid correctly?

Fixed
 

No it wasnt - I never spotted that myself thank you, seems you need to enter merchant ID in both npctypes and merchant list.
It makes sense now, I can see it that you can have an npc with another npcs merchant ability - by changing it to the same it fixed this instantly thank you for your help.

I'm glad your issue has been resolved, it's small stuff that messes with you the most.