Polyglot eCommerce Translator - Multilingual translator for online stores

Description Polyglot eCommerce Translator - Multilingual translator for online stores

Smart Automatic Product Translation System — a ready-to-use solution for a multilingual online store

What is it?

This is  ready-to-implement set of scripts for automatically translating OpenCart products into multiple languages ​​using leading machine translation APIs:

• Google Cloud Translation
• DeepL Pro
• Azure Translator (Microsoft)
• Gemini AI (Google AI)

Each module is a standalone, independent, and fully customizable PHP script that can be integrated directly into the backend or run via cron. The scripts require no additional dependencies other than the standard server configuration (PHP + MySQL + cURL).

⚙️ Features and Capabilities:

✅ Fully automated product translation

Translate product names and descriptions from the source language (Russian) to the target languages ​​(Ukrainian, English).

Supports multiple launches without duplication—the system remembers which products have already been translated.

Smart search for untranslated products—only relevant entries are added to the queue.

Supports multiple APIs simultaneously.

Not tied to a single service:

You can:

• test different APIs on the same products,
• select the optimal one based on quality/price,
• easily switch when terms or rates change

Database and SEO Integration

Automatically save translations to the product_description table

Generate SEO-friendly URLs (seo_url) in the target language

HTML markup preservation: scripts correctly process tags, avoiding layout corruption

Flexible Volume Management

Set a maximum number of translations per day (for example, to stay within free API limits)

Support for queues and batch processing.

Intelligent Enhancements

Translation Caching (for Azure/Gemini): texts are not retranslated if they are already in the cache

Splitting long descriptions into parts when the API limit is exceeded

HTML and special character processing before translation and insertion into the database

Security and Reliability

Complete Isolation from the Frontend

Scripts run only via internal calls—via a direct URL, AJAX, or cron

No open endpoints for public access—everything is managed through the admin panel or server

Reliable Data Management

Use of prepared SQL queries (mysqli::prepare)—protection against SQL injection

Escaping of quotes and special characters before writing to the database

UTF-8 correctness at all stages

Fault Resilience

Automatic Retries (up to 3 attempts for API errors)

Pauses between requests — avoid blocking and rate limits

Color-coded logging of all operations (INFO, WARN, ERROR, CACHE)

⏳ Resource Management

API limit monitoring (DeepL — via their official endpoint, others — via internal statistics)

Automatic shutdown if <500–1000 characters remain in a month

Large data support without memory overload

Monitoring and Reporting

Cumulative Statistics

A translation_stats.json file is maintained: how many products have been translated, how many characters have been used

A separate translation_totals.json file for summary statistics for all APIs

Telegram Notifications

• Detailed reports after each run:
• How many products have been translated
• Which languages ​​have been used
• How many characters have been used
• Examples Translated and failed products
• Notifications can be disabled — flexible configuration

Progress and log files

translation_progress.json file — tracks the current stage (search → translation → save → completion)

Log file rotates when 1 MB is exceeded — doesn't clog disk space

Support for two log interface languages: Russian (ru) and Ukrainian (ua)

Ease of administration

Browser or cron management

AJAX mode support — progress is visible in real time

Ability to run in the background via cron

Force state reset via ?reset=1

Cache clearing (?clear_cache=1) — for retraining or error fixing

Testing and debugging

Detailed logs with context: product ID, stage, Language, text length

Ability to quickly identify problematic products and retranslate manually

Modular architecture

All scripts use common helper functions from translation_functions.php

Unified configuration structure (config.php) — easy switching between APIs

Commercial value

These aren't just scripts — they're an investment in sales growth.

✅ Increased audience reach: Open new language markets without manual labor

✅ Increased trust: High-quality translation = professional image

✅ SEO in new languages: Automatic generation of SEO URLs and translated content

✅ Cost savings of up to 90% compared to manual translation or external agencies

✅ Scalability: The system can handle a catalog of tens of thousands of products

Technical Requirements

PHP 7.3+

Extensions: mysqli, curl, mbstring, json

MySQL 5.7+ / MariaDB

Access to API keys of one or more services

Ability to write to the file system (for logs, cache, and statistics)

(tested on ocStore 3.0.3.7)

Result: a multilingual store in hours, not weeks (depending on the number of products)

By purchasing this package, you get more than just code, but a ready-made business system that:

• Works 24/7
• Minimizes risks
• Maximizes reach
• Reduces costs
• Guarantees quality

Ideal for:

— OpenCart / OcStore online store owners

— Promotion and localization agencies

— Developers implementing multilingual support for clients

— Marketers launching export campaigns

Ready to go international effortlessly?

This translation system is your first step to global success.