Store Feed Import - Retailer Feed Processor

Backend (.NET)

About

A cron-style .NET service that pulls retailer store feeds (products, pricing) via FTP, ingests them into each chain's SQL database, generates reports, and surfaces downstream sync events and alerts.

My Role

Developed a feed import service handling product/pricing feeds from retailer FTP into SQL per chain. Automated reporting back to retailers via FTP archives and messaging into RabbitMQ. Implemented error reporting via SendGrid emails.

Core Capabilities

• Feed lifecycle automation: download, transform, load, report upload, message publish
• Multi-chain handling with restricted chain runs for staggered schedules
• Error visibility through email alerts and operational logging

Architecture

• .NET console app with command-line args for env/chain
• FTP connectivity for feed download and report upload
• SQL Server (StoreTracker + chain DBs) for data persistence
• RabbitMQ fan-out and SendGrid for notifications

Tech Stack