I’m looking for an efficient way to synchronize my database across multiple multisites in REAL TIME. My website operates in 10 different regions, and currently has 200 active listings on the main site, let’s call it example.com. I want all 200 active listings on the main website to be displayed on the other nine multisites without the need for manual addition. For instance, the main website is example.com, and one of the multisites is example.com/de.
Specifically, I’m seeking a real-time solution that will update all multisite databases simultaneously. If a vendor adds a new listing on example.com, I want it to be automatically reflected on example.com/de and all other multisites. I’m not sure that the import listings extension is the ideal approach as I want the databases along the multisites to be updated in real time and for every new addition (201st listing, 202nd listing etc).
Do you have any suggestions on how to achieve this?
Please let me know what’s the difference between these sites, is it a different language? If so then syncing listings is not enough, it will also require translation. If auto-translation is ok you can also consider using the same site with an automatic translation switcher, e.g. Google Translate.
Hello @ihor , the difference between the sites is based on language AND currency. It is not helpful to use an auto-translation switcher because switching the currency is also necessary. Unfortunately, Hivepress does not support multi-currency easily, particularly for marketplace, and even a currency switcher will not solve the problem. The aim is to create subdomains for each currency and language, but this approach creates a challenge since each subdomain has its own database. This means that buyers in one subdomain cannot search for, find, and book listings in another subdomain. To address this issue, it would be necessary to synchronize all the listings across each subdomain to enable access from any subdomain.
Yes, currently there’s no option to allow vendors to set different currency per listing, we’ll consider adding it. You can allow users to switch the displayed currency using switchers.
The topic seems to mention the language only, but I don’t recommend keeping multiple languages within the same platform with user-generated content, this will cause performance and content issues in the long run, e.g. reviews will be posted in different languages (so some auto-translator would be required anyway, and storing in which language the review was posted, auto-detection would also be required for this).
If it’s possible, I highly recommend creating separate platforms for different markets. The same user database can be implemented using Multisite.
Hello @ihor, in your previous message you said “If it’s possible, I highly recommend creating separate platforms for different markets. The same user database can be implemented using Multisite.”
This leads us back to my original question: Is it possible to implement the same user database accross all multisites when using multisite? My objective is to avoid a situation where users must create identical listings on each subdomain to enable buyers from various subdomains to access them.
Would you be able to provide me with extensive instructions on how to configure multisite? Thank you.
Yes, if you mean user account this may be possible with WordPress Multisite installation. It shares the same users database, but posts (also listings, vendors, reviews etc.) are separate What is Multisite? How to Create WordPress Multisite Network Please note that we don’t guarantee 100% compatibility with Multisite but there are no known issues yet.