Touhou Mystia's Izakaya

Touhou Mystia's Izakaya

40 ratings
"Perfect" Menu for every Izakaya
By Lauchkun
I always wanted to do this for myself, because I am wierd. And then I thought I can share this with you guys. And it's easier while playing on SteamDeck to just open up my guide. So if you found it helpfull, I would be happy for some feedback.

I used Excel and Access for this. If you are interested, you can download at the bottom of this guide.

Update1: Just added Hakurei Shrine and Bamboo Forest. Thanks for pointing it out (google doc not updated tho. Too lazy.). Hopefully the last Update is when I add DLC 5 Dishes and making everything pretty.

Update2: all DLC are here, and an extra section for Menus without dlc, still no doc tho. And still ugly. Thinking about doing one for Rare guest ¯\_(ツ)_/¯
2
3
3
   
Award
Favorite
Favorited
Unfavorite
Disclaimer/ things I want to tell you.
Things I want to tell you what I learned while creating the database or from the game itself:

  • You do NOT NEED TO add extra ingredients so you can reach a pink rating for normal guests. It either got changed some time ago or somebody or somthing got misunderstood and everyone then thought we need to add extra stuff. Thats why I wanted to make this guide in the first place, because I realize while playing, I never add stuff and still get pink rating sometimes.
  • While "Goblin" is in the list Customer, has no specific location, he will never be taking into account.
  • Same thing with "Jiangshi" but in reverse. Since she has every tag, she didn't get any tags assigned in the list, or else it would artificially boost every dish and beverage in the list and it would get mentioned more often then it had to be.
  • "Dark Matter" is there for fun.
  • Dishes and Beverages do have some extra attributes assigned like there price or DLC they come from. While I didn't use them here, if you know how to use Access and Pivot Table in Excel, you can also filter them by DLC you have or unlocked them in the first place. Or order them by Price.
  • Also same with the attribute "Kitchenware", but just pay attantion at selecting them for your loadout.

Ahh yeah. And SPOILER for everything that I will mention from now on.

That should be all for now. I hope. Will add stuff later if I remember stuff.
Things to know before you get started
I wanna tell you some tips for selecting your stuff and explain some other stuff:

  • Now that I have all DLC dishes available, I am going to make a second section with Menus without DLCs. For players who only have the base game
  • When I say "Stuff" from now on, it will mean "Dishe and Beverage". Because I am lazy at writing it. But I will specifically mention them if needed.
  • In the list, I will put in for every Izakaya, it will show different "Stuff", according to how many Tags they cover in that specific Izakaya. And the higher the number, the more it covers.
  • While you could just select the top eight "Stuff" in every list and call it a day, you have to know that sometimes, not every tag will be covered by the top eight, this goes particularly for "Beverages" with the tag "No Alcohol". Didn't playtest it. So you have to test it yourself. You will know it when they order Green Tea. And same goes for Dishes that are above average Expensive, since they usually have more tags
  • Tip when you already unlocked Yuuma Toutetsu: always add the most expensive "Stuff" you can afford to offer in your menu. Since her spellcard will just make everyone order just that. So good way of making good cash.
  • I printed the list into .pdf and then converted into .jpg. I will only show the first page that shows all the Beverage and the Dishes that fits into the first page. The pages are ugly enough. (Imagine having black paper)

  • Usually, you just go through the list from top to bottom and skip the "Stuff" you didn't unlocked yet or just don't put into your menu for any reason.

Should be all for now. I think.
List of Menus (no DLC)
Didn't playtest it, but on paper it should work and give you most of the time a pink rating, if not, try to replace it with something different also.

And sinc this is the "no DLC" section, getting a pink rating is going to be harder so yeah, keep that in mind.

Also, "Stuff" with the same number have to same amount of tags covered, so you have the choice of which one you want. Or just take all of them.

Also also, I am to lazy to make the table manually here on steam, and dont want to enter every single thing.

I will show the Menu without DLC first

Youkai Trail

Human Village

Hakurei Shrine

Scarlet Devil Mansion

Bamboo Forest of the Lost

Youkai Mountain

Forest of Magic

Former Hell

palace of the Earth Spirit

Myouren Temple

Divine Spirit Mausoleum

Shining Needle Castle

Garden of the Sun

Makai

Lunar Capital


