Pocket Fel Spreader Farming
-
Pocket Fel Spreader Farming Pocket Fel Spreader Farming Better done in a
group. You don’t get extra chance at loot, but you do get extra eyes, who
can cove...
9.13.2013
Full 83-84 MoP Armor TradeSkillMaster Importable Lists
About a month ago it occurred to me that if I had a list of every desirable 83-84 Mists of Pandaria armor and suffix in the game and was able to import that list into TradeSkillMaster that I would be able to greatly simplify not only the selling of items in my 83-84 market items but also make buying them easier.
My goal was to build such a set of master lists I could import into TradeSkillMaster groups. Once I had created a groups using this lists I could then build TSM shopping operations to search for the items and TSM Auctioning Operations to sell these items. All this with out ever having to spend time adding newly purchased items one by one into TSM groups by hand.
Read on past the jump for more info on how I create the lists and, more importantly, the lists themselves for you import into TradeSkillMaster and use yourself.
The Methodology
I created these importable lists by first figuring our how to import items including suffixes into TradeSkillMaster. The answer was provided by the tooltip that appears when you mouse over the "Import String" entry field inside the Group > Import/Export tab.
TradeSkillMaster "Import String" Tooltip |
The above image shows the tooltip which says "For randomly enchanted items, the format is <itemID>:<randomEnchant> (ex: 38472:-29)".
In order to add a random enchant (AKA a "suffix") we add ":-" to the item ID along with the random suffix (AKA "randomEnchant") ID.
The two things I had to do then was first get a list of all the item IDs that were included in the 83-84 Mists of Pandaria armor items and then get a list of all the desirable suffix IDs.
I then needed to merge these lists together to form the master lists that combined every item with every suffix.
What Are Suffixes?
For the sake of this post just know that "suffix", "Item Suffix", "Random Suffix", "Random Enchant" and "Random Enchantment" are all the same thing. They are the parts of an item name after the words "of the".
They are the random property that World of Warcraft adds to the base items when they are dropped by mobs.
For example in the case of "Brick Breastplate of the Earthfall" the part of the name called "of the Earthfall" (or simply "Earthfall") is the suffix.
Suffixes all have their own set of properties they give items. In the case of "Earthfall" the items have Stamina, Strength, Critical Strike and Haste.
Gathering The Item IDs
To get the item IDs I used Wowhead.com filters to narrow results for each armor type (cloth, leather, mail, plate and other) to only the 83-84 items that were Bind of Equip and Added in Mists of Pandaria.
Once I had the filtered results I then copied and pasted the result's web page table into SLAGIT which was a tool we host here at Power Word: Gold (now updated and known as "Grouper") that allows you to obtain item IDs from links copied from sites like Wowhead , The Undermine Journal and WoWuction.
We're happy to announce that we've updated SLAGIT to work with TradeSkillMaster 2.0. The tool is now called Grouper and you can find a link to the new and improved tool at the top of Power Word: Gold.
I now had lists of Item IDs for all the various armor types (cloth, leather, mail, plate and other) for all the level 83-84 Mists of Parndaria items I intended to buy and sell.
Gathering The Suffix IDs
Once I had the Item IDs I was ready to marry them to the desirable suffixes. To obtain the suffixes I did a web search and was able to find the ItemRandomSuffix page on Wowpedia.
This page included a list of all the random suffixes in the game and more importantly their suffix IDs. The page also noted that each suffix ID needed a "-" before it as noted in the TSM tooptip mentioned above.
This meant that for each suffix I wanted to use to build an item + suffix itemString I would simply add ":", "-" and then the suffix id. For example if adding suffix ID "5" I would add ":-5" to the itemString.
I using the information I obtained from the ItemRandomSuffix page and by examining the "Random Enchantments" section of the item page on Wowhead for example items in the 83-85 range (to determine which suffixes were included on each armor type) I was able to build a list of possible suffixes for each armor type.
I then removed suffixes I didn't plan to buy or sell. This gave me a master list of all desirable suffixes for each armor type.
Combining Item and Suffix IDs
Now I had two giant lists. One being the item IDs of all the base 83-84 Mists of Pandaria armor and the other a list of all the desirable suffixes for each armor type.
All I had to do now was combine these lists and generate a master list of item ID + suffix IDs.
This was by far the trickiest part of the process. After some rather time-intensive work with spreadsheets I was finally able to build master lists that included item IDs and suffix IDs.
For example if I had an item like a "Reed Cord" (which is a level 84 cloth belt) I would take its item ID of "82029" and duplicate it by the number of item different suffixes I needed to add,
Once I had say miutiple copies of "82029" on the spreadsheet I would add ":-" and then all the suffix IDs such as suffix ID "42" which happens to be "of the Elder" and finally add "," to the end (to properly prepare it for list format).
I would end up with something like " 82029:-42," which imports into TradeSkillMaster as "Reed Cord of the Elder".
I did this over and over for each and every item.
Luckily using a spreadsheet helped with some of the heavy lifting. I could quickly duplicate item IDs along with using the spreadsheet to duplicate lists of suffix IDs easily.
I then used a concatenate function in the spreadsheet to build the final proper item ID + suffix ID and did a bit of clean up in a text editor to properly format the lists for import into TradeSkillMaster.
(I'm sure you computer programmers out there could build a program to do this but I worked with the tools I had available and knew how to use.)
Making The Sausage
After this somewhat laborious process I ended up with TSM importable lists that included all the level 83-84 Mists of Pandaria cloth, leather, mail, plate and other armor items including all the desirable suffixes.
If you've worked the 83-84 item market you know that in general it's a process of using something (often Auctioneer saved searches) to buy items, adding them to lists manually and then selling them.
Adding items to lists can take a good amount of time and eliminating the need to search through various groups and subgroups to put items into them can make the process of selling 83-84 items even more efficient.
I also wanted to see if I could eliminate the need to use Auctioneer saved searches and only have to use TradeSkillMaster.
One of the reasons I had stuck with Auctioneer for buying items was the ability to ignore undesirable items from future searches. I realized I could accomplish the same thing by simply not including those items while I was building the initial TSM lists.
The other thing I liked about Auctioneer saved searches was the ability to search for items under a certain price. Building a TradeSkillMaster Shopping Operation with a maximum price accomplished the same thing with the additional benefit of being able to use all the various options TSM has to build price sources (min, max, The Undermine Journal GE, etc.).
Use The Process
I hope that by going through a little bit of the process of how I created the lists below you will be able build your own TradeSkillMaster importable lists that also include suffixes.
It's great for markets like flipping items where the items are a known quantity and where you want to front load a lot work by building the lists ahead of time.
How I Use These Lists
With the ability inTradeSkillMaster to use the same group for shopping and auctioning I thought I would spend a bit of time explaining how I use the groups created from these lists day-to-day.
I created a master group called "83-84". I then created subgroups for each armor type: Cloth, Leather, Mail, Plate and Other.
I then imported the finished lists into the subgroups and created and added a Shopping Operation to each subgroup.
I plan on doing another post that goes into some of my more esoteric and complex Shopping Operations but for most people a simple "45g" would suffice for shopping operations for most of these groups.
I then added an Auctioning Operation to each groups as well. As a usable example you might use an operation that sells the non-plate items for 245g for example and plate items 395g to start off with.
My Routine
My routine using the groups I created from these master lists is:
- Re-post expired auctions as normal.
- Click the "Shopping" tab in TSM > click the "TSM Group" button in the top of the window beside "Sidebar Pages:" at the top of the Shopping window.
- Select wanted groups (or press the "Deselect All Groups" button and then select the wanted groups) in the Sidebar until only the groups I want to search for are highlighted in yellow.
- Press the "Start Search" button at the bottom of the sidebar.
- Once the search is complete I select the items and press "Buyout" one-by-one.
Advanced Tip
If you want to speed up the buying of multiple items and you already use the "Create Macro and Bind ScrollWheel" auctioning option to buy and cancel items by holding down Ctrl and moving your mousewheel back and forth you can add the following to your TSM macro (it has a pure green icon).
If you want to speed up the buying of multiple items and you already use the "Create Macro and Bind ScrollWheel" auctioning option to buy and cancel items by holding down Ctrl and moving your mousewheel back and forth you can add the following to your TSM macro (it has a pure green icon).
/click TSMAHTabBuyoutButton
/click TSMAHConfirmationActionButton
(Be sure to make a backup copy of the changes TSM macro (perhaps in another macro slot) as setting the command in the future will erase these modifications.)
After adding the above to your TSM macro all you have to do to buy out multiple items is first select the top item in the list until it is highlighted in yellow and then hold Ctrl and move your mousewheel back and forth.
This will automatically select the next item in the list and press "Buyout" and so on. which is quite handy for buying a lot of items in a row.
No Backstock
Once I've purchased all the items that show up in the results I head back to the auction house and sell the items I've just purchased.
I have also started what I call a "no backstock" policy which means I no longer keep backstock of my 83-84 items.
If I have any items left in my bags after posting it means that I have duplicate items. I simply sell these items to the vendor.
It means that I don't have them in the future to sell if the ones on the auction house sell out but it also means I never have to go searching through my guild bank looking for duplicate items.
Granted the "Move AH Shortfall to Bags" option in TSM_Warehousing does make that process a bit shorter but I've found the peace of mind of never having to worry about putting backstock into the guild bank and pulling it out again really streamlines the process of selling these items and saves me time.
If you want to use a backstock system feel free but for me the little bit of revenue loss is worth the peace of mind and ease of use of my "no backstock" system.
Creating TSM Groups/Subgroups
I wanted to give a few brief instructions on how to import these lists. To import the lists you first need to create a group and/or subgroup to import the items in to.
To create a TSM group:
Go to the TSM settings (/tsm or use the minimap button) > click the Groups icon at top (blue crystal) > click "Groups" in the left column > enter a name into "Group Name" entry field in the right column > click the red "Okay" button that appears and the right of the entry field.
Your new group will appear in the left column.
To create a TSM subgroup:
Go to the TSM settings (/tsm or use the minimap button) > click the "Groups" icon at top (blue crystal) > click the name of the group you want to create the subgroup under in the left column > click the "Management" tab at the top of the right column > enter a name into "New Subgroup Name" entry field in the right column > click the red "Okay" button that appears and the right of the entry field.
Your new subgroup will appear under the group you created it in in the left column.
Importing Lists Into TSM Groups/Subgroups
Now that you have a group or subgroup you need to import the items into the group.
To import a list to a TSM group/subgroup:
Select the text listed below (only selecting the text in the Courier font) and copy it to your clipboard (Ctrl+C or similar) > go to the TSM settings (/tsm or use the minimap button) > click the "Groups" icon at top (blue crystal) > click the name of the group or subgroup you want to import the items into in the left column > click the "Import/Export" tab at the top of the right column > click inside the "Import String" entry field until your cursor appears blinking inside the entry field > paste the text you copied to your pasteboard earlier (Ctrl+V or similar) > click the red "Okay" button that appears and the right of the entry field.
TSM should give you a indication in your chat window that the items have been imported. To verify click the "Items" tab at the top of the right column. The items you imported should be listed in the right-most sub-column labeled "Group Items".
The Master Lists
Below are the importable TradeSkillMaster lists for all the desirable items I buy and sell in my 83-84 Mists of Pandaria armor category.
The lists do not include any weapons. I may make those lists in the future.
The lists consist of every possible 83-84 item + suffix except "...of the Whale", "...of the Beast", "...of the Tiger", "...of the Eagle" and "...of the Seer" which were all eliminated for being particularly poor sellers in my research.
Importable 83-84 Mists of Pandaria Cloth List:
82029:-42,82029:-138,82029:-130,82029:-114,82029:-39,82029:-36,82029:-131,82029:-132,82029:-129,82030:-42,82030:-138,82030:-130,82030:-114,82030:-39,82030:-36,82030:-131,82030:-132,82030:-129,82031:-42,82031:-138,82031:-130,82031:-114,82031:-39,82031:-36,82031:-131,82031:-132,82031:-129,82032:-42,82032:-138,82032:-130,82032:-114,82032:-39,82032:-36,82032:-131,82032:-132,82032:-129,82033:-42,82033:-138,82033:-130,82033:-114,82033:-39,82033:-36,82033:-131,82033:-132,82033:-129,82034:-42,82034:-138,82034:-130,82034:-114,82034:-39,82034:-36,82034:-131,82034:-132,82034:-129,82035:-42,82035:-138,82035:-130,82035:-114,82035:-39,82035:-36,82035:-131,82035:-132,82035:-129,82036:-42,82036:-138,82036:-130,82036:-114,82036:-39,82036:-36,82036:-131,82036:-132,82036:-129,81966:-42,81966:-138,81966:-130,81966:-114,81966:-39,81966:-36,81966:-131,81966:-132,81966:-129,81967:-42,81967:-138,81967:-130,81967:-114,81967:-39,81967:-36,81967:-131,81967:-132,81967:-129,81968:-42,81968:-138,81968:-130,81968:-114,81968:-39,81968:-36,81968:-131,81968:-132,81968:-129,81969:-42,81969:-138,81969:-130,81969:-114,81969:-39,81969:-36,81969:-131,81969:-132,81969:-129,81970:-42,81970:-138,81970:-130,81970:-114,81970:-39,81970:-36,81970:-131,81970:-132,81970:-129,81971:-42,81971:-138,81971:-130,81971:-114,81971:-39,81971:-36,81971:-131,81971:-132,81971:-129,81972:-42,81972:-138,81972:-130,81972:-114,81972:-39,81972:-36,81972:-131,81972:-132,81972:-129,81973:-42,81973:-138,81973:-130,81973:-114,81973:-39,81973:-36,81973:-131,81973:-132,81973:-129
Importable 83-84 Mists of Pandaria Leather List:
81981:-40,81981:-134,81981:-91,81981:-5,81981:-133,81981:-131,81981:-132,81981:-135,81981:-137,81981:-136,81979:-40,81979:-134,81979:-91,81979:-5,81979:-133,81979:-131,81979:-132,81979:-135,81979:-137,81979:-136,81976:-40,81976:-134,81976:-91,81976:-5,81976:-133,81976:-131,81976:-132,81976:-135,81976:-137,81976:-136,81978:-40,81978:-134,81978:-91,81978:-5,81978:-133,81978:-131,81978:-132,81978:-135,81978:-137,81978:-136,81977:-40,81977:-134,81977:-91,81977:-5,81977:-133,81977:-131,81977:-132,81977:-135,81977:-137,81977:-136,81980:-40,81980:-134,81980:-91,81980:-5,81980:-133,81980:-131,81980:-132,81980:-135,81980:-137,81980:-136,81975:-40,81975:-134,81975:-91,81975:-5,81975:-133,81975:-131,81975:-132,81975:-135,81975:-137,81975:-136,81974:-40,81974:-134,81974:-91,81974:-5,81974:-133,81974:-131,81974:-132,81974:-135,81974:-137,81974:-136,82037:-40,82037:-134,82037:-91,82037:-5,82037:-133,82037:-131,82037:-132,82037:-135,82037:-137,82037:-136,82038:-40,82038:-134,82038:-91,82038:-5,82038:-133,82038:-131,82038:-132,82038:-135,82038:-137,82038:-136,82039:-40,82039:-134,82039:-91,82039:-5,82039:-133,82039:-131,82039:-132,82039:-135,82039:-137,82039:-136,82040:-40,82040:-134,82040:-91,82040:-5,82040:-133,82040:-131,82040:-132,82040:-135,82040:-137,82040:-136,82041:-40,82041:-134,82041:-91,82041:-5,82041:-133,82041:-131,82041:-132,82041:-135,82041:-137,82041:-136,82042:-40,82042:-134,82042:-91,82042:-5,82042:-133,82042:-131,82042:-132,82042:-135,82042:-137,82042:-136,82043:-40,82043:-134,82043:-91,82043:-5,82043:-133,82043:-131,82043:-132,82043:-135,82043:-137,82043:-136,82044:-40,82044:-134,82044:-91,82044:-5,82044:-133,82044:-131,82044:-132,82044:-135,82044:-137,82044:-136
Importable 83-84 Mists of Pandaria Mail List:
81982:-40,81982:-134,81982:-91,81982:-5,81982:-133,81982:-131,81982:-132,81982:-135,81982:-137,81982:-136,81989:-40,81989:-134,81989:-91,81989:-5,81989:-133,81989:-131,81989:-132,81989:-135,81989:-137,81989:-136,81986:-40,81986:-134,81986:-91,81986:-5,81986:-133,81986:-131,81986:-132,81986:-135,81986:-137,81986:-136,81987:-40,81987:-134,81987:-91,81987:-5,81987:-133,81987:-131,81987:-132,81987:-135,81987:-137,81987:-136,81985:-40,81985:-134,81985:-91,81985:-5,81985:-133,81985:-131,81985:-132,81985:-135,81985:-137,81985:-136,81984:-40,81984:-134,81984:-91,81984:-5,81984:-133,81984:-131,81984:-132,81984:-135,81984:-137,81984:-136,81983:-40,81983:-134,81983:-91,81983:-5,81983:-133,81983:-131,81983:-132,81983:-135,81983:-137,81983:-136,81988:-40,81988:-134,81988:-91,81988:-5,81988:-133,81988:-131,81988:-132,81988:-135,81988:-137,81988:-136,82021:-40,82021:-134,82021:-91,82021:-5,82021:-133,82021:-131,82021:-132,82021:-135,82021:-137,82021:-136,82022:-40,82022:-134,82022:-91,82022:-5,82022:-133,82022:-131,82022:-132,82022:-135,82022:-137,82022:-136,82023:-40,82023:-134,82023:-91,82023:-5,82023:-133,82023:-131,82023:-132,82023:-135,82023:-137,82023:-136,82024:-40,82024:-134,82024:-91,82024:-5,82024:-133,82024:-131,82024:-132,82024:-135,82024:-137,82024:-136,82025:-40,82025:-134,82025:-91,82025:-5,82025:-133,82025:-131,82025:-132,82025:-135,82025:-137,82025:-136,82026:-40,82026:-134,82026:-91,82026:-5,82026:-133,82026:-131,82026:-132,82026:-135,82026:-137,82026:-136,82027:-40,82027:-134,82027:-91,82027:-5,82027:-133,82027:-131,82027:-132,82027:-135,82027:-137,82027:-136,82028:-40,82028:-134,82028:-91,82028:-5,82028:-133,82028:-131,82028:-132,82028:-135,82028:-137,82028:-136
Importable 83-84 Mists of Pandaria Plate List:
82067:-7,82067:-125,82067:-127,82067:-45,82067:-123,82067:-122,82067:-120,82067:-42,82067:-118,82067:-39,82067:-121,82067:-139,82067:-124,82067:-128,82067:-43,82067:-36,82067:-131,82067:-132,82068:-7,82068:-125,82068:-127,82068:-45,82068:-123,82068:-122,82068:-120,82068:-42,82068:-118,82068:-39,82068:-121,82068:-139,82068:-124,82068:-128,82068:-43,82068:-36,82068:-131,82068:-132,82069:-7,82069:-125,82069:-127,82069:-45,82069:-123,82069:-122,82069:-120,82069:-42,82069:-118,82069:-39,82069:-121,82069:-139,82069:-124,82069:-128,82069:-43,82069:-36,82069:-131,82069:-132,82070:-7,82070:-125,82070:-127,82070:-45,82070:-123,82070:-122,82070:-120,82070:-42,82070:-118,82070:-39,82070:-121,82070:-139,82070:-124,82070:-128,82070:-43,82070:-36,82070:-131,82070:-132,82071:-7,82071:-125,82071:-127,82071:-45,82071:-123,82071:-122,82071:-120,82071:-42,82071:-118,82071:-39,82071:-121,82071:-139,82071:-124,82071:-128,82071:-43,82071:-36,82071:-131,82071:-132,82072:-7,82072:-125,82072:-127,82072:-45,82072:-123,82072:-122,82072:-120,82072:-42,82072:-118,82072:-39,82072:-121,82072:-139,82072:-124,82072:-128,82072:-43,82072:-36,82072:-131,82072:-132,82073:-7,82073:-125,82073:-127,82073:-45,82073:-123,82073:-122,82073:-120,82073:-42,82073:-118,82073:-39,82073:-121,82073:-139,82073:-124,82073:-128,82073:-43,82073:-36,82073:-131,82073:-132,82075:-7,82075:-125,82075:-127,82075:-45,82075:-123,82075:-122,82075:-120,82075:-42,82075:-118,82075:-39,82075:-121,82075:-139,82075:-124,82075:-128,82075:-43,82075:-36,82075:-131,82075:-132,81996:-7,81996:-125,81996:-127,81996:-45,81996:-123,81996:-122,81996:-120,81996:-42,81996:-118,81996:-39,81996:-121,81996:-139,81996:-124,81996:-128,81996:-43,81996:-36,81996:-131,81996:-132,81994:-7,81994:-125,81994:-127,81994:-45,81994:-123,81994:-122,81994:-120,81994:-42,81994:-118,81994:-39,81994:-121,81994:-139,81994:-124,81994:-128,81994:-43,81994:-36,81994:-131,81994:-132,81990:-7,81990:-125,81990:-127,81990:-45,81990:-123,81990:-122,81990:-120,81990:-42,81990:-118,81990:-39,81990:-121,81990:-139,81990:-124,81990:-128,81990:-43,81990:-36,81990:-131,81990:-132,81993:-7,81993:-125,81993:-127,81993:-45,81993:-123,81993:-122,81993:-120,81993:-42,81993:-118,81993:-39,81993:-121,81993:-139,81993:-124,81993:-128,81993:-43,81993:-36,81993:-131,81993:-132,81992:-7,81992:-125,81992:-127,81992:-45,81992:-123,81992:-122,81992:-120,81992:-42,81992:-118,81992:-39,81992:-121,81992:-139,81992:-124,81992:-128,81992:-43,81992:-36,81992:-131,81992:-132,81991:-7,81991:-125,81991:-127,81991:-45,81991:-123,81991:-122,81991:-120,81991:-42,81991:-118,81991:-39,81991:-121,81991:-139,81991:-124,81991:-128,81991:-43,81991:-36,81991:-131,81991:-132,81995:-7,81995:-125,81995:-127,81995:-45,81995:-123,81995:-122,81995:-120,81995:-42,81995:-118,81995:-39,81995:-121,81995:-139,81995:-124,81995:-128,81995:-43,81995:-36,81995:-131,81995:-132,81997:-7,81997:-125,81997:-127,81997:-45,81997:-123,81997:-122,81997:-120,81997:-42,81997:-118,81997:-39,81997:-121,81997:-139,81997:-124,81997:-128,81997:-43,81997:-36,81997:-131,81997:-132
Importable 83-84 Mists of Pandaria Other List (Cloaks, Jewelry, etc.):
82074:-7,82074:-125,82074:-127,82074:-45,82074:-123,82074:-122,82074:-120,82074:-42,82074:-118,82074:-39,82074:-121,82074:-139,82074:-124,82074:-128,82074:-43,82074:-36,82074:-131,82074:-132,82004:-7,82004:-125,82004:-127,82004:-45,82004:-123,82004:-122,82004:-120,82004:-42,82004:-118,82004:-39,82004:-121,82004:-139,82004:-124,82004:-128,82004:-43,82004:-36,82004:-131,82004:-132,82060:-18,82060:-7,82060:-125,82060:-127,82060:-45,82060:-123,82060:-122,82060:-120,82060:-42,82060:-118,82060:-138,82060:-130,82060:-114,82060:-134,82060:-39,82060:-121,82060:-91,82060:-139,82060:-5,82060:-124,82060:-128,82060:-43,82060:-36,82060:-133,82060:-131,82060:-132,82060:-129,82060:-135,82060:-137,82060:-136,82063:-18,82063:-7,82063:-125,82063:-127,82063:-45,82063:-123,82063:-122,82063:-120,82063:-42,82063:-118,82063:-138,82063:-130,82063:-114,82063:-134,82063:-39,82063:-121,82063:-91,82063:-139,82063:-5,82063:-124,82063:-128,82063:-43,82063:-36,82063:-133,82063:-131,82063:-132,82063:-129,82063:-135,82063:-137,82063:-136,82005:-18,82005:-7,82005:-125,82005:-127,82005:-45,82005:-123,82005:-122,82005:-120,82005:-42,82005:-118,82005:-138,82005:-130,82005:-114,82005:-134,82005:-39,82005:-121,82005:-91,82005:-139,82005:-5,82005:-124,82005:-128,82005:-43,82005:-36,82005:-133,82005:-131,82005:-132,82005:-129,82005:-135,82005:-137,82005:-136,82007:-18,82007:-7,82007:-125,82007:-127,82007:-45,82007:-123,82007:-122,82007:-120,82007:-42,82007:-118,82007:-138,82007:-130,82007:-114,82007:-134,82007:-39,82007:-121,82007:-91,82007:-139,82007:-5,82007:-124,82007:-128,82007:-43,82007:-36,82007:-133,82007:-131,82007:-132,82007:-129,82007:-135,82007:-137,82007:-136,82061:-18,82061:-7,82061:-125,82061:-127,82061:-45,82061:-123,82061:-122,82061:-120,82061:-42,82061:-118,82061:-138,82061:-130,82061:-114,82061:-134,82061:-39,82061:-121,82061:-91,82061:-139,82061:-5,82061:-124,82061:-128,82061:-43,82061:-36,82061:-133,82061:-131,82061:-132,82061:-129,82061:-135,82061:-137,82061:-136,82062:-18,82062:-7,82062:-125,82062:-127,82062:-45,82062:-123,82062:-122,82062:-120,82062:-42,82062:-118,82062:-138,82062:-130,82062:-114,82062:-134,82062:-39,82062:-121,82062:-91,82062:-139,82062:-5,82062:-124,82062:-128,82062:-43,82062:-36,82062:-133,82062:-131,82062:-132,82062:-129,82062:-135,82062:-137,82062:-136,82010:-18,82010:-7,82010:-125,82010:-127,82010:-45,82010:-123,82010:-122,82010:-120,82010:-42,82010:-118,82010:-138,82010:-130,82010:-114,82010:-134,82010:-39,82010:-121,82010:-91,82010:-139,82010:-5,82010:-124,82010:-128,82010:-43,82010:-36,82010:-133,82010:-131,82010:-132,82010:-129,82010:-135,82010:-137,82010:-136,82017:-18,82017:-7,82017:-125,82017:-127,82017:-45,82017:-123,82017:-122,82017:-120,82017:-42,82017:-118,82017:-138,82017:-130,82017:-114,82017:-134,82017:-39,82017:-121,82017:-91,82017:-139,82017:-5,82017:-124,82017:-128,82017:-43,82017:-36,82017:-133,82017:-131,82017:-132,82017:-129,82017:-135,82017:-137,82017:-136
Conclusion
I hope that you find these importable lists for 83-84 Mists of Pandaria armor items useful.
I've found the 83-84 Mists of Pandaria item market to be a very profitable and reliable market. These lists make running the market even easier because we now can use one set of pre-defined groups and simply add a Shopping and Auctioning Operation to them.
This eliminates the need to use things like Auctioneer saved searches. It also saves us the time of having to categorize items one-by-one as they are purchased.
I also hope that by reading this you've been able to see the power of pre-building TSM importable lists that include all the suffixes you want.
While it's a fairly complex process (and I didn't go into all the nitty-gritty details of all the spreadsheet-fu that went into compiling the lists from two disparate sources) I think those of you out there who are able to grasp the concept can use it in the future in your own way.
Most of all these lists have made me much more efficient in running my 83-84 Mists of Pandaria markets. Efficiency is never a bad thing.
Additional Reading:
- A Guide To SLAGIT - The TSM Shopping List & Auctioning Group Import Tool (Now known as Grouper.)
- The Big List Of 77-79 & 83-84 Item Flipping Information
- MoP "Uber" Blue TradeSkillMaster Dealfinding Lists
- Do Suffixes Matter When Selling Flipping Items?
- Level 83-84 MoP Armor Sales Data And Analysis
Like this post? Get even more Power Word: Gold - Purchase our 75-Page Mists of Pandaria Gold Guide, subscribe via RSS, subscribe to the Podcast via iTunes or RSS, watch our Livestreams, follow us on Twitter, Circle us on Google+, Like us on Facebook and subscribe via Youtube.
Subscribe to:
Post Comments
(
Atom
)
Search powered by DuckDuckGo
Featured Post
A Guide to Farming Instances For Mogging Items
Today's guest post was written by Ohnekase from the gold-making blog Meet Ohnekase . You can also follow them on twitter at @WowOhn...
Popular Posts
-
Today's guest post was written by Ohnekase from the gold-making blog Meet Ohnekase . You can also follow them on twitter at @WowOhn...
-
(Today's guest post was written by Animadnb. If you would like your gold-making guest post featured on Power Word: Gold please submit...
-
With the recent news that Activision Blizzard is buying back a controlling interest from Vivendi it was also made known that the curr...
-
I decided to have some fun with the exported data you can get from the Resources > Data Export page on WoWuction ( example page ). ...
-
We've created a tool for creating importable TradeSkillMaster (TSM) groups from almost any webpage that includes links to World of...
Gold-Making Blog Roll
-
-
Computer Trouble - I shut my computer down around 10 AM on Wednesday, like I always do when I don’t plan on using it for several hours. Spent some time at my Mom’s house wi...
-
Diablo 3: Season 6 ending soon - Friday, July 22 D3 season 6 is over. Friday, August 5 season 7 starts. You can read all details on battle.net
-
Legion pre-patch Q&A - First things first: - Remember to update your addons - Remember to check the "Load out-of-date addons" checkbox in your character screen *How...
-
2015 in absentia - I almost can't believe this is my first post in more than a year. I post glyphs just recently, and it was the first time in three months. So I thought I'...
-
Mechanisms of Action - It's been... a couple months - I think? Since I last really played WoW. Sure, I've logged in, but - I just screwed around in my Garrison and then stared ...
-
Így indul 2015 - Kedves Book of Gold vásárlók/érdeklődők! A 2015. január 1-től életbe lépő rengeteg törvénymódosítás között szerepelt egy ÁFA-törvény módosítás is. Eszerin...
-
Hearthstone - Hook, Line and Sinker - So I’m a fan of Blizzard games. World of Warcraft has been my primary method of distracting myself from pain since the Wrath of the Lich King (WotLK) expa...
-
Old school potions are insane - Hey peeps! Quick update here. If you have an alchemist laying around with Potion of treasure finding (Cataclysm recipe) and potion of luck (MOP recipe) t...
-
Name the Podcast: Vote - The finalists have been chosen! Now is the time to vote!! The poll will close right before we record Episode 4! You'll be able to vote 3 separate times 1. ...
Blog Archive
-
2016
(5)
- Aug 14 - Aug 21 (1)
- Aug 7 - Aug 14 (2)
- Jul 31 - Aug 7 (1)
- Feb 7 - Feb 14 (1)
-
2015
(13)
- Nov 29 - Dec 6 (1)
- Nov 22 - Nov 29 (1)
- Jun 28 - Jul 5 (1)
- Jun 21 - Jun 28 (1)
- Jun 14 - Jun 21 (1)
- Jun 7 - Jun 14 (2)
- May 31 - Jun 7 (1)
- May 24 - May 31 (1)
- Apr 19 - Apr 26 (1)
- Apr 5 - Apr 12 (2)
- Jan 4 - Jan 11 (1)
-
2014
(91)
- Dec 28 - Jan 4 (2)
- Dec 21 - Dec 28 (4)
- Dec 14 - Dec 21 (4)
- Dec 7 - Dec 14 (3)
- Nov 30 - Dec 7 (4)
- Nov 23 - Nov 30 (5)
- Nov 16 - Nov 23 (7)
- Nov 9 - Nov 16 (1)
- Oct 26 - Nov 2 (2)
- Oct 19 - Oct 26 (1)
- Aug 10 - Aug 17 (2)
- Jul 27 - Aug 3 (1)
- Jul 20 - Jul 27 (2)
- Jul 13 - Jul 20 (3)
- Jul 6 - Jul 13 (1)
- Jun 29 - Jul 6 (3)
- Apr 6 - Apr 13 (2)
- Mar 30 - Apr 6 (4)
- Mar 23 - Mar 30 (4)
- Mar 16 - Mar 23 (3)
- Mar 9 - Mar 16 (4)
- Mar 2 - Mar 9 (5)
- Feb 23 - Mar 2 (4)
- Feb 16 - Feb 23 (2)
- Feb 9 - Feb 16 (5)
- Feb 2 - Feb 9 (4)
- Jan 26 - Feb 2 (3)
- Jan 19 - Jan 26 (3)
- Jan 12 - Jan 19 (2)
- Jan 5 - Jan 12 (1)
-
2013
(227)
- Dec 29 - Jan 5 (2)
- Dec 22 - Dec 29 (2)
- Dec 15 - Dec 22 (3)
- Dec 8 - Dec 15 (2)
- Dec 1 - Dec 8 (3)
- Nov 24 - Dec 1 (3)
- Nov 17 - Nov 24 (4)
- Nov 10 - Nov 17 (3)
- Nov 3 - Nov 10 (1)
- Oct 27 - Nov 3 (3)
- Oct 20 - Oct 27 (4)
- Oct 13 - Oct 20 (3)
- Oct 6 - Oct 13 (1)
- Sep 29 - Oct 6 (4)
- Sep 22 - Sep 29 (4)
- Sep 15 - Sep 22 (4)
- Aug 25 - Sep 1 (2)
- Aug 18 - Aug 25 (4)
- Aug 11 - Aug 18 (1)
- Aug 4 - Aug 11 (4)
- Jul 28 - Aug 4 (6)
- Jul 21 - Jul 28 (9)
- Jul 14 - Jul 21 (4)
- Jul 7 - Jul 14 (7)
- Jun 30 - Jul 7 (6)
- Jun 23 - Jun 30 (5)
- Jun 16 - Jun 23 (2)
- Jun 9 - Jun 16 (7)
- Jun 2 - Jun 9 (7)
- May 26 - Jun 2 (4)
- May 19 - May 26 (8)
- May 12 - May 19 (7)
- May 5 - May 12 (3)
- Apr 28 - May 5 (7)
- Apr 21 - Apr 28 (9)
- Apr 14 - Apr 21 (9)
- Apr 7 - Apr 14 (8)
- Mar 31 - Apr 7 (5)
- Mar 24 - Mar 31 (5)
- Mar 17 - Mar 24 (4)
- Mar 10 - Mar 17 (3)
- Mar 3 - Mar 10 (4)
- Feb 24 - Mar 3 (3)
- Feb 17 - Feb 24 (3)
- Feb 10 - Feb 17 (5)
- Feb 3 - Feb 10 (5)
- Jan 27 - Feb 3 (6)
- Jan 20 - Jan 27 (6)
- Jan 13 - Jan 20 (5)
- Jan 6 - Jan 13 (7)
-
2012
(151)
- Dec 30 - Jan 6 (2)
- Dec 23 - Dec 30 (1)
- Dec 16 - Dec 23 (4)
- Dec 9 - Dec 16 (8)
- Dec 2 - Dec 9 (5)
- Nov 4 - Nov 11 (1)
- Oct 28 - Nov 4 (2)
- Oct 21 - Oct 28 (3)
- Oct 14 - Oct 21 (3)
- Oct 7 - Oct 14 (3)
- Sep 30 - Oct 7 (1)
- Sep 23 - Sep 30 (4)
- Sep 16 - Sep 23 (6)
- Sep 9 - Sep 16 (3)
- Aug 26 - Sep 2 (3)
- Aug 19 - Aug 26 (3)
- Aug 12 - Aug 19 (1)
- Aug 5 - Aug 12 (4)
- Jul 29 - Aug 5 (4)
- Jul 22 - Jul 29 (3)
- Jul 15 - Jul 22 (4)
- Jul 8 - Jul 15 (2)
- Jul 1 - Jul 8 (3)
- Jun 24 - Jul 1 (3)
- Jun 17 - Jun 24 (7)
- Jun 10 - Jun 17 (2)
- Jun 3 - Jun 10 (1)
- May 27 - Jun 3 (1)
- May 20 - May 27 (2)
- May 13 - May 20 (3)
- May 6 - May 13 (3)
- Apr 29 - May 6 (4)
- Apr 22 - Apr 29 (3)
- Apr 15 - Apr 22 (2)
- Apr 8 - Apr 15 (3)
- Apr 1 - Apr 8 (4)
- Mar 25 - Apr 1 (3)
- Mar 18 - Mar 25 (5)
- Mar 11 - Mar 18 (2)
- Mar 4 - Mar 11 (1)
- Feb 26 - Mar 4 (3)
- Feb 19 - Feb 26 (2)
- Feb 12 - Feb 19 (5)
- Feb 5 - Feb 12 (7)
- Jan 29 - Feb 5 (3)
- Jan 22 - Jan 29 (2)
- Jan 15 - Jan 22 (2)
- Jan 8 - Jan 15 (4)
- Jan 1 - Jan 8 (1)
-
2011
(159)
- Dec 25 - Jan 1 (2)
- Dec 18 - Dec 25 (3)
- Dec 11 - Dec 18 (3)
- Dec 4 - Dec 11 (2)
- Nov 27 - Dec 4 (4)
- Nov 20 - Nov 27 (2)
- Nov 13 - Nov 20 (2)
- Nov 6 - Nov 13 (2)
- Oct 30 - Nov 6 (2)
- Oct 23 - Oct 30 (1)
- Oct 16 - Oct 23 (1)
- Oct 9 - Oct 16 (3)
- Oct 2 - Oct 9 (2)
- Sep 25 - Oct 2 (3)
- Sep 18 - Sep 25 (4)
- Sep 11 - Sep 18 (2)
- Sep 4 - Sep 11 (3)
- Aug 28 - Sep 4 (4)
- Aug 21 - Aug 28 (4)
- Aug 14 - Aug 21 (1)
- Jul 31 - Aug 7 (1)
- Jul 24 - Jul 31 (3)
- Jul 17 - Jul 24 (3)
- Jul 10 - Jul 17 (4)
- Jul 3 - Jul 10 (3)
- Jun 26 - Jul 3 (3)
- Jun 19 - Jun 26 (5)
- Jun 12 - Jun 19 (2)
- Jun 5 - Jun 12 (3)
- May 22 - May 29 (6)
- May 15 - May 22 (4)
- May 8 - May 15 (3)
- May 1 - May 8 (3)
- Apr 24 - May 1 (4)
- Apr 17 - Apr 24 (5)
- Apr 10 - Apr 17 (4)
- Apr 3 - Apr 10 (8)
- Mar 27 - Apr 3 (5)
- Mar 20 - Mar 27 (7)
- Mar 13 - Mar 20 (6)
- Mar 6 - Mar 13 (5)
- Feb 27 - Mar 6 (4)
- Feb 20 - Feb 27 (5)
- Feb 13 - Feb 20 (7)
- Feb 6 - Feb 13 (6)
Pages
Topics
- 77-80
- 83-84
- Addons
- Alchemy
- Analysis
- Arbitrage
- Auctioneering
- Auctions
- Barking
- Battle Pets
- Beta
- Blacksmithing
- Blog
- Blogging
- Breaking
- Community
- Competition
- Crafting
- Cross-faction
- Diversity
- Enchanting
- Engineering
- Expansions
- Farming
- Fishing
- Flipping
- Garrisons
- Gathering
- Gems
- Gold
- Grinding
- Guest
- Guides
- Herbalism
- HowTo
- Inscription
- Jewelcrafting
- Just-In-Time
- Leatherworking
- Leveling
- Livestream
- Market
- Mining
- Mogging
- MoP
- Mounts
- Pets
- Podcasts
- Potential
- Pricing
- Prospecting
- Shuffling
- Skinning
- Speculation
- Stockpiling
- Tailoring
- Theory
- Tips
- Tools
- TradeSkillMaster
- Trends
- Tricks
- Tutorials
- Vendors
- Video
- Warlords of Draenor
nc ty for that m8 what do u prefer for posting price?
ReplyDeleteA good starting price for most items is 245g.
DeleteThanks for spending the time to put this together, Jim. Must have taken you a long while! I appreciate your work, keep up the awesome.
ReplyDeleteGlad to help.
DeleteThanks so much for doing this! I cringe at the time it took!
ReplyDeleteGlad it helped. Part of the time was figuring out *how* to do it. After that it's just repetitive "hurry up and get this done" work. I wanted to use it as a tool so it was worth the upfront effort to save me time later.
DeleteThanks a lot, I was looking for this method since a long time.
ReplyDeleteAlso thank you for posting the 83-84 list, I'll save a lot of time !
P.S. English isn't my native langage
Glad it helped you out!
DeleteI still don't understand why people would want to buy these items?
ReplyDeleteMainly because they are the most powerful items you can wear at 83-84. People may use them while finishing up leveling in Cataclysm or doing PVP Battlegrounds to level up.
DeleteHi, thanks for the lists. I was unable to import the Mail list, it only added 7 items, whereas all the others added 180-250. Thoughts?
ReplyDeleteI'm not sure. I'll look it over when I get a chance.
DeleteI tried fixing the formatting. Give it a try now.
Delete