It seems that you're using an outdated browser. Some things may not work as they should (or don't work at all).
We suggest you upgrade newer and better browser like: Chrome, Firefox, Internet Explorer or Opera

×
avatar
action_fan: GOG shows different regional prices in USD. GOG DB shows just USA prices, and Yepoleb doesn't want to add other regions.
It would be nice indeed if it showed more currencies, but also the dollar price is a good indicator for discounts and price drops.
If I see a game has currently a 30% discount (yay!!!) but it had 80% in the recent past (excluding launch discount), then I won't buy it now and wait for a better offer.
avatar
action_fan: GOG shows different regional prices in USD. GOG DB shows just USA prices, and Yepoleb doesn't want to add other regions.
I did google this specific forum thread for such discussion before posting, and found posts from 2017, where what you wrote was also mentioned.

Big reason I asked the question was to check if everything was alright with gogdb aaand a no lesser reason - to check my memory, because I seem to recall that games on gog and gogdb used to have same prices in USD for me.

Oh well, no point in talking about it further, since I didn't keep my own game prices database and can't check if I'm just remembering incorrectly.

Thanks for the reply.
Post edited December 15, 2022 by McFirson
Cheers Yepoleb,

I noticed for numerous titles there are DLCs with unknown data listed, for example:
https://www.gogdb.org/product/1199381642#references

This may be because these products do not have 'visible' API or store entries, however if you are so inclined, it is possible to collect most of the necessary data to identify these entries from the expanded_dlcs field:
https://api.gog.com/products/1199381642?expand=expanded_dlcs
avatar
action_fan: GOG shows different regional prices in USD. GOG DB shows just USA prices, and Yepoleb doesn't want to add other regions.
Thanks for answering their question. My stance on showing regional pricing has changed when GOG abandonned the fair price package program (it gave you the money you were paying over the US price as wallet funds). It's just really hard to do this in a way that is useful, always correct and does not arbitrarily discriminate between regions. That's why I have given up on it twice, but I still want to do it eventually.

avatar
SCPM: This may be because these products do not have 'visible' API or store entries, however if you are so inclined, it is possible to collect most of the necessary data to identify these entries from the expanded_dlcs field
I've known about this for a while, it is difficult to implement because of the way the updater works. It is not designed to modify the data for games other than the one it is currently processing. Also on my list of harder problems to tackle.
avatar
action_fan: GOG shows different regional prices in USD. GOG DB shows just USA prices, and Yepoleb doesn't want to add other regions.
avatar
Yepoleb: Thanks for answering their question. My stance on showing regional pricing has changed when GOG abandonned the fair price package program (it gave you the money you were paying over the US price as wallet funds). It's just really hard to do this in a way that is useful, always correct and does not arbitrarily discriminate between regions. That's why I have given up on it twice, but I still want to do it eventually.
Why difficult? If GOGDB will check regional prices, it should display all of them on a title's pricing tab, in both local currency and USD, and even better if it'd also display the percentage difference compared to US price. (Or, well, take SteamDB as example?)
The problem may be the graph, since historical regional prices weren't stored, and it may take too much space to do so in the future, but if you take the price in local currency into account, normally the difference is just rounding when it comes to discounts, so it should typically look the same for all regions, the one exception being if regional pricing was added or removed for a game at some point. Granted, if you also add the exchange rate changes, it becomes messier, but charts can be seen elsewhere, for example on isthereanydeal, and GOG DB may even have a link pointing those who want it to the relevant page. Information about all current prices for one game and how they compare, however, isn't readily available for GOG since MaGOG decided enough was enough, so that should be the key point. That and information about the lowest ever price, in both USD and local currency where applicable.
avatar
Cavalary: Why difficult? If GOGDB will check regional prices, it should display all of them on a title's pricing tab, in both local currency and USD, and even better if it'd also display the percentage difference compared to US price.
Collecting all the data in the first place is, because there's no single API call you can make to get all the currencies available for a region. So you're stuck with doing calls per country code (there's quite a few of those...), not to mention the endpoints are prone to errors and timeouts. Storing price data can also prove a challenge in the long run, since a sale will impact most of the values. So you have large amounts of fast changing data to manage - quite a nightmare.

Of course, GOG doesn't have that problem since their calculations are code based. A far better option would be for GOG to expose what is being applied to the base price for each region and currency to obtain the final price and what country codes are part of a region (as a real-time API endpoint), but meh... I guess they have no interest to do that as all their APIs are meant to serve Galaxy + the website (neither are designed with price tracking in mind).

Yepoleb's problems may be a bit different, but I've answered it because I also tried implementing it in the past and simply went with a configurable region/currency for single price tracking to suit my purposes (though in general I like to collect as much data as possible, it simply was too daunting a task in this case). MaGOG really was doing the "Lord's work" here and was quite a marvel of computer engineering.
Post edited January 01, 2023 by WinterSnowfall
avatar
Cavalary: Why difficult? If GOGDB will check regional prices, it should display all of them on a title's pricing tab, in both local currency and USD, and even better if it'd also display the percentage difference compared to US price. (Or, well, take SteamDB as example?)
GOG does not have regions in the way Steam does, discounts seem to get applied on a per-country basis. There are about 200 recognized states, I can't request them all and it would not be useful. Now make a list of all the important ones without offending anyone. That's the hard problem I'm dealing with.
avatar
Yepoleb: GOG does not have regions in the way Steam does, discounts seem to get applied on a per-country basis. There are about 200 recognized states, I can't request them all and it would not be useful. Now make a list of all the important ones without offending anyone. That's the hard problem I'm dealing with.
Requesting all would be what I was thinking about, yes... Otherwise, MaGOG had a list of regions, countries with the same price across all games, but it became ever more fragmented because this game or that happened to differ in pricing. So the right way would be to just request and list all, yes.
But if you say that's not possible... I guess you could look at the visitor country stats for GOGDB as a way to judge what would be useful. Or you could first try to determine what regions do still exist, countries with the same pricing for all games, and use those (or maybe mrkgnao still has some useful info to pass along?), and then look at stats for the rest?
Here are GOG's 50 regions as last recorded on 31 Dec. 2020 (Format is REGION|MEMBER_COUNTRIES):

Australia (AU)|Australia (AU)
New Zealand (NZ)|New Zealand (NZ)
Most of Latin America (AR)|Argentina (AR), Bolivia, Plurinational State of (BO), Dominican Republic (DO), Ecuador (EC), Guatemala (GT), Honduras (HN), Haiti (HT), Nicaragua (NI), Paraguay (PY), El Salvador (SV)
Chile (CL)|Chile (CL)
Colombia (CO)|Colombia (CO)
Costa Rica (CR)|Costa Rica (CR)
Mexico (MX)|Mexico (MX)
Panama (PA)|Panama (PA)
Peru (PE)|Peru (PE)
Puerto Rico (PR)|Puerto Rico (PR)
Uruguay (UY)|Uruguay (UY)
Brazil (BR)|Brazil (BR)
Canada (CA)|Canada (CA)
Northern Eurozone (DE)|Germany (DE), Andorra (AD), Austria (AT), Belgium (BE), Finland (FI), France (FR), Ireland (IE), Iceland (IS), Liechtenstein (LI), Luxembourg (LU), San Marino (SM)
Southern Eurozone (IT)|Italy (IT), Cyprus (CY), Spain (ES), Greece (GR), Portugal (PT)
Denmark (DK)|Denmark (DK)
Malta (MT)|Malta (MT)
Monaco (MC)|Monaco (MC)
Netherlands (NL)|Netherlands (NL)
Norway (NO)|Norway (NO)
Sweden (SE)|Sweden (SE)
Switzerland (CH)|Switzerland (CH)
United Kingdom (GB)|United Kingdom (GB)
EU Central Europe (CZ)|Czech Republic (CZ), Hungary (HU)
Slovakia (SK)|Slovakia (SK)
Poland (PL)|Poland (PL)
EU Eastern Europe (RO)|Romania (RO), Bulgaria (BG), Croatia (HR), Lithuania (LT), Latvia (LV), Slovenia (SI)
Estonia (EE)|Estonia (EE)
Rest of Europe (RS)|Serbia (RS), Montenegro (ME), Holy See (Vatican City State) (VA)
Russia (RU)|Russian Federation (RU)
Ukraine (UA)|Ukraine (UA)
Nine Former Soviet Republics (UZ)|Uzbekistan (UZ), Armenia (AM), Azerbaijan (AZ), Belarus (BY), Kyrgyzstan (KG), Kazakhstan (KZ), Moldova, Republic of (MD), Tajikistan (TJ), Turkmenistan (TM)
Most of the World (PK)|Pakistan (PK), Afghanistan (AF), Antigua and Barbuda (AG), Anguilla (AI), Albania (AL), Angola (AO), Antarctica (AQ), American Samoa (AS), Aruba (AW), Åland Islands (AX), Bosnia and Herzegovina (BA), Barbados (BB), Bangladesh (BD), Burkina Faso (BF), Bahrain (BH), Burundi (BI), Benin (BJ), Saint Barthélemy (BL), Bermuda (BM), Brunei Darussalam (BN), Bonaire, Sint Eustatius and Saba (BQ), Bahamas (BS), Bhutan (BT), Bouvet Island (BV), Botswana (BW), Belize (BZ), Cocos (Keeling) Islands (CC), Congo, the Democratic Republic of the (CD), Central African Republic (CF), Congo (CG), Côte d'Ivoire (CI), Cook Islands (CK), Cameroon (CM), Cabo Verde (CV), Curaçao (CW), Christmas Island (CX), Djibouti (DJ), Dominica (DM), Algeria (DZ), Egypt (EG), Western Sahara (EH), Eritrea (ER), Ethiopia (ET), Fiji (FJ), Falkland Islands (Malvinas) (FK), Micronesia, Federated States of (FM), Faroe Islands (FO), Gabon (GA), Grenada (GD), Georgia (GE), French Guiana (GF), Guernsey (GG), Ghana (GH), Gibraltar (GI), Greenland (GL), Gambia (GM), Guinea (GN), Guadeloupe (GP), Equatorial Guinea (GQ), South Georgia and the South Sandwich Islands (GS), Guam (GU), Guinea-Bissau (GW), Guyana (GY), Heard Island and McDonald Islands (HM), Israel (IL), Isle of Man (IM), British Indian Ocean Territory (IO), Iraq (IQ), Jersey (JE), Jamaica (JM), Jordan (JO), Kenya (KE), Cambodia (KH), Kiribati (KI), Comoros (KM), Saint Kitts and Nevis (KN), Kuwait (KW), Cayman Islands (KY), Lao People's Democratic Republic (LA), Lebanon (LB), Saint Lucia (LC), Sri Lanka (LK), Liberia (LR), Lesotho (LS), Libya (LY), Morocco (MA), Saint Martin (French part) (MF), Madagascar (MG), Marshall Islands (MH), Macedonia, the former Yugoslav Republic of (MK), Mali (ML), Mongolia (MN), Northern Mariana Islands (MP), Martinique (MQ), Mauritania (MR), Montserrat (MS), Mauritius (MU), Maldives (MV), Malawi (MW), Mozambique (MZ), Namibia (NA), New Caledonia (NC), Niger (NE), Norfolk Island (NF), Nigeria (NG), Nepal (NP), Nauru (NR), Niue (NU), Oman (OM), French Polynesia (PF), Papua New Guinea (PG), Saint Pierre and Miquelon (PM), Pitcairn (PN), Palestine, State of (PS), Palau (PW), Qatar (QA), Réunion (RE), Rwanda (RW), Solomon Islands (SB), Seychelles (SC), Saint Helena, Ascension and Tristan da Cunha (SH), Svalbard and Jan Mayen (SJ), Sierra Leone (SL), Senegal (SN), Somalia (SO), Suriname (SR), Sao Tome and Principe (ST), Sint Maarten (Dutch part) (SX), Swaziland (SZ), Turks and Caicos Islands (TC), Chad (TD), French Southern Territories (TF), Togo (TG), Tokelau (TK), Timor-Leste (TL), Tunisia (TN), Tonga (TO), Trinidad and Tobago (TT), Tuvalu (TV), Tanzania, United Republic of (TZ), Uganda (UG), United States Minor Outlying Islands (UM), Saint Vincent and the Grenadines (VC), Virgin Islands, British (VG), Virgin Islands, U.S. (VI), Viet Nam (VN), Vanuatu (VU), Wallis and Futuna (WF), Samoa (WS), Yemen (YE), Mayotte (YT), Zambia (ZM), Zimbabwe (ZW)
China (CN)|China (CN)
Hong Kong (HK)|Hong Kong (HK)
India (IN)|India (IN)
Indonesia (ID)|Indonesia (ID)
Japan (JP)|Japan (JP)
Macao (MO)|Macao (MO)
Malaysia (MY)|Malaysia (MY)
Philippines (PH)|Philippines (PH)
Saudi Arabia (SA)|Saudi Arabia (SA)
Singapore (SG)|Singapore (SG)
South Africa (ZA)|South Africa (ZA)
South Korea (KR)|Korea, Republic of (KR)
Taiwan (TW)|Taiwan, Province of China (TW)
Thailand (TH)|Thailand (TH)
Turkey (TR)|Turkey (TR)
United Arab Emirates (AE)|United Arab Emirates (AE)
Rest of the World (US)|United States (US), Cuba (CU), Iran, Islamic Republic of (IR), Korea, Democratic People's Republic of (KP), Myanmar (MM), Sudan (SD), South Sudan (SS), Syrian Arab Republic (SY), Venezuela, Bolivarian Republic of (VE)

The "more important" regions, IMO, are:
AU
AR
BR
CA
DE
IT
NO
SE
GB
CZ
PL
RO
RU
UA
CN
US

The "must have" regions, IMO, are:
AU
BR
CA
DE
GB
PL
RU
CN
US

Disclaimer: My knowledge is outdated by at least two years.
Post edited January 02, 2023 by mrkgnao
P.S. MaGog used to check the 50 regions every 6 hours for all games, and all the 200+ countries once a week to detect new "regions".
Thanks for that mrkgnao.

Thought about it a little more, and what I'd do if checking each country for each game wouldn't be possible would be something like this:
True, first need a priority list for countries, but that doesn't seem that much of a problem. You could make it relevant to GOGDB, by looking at the country visitor list, or you could do what MaGOG did and go by population, which has the added advantages of being "more" objective, easily verifiable and also able to be pulled straight from an existing list, not generated manually or needing a script to generate it from some site data.
That done, when a new title gets added, check all countries in the order from that priority list and store the first one that has a different price from any others checked before, forming a list of regions relevant to that title. For many titles, there will only be several, probably the "must haves" mentioned by mrkgnao above, and for some even just a few, and those going into the dozens will be very rare. Then you'd just check each of those regions, so the highest priority country from each, with the regular frequency, and update the matrix by checking all at a feasible interval, like it was with one week for MaGOG, or every other week if by now the catalog grew too much for weekly to still be feasible. (Of course, would need an initial check of the entire catalog to populate the list when starting to gather regional pricing data.)
Then you'd just list each game's different regional prices, so per region, with a list of countries included in each region available, for example by clicking to expand a region, or as a tooltip, though I dislike things popping up on hover, and a note that only the "main" country listed for a region is checked regularly and the date when the pricing matrix was last confirmed.
Hope I didn't make things too unclear.
Are the new tags and user ratings not covered by the GOG API? Is there any hope of seeing them collected by GOG DB?
I have seen that the ratings are present on the backup files, even though they are not displayed on the website. Oh, joy!
Looking forward for the tags too. They would be quite helpful to me.
Thank you.
For whatever reason, the package called Silver Box Classics has not had its actual contents (which should be four individual library entries) picked up on the GOGDb site -- the "references" tab is empty, and searching for the individual games brings up nothing, either. Not sure if this is due to GOG having done something unusually with that title, or what.
avatar
HunchBluntley: Not sure if this is due to GOG having done something unusually with that title, or what.
It's a problem with some bundled tittles, when the actual games are stored under different IDs and no API linkage is provided. It's not the only entry with this particular problem... Most likely the 4 game IDs will have to be added manually to GOGDB.

avatar
Gede: Are the new tags and user ratings not covered by the GOG API? Is there any hope of seeing them collected by GOG DB?
Sorry for the late reply (not sure if you're still looking for an answer, even :). All tags are visible in the GOG APIs because that's how Galaxy/the website lists them in the first place. It shouldn't be hard to add them as part of the visible website metadata (I'm already collecting them with my own scripts), but that's on Yepoleb to decide.

As for the ratings, they are part of separate endpoints, so that's a bit more complicated, yet not impossible. The ratings you are seeing in the backups are not the newly added ones (external reviews), but rather GOG's own. If that's what you're looking for, they've always been there, I think, just not shown on GOGDB.

P.S.: If you need a consolidated list of tags or ratings in a csv format, do let me know :).
Post edited April 06, 2023 by WinterSnowfall