Transfer of the website from the old platform (Simpla) to the new one (OpenCar)
Client: Online electronics store (Antennas, GPS equipment).
Task: Transfer the blog and catalog of products, categories, and photos from the old CMS to the new one while preserving SEO positions and adding multilingual support (UA, EN).
Requirements:
* Outdated system: The source site on SimplaCMS did not have a full API, access was only direct to the MySQL database.
* Lack of content: The source data was only in Russian. The new site required high-quality Ukrainian and English translations.
* SEO risks: It was critically important to maintain the URL structure to avoid losing traffic from Google.
Solution: Instead of manual transfer, a custom ETL pipeline was developed in Python. The script connects directly to the old database, bypassing admin panel restrictions, and extracts "raw" data about products, price variants, and images.
Integrated Google Gemini API for automatic content translation (UA, EN).
Implemented GEO-optimization: AI generated unique meta-descriptions and marketing blocks tailored for the Ukrainian market.
Correction of "broken" meta-tags on the fly.
Automatic creation of the category and product structure in the new database.
Mapping paths to images (considering changes in folder structure on the server).
Transfer of old URLs (slugs) into the seo_url table of OpenCart for seamless redirection.
Additionally, a js script was integrated that automatically assigned a random rating (from 4.1 to 5 stars) to each product without physically adding product reviews.
Result: 100% automation. Over 150 product items were transferred in a matter of minutes after the script was written.
Time savings: Approximately 40-50 hours of manual work for the copywriter and content manager were saved.
Content quality: The site received literary translations and SEO-optimized texts without costs for a translation agency.
Preserved SEO: Links from the old site work correctly on the new one.
Technology stack: Python, Pandas, PyMySQL, Google Gemini API, OpenCart MySQL structure.
#python #AI #content-management #OpenCart
Task: Transfer the blog and catalog of products, categories, and photos from the old CMS to the new one while preserving SEO positions and adding multilingual support (UA, EN).
Requirements:
* Outdated system: The source site on SimplaCMS did not have a full API, access was only direct to the MySQL database.
* Lack of content: The source data was only in Russian. The new site required high-quality Ukrainian and English translations.
* SEO risks: It was critically important to maintain the URL structure to avoid losing traffic from Google.
Solution: Instead of manual transfer, a custom ETL pipeline was developed in Python. The script connects directly to the old database, bypassing admin panel restrictions, and extracts "raw" data about products, price variants, and images.
Integrated Google Gemini API for automatic content translation (UA, EN).
Implemented GEO-optimization: AI generated unique meta-descriptions and marketing blocks tailored for the Ukrainian market.
Correction of "broken" meta-tags on the fly.
Automatic creation of the category and product structure in the new database.
Mapping paths to images (considering changes in folder structure on the server).
Transfer of old URLs (slugs) into the seo_url table of OpenCart for seamless redirection.
Additionally, a js script was integrated that automatically assigned a random rating (from 4.1 to 5 stars) to each product without physically adding product reviews.
Result: 100% automation. Over 150 product items were transferred in a matter of minutes after the script was written.
Time savings: Approximately 40-50 hours of manual work for the copywriter and content manager were saved.
Content quality: The site received literary translations and SEO-optimized texts without costs for a translation agency.
Preserved SEO: Links from the old site work correctly on the new one.
Technology stack: Python, Pandas, PyMySQL, Google Gemini API, OpenCart MySQL structure.
#python #AI #content-management #OpenCart
Vinnytsia 
Available for hire
Offer work