Gambio FTP Stock Sync Script
Budget: €30 – €250 EUR
My Gambio-based shop needs a small automation layer that pulls product data and images from two separate FTP servers, merges everything into a single CSV ready for the Gambio importer, and then keeps stock figures perfectly in sync. The feeds on the servers change roughly every 30 minutes, so the script must connect on that schedule, download the fresh CSV files, spot any new or removed SKUs, and update quantities accordingly.
Images only need a full download the first time; afterwards the solution should compare timestamps or hashes so that files are fetched again only when the related product information has changed. The whole workflow will run through cron, so every step—from grabbing the files to dropping the final importable CSV in a target folder—has to execute unattended.
I am not tied to any particular naming convention for either data files or images and would welcome sensible guidance here. What matters is that the resulting dataset imports cleanly into Gambio without manual tweaks and that adding an extra supplier later on is a straightforward configuration change rather than fresh development work.
Error handling is essential: please have the script write a clear, rotating log file describing any connection problems, malformed rows, or image mismatches so I can review issues at a glance.
Deliverables
• A well-documented script (Python, PHP, or similar) that:
- Connects to two FTP servers, authenticates, downloads product CSV and images
- Runs every 30 minutes via cron, updating stock, adding new items, and flagging deletions
- Performs a one-time full image pull and subsequent change-based updates
- Outputs a consolidated, Gambio-ready CSV in UTF-8 with correct field mapping
- Writes human-readable log files for any errors or anomalies
• Clear setup instructions plus notes on how to plug in additional suppliers later
Once this is in place I’ll test the import on a staging shop; acceptance is a successful, error-free cron run that loads the updated catalogue in Gambio with accurate stock and images. I’m open to your time estimate and any suggestions that make the system more scalable.
Images only need a full download the first time; afterwards the solution should compare timestamps or hashes so that files are fetched again only when the related product information has changed. The whole workflow will run through cron, so every step—from grabbing the files to dropping the final importable CSV in a target folder—has to execute unattended.
I am not tied to any particular naming convention for either data files or images and would welcome sensible guidance here. What matters is that the resulting dataset imports cleanly into Gambio without manual tweaks and that adding an extra supplier later on is a straightforward configuration change rather than fresh development work.
Error handling is essential: please have the script write a clear, rotating log file describing any connection problems, malformed rows, or image mismatches so I can review issues at a glance.
Deliverables
• A well-documented script (Python, PHP, or similar) that:
- Connects to two FTP servers, authenticates, downloads product CSV and images
- Runs every 30 minutes via cron, updating stock, adding new items, and flagging deletions
- Performs a one-time full image pull and subsequent change-based updates
- Outputs a consolidated, Gambio-ready CSV in UTF-8 with correct field mapping
- Writes human-readable log files for any errors or anomalies
• Clear setup instructions plus notes on how to plug in additional suppliers later
Once this is in place I’ll test the import on a staging shop; acceptance is a successful, error-free cron run that loads the updated catalogue in Gambio with accurate stock and images. I’m open to your time estimate and any suggestions that make the system more scalable.
Related categories:
PHP
Python
Software Architecture
MySQL
Image Processing
Scripting
Documentation
Automation