When searching for the datasets of items that are tradeable I found out that it doesn't exists, all datasets that are out there contain all item info.
So i decided to clean up dataset which is provided by https://github.com/cmangos/wotlk-db, so you don't have to.
I managed to shorten it from 44k rows to 18k. There are still some non-tradeable items in this dataset, but it's good enough for me. You can narrow down it further if you want.
I also changed original table columns.
You can run scripts on a database of your choice.
wotlk-original.sql script contains unfiltered data and made for MySQL db.
wotlk-cleaned-up.sql script contain filtered data and made for Postgresql db.
cleaning-script.sql contains script that was used to filter original dataset.
Original structure and column descriptions can be found here: https://github.com/cmangos/issues/wiki/item_template
Id of the item. This id is used in wowhead search so you can view it in a more friendly form by putting id in this link https://www.wowhead.com/wotlk/item= "item id"
Type of the item:
ID | Name |
---|---|
0 | Consumable |
1 | Container |
2 | Weapon |
3 | Gem |
4 | Armor |
5 | Reagent |
6 | Projectile |
7 | Trade goods |
8 | Recipe |
9 | Quiver |
10 | Quest |
11 | Key |
12 | Miscellaneous |
13 | Glyph |
Item's name.
Quality of the item:
ID | Color | Quality |
---|---|---|
0 | White | Common |
1 | Green | Uncommon |
2 | Blue | Rare |
3 | Purple | Epic |
4 | Orange | Legendary |
The price that the vendor will pay you for the item when you sell it and if it is possible to be sold, in copper. Put in 0 if the item cannot be sold to a vendor.
In what slot the item can be equipped.
ID | Slot Name | ID | Slot Name |
---|---|---|---|
0 | Non equipable | 15 | Ranged |
1 | Head | 16 | Back |
2 | Neck | 17 | Two-Hand |
3 | Shoulder | 18 | Bag |
4 | Shirt | 19 | Tabard |
5 | Chest | 20 | Robe |
6 | Waist | 21 | Main hand |
7 | Legs | 22 | Off hand |
8 | Feet | 23 | Holdable (Tome) |
9 | Wrists | 24 | Ammo |
10 | Hands | 25 | Thrown |
11 | Finger | 26 | Ranged right |
12 | Trinket | 27 | Quiver |
13 | Weapon | 28 | Relic |
14 | Shield |
URL friendly name of the item