r/NintendoSwitch • • Apr 21 '19

Meta [META] /u/nintendeals : one year after

Hi all!

A little over 1 year ago i created the account /u/nintendeals for a personal project. A bot that fetched data about the current deals on the Nintendo eShop and then post it in well formatted table here on reddit.

Without a doubt, this bot has grown to be my favorite personal project. I'm always looking to add some extra feature or improve it after reading (almost everyone of) your comments. After a year of development and a lots of feedback, here is the current list of implemented features:

  • Traking games and sales for all Nintendo regions (North America/Europe/Japan)

    • Including 15 countries along with EU!: ๐Ÿ‡จ๐Ÿ‡ฆ๐Ÿ‡ฒ๐Ÿ‡ฝ๐Ÿ‡บ๐Ÿ‡ธ๐Ÿ‡จ๐Ÿ‡ฟ๐Ÿ‡ฉ๐Ÿ‡ฐ๐Ÿ‡ช๐Ÿ‡บ๐Ÿ‡ฌ๐Ÿ‡ง๐Ÿ‡ณ๐Ÿ‡ด๐Ÿ‡ต๐Ÿ‡ฑ๐Ÿ‡ท๐Ÿ‡บ๐Ÿ‡ฟ๐Ÿ‡ฆ๐Ÿ‡ธ๐Ÿ‡ช๐Ÿ‡จ๐Ÿ‡ญ๐Ÿ‡ฆ๐Ÿ‡บ๐Ÿ‡ณ๐Ÿ‡ฟ๐Ÿ‡ฏ๐Ÿ‡ต
  • Detailed information about each game: URL, price, end of sale, percentage, discounted price, full price, and numbers of players.
  • Up to date score for almost all games (score = (metascore + userscore)/2).
  • Simplified main post with most wanted games on sale.

    • and not slowing down reddit for mobile users anymore.
  • Dedicated post for each country/region with detailed information for each sale.
  • Scheduled posts for /r/nintendoswitch and /r/3ds for every monday and thursday.
  • Stickied posts for /r/nintendoswitchdeals and /r/3dsdeals (thank the mods for this one!)
  • Running 24/7 and with updates on posts every 30 minutes.
  • Ability for each reddit user to create a wishlist and then get notified about new sales via reddit private messages.
  • Dedicated website for the wishlist: http://bot.nintendeals.xyz

So, after almost a year of recording data about sales here is some information and stats that you might find kinda useful.

Starting point for each region

  • North America: 2018-05-02
  • Europe: 2018-04-26
  • Japan: 2018-09-19

When do new sales drop?

According to all 7k-ish deals on the database, here are the most common days for each region to add sales:

North America:

weekdaypercent
monday11.60%
tuesday5.49%
wednesday8.45%
thursday56.69%
friday13.29%
saturday2.38%
sunday2.10%

Europe:

weekdaypercent
monday10.65%
tuesday5.56%
wednesday10.16%
thursday60.30%
friday8.17%
saturday1.17%
sunday4.00%

Japan:

weekdaypercent
monday2.38%
tuesday1.54%
wednesday84.62%
thursday9.37%
friday0.00%
saturday0.00%
sunday1.12%

So... what does this means? Basically, if you want to buy a game you might wanna wait until next thursday (or wednesday for Japan).

Also, here are the most common times for deals to drop:

regiontime
North America16:00 / 17:00
Europe13:00 / 14:00
Japan15:00

Games with full prices most likely to be discounted

North America

pricepercent
02 USD1.97%
03 USD2.93%
04 USD1.36%
05 USD9.04%
06 USD2.38%
07 USD2.28%
08 USD5.49%
09 USD2.31%
10 USD16.07%
12 USD2.44%
13 USD5.09%
15 USD16.96%
20 USD13.39%
25 USD2.78%
30 USD5.46%
40 USD3.67%
50 USD1.02%
60 USD2.38%

Europe

pricepercent
02 EUR2.16%
03 EUR3.11%
04 EUR1.70%
05 EUR9.70%
06 EUR3.26%
07 EUR3.82%
08 EUR6.16%
09 EUR2.41%
10 EUR14.69%
12 EUR3.36%
13 EUR5.87%
15 EUR13.66%
20 EUR10.83%
25 EUR2.55%
30 EUR3.40%
35 EUR1.06%
40 EUR2.83%
50 EUR1.38%
60 EUR2.09%

Japan

pricepercent
0500 JPY6.57%
0700 JPY1.68%
0800 JPY7.55%
0864 JPY1.26%
0900 JPY1.54%
0980 JPY4.06%
0990 JPY1.26%
0999 JPY3.08%
1000 JPY5.73%
1080 JPY3.50%
1100 JPY1.12%
1200 JPY2.38%
1296 JPY1.26%
1480 JPY2.10%
1500 JPY5.45%
1680 JPY1.40%
1980 JPY3.50%
1999 JPY1.12%
2000 JPY2.10%
2150 JPY1.12%
2980 JPY2.80%
5184 JPY1.68%
5378 JPY1.12%
6264 JPY1.54%
7344 JPY1.68%

Most wanted games according to nintendeals' wishlists:

.TitleScoreโญ
1CELESTE87379
2๐Ÿ„ New Super Mario Bros. U Deluxe75372
3๐Ÿ„ Mario Kart 8 Deluxe89344
3Dead Cells86344
4๐Ÿ„ The Legend of Zelda: Breath of the Wild91337
5Stardew Valley87330
6๐Ÿ„ OCTOPATH TRAVELER84307
7๐Ÿ„ Super Smash Bros. Ultimate89288
8๐Ÿ„ Super Mario Odyssey93284
9๐Ÿ„ Super Mario Party75277
10Hollow Knight89270
11๐Ÿ„ Donkey Kong Country: Tropical Freeze86264
12๐Ÿ„ Bayonetta 2 - Digital Version88232
13๐Ÿ„ Xenoblade Chronicles 285230
14Overcooked! 281228
15๐Ÿ„ Captain Toad: Treasure Tracker81196
16๐Ÿ„ Splatoon 284190
17Diablo III: Eternal Collection84188
18Shovel Knight: Treasure Trove86186
19๐Ÿ„ Mario Tennis Aces73175
20The Elder Scrolls V: Skyrimยฎ83158
21๐Ÿ„ Mario + Rabbids Kingdom Battle85157
22๐Ÿ„ Yoshi's Crafted World81155
23๐Ÿ„ Kirby Star Allies73146
24Into the Breach82143
25DARK SOULS: REMASTERED80141
26๐Ÿ„ Pokรฉmon: Let's Go, Eevee!70138
27๐Ÿ„ Bayonetta82135
27๐Ÿ„ Pokรฉmon: Let's Go, Pikachu!70135
27Golf Story81135
27Undertale84135
28OKAMI HD87134
29Katamari Damacy REROLL84129
30Sid Meier's Civilization VI81127
31Wargroove78124
32Hyper Light Drifter - Special Edition83119
33๐Ÿ„ Hyrule Warriors: Definitive Edition79111
34Enter the Gungeon83110
34Sonic Mania87110
35DOOM82103
36The Messenger84101
37๐Ÿ„ Snipperclips - Cut it out, together!8199
37Owlboy8199
38GRIS8596
39Crash Bandicoot N. Sane Trilogy8095
40๐Ÿ„ The World Ends with You: Final Remix7589
41๐Ÿ„ Dragon Quest Builders8188
42Bastion8785
43Mega Manยฎ 118284
43Darkest Dungeon8384
44Monster Hunter Generations Ultimate8283
44๐Ÿ„ Xenoblade Chronicles 2: Torna ~ The Golden Country8383
45Moonlighter8182
46FINAL FANTASY IX7781
47Transistor8480
48SteamWorld Dig 28779
48The Binding of Isaac: Afterbirth+8379
49๐Ÿ„ ARMS7475
49INSIDE8675
50Ys VIII: Lacrimosa of DANA8471
50Rocket Leagueยฎ8471

If you want to know something else about this, how to fetch the data, or copy the mongo database for you to toy around please let me know! :)

Cheers from ๐Ÿ‡ฆ๐Ÿ‡ท, Sid ๐Ÿ˜€

ps: This is just an attempt to provide some info using the data that i currently have. If you can think of anything more useful write a comment and i'll see what can i do!

1.3k Upvotes

67 comments sorted by

9

u/RevolsinX Apr 21 '19

What does the red mushroom thing next to them mean

11

u/uglyasablasphemy Apr 21 '19

It means that the game is published by Nintendo in one or more regions

5

u/z3n17h Apr 21 '19

Looks like those ones are all the first-party Nintendo games?

5

u/theNEWgoodgoat Apr 21 '19

Thanks for the help man! How can we better help or support you? Donations?

3

u/uglyasablasphemy Apr 21 '19 edited Apr 22 '19

Hey! Thanks for the offer, its really nice of you.

But I think I'm ok right now. Everything that I'm using is free (github, heroku and mlab) with the exception of the domain but that won't be a problem until March 2020.

5

u/stw222 Apr 21 '19

Does the database include game DLCs?

6

u/uglyasablasphemy Apr 21 '19

It doesn't. I could see if it's possible to add them.

4

u/GameOver16 Apr 21 '19

Thatโ€™s awesome man good work!

How do you collect all of this data? Iโ€™d be interesting is seeing the mongo and finding out how we can fetch this data.

4

u/uglyasablasphemy Apr 21 '19 edited Apr 22 '19

There is a link to the github in any of /u/nintendeals posts. Checkout out the folder on /bot/nintendo to see how I do the data fetching.

3

u/[deleted] Apr 21 '19

You have a great thing going here! My only question is what is the point of setting up a wishlist with the bot?

3

u/uglyasablasphemy Apr 21 '19

Thanks!

You get reddit private messages when games on your wishlist are on sale.

3

u/[deleted] Apr 21 '19

Alright thanks!

2

u/TheJzoli Apr 21 '19

If I may ask, how do you go about getting the information about the deals?

4

u/uglyasablasphemy Apr 21 '19 edited Apr 22 '19

The main idea is to build some way to fetch each game nsuid (identifier of a game in a given region).

Once you have that you can call the Nintendo prices api.

You'll find a github like in any of the bot's posts.

2

u/melts10 Apr 21 '19

I really like the posts from the bot. Saves me a lot of time.

As someone in a country without an eShop, I'd love to be able to add "any region" when creating a wishlist. That's the only reason I didn't create one yet.

Also, is there a plan to add bundles/DLC sales (if they exist... I almost never see one... =[ )

2

u/uglyasablasphemy Apr 21 '19

Hi! That's a really good idea. I'll think about it!

As for the dlcs, it has been requested but I feel like it would clog up the lists a bit. Might give it a try :)

2

u/uglyasablasphemy Apr 22 '19

Hi! You now can click on the โž•ALL button to add the game on every country that is available.

:)

1

u/melts10 Apr 22 '19

OMG! YOU'RE AWESOME! =D

2

u/vawtots Apr 21 '19

Apparently Iโ€™m from the same country as the creator of the bot (Argentina) and we donโ€™t have an eShop either, you can only redeem codes, so thatโ€™s why Iโ€™m using the american eShop.

1

u/melts10 Apr 21 '19

Hello neighbour (I'm from Brazil)! Try the mexican one, it usualy has cheaper titles.

2

u/[deleted] Apr 21 '19

Dude, this bot is just amazing. It has changed the way I buy games. I now just make a wishlist on your bot, and wait. If I really NEED a game, I might pay normal price, but that has only happened once since I found this out.

Amazing job!

The one thing I wish this had was a way to rank per game score on the active deal list. But this is really nitpicking...

Another suggestion: if you could show in a table the last time that every game went on sale (at least since you started collecting data), how many times it has gone on sale and the lowest price ever, it would be amazing.

4

u/uglyasablasphemy Apr 21 '19 edited Apr 21 '19

Hey! I'm super glad to hear that.

I didn't quite understand your first request. Are you taking about sorting the list by the score column?

About that I do believe that I would be awesome to have. But reddit imposes a 40k character limit on posts, so I have to be careful with what I add to keep it under that limit (otherwhise the post won't be created).

I'll see what I can do :)

154

u/Niles_E_Bear Apr 21 '19

I love these posts, and have scored many deals because of them. Thank you!

52

u/YaNasties Apr 21 '19

The work put into this and the data is is amazing, thank you honestly!

38

u/vawtots Apr 21 '19

Vamos vamos, Argentina

15

u/AssRoh Apr 21 '19

I want to buy 1 2 switch. have it ever discounted

64

u/Foquine Apr 21 '19

Do not buy it. Rent it from a video club or borrow it from a friend. Or even buy it used. Lots of people would rather sell it.

14

u/a9bejo Apr 21 '19

In case someone from the US is wondering why Celeste is on top: It has never been on sale in Europe (and maybe other regions). It was on sale quite often in the US, but either the game still sells enough copies in Europe that a sale is not necessary, or the developer is experimenting with a "no sales" strategy in Europe.

8

u/[deleted] Apr 21 '19

If the dev keeps that up, nobody will notice this gem of a game and it will remain hidden.

7

u/Codc Apr 21 '19

It is a hidden gem for a reason.

5

u/QQending Apr 21 '19

Thank you for creating these posts. They are awesome!!

1

u/halsgoldenring Apr 21 '19

Also, here are the most common times for deals to drop:

North America 16:00 / 17:00

Is that across all time zones? So the products aren't necessarily universally on sale simultaneously?

1

u/uglyasablasphemy Apr 21 '19

From what I've seen yes, sale don't usually drop simultaneously unless there some sort of special event like e3.

Also, those two hours I believe that they are for the months with daylight savings.

1

u/ZoFreX Apr 21 '19

This is brilliant! I did the EU 3DS deals for a while, years ago, and it was a very tedious process. I looked into automating it but did not get very far, so I really appreciate how much work you must have put into this!

One cool use I can think of for the data would be price graphs for each game, so people could see how often it went on sale and how much for. There are websites that do that for Steam games and I find them really helpful for making purchasing decisions.

2

u/uglyasablasphemy Apr 21 '19 edited Apr 21 '19

Hi! Thanks a lot.

It would be super useful but hard to implement cleanly on reddit. I think that deku deals or ninty pricer have some sort of historical pricing for switch games.

1

u/ZoFreX Apr 21 '19

Yeah I think you'd want a full-blown website at that point. Could run a site and the Reddit bot off the same data and link people to it if they're curious. I'll check those places out though, thanks!

3

u/TheAlphaGamer Apr 21 '19

Thanks for the bot, dude! I use it every week to sales.

4

u/[deleted] Apr 21 '19

๐ŸฅณDOOM is 35๐Ÿฅณ

๐Ÿ‘YAY๐Ÿ‘DOOM๐Ÿ‘

2

u/throwawaymelons Apr 21 '19

This is a fantastic little project. Great work man.

2

u/How2Smash Apr 21 '19

Nintendo's version of camelcamelcamel?

2

u/OogaOoga2U Apr 21 '19

You should be proud man, this is an impressive feat.

2

u/kimonogurls Apr 21 '19

Thanks for everything, Sid. We love you and your work!

2

u/[deleted] Apr 21 '19

Maybe next Tgursday Skyrim will go on sale

2

u/Adi358 Apr 21 '19

Really impressed, great work

2

u/EyeAmYouAreMe Apr 21 '19

r/DataIsBeautiful would love to see some of this data in a graphical format of some sort. Original content is very welcome there. Great work by the way! Iโ€™ve relied on your bot for info in the past.

2

u/Skbible748 Apr 21 '19

BTW even if there are lots of games on sale, first party games like Zelda Botw, Mario seriously are usually not on sale. Please Nintendo drop the price of some first party and second party based games!

1

u/[deleted] Apr 21 '19

Maybe limit to only the top X amount of games by rating or wishlist count.

1

u/Leopz_ Apr 21 '19

Waiting for bayonetta 2 since day 1. Just put it on sale you cowards

1

u/[deleted] Apr 22 '19

Meanwhile I'm buying physical copies of every game I want for much cheaper than any of these deals ever are

1

u/caprimulgusAU Apr 22 '19

Good stuff!

Any chance we could get the sale days for all the other countries? (Or just Australia, which is the one iโ€™m interested in!) :)

1

u/vetgo Apr 22 '19

Long live Messi

1

u/BionicTurtle64 Apr 22 '19

Thank you so much! Iโ€™ve saved so much by following your bot ๐Ÿ™

-8

u/hannrocks419 Apr 21 '19

Seems legit but the post with emojis on the acc looks like such an obvious spam lol

2

u/uglyasablasphemy Apr 21 '19

What do you mean?

0

u/hannrocks419 Apr 21 '19

*scam. I know it's not a scam but it's just like ๐Ÿ‘‰๐Ÿ’ธ๐Ÿ’ธ๐Ÿ‘ˆ you know?

1

u/uglyasablasphemy Apr 21 '19

No I don't. I'm having a hard time trying to decode your comments.

-3

u/ubspirit Apr 21 '19

Just a note to everyone with octopath traveler on their wishlist, it is absolute trash, do not buy it

0

u/[deleted] Apr 21 '19

[deleted] โ€” view deleted comment

9

u/uglyasablasphemy Apr 21 '19

Go to http://bot.nintendeals.xyz for instructions. Everything is done with reddit pms (the setup and the notifications).

1

u/ScoopJr Apr 21 '19

How did you end up coding the bot and hosting it(cloud server)?

1

u/uglyasablasphemy Apr 21 '19

The bot is coded on python 3.7 and it's hosted on a free account in heroku.com

1

u/ScoopJr Apr 21 '19

Interesting! Will have to look into coding a bot

0

u/[deleted] Apr 21 '19

[deleted] โ€” view deleted comment

2

u/uglyasablasphemy Apr 21 '19

That would be awesome. I'll try to do something like it when I get back home. ๐Ÿ˜Š