RaportFeed
A high-performance desktop application built in Python and WebView2 that automates multi-supplier XML feed ingestion, real-time stock/price synchronization via Allegro REST API, and prevents catastrophic pricing errors through intelligent bundle detection and cryptographic licensing.
📦 RaportFeed
Automated E-commerce Inventory & Price Synchronization Engine
📌 Overview
RaportFeed is a production-grade Windows desktop application engineered for high-volume e-commerce merchants operating on Allegro (Poland’s leading marketplace). The platform bridges multi-supplier B2B XML feeds with live marketplace offers, handling automated price reconciliation, stock management, and critical financial safety checks.
Built with a dual-layer architecture combining a Python core and a Microsoft Edge WebView2 (Chromium) frontend, RaportFeed delivers native desktop performance paired with a sleek, reactive dashboard interface.
🚀 Key Technical Challenges & Solutions
1. Financial Safety & “Price Drop Guard”
- The Problem: Automated dropshipping synchronizations often misidentify product bundles (e.g., selling a 2-pack at single-item wholesale prices) or propagate upstream wholesaler pricing typos, resulting in severe financial losses.
- The Solution: Engineered a heuristic Price Drop Guard:
- Employs NLP-based keyword and title analysis to identify multipacks (
2-pack,zestaw x2/x3) and automatically adjusts base price multipliers. - Implements an anomaly threshold (intercepting drops >40%) that halts unauthorized batch updates and requires explicit merchant confirmation.
- Employs NLP-based keyword and title analysis to identify multipacks (
2. Fault-Tolerant State Management & 1-Click Rollback
- Implemented a transactional snapshot engine before every batch dispatch.
- If any discrepancy occurs, users can execute an instant 1-Click Rollback, restoring previous marketplace states without manual intervention.
3. Enterprise Asymmetric Cryptography (Licensing)
- Designed a custom, zero-dependency licensing mechanism using Ed25519 digital signatures (
cryptographylibrary). - Client applications verify tamper-proof signed license tokens offline via the author’s embedded public key, while supporting remote invalidation (Kill-Switch) and automatic client-side updates via GitHub Gist REST API.
4. Modern Desktop Architecture (Python + WebView2)
- Built a single-executable standalone bundle (
.exe) embedding HTML5, Tailwind CSS, Lucide Icons, and Chart.js via pywebview. - Eliminates heavy browser overhead (unlike Electron) by utilizing the OS-native Chromium engine, resulting in sub-second startup times and <90 MB RAM usage.
🛠️ Tech Stack & Architecture
- Core & Backend: Python 3.11+, Multi-threading, Requests, urllib3, Packaging
- Marketplace Integration: Allegro REST API (OAuth2 Device Code Authorization flow)
- Frontend / UI: Microsoft Edge WebView2, HTML5, Tailwind CSS, Chart.js, Lucide Icons
- Security & Crypto: Ed25519 (Asymmetric Digital Signatures), PKCS#8
- Packaging & Distribution: PyInstaller (Single-file binary distribution, atomic self-updating engine)
- Data Processing: Streaming XML/CSV parsing, openpyxl, pandas