Wow Auctioneer database parser II

Wanna break down your auction house scans? Would you like a spreadsheet to search in for current prices? Wanna research items maybe you should be selling? Well there is a website for you!

Wow Auctioneer database parser II is a website that will take your auction house data and convert it to a CSV file that you can open up in excel. You will need to get the latest version of auctioneer and Auc-db installed to run a scan and have a database file to export. This export allows you to view the latest auction house data from your most recent scan.

I like using this to quickly lookup prices for various items, especially if I'm farming or I'm away from the auction house. You can also use it to quickly compare faction prices on the same realm. Run a scan on horde, export, then jump over to alliance and do the same. Compare the prices and see what items you can faction trade to sell on the other side for higher profit. (This will require two accounts)

Let me know what you think!

Export BeanCounter Data To Excel

After doing some more research I've found someone who has created an excel workbook that uses macros to export your BeanCounter data. This is a little bit more advanced method than I'm used to sharing with my readers but if you're interested in breaking down your BeanCounter data and drilling down in the data then this is for you. I wanted to see if there was something else available since WoW Sales Report is no longer being updated and it does not work with newer auctioneer data.

The Download & Install

You can download the file from curse gaming, BeanCounter Export. You will need Office 2007 and macros must be installed. If you need to enable macros go to File -> Excel Options -> Trust Center -> Trust Center Settings. I have not tested this file in OpenOffice but I'm sure it will work in the newest version.

It doesn't matter where you put the file, your desktop or my docs will be fine. Double click on the file and edit the settings on the first page of the workbook then press ALT + F8 to run the macro. A popup box will ask if you want to run Readfile, click run. A box will pop up and ask you for the path, enter this path name but edit it for your account name c:\program files\World of warcraft\Wtf\Account\"Account Name"\saved variables\beancounter.lua . It will say done, click ok.

Changing Options

You should now be able to look at your auction house transactions based upon the settings you selected. The currency data is a bit messy but we can fix this by selecting columns E through K then right click on any column then click Format Cells. Go to Custom then copy past this, 0"."0000;-0"."00;0"."00. This will change the format to gold so it's easier to read.

By using the top menu buttons you can sort the data any which way you want. This export is great because it allows you to see sales patterns, what items are your hottest sellers, and what classes you might be tailoring too.

How to Use Auctionator

There is a lot of emphasis on using Auctioneer, which is a great addon but it can be intimidating to most players that are new to the auction house game. Auctionator is a lightweight and easy to use addon for the auction house. It allows you to quickly post auctions, buy items, and cancel auctions that you have been undercut on.

I would recommend going to google and do a search for Auctionator, the first result should be for curse gaming, go there and download the latest version. You will need to place it in your World of Warcaft/Interface/Addons folder. You will need to restart wow if you do this install if you still have the game running. Select which characters you will want to use this addon at your character selection screen. Now get to an auction house and open an auction house window with an auctioneer. You should see three new tabs in orange lettering at the bottom of the auction house window, Buy, Sell, & More.

Buying

1. Click on the Buy Tab.

2. Click on the Full Scan Button (Upper Right Hand of AH Window).

3. New Dialog Box Should Open -> Click on Start Scanning -> When it's finished, click Done.

4. One the Buy Tab, search for an item you would like to buy.

5. In the Search Item click on the item you are looking for. It will breakdown prices listed for that item by stack and quantity.

6. Once an item is highlighted, click on the Buy Button (Lower Right Hand of AH Window).

7. Enter in the number of stacks you want to buy -> Click Buy.

If there is 40 stacks of infinite dust and you enter in 40 stacks to buy, Auctionator will instantly buy all 40 stacks for you! You will no longer have to hunt through the list and select each stack 40 times to buy them all. This also allows you to easily see quantities better, for example, when arrows are posted in singles or stacks of 100.

Selling

1. Click on the Sell Tab.

2. Drag an Item to left side of the AH window and insert it into the blank box. Auctionator will list your competition's current prices for that item. Auctionator will automatically enter the price you should post the item for, lower than your competition.

3. If you are satisfied with the price and quantity, click Create Auctions.

Undercuts

1. Click on the More Tab.

2. Click on the button, Check for Undercuts, this will search through your auctions and detect whether or not you have been undercut.

3. If undercuts are found it will ask you to cancel your auctions that have been undercut, click Yes. Auctionator will cancel all auctions immediately.

Settings

Inside of WoW go into your interface settings -> Addons -> Auctionator

There are a few settings we want to look at.

1. Select Show Tooltips (If you want price history on your items)

2. Undercutting -> Enter in the price threshold you want to undercut with

3. Selling -> Setup stack sizes for various item types

I love this addon because it is so easy to use and it really streamlines your auction house processes. Buying and selling are not much easier than this!

Questions for Comments

Do you use Auctionator? Do you prefer using Auctioneer instead? Which addons do you use to for your gold making business?