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 Product Attribute Translation for ocStore 3.0.3.7

Attribute Translator is a professional PHP script for automatically translating product attribute values (sizes, colors, characteristics, etc.) from Russian into Ukrainian and English. The solution was created specifically for owners of online stores based on the ocStore 3.x engine who need to quickly and efficiently localize product cards without manual copying and hiring translators.

The script uses the Windows Azure Translator API (high-quality neural network translation), 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 entries);
• Translates them through Microsoft Azure Translator into Ukrainian and/or English;
• Saves translations to the same table (by adding or updating records);
• Keeps a detailed log of translated records and statistics;
• Provides a user-friendly web interface in Russian or Ukrainian.
• The script is written without frameworks, runs on a standard LAMP stack and does not require modification of the ocStore core.
  
  

Features:

1. Automatic translation of RU → UA, RU → EN attributes 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. Bulk save/delete selected records.
5. Filtering by product ID, attribute ID, language, text, as well as by the "Waiting for translation" status. Selection of records translated on a specific day.
6. Search for existing translations in the database and add them to the log so as not to waste API requests again.
7. CLI script (cron_translate.php) for running on cron — translation in the background.
8. Telegram notifications about the end of the translation session (number of translated attributes, execution time, progress).
9. Limit API requests (protection against quota excess).
10. Logging of all actions with log rotation (by day and file size).
11. Support for two interface languages – Ukrainian and Russian (it is easy to add others).
12. Security: sessions, HTTP-only cookies, authorization, SQL injection protection through prepared requests.

Who is useful:

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 table oc_product_attribute
CPU resources + RAM - 1 vCPU, 1 GB RAM (for 10-30 thousand attributes)
Disk space - 200-500 MB (logs + JSON files)
Cron (optional) - Access to PHP
CLIExternal APIs - Microsoft Azure Translator API (key + region)Telegram (optional)
- bot token + chat ID
Write permissions - In the folder with the write script (logs, JSON)
HTTPS support - Not required, but recommended for authorization

securityYou get:

• Full source code (PHP, HTML/CSS, SQL schema not required - work with the existing ocStore table).
• Free consultation on the first launch.
• The ability to modify for specific wishes (adding other languages, integration with Google Translate API, export, etc.).
  
  

Diagnostics and maintenance (setup_sqlite.php)

• Installing the SQLite database: - Creating tables for translation logs, statistics and marked dates
• Full diagnostics: - Checking: SQLite size, number of entries, PHP settings, extensions, connection to MySQL, Cron status, access rights, database integrity, Telegram bot
• Cleaning up deleted items: - Finding and deleting translation records for items that have been removed from the store (frees up space)
• VACUUM optimization: - Compressing the SQLite file after deleting the entries
  
  

Installation

Step 1. Upload files

Copy all script files to a separate folder on the server (e.g., /public_html/attribute/)

Step 2. Configure config.php

Edit the file config.php:

MySQL connection data (ocStore database)

define('DB_HOST', 'localhost');

define('DB_USER', 'your_user');

define('DB_PASS', 'your_password');

define('DB_NAME', 'base_name');

define('DB_PREFIX', 'oc_');

Login details for the script admin panel

define('ADMIN_USER', 'admin');

define('ADMIN_PASS', 'your_password');

Azure Translator API key

define('AZURE_KEY', 'your_key');

define('AZURE_REGION', 'westeurope');

Telegram bot (optional)

define('TELEGRAM_BOT_TOKEN', 'token_bot');

define('TELEGRAM_CHAT_ID', 'your_chat_id');

Step 3. Installing the SQLite database

Open in your browser: http:// your_site/attribute/setup_sqlite.php

Click "Install / Reinstall" - the translation_data.sqlite database will be created automatically.

Step 4. Check

Go to: http:// your_site/attribute/index.php — log in with your login/password from config.php.

Step 5. Setting up Cron (for automatic translation)

# Converting values into Ukrainian (every 15 minutes)

*/15 * * * * php /path/to/folder/cron_translate.php uk values

# Translating values into English

*/15 * * * * php /path/to/folder/cron_translate.php en values

# Translating attribute names into Ukrainian

*/15 * * * * php /path/to/folder/cron_translate.php uk attributes

# Translating attribute names into English

*/15 * * * php /path/to/folder/cron_translate.php en attributes

Recommended PHP settings

max_execution_time - 3600 (for web) / 900 (for cron)

memory_limit - 512M

Licensing The

script is protected by a license key. The license.key file must contain a SHA256 hash from the domain.

Update: 

*The script is designed for ocStore 3.0.3.7, but can work with other versions of OpenCart/ocStore if the structure of the tables is the same.*