Part 14: Custom material pricing

While all this automation helps our business tremendously in day-to-day operations, sometimes you need to intervene at the ground floor. I’m talking about overriding the default price formula.

We have previously spent quite a bit of time making custom price sources and knitting formulas together to make sensible prices on most items. Some items, however – are tricky – like Spirit of Harmony.

It’s soulbound, so there’s no AH price available (dbmarket, dbminbuyout, avgbuy, avgsell)
It’s not crafted in any way, so it doesn’t have a crafting cost. It straight up sucks. But you do want to assign a value to it, since it’s used in many crafts.

Other items you may have a personal arrangement (i.e. personal ore farmers) of getting at a set price, so you want to set that price in stone- that is fine as well.

You shuffle extensively, and want to use the shuffle-formula we talked about earlier for those items.

There are many reasons for wanting to change an items material pricing method, and the good news is that for all reasons – there is the same solution!


The yellow pages of TSM

The rightmost icon on your TSM is called ‘Crafting‘. Inside you are presented with 2 tabs, Crafts and Materials. Click ‘Materials’. A nice tip is to sort this list by Number Owned – like above.

This is the yellow pages of TSM. All materials used in crafts are listed here. You may notice this window lag a bit, because it displays insane amounts of data. This can be remedied somewhat by filtering by profession up top. ALL these items get their Mat Price by default by the formula we set earlier – in crafting operations options. For some items though, we want a different formula.

Default Material Cost Method <- The fallback formula for all items (defined by me)

Let’s say I want the price of Ghost Iron Bars to reflect the lowest price of either 2x Ghost Iron Ore, or the average buying price, how would I go about that?


New shiny formula to serve new purpose – only reflecting the price of 2x ore.

I simply locate Ghost Iron Bar in the list, left click it to get this window – and replace the default formula with
min(2*matprice([Ghost Iron Ore]),avgbuy)
This is a pretty weak example, since listing the materials for the craft is the same as just typing “Crafting”, but if you have no smelter who can smelt ghost iron, you could do it like this.

We made a long formula for shuffle materials earlier;

  • shuffle: ((dbmarket/((dbmarket(item:76131)+dbmarket(item:76138)+dbmarket(item:76142)+dbmarket(item:76141)+dbmarket(item:76139)+dbmarket(item:76140)+(27*dbmarket(item:74249))+(2*dbmarket(item:74250)))))*(avgbuy(item:72092)*120))

This is the place to insert this formula if you want to use it. It should be in all the 6 rare MOP-gems, mysterious essence, and spirit dust – as shown in the picture.


Pegging the price of spirit dust to the ecosystem of the Ghost Iron Ore shuffle

You may notice the price-string is shufflemarket, not shuffle – which is another one i made that is essentially
shufflemarket: first(shuffle, mymarket)
This is just to avoid errors if one gem gets no AuctionDB-data for some reason, pulling some backup prices from buying and selling data.

One last example I want to do, and it’s the Sha Crystal. It can be crafted, but only once a day. BUT, since there is no other way to craft it – that will count as the crafting cost. This could end up with you selling epic enchants really cheap. We need to remove ‘Crafting’ from the price settings of Sha Crystals – infact, I want to remove most of the formula, keeping the focus on the price i keep paying for them on the AH.


Focused on the buying price. Vendorbuy is there for completeness.

I include vendorbuy just for coding discipline – if a vendor starts selling sha crystals for 20g tomorrow, your prices will instantly reflect that – even though it’s not going to happen.


6 responses to “Part 14: Custom material pricing

  1. David Rice

    08/01/2014 at 21:19

    The custom price for Ghost Iron ore formula above does not work for me “min(2*matprice([Ghost Iron Ore]),avgbuy)” I believe you have to use the item # in place of the name, unless you created a custom price call “Ghost Iron Ore” that your referencing back too.

    min(2*matprice(item:720920), avgbuy)

    I also tried

    min(2*avgbuy(item:720920), avgbuy)

    This still returned no value for ghost iron bar, there is a matcost listed for ghost iron ore in tooltips view so I am not sure why this isn’t working.

    The formula from my default first(min(vendorbuy,avgbuy,crafting),avgsell,dbmarket,dbminbuyout) returns a value so I assume its not an issue with the addon.

    • thelunchmoney

      08/01/2014 at 21:22

      If you shift-link Ghost Iron ore it works, and also an itemid does not have 6 numbers, but 5 – so I think you got the wrong one.

      Ghost Iron ore is 72092, don’t know where your last 0 comes from.

  2. shadowfirefly

    02/04/2015 at 05:14

    Terrific guide man, the best TSM informations I could find.

    It would be great to know what custom price formulas are you using in for WoD for cd mats like taladite crystals. Right now I’m using

    ((5 * dbmarket(item:109118) + (5 * dbmarket(item:109119)))

    but that’s too simple,what would you change it to? Thank you very much!

    p.s. I’m using your custom prices and your formulas for Default Material Cost Method and Default craft value method, they work great!

  3. Tox

    19/12/2016 at 14:48

    I know I’m late to the party and we’re now using TS3 but this is an awesome guide and makes me eager to get my business up and running. Thank you for putting all the time and effort in to writing this.

  4. simeonpashley

    16/05/2017 at 19:35

    +1 This is still a great guide in 2017

  5. Elethelectric Penguin

    10/06/2017 at 08:11

    Your guide helped me immensely.

    I knew what I wanted to do – I knew the formula’s I wanted to use, the item’s I wanted to make and the path to success gold-wise I had in front of me was mostly fool proof – except for one thing…I struggled with TSM’s configuration interface. – I could see that I needed to put things into groups and setup operations but I always ended up with more or less a group and an operation per item – which was loads more leg work than seemed necessary. I knew there was a simpler way, and working through your guide from start-to finish taught me everything I needed to know in one afternoon.

    Thank you for taking the time to write this guide.

    May your goblin ways lead you to great wealth.

    Zug Zug.


Reply to this nonsense

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: