1.在creature_template新建商人。或者修改一个现成的商人，我这里新建一个商人。

INSERT INTO `acore_world`.`creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `speed_swim`, `speed_flight`, `detection_range`, `scale`, `rank`, `dmgschool`, `DamageModifier`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `spell_school_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES (80000, 0, 0, 0, 0, 0, 4024, 0, 0, 0, '神秘商人', '传家宝', 'Buy', 0, 34, 34, 0, 3322, 128, 1, 1.14286, 1, 1, 18, 1, 0, 0, 1, 1500, 2000, 1, 1, 1, 32768, 2048, 0, 0, 0, 0, 0, 0, 7, 0, 4481, 4481, 0, 0, 0, 54, 244, 'SmartAI', 0, 1, 1.1, 1, 1, 1, 0, 0, 1, 0, 0, 0, '', 12340);

2.在npc_vendor表中建立关联的售卖物品清单。

INSERT INTO `npc_vendor` VALUES (80000, 1, 4500, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 6265, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 6948, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 1, 34067, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 1, 38082, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 42943, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 42944, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 42945, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 42946, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 42947, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 42948, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 42949, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 42950, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 42951, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 42952, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 42984, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 42985, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 42991, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 42992, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 44091, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 44092, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 44093, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 44094, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 44095, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 44096, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 44097, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 44098, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 44099, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 44100, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 44101, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 44102, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 44103, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 44105, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 44107, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 48677, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 48683, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 48685, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 48687, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 48689, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 48691, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 48716, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 48718, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 50255, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 1, 51809, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 60000, 0, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (80000, 0, 60001, 0, 0, 0, 0);

3.在游戏内 使用NPC命令，将该商人放置于你需要的地方。