Having a website in multiple languages is important if you want to reach a larger audience and have higher earnings on Adsense. Thinking about it for years I tried to find practical ways to translate my website, until I finally reached a verdict.
First translation experience with Polylang
Most people I know recommend using WPML, I even bought a license, but I had a bad experience and ended up asking for a refund and using the free Polylang option.
Polylang at no cost allows you to manage a website in multiple languages and with translated URLs. Unfortunately things have to be done manually. I even translated some articles using the Lingotek extension with free API, but because of some problems I preferred to resort to manual translation with Google Translate.
I arrived over 2 years to translate more than 130 articles in English and 60 articles in Spanish. I got about 50,000 organic monthly visits to the Spanish and English pages, so there came a time that I thought about expanding even more.
Unfortunately it is not practical to translate using Google Translate article by article, I also did not like the fact that polylang mixes translated articles in the same data table as wp-posts;
Looking for alternatives to machine translation - GTranslate
In the middle of creating a song lyrics site, want a plugin that allows you to automatically translate my entire site into multiple languages. Among all the alternatives I found in the recommendation articles, I ignored Weglot and Translatepress and ended up being attracted by GTranslate.
GTranslate seems to be incredible, as it does not store data on your server or database, but on their own HOST and CDN. Another interesting factor is that they automatically translate all articles into more than 40 languages with URL and SEO.
I'm talking about the paid version, since its free version is worthless to SEO. The big problem is that your monthly installments are salty. The translated link plan costs $ 27 a month. I didn't see any problems, since there are thousands of pages being hosted on their server. He had faith that foreign visits would generate $ 27 a day.
In just one day using paid GTranslate, more than 90,000 pages in other languages were generated, but I had a problem that disappointed me, the cache plugin ended up breaking the translated sites because of the dynamic minification URL.
Leaving GTranslate and getting to know TranslatePress
I started to get irritated and went back to searching for alternatives, I ended up paying attention to Translatepress. Initially he did not attract me because of the need to use API for automatic translation that is usually paid for. The translation also seems to be complex, since you translate blocks and strings instead of copying and translating an entire article as in polylang.
I started thinking about the annual expenses with GTranslate that exceeds 279 dollars, against Translatepress 80 dollars a year, being able to get a license of 130 dollars to use in up to 3 sites in the future. I came to the conclusion that it was not worth paying eternally for GTranslate with the possibility of losing all translation if I stop paying the subscription or the company goes bankrupt.
So I ended up migrating to TranslatePress and in one day I translated all 1800 articles into English using the Google Translate API which is very accurate and uses neural translation. Unfortunately the $ 300 earned from Google is over, I wasn’t looking to pay $ 90 for just one million translated characters.
How did I translate with Translatepress without a Translation API?
I had already added more than 10 languages before I even finished translating one. I thought about deleting it to prevent pages in Portuguese from being displayed in other languages, but I was afraid to negatively affect SEO.
One of the things I liked about TranslatePress is the fact that they use a table for each language in the database. This gave me an idea, I took the tables of all languages and found that I can translate them quickly.
It is not a simple process, but it is better than translating article by article, block by block. I created a local MySQL server and copied the tables I wanted to translate to the local server (it is faster).
On the local server I filtered the lines I didn't want to translate and copied over 10,000 lines of the original text, pasted it into an excel column and used the google translator for documents (no character limits) and quickly translated 10,000 lines of strings in minutes .
Because it has about 2000 articles in the original language, each language table contains about 250,000 rows, so it was a long process, but there were moments when I translated 25,000 rows from the database into just one excel file.
You just need to be careful that no characters, formatting or line breaks change the number of lines when copying and pasting in excel. Every time I copied and pasted something from the database to Excel, I checked the number of rows.
Each item you copy, translate and paste from the column original for translated, you need to change the column number status for 2, thus preventing the automatic translation of Translatepress from re-translating that line.
One of the advantages of translating directly from the database is to avoid spending on characters from the Google Translation API or Deepl. Since my site has a lot of English characters, thousands of lines I just had to copy and paste into the column translated.
I used Navicat to edit the databases in a grid, I tried with dbeaver, but due to lack of knowledge I was unable to page or use the filters in the database. Filters are important to help you find texts that do not need to be translated, that can be simply copied and pasted into the table translated.
I didn't want to install a MySQL server on my personal machine, so I used Docker to create the Localhost server, since editing directly from the site is very slow, especially for tables with more than 10,000 loaded rows.
Bypassing the 5000 Google Translate Limits characters
I made a video showing how I edit the database and how I circumvent the translation limit, I hope you like the video showing step by step:
What do we learn from this lesson?
Even without having much knowledge in programming, I was able to find an alternative to the Google Translator API to quickly and massively translate my website into other languages. You can also do similar things!
Without a doubt, Translatepress is one of the best translation plugins for WP, leaving the article database simple and fluid, without messing up your WP-Admin and with a nice support. In addition to translating texts in articles that are effective on other pages.
On my song lyrics website, I was able to keep the original content and translate only the H2 titles using Translatepress. I spent hours in groups looking for a solution that was in front of me.
I also recommend GTranslate if you want to avoid any work and headaches, or if you want a separate host for foreign sites, especially if using subdomains or ccTLD. Subdirectory will still need an initial request from your server. Just keep in mind that if you stop paying, you will lose all translations.
Is it worth buying Translatepress?
I love the plugin, but I find it a bit expensive with a single license of 79 euros per year, so I bought the Developer version right away and offer a license to some customers who want to translate their website in order to help fund this 200 euros plugin.
If you want an official Translatepress license or help translating, just contact us at Contact Form I can give you a budget, a much cheaper alternative for those who want to use Translatepress.
I hope you enjoyed this article, if you liked it share and follow our website, also leave your comments! Thank you and see you next time!