Updating existing and adding new products on Prom.

Prepare an import file with products that had a complex fragmented structure (separate tables for characteristics, photos, and descriptions) and was not suitable for direct upload to the marketplace. Some products had already been added to the site, with many having incorrect descriptions or translations, and some did not have all photos uploaded.

What has been done:
1. Developed a Python script to consolidate data from various sources into a single import file.
2. Implemented automatic transfer of characteristics (sizes, materials) into the corresponding fields of Prom.
3. Set up category mapping for the correct distribution of products according to the marketplace structure.
4. Using AI, generated updated product names, descriptions, titles, and all information placed in a valid XLSX file, which successfully passed the import and created correct product cards.

Stack: Python, Pandas, Excel Automation, API Gemini

#python #AI #promua #Online-store