Youkai Trail (All DLC)
Human Village (All DLC)
Hakurei Shrine (All DLC)
Scarlet Devil Mansion (All DLC)
Bamboo Forest of the Lost (All DLC)
Youkai Mountain (All DLC)
Forest of Magic (All DLC)
Former Hell (All DLC)
Palace of the Earth Spirit (All DLC)
Myouren Temple (All DLC)
Divine Spirit Mausoleum (All DLC)
Shining Needle Castle (All DLC)
Garden of the Sun (All DLC)
Makai (All DLC)
Lunar Capital (All DLC)
Explaining how I did it/ When you want to do it yourself
You can just ignore from here on. But if you are interested and want to use it yourself. Sure.

DISCLAIMER: You can't share a link for Access. So tutorial is actually useless now. Or you just make your own database. Just don't want to delete this now because of my wasted time I invested here.

First I made a database with all the stuff I need:

Starting by entering all the informations we have/ want/ need.

The customers,

the "Stuff"

and the other "Stuff"

As already mentioned, we don't need everything. But it's nice to have those if you want to do some more filtering and order it by somthing like the price.

Then you need to make your relationships that looks like this:

(Never though that I have to do this again outside of school)

The important stuff should be at the bottom. There you get your filtering.

  • Customer Name: Don't realy need it. You can search for a specific customer by entering there Name into the "Criteria" cell
  • Targeted Location: Put in the Location you want to have.
  • Beverage: If you want the table with the beverage, check its boxes (in the screenshot, the unchecked one).
  • Dishes: Same as the Beverage
  • Just remember that you either check the box from the dishes, or the beverage. Not both at the same time, or it won't work.
  • The criteria in "Tag.Value" compares the tags from the dishes with the preferred one of the customer. For every matching tag, it will get mentioned once. Same with the beverage.
  • If you want to filter it my somthing of your choice, click onto the attribute you wish to filter by (ex. DLC in dishes.) Then put in the criteria you want. Like "2" for only giving out dishes from DLC 2.

You will get a table where everything will get listed.
Here you can see "Unzan Cotton Candy" getting mentioned twice because of the tag "Fruity" and "Sweet". And this goes on for everything else

Then you just copy everything and put it into Excel to make a Pivot Table, while counting the amount dishes that got mentioned multiple time.
Links to download
Can't share the Access one for some reason, so you only get the Excel one

Excel:
https://1drv.ms/x/c/05c097a3357b50ce/ES3meVutb7tLkkQCjt0NnA8Bm5kcZOrw8peAhsoz3zDmow?e=vMxcSC
Thanks for reading until here. Please overlook any spelling mistakes. Thanks

13 Comments
elna 19 Jul @ 4:06pm 
you. are. amazing. thank you SO much! :Refrain_Heart:
Lauchkun  [author] 19 Jul @ 7:55am 
Updated link for the excel sheet. Steam need a while to aprrove the change. Check it again when it is done.
elna 19 Jul @ 12:27am 
first of all, thank you so much for creating this guide!! it's really helpful. second, i want to use the excel sheet, but it seems the shrine & bamboo forest aren't on there either. i was wondering if you had an updated excel sheet? if not, that's ok, i can keep using the images here. i just found the excel slightly easier to look at. :MHRISE_Felyne:
NeuroSkall 5 Apr @ 3:50am 
Getting a pink rating on a regular guest is most likely due to the effect of the 'Lucky Peach' item Tenshi gives you when you reach max bond with her (it gives a 15% chance for a guest to give a perfect rating regardless of satisfaction), since the wiki says orange is the highest rating you can get from regular guests
That aside, I think the confusion comes from someone in the story saying you should add extra ingredients to your dishes because no one likes dishes made by the book. Something along those line, at least, I can't remember who said it or when because it's been a while since I've gone through the story
SeaDust57634585 30 Sep, 2024 @ 10:28pm 
Thanks! It really bothers me to have an empty space in my notebook, so i guess i need to try grinding out alice's reward card for that goblin
Lauchkun  [author] 22 Sep, 2024 @ 3:30pm 
And added Hakurei Shrine and Bamboo Forest. Tahnks again for pointing it out
Lauchkun  [author] 22 Sep, 2024 @ 2:48pm 
Alice's spellcard can spawn them. They are just there existing I guess.
SeaDust57634585 21 Sep, 2024 @ 7:59pm 
Where does the goblin guest spawn?? Is it in an event or something?
KikiMofo 1 Sep, 2024 @ 2:14pm 
Awesome. But yeah no biggie. Just nice to have it all laid out like that for presets.
Lauchkun  [author] 1 Sep, 2024 @ 11:49am 
Thanks for pointing out. No, I just forgot it. Will fix it as soon as possible. Have to relearn excel and access now xD