SFTP CSV Import Dual PrestaShop Stores
Full product catalog synchronization from CSV via SFTP to two PrestaShop stores, with manufacturer mapping, feature handling, and pricing management.
SFTP
CSV delivery
SyncEngine
14 flows · 27 routines
PrestaShop
2 stores
2
Shops
2
Automations
14
Flows
27
Routines
Data Ingestion
CSV Processing
- Full CSV import from SFTP server
- Separate SFTP connections per store
- Production + ACC (staging) environment support
- Automatic manufacturer, feature, and feature value storage updates
Data Transformation
- Set correct data format per language (EN/NL)
- Map features and feature values to PrestaShop IDs
- Merge categories with fallback to default category
- Remove unwanted characters and filter empty categories
Product Synchronization
Manufacturer Management
- Automatic manufacturer creation if not exists
- Manufacturer storage updated per import cycle
- Brand mapping from CSV data
Features & Categories
- Feature mapping from prefixed colums to PrestaShop IDs
- Separate EN and NL feature handling with filtering
- Category merging with format conversion
- Product feature removal when no features available
Pricing & Environment
Price Management
- Comma-to-dot price format conversion (EUR)
- Price exclusion calculation
- Specific prices update per product
- Language-aware pricing (EN/NL)
ACC Staging Environment
- Full ACC mirror of production automations
- ACC SFTP connections per store
- ACC PrestaShop connections
- Complete feature value and manufacturer sync in staging
Architecture Overview
CSV data delivered via SFTP, processed through SyncEngine, and synchronized to two PrestaShop stores plus ACC staging environments.
SFTP Server
CSV delivery
SyncEngine
CSV processing · Feature mapping · Price handling
PrestaShop Stores
2 stores + ACC staging
Store Architecture
Two PrestaShop stores with production + ACC environments.
store-a.com
Store A (Production)
store-b.com
Store B (Production)
staging-a.com
Store A ACC (Staging)
staging-b.com
Store B ACC (Staging)
Technologies & Connections
PrestaShop REST API
SFTP (SSH File Transfer)
CSV Processing & Parsing
Manufacturer Management
Feature Mapping
Specific Prices
Multi-Language (EN/NL)
ACC Staging Mirror
Category Merging
Price Format Conversion
See SyncEngine in action
Discover how SyncEngine can handle your data synchronization needs.