Web dev obstacle | Update ±100 pages with content from central database

[Leroooy]

Hi there.*I’m wrestling*with a tricky web development obstacle, and I really have no idea where to start at the moment.* If you're reading this, I appreciate it. If you can help me figure out a solution...well, I owe you a beer mate. :coffee:

My current major project is a ground-up*rebuild of*our non-profit's website There are three key functionalities that I need to implement (well, more, but these three are linked and are giving me the biggest headache*right now).*We*have ± 100 active countries in our movement, and the current website I built (and copied and pasted and copied and pasted and...) a page for every. single. one.

I'm not going through that again (and it's SUPER unfriendly to maintain). So what I need is:

1. Two different page templates — one for countries with all the necessary info and images, and one for countries with limited or no info — which I can populate from a single database. That way, updating content is all done in one place, and updating design is done in one place.
2. This database needs to be editable by key people around the world with some degree of version control in place, so that each country has a degree of control over the info on their own page, but I retain admin edit & veto rights.
3. I’d like for all of this info to be translatable by people from each country.

I know there are a bunch of translation plugins for the third functionality, so it’s more about what will be most effective once everything else is in place.

The second functionality also has some apparent solutions — using git makes a lot of sense, for example — but I think how easy it is to implement will largely depend on number one.

Which bring us to point one.*I’m not even really sure where to start looking for a solution for the first problem. The logic is pretty straightforward, but I have no idea what technologies are available or how to integrate them to achieve the stated goal.

A constraint*is that the bulk of the website should be built in WordPress (for a number of reasons, but primarily because a) I know the CMS pretty well, and b) it is easy to convert to a PWA, which is another thing I need to figure out but at least there are good plugins for that ey?)

Another constraint is that I'm currently working man alone, and it's a decentralized non-profit so budget is pretty much non-existent. It's a fun challenge, but also :unsure: :frantic:

[bleau canon]

You might do better asking your questions on a web dev or Wordpress forums.