Atribute Translator - translation of attribute values for ocStore 3.0.3.7

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:

1. Automatic translation of attributes RU → UA, RU → EN via Microsoft Azure Translator (high quality, support for technical terms).
2. Web interface with authorization, statistics, filtering and pagination
3. .Manual editing of translated attributes directly from the browser
4. .Mass saving / deleting of selected records.
5. Filtering by product ID, attribute ID, language, text, and "Pending translation" status.
6. Search for existing translations in the database and add them to the log, so as not to waste API requests repeatedly
7. .CLI-script (cron_translate.php) to run by cron - translation in the background.
8. Telegram-notifications about translation session completion (number of translated attributes, execution time, progress).
9. Limiting requests to API (protection from quota exceeding).
10. Logging of all actions
11. .
with log rotation (by day and file size).
12. Support of two interface languages - Ukrainian and Russian (it is easy to add others).
13. Security: sessions, HTTP-only cookies, authorization, SQL injection protection via prepared queries
.

Who it is useful for:

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: