How to Use TSM's BankUI | Warehouse, Mail & Auction Operations | Shadowlands | WoW Gold Making Guide

[@alyswhisperwind3784]

So I came across your channel while looking for a reason while my mats were not stacking properly when I was using warehouse operation for some reason(still have that issue I am looking for help on the TSM discord), but seeing your guides and the fact that you offered free groups and profile to the community is awesome, makes me want to learn TSM. Your guides are easy and very visual and its awesome. Thank for you putting together comprehensive videos with a very clean TSM profile setup, it makes TSM way more accessible to people like me who came back to the game after 14 years of break and try to push into making a decent amount of gold to self sustain themselves but not necessarily have IRL time to spend hours on end to setup TSM and other query to fetch data. Truly awesome work.(I post comment on this video because its the first one I watch but im bout to binge the rest)

[@sametderin7973]

I searched for it on the internet but couldn't find it, or rather I didn't even know how to search for it... I came across your video and learned it, thank you a lot!

[@Penguinr2gt]

Glad it was helpful!!!

[@rickl9462]

Wow your TSM guides are amazing! I'd almost think you were the one who created this mod with how well you explain all it's functions. Thanks for all the great video tutorials!

[@Penguinr2gt]

Glad they are helpful!

[@Lebus78]

Thanks very much. I knew most of this from all of your previous videos and using groups etc. But what I had never seen was tying "/tsm bankui" to open it before and it was all I needed.

[@atoering]

This was fantastic! I never knew the bank function existed & it would've saved so much time.

[@jaimenegron406]

Omg I joined the discord yesterday but Im now going back to watch all of the tutorials. Crafters mark crafting… here I come!

[@Penguinr2gt]

You got this!

[@fleau7041]

So we can't say "Take in the bank the item i dont have on auction house" it only work with bags right, not AH? ^^

[@MrBerecibare]

Thank, This was fantastic!

[@umut1211]

wow so fast ! thanks, keep up the great work :)

[@mrmoffett7034]

Great video keep it up cant wait for part two!!

[@erdoganborklu]

I'll name my second daughter as Penguin :) You're the best !

[@TheDOC1988]

This was very helpful, thanks for the video

[@JesusFreakJH]

thx - great pace

[@jimdelsol1941]

Thank you very much !

[@Mactastico1]

Hello, is it possible to use shortfall to add unique items to my bags? Say I only want to have 1 of each possible transmogs in either my bag och currently posted on the AH? Can seem to get it to work... If my post cap is one will TSM take in consideration the items I already have posted?

[@casstabra]

thank you for this

[@istvanbiro8474]

Great video. Maybe you can make another one about auctioning the items?

[@andrewhenshaw4067]

I recently started using tsm and ran into problem when I'm posting items(in this case gear) It only says "undercutting competition" on some items. It says "posting for normal price" even when the item already is on the AH. I would like it to always undercut if the item already is on the AH sence the "posting for normal price" is usually much higher and with tmog gear it wouldn't sell if I dont undercut I have a temporary workaround buy putting "normal price" at 100% db minbuyout but I don't know if that always works out Is there a way to post so it always undercuts if the item is already available? And why does it undercut sometimes and "posts at normal price" other times? Would be SO thankfull for an answer😀

[@Penguinr2gt]

If it’s gear you are having issues with, it’s due to the way you group them. If it’s tmog you need to group them with “Base Item” when adding them to the group, if it’s Crafters Marks gear, you need to add them with “Item Level”…. If they are already grouped you will have to either remove all of them or just delete the group and remake it

[@andrewhenshaw4067]

@@Penguinr2gt I will try that Thank you!

[@UberFile]

Hey Penguin, I don't know where else to suggest this but I wrote a whole speech earlier about how I recommend Loonie Tunes application after JustAHoax user, but It got deleted probably because I linked his github page and some examples of my usages of the program in your spreadsheets, but if you google his GitHub "justahoax loonie-tunes GitHub" then you can find the application I'm about to talk about below The application basically just creates a CSV file from everything from your TSM auction house, You can use that CSV file to your advantage by putting it in your spreadsheets to automate putting in prices, for example, the vendor shuffle sheet you created. I would provide an example since I've modified your sheet to be automatic, If I could somehow contact you and show you what I mean if you don't understand what I mean, that would be no problem. The reason why I'm also suggesting it is that I had a difficult time "upgrading" your spreadsheet to be automatic, maybe you'd be interested in "upgrading" your future/current sheets to be automatic with his software. It saves a bunch of time not having to manually put prices of different mats into the spreadsheet and having it be automatic (semi-automatic though, you still have to run his CSV program to get the latest up-to-date prices every time). And Here I ended up writing another speech about using his software but feel free to ask me questions on how I implemented it in your sheets if needed. Also, thanks for the content you provide, it's been awesome since I started playing again in Shadowlands.

[@Therealzipy]

Could u help me do this?

[@Therealzipy]

Please help me automate the spreedsheets thanks. I've downloaded and setup the application but dont know how to make use it in spreadsheets.

[@UberFile]

@@Therealzipy Sure, Start by opening the spreadsheet you choose to automate in Excel, after doing that, create a new page called PricesAH, on the new page, head over to Data -> New Query -> From File -> From CSV. Then you head to Connections and make sure it fetches the new information each time you open the excel spreadsheet. I recommend creating 2 new columns in PricesAH named MinBuyoutGold and MarketValueGold to make them easily compatible with the spreadsheets, you just take the MinBuyOut and divide it by 10000, then you get the right amount of gold for the spreadsheets so like 101000 MarketValue = 10.1G, After you do this, head to the spreadsheet you wish to automate, replace for example Shrouded Cloth with the corresponding item string using VLOOKUP, here is an example for the Shrouded Cloth =VLOOKUP(A5, PricesAH!$A3:$H19416, 8, FALSE). Then you just have to modify the formulas to include the VLOOKUP results and voila, you've got an automated spreadsheet, best of luck! It takes a while to modify all of your wanted spreadsheets but once you've done it, it's set and forget.

[@Therealzipy]

@@UberFile oh thats a lot. Mind helping me on discord instead? Sry lol, a bit hard to understand. Discord is T4K Zipy#3916

[@Therealzipy]

@@UberFile im also on penguins discord if u wanna search for me there

[@Nasilje.u.Daskvudu]

no spreadsheets =\

[@tankl.jackson3481]

/tsm bankui

[@rushed3897]

early gang here

[@NIKVSEM]

Too much of extra info in form of pure text. Really hard to follow. But good overall. Well. 70-80%