Subiekt ERP integration system ↔ PrestaShop 8 e-commerce channel

For the Elektrokram wholesaler, I implemented a comprehensive project to modernize and digitize sales processes – from the environment architecture, through ERP integration, to the implementation of an online store. The starting point was the local Subiekt GT database containing over 4,000 products, which until then had operated exclusively offline.

Project Description

I created an integration system that serves as a “middle layer” between the wholesaler and the online store. The system periodically retrieves and processes data from the local database (MSSQL), normalizes it, and stores it in the PrestaShop 8-based store – along with inventory levels, prices, descriptions, images, manufacturers, and product features.

The integration works bidirectionally: orders from the store are automatically transferred to Subiekt, and the sales department has immediate insight into online sales. The entire system has been optimized for performance and security, powered by reporting mechanisms, cron, logs, and automatic notifications.

Finally, I coded the frontend, advanced store search, a responsive version in Bootstrap, SEO optimization, and VPS server configuration.

Key Features:

  • Two-way Subiekt ↔ PrestaShop 8 integration
    Automatic data exports and imports in cron cycles.
  • Support for full product data
    Descriptions, images, prices, categories, manufacturers, technical features, SKUs.
  • Real-time inventory synchronization
    Downloading data from Subiekt and updating the store.
  • Automatic order processing
    Orders from the store go directly to the ERP.
  • Advanced product search
    Filtering by features, technical parameters, and manufacturers.
  • PrestaShop 8 store implementation
    Proprietary frontend, layout, optimizations, and UX improvements.
  • Security, performance, and stability
    Implementation of logging, error reporting, and data validation.
  • Technical SEO and speed optimization
    Caching, compression, template and query optimization.

My role:

  1. System architecture and integration design,
  2. Frontend, backend, and integration logic development (PHP),
  3. MSSQL → MySQL data processing and mapping,
  4. ETL mechanism and multi-stage validations,
  5. PrestaShop modifications to meet custom requirements,
  6. Server configuration, SEO, performance and security optimization,

Results:

  • Full automation of processes that previously took many hours per week,
  • Up-to-date inventory and prices in the store 24/7,
  • Elimination of manual product handling errors,
  • Increased sales and streamlined sales department operations,
  • A stable, fast, and optimized online store.

Technologies and Tools

HTML, CSS, PHP, MySQL, MSSQL, PrestaShop 8, JavaScript, Bootstrap, AJAX, cron, cURL
Apache/Nginx, Linux, git, performance optimization, ETL, logging and monitoring, application security.

See other projects