Description Atribute Translator - translation of attribute values for ocStore 3.0.3.7
Attribute Translator - intelligent translation of product attributes for ocStore 3.0.3.7
Attribute Translator is a professional PHP-script for automatic translation of product attribute values (sizes, colors, characteristics, etc.) from Russian to Ukrainian and English. The solution is created specifically for owners of online stores on ocStore 3.x engine, who need to quickly and efficiently localize product cards without manual copying and hiring translators.
The script uses Microsoft Azure Translator API (neural network translation of high quality), works through a web interface, supports batch mode, can resume interrupted sessions and sends reports to Telegram.
Description:
- Attribute Translator is a standalone PHP/MySQL web application that:
- Connects to the ocStore attribute table (oc_product_attribute);
- Selects all Russian-language attribute values (ignoring empty and technical records);
- Translates them through Microsoft Azure Translator into Ukrainian and/or English;
- Saves translations to the same table (adding or updating records);
- Maintains a detailed log of translated records (translated_log.json) and statistics (translation_stats.json);
- Provides a convenient web-interface in Russian or Ukrainian.
- The script is written without frameworks, runs on standard LAMP stack and does not require modification of ocStore kernel.
Features:
- Automatic translation of attributes RU → UA, RU → EN via Microsoft Azure Translator (high quality, support for technical terms).
- Web interface with authorization, statistics, filtering and pagination
- .Manual editing of translated attributes directly from the browser
- .Mass saving / deleting of selected records.
- Filtering by product ID, attribute ID, language, text, and "Pending translation" status.
- Search for existing translations in the database and add them to the log, so as not to waste API requests repeatedly
- .CLI-script (cron_translate.php) to run by cron - translation in the background.
- Telegram-notifications about translation session completion (number of translated attributes, execution time, progress).
- Limiting requests to API (protection from quota exceeding).
- Logging of all actions
- . with log rotation (by day and file size).
- Support of two interface languages - Ukrainian and Russian (it is easy to add others).
- Security: sessions, HTTP-only cookies, authorization, SQL injection protection via prepared queries .
Who it is useful for:
| Audience | Uses |
| Owners of online stores on ocStore / OpenCart | Fast catalog localization without hiring translators. |
| SEO-specialists | Improvement of ranking in Ukrainian and English language rendition due to unique localized attribute texts. |
| Web-developers / integrators | Ready-made, cleanly written solution without frameworks, easy to customize for any task. |
| Marketplaces / multivendors | Translate attributes of thousands of products from different sellers into a single format. |
| Large catalogs (10k+ products) | CLI-mode and query limitation allow to translate massive data without server crash. |
Technical requirements for hosting / server:
PHP - 7.3+
PHP extensions - mysqli, curl, json, session
MySQL / MariaDB - 5.7+
Web Server - Apache / Nginx + mod_php / PHP-FPM
Database Access - Read/Write to oc_product_attribute table
CPU + RAM Resources - 1 vCPU, 1 GB RAM (for 10-30 thousand attributes. attributes)
Disk space - 200-500 MB (logs + JSON files)
Cron (optional) - Access to PHP CLI
External APIs - Microsoft Azure Translator API (key + region)
Telegram (optional) - bot token + chat ID
Write permissions - In the folder with the script to write (logs, JSON)
HTTPS support - Not required, but recommended for authorization security.
You get:
- Full source code (PHP, HTML/CSS, SQL schema is not required - working with existing ocStore table).
- Free consultation on the first launch.
- Possibility of customization for specific wishes (adding other languages, integration with Google Translate API, export, etc.).
Update:
| Function | Description | |
| Two types of translation | Attribute names + attribute values | |
| Separate statistics | Separate blocks for attributes and values | |
| Filtering by data type | Selection between values and attributes | |
| Filtering by yes those | Search for records translated on a specific date | Search for records translated on a specific date |
| Checked dates | Quality control with visual indication | |
| Icon tips | Intuitive interface | |
| Separate logs | translated_log_values.json and translated_log_attributes.json | |
| Separate statistics | translation_stats_values.json and translation_stats_attributes.json |
















