Custom Prices & Pastebin Links

1st Section: CUSTOM PRICES FOR PROFILE Sheymin, Sheynorm, Sheymax (REQUIRED)
2nd Section: Custom prices for Blood of Sargeras and Primal Sargerite (Optional)
3rd Section: Links to all 3 pastebins:


1st Section:

TSM4 users will no longer have to make sheymin, sheynorm, sheymax when they are importing my groups. Any custom prices referred to in the imports will just come with the imports now. Anyone still using TSM3 will have to make these 3 custom prices below: (Edit:This is technically not implemented yet in the TSM4 beta but it will be implemented eventually, so for now you still have to make sheymin, sheynorm and sheymax)

Step 1:

In the box Custom Price Source Name" type exactly this with no quotations, all lower case, "sheymin" and hit enter.
Then in the box "Custom Price for this Source" type in exactly this"


max(first (105% Max(Crafting, AvgBuy)/0.95, 70% first(min(DBMarket, 150% DBRegionMarketAvg), DBRegionHistorical, DBGlobalMarketAvg, DBGlobalHistorical)), 110% VendorSell/0.95)

Step 2:

In the box Custom Price Source Name" type exactly this with no quotations, all lower case, "sheynorm" and hit enter.
Then in the box "Custom Price for this Source" type in exactly this"


max(200% Max(Crafting, AvgBuy)/0.95, 150% first(min(DBMarket, 150% DBRegionMarketAvg), DBRegionHistorical, DBGlobalMarketAvg, DBGlobalHistorical), 110% VendorSell/0.95)


Step 3:

In the box Custom Price Source Name" type exactly this with no quotations, all lower case, "sheymax" and hit enter.
Then in the box "Custom Price for this Source" type in exactly this"

max(500% Max(Crafting, AvgBuy)/0.95, 500% first(min(DBMarket, 150% DBRegionMarketAvg), DBRegionHistorical, DBGlobalMarketAvg, DBGlobalHistorical), 110% VendorSell/0.95)



I decided to replace "dbmarket" with "min(DBMarket, 150% DBRegionMarketAvg)" to control/account for those situations where dbmarket continuously inflates to outrageously high values. By replacing with "min(DBMarket, 150% DBRegionMarketAvg)", any time dbmarket climbs higher than 150% dbregionmarketavg, it will just use 150% dbregionmarketavg. This will prevent dbmarket from climbing to ridiculously high values. You can adjust the 150% if you like. I've had lots of people ask me ways to account for this/prevent this from happening. There are many ways to do this but this is an easy solution.




2nd Section:

Primal Sargerite Custom Price:

max(dbmarket(i:151565) * 10, dbmarket(i:151564) * 10, dbmarket(i:151566) * 10, dbmarket(i:151567) * 10, dbmarket(i:151579) / 10, dbmarket(i:151722) / 10, dbmarket(i:151720) / 10, dbmarket(i:151718) / 10, dbmarket(i:151721) / 10, dbmarket(i:151719) / 10)

Blood Of Sargeras Custom Price:

max(dbmarket(i:124118) * 10, dbmarket(i:124119) * 10, dbmarket(i:124120) * 10, dbmarket(i:124121) * 10, dbmarket(i:124107) * 10, dbmarket(i:124108) * 10, dbmarket(i:124109) * 10, dbmarket(i:124110) * 10, dbmarket(i:124111) * 10, dbmarket(i:124112)* 10, dbmarket(i:124101) * 10, dbmarket(i:124102) * 10, dbmarket(i:124103) * 10, dbmarket(i:124104) * 10, dbmarket(i:124105) * 3, dbmarket(i:123918) * 10, dbmarket(i:123919) * 5, dbmarket(i:124113) * 10, dbmarket(i:124115) * 10, dbmarket(i:124438) * 20, dbmarket(i:124121) * 20, dbmarket(i:124437) * 10, dbmarket(i:124440) * 10, dbmarket(i:124441) * 3)




3rd Section:


The main pastebin:  TSM4 only : https://pastebin.com/u/sheyrah
                    Is now for TSM4 users. It has group structure, item ID's, and TSM4 operations
                    All the TSM4 groups are not done yet, currently working on them. Any groups that are TSM4 are clearly defined in
                    the title of the import

The alternate pastebin: TSM3 only:  https://pastebin.com/u/sheyrah_alternative
                        It is for TSM3 users. It has group structure, item ID's, and TSM3 operations
                        This is for TSM3 users. It is a little older and will not be updated. There are only a few small items recently
                        added to the game that are missing. Is it still very functional and very similar to the updated TSM4 main
                        pastebin. It's still more than good enough to use. It is also broken down into smaller pieces so a little bit
                        of extra time is needed for importing

The item ID pastebin:   TSM3 & TSM4: https://pastebin.com/u/sheyrah_ID
                        These is for TSM4 and TSM3 users. It only have group structure and item ID's (No operations)
                        These are the recently updated groups (March 9 2018) that I did while updating my pastebin for TSM4 users.
                        Since it only uses group structure and item ID's, it will work fine for both TSM4 and TSM3 users. This has been
                        tested and it does work for both.


Friendly reminder that you must reload your UI (type /reload) after every single import or the next import won't work. Make sure you have all the official TSM modules installed or it won't work, the most common ones people forget to install or turn on are, AuctionDB (for pricing info) , Accounting (for avgbuy values), and Crafting (if you craft anything to sell). When the option comes up to "Skip", "Replace" or "Cancel", just spam the button "Replace". Be Patient, some of the large groups can take 20-30 sec to import, just wait and don't click anything, or you will crash.