npc_vendor_template

Back to world database list of tables.

The `npc_vendor(_template)` table

holds the vendor data for all NPCs that sell items by `creature_template`.`entry` or creature_template.VendorTemplateId.

The gold price for each item is in its item template as BuyPrice.

Structure

Field	Type	Null	Key	Default	Extra
entry/VendorTemplateId	int(10) unsigned	NO	PRI	0
item	int(10) unsigned	NO	PRI	0
maxcount	int(10) unsigned	NO		0
incrtime	int(10) unsigned	NO		0
slot	tinyint(3) unsigned	NO		0
ExtendedCost	mediumint(8) unsigned	NO		0
condition_id	mediumint(8) unsigned	NO		0
comments	text	NO		NULL

Description of the fields

entry/VendorTemplateId

For npc_vendor it’s the `creature_template`.`entry` of the creature

For npc_vendor_template it’s the creature_template.VendorTemplateId of the vending_list which is sold by this entry.

item

The item ID. See item_template.entry

maxcount

The maximum number of copies of the item the vendor has available to be sold. If 0, then it is an unlimited number of copies.

incrtime

Combined with maxcount, this field tells how often (in seconds) the vendor list is refreshed and the limited item copies are restocked. For limited item copies, every refresh, the quantity is increased by item_template.BuyCount

slot

Decides position of the sold item in the vendor menu

slot	slot
1	2
3	4
5	6
7	8
9	10

ExtendedCost

The value here corresponds to the ID in ItemExtendedCost.dbc and that ID controls the item’s non monetary price, be it honor points, arena points, different types of badges or any combination of the above.

condition_id

Condition to buy the item

comments

Description – Currently “Item Name”