Integration with TorgSoft -> Shopify

Integration between the accounting system Torgsoft and the Shopify platform to combine two systems: offline warehouse with online store. Motivation — to adapt products from Torgsoft (with their data structure) to the requirements of Shopify, creating product variants, groups, and custom fields. This allows for automatic export of the catalog without manual adjustments, saving time on processing stock, prices, and photos. Similar adaptations can be made for other accounting systems (for example, 1C) and platforms (WooCommerce).

What was implemented and for what purpose
FTP for export from Torgsoft: Set up a server for automatic receipt of CSV and images — ensures secure access and data transfer without manual copying.

Product and variant adaptation: The parser creates product groups, unique IDs, variants (colors, sizes), and custom solutions according to Shopify requirements (Handle, Title, Variants) + client requests (transliteration, tags) — makes the data compatible, minimizing import errors.

Web server for photos: Deployed under IIS with WSGI on Windows Server for generating image URLs — photos are immediately ready for Shopify, without external services.

Notifications in Telegram: The script sends reports with files and statistics (number of SKUs, processing time) — helps the team quickly understand the status of the export.

Archiving and logs: Everything is archived to track conflicts (name errors, duplicates); detailed reports record exports, creation of variants and fields — simplifies auditing.

Technologies: Python 3, Pandas, Flask (WSGI), FTP, Telegram API, Hashlib.

The solution is flexible: easy to add fields or integrate with other systems.