Why Did I Build This?
"Manually transferring thousands of product variations (frames, albums, magnets) from an Ikas storefront to Trendyol is highly prone to human error and massively time-consuming. Trendyol requires strict formatting, specific category codes, and commission-adjusted pricing. I built this automation bot to completely eliminate manual data entry. It parses the raw Ikas CSV, applies complex heuristic filters to categorize items, automatically recalculates prices based on commission rates, and injects the formatted data directly into Trendyol's proprietary `.xlsx` templates."
Architecture & Decisions
The script utilizes `pandas` for high-speed, vectorized CSV ingestion and filtering. Products are routed into specific in-memory DataFrames (Frames, Albums, Magnets, Digital Prints) using RegEx masking to prevent overlap. Custom heuristic functions parse unstructured product names to extract metadata like dimensions, colors, and materials. The transformation pipeline computes pricing margins dynamically. Finally, `openpyxl` accesses the target `.xlsx` template sheets, maps the structured data to Trendyol's strict column headers, and saves the bulk-upload-ready files without disrupting the original Excel formatting.
Key Features
- 01.Automated parsing and routing of Ikas CSV exports into distinct product categories
- 02.Heuristic string analysis via Regex to extract dimensions and localize color/material metadata
- 03.Dynamic margin and commission recalculation pipeline
- 04.Direct I/O writing to proprietary `.xlsx` bulk upload templates via `openpyxl`
- 05.Strict SKU formatting and automated barcode standardization
This project serves as a robust bridging utility between disjointed e-commerce architectures. By treating the migration process as a strict data pipeline, the script ensures absolute data integrity. The complex regex-based extraction logic successfully parses unstructured user-input strings into cleanly localized columns, proving that heavy administrative overhead can be reliably solved with targeted Python automation.