Good morning all
So yesterday I sat down and did a fair bit of "grunt" work in relation to my strategy for gold making. I investigated and investigated, tinkered and tinkered and feel I'm getting some noticeable returns. I increased my efficeny, diversed a little and feel more confident in my gold making ability.
Quickly put together last night was a little spreadsheet that calculates my cost price for Living Steel and Glyphs. Then it dawned on me, that I should really track what Glyphs I'm selling regularly or by high volume, so I can keep them stocked.
Then obviously that spread out to Enchanting, what scrolls do I sell the most, and then gems, what gems am I shifting the most. I've had problems where I've been WAY to reliant on the the price that TSM crafting indicates the item is currently selling for, and if I'm honest I don't trust it anymore, as its incorrect everytime I check the realtime data, in most cases nowhere close.
So I'm wondering how do people track their sales. What do you find the most effective?
I tried obviously a few methods last night
I exported my MySales data to Excel. The process of cleaning the lua file wasn't difficult, only about 5 minutes. Then I organised everything by name. I took out the Glyphs into a new spreadsheet and then formatted the data better. So I had item name / quantity sold / avg price/ total revenue.
I then did this for Scrolls and gems.
It was a bit of a tedious process once it came to moving into my own spreadsheet. Alot of copy and pasting and editing. I'd ideally like to have the information in my own spreadsheet that I can filter, graph and all that jazz.
Viewing through the UI. SO I have obviously TSM_Accounting and MySales. Both contain accurate data on my sales recorded via the mailbox which is good. It has the ideal format really, its there, its done, its quick and easy. I can't remember which one it was, but one even bulked items that have sold multiple times showing amount sold, total revenue and avg price. This is ideal information. I could just read the UI, but I'd prefer to export to a spreadsheet I can hold onto.
So I'm wondering how do people track their sales. What do you find the most effective? I want to be more vigilant of what I'm selling and what sells well, instead of seeing TSM_Crafting telling me a glyph sells for 200g only to craft and post it and see it sells for like 7 g
And this excercise last night showed me some scrolls I've been selling a few of, and I was able to make alot more then normal and shift them all in the same night.