ProductImporterPro

ProductImporterPro is a full-stack bulk product import platform for e-commerce-style catalogs. It allows you to upload CSV files, process them asynchronously, and manage products with a modern React UI and real-time progress updates.

Features

• CSV upload with drag‑and‑drop and server‑side validation = Asynchronous bulk import with progress bar and history
• Product listing, filtering, and management
• Webhook support for integration with external systems
• Production‑ready deployment using containers and a managed PostgreSQL service

Tech Stack

• Frontend: React, Vite, TypeScript
• Backend: FastAPI (Python), SQLAlchemy
• Database: PostgreSQL (Aiven managed instance)
• Async & Queue: Celery, RabbitMQ, Redis (results/progress cache)
• Infrastructure: Docker, Railway (containers + orchestration)

Why this stack?

• React + TypeScript – Type‑safe, component‑based UI with great DX and easy state management.
• FastAPI + SQLAlchemy – Fast async APIs, automatic docs, and a clean ORM layer for PostgreSQL.
• Celery + RabbitMQ + Redis – Reliable background job processing for large CSVs without blocking requests.
• PostgreSQL – Stable relational store with strong SQL support and indexing.
• Docker + Railway – Reproducible builds and one‑click deployment of all services.

Architecture components

Component	What it does in ProductImporterPro	Connects to	Why it’s used (benefit)
React (Vite) Frontend	Upload CSV, show task history, display live progress via SSE, manage products & webhooks.	FastAPI (HTTP + SSE).	Fast UI, great DX, real-time progress UX.
FastAPI Backend	Receives uploads, creates UploadTask, stores CSV bytes in Redis, enqueues Celery job, streams progress from Redis via SSE, exposes CRUD APIs.	React, Redis, RabbitMQ, PostgreSQL.	Async-friendly APIs, clean validation, keeps requests fast.
RabbitMQ	Message broker that queues Celery jobs (import, trigger_webhooks, delete_all_products).	FastAPI (publish), Celery Worker (consume).	Reliable async job queue; lets you scale workers independently.
Celery Worker	Runs heavy jobs: retrieve CSV from Redis, parse/validate/dedupe, bulk upsert into Postgres, update progress in Redis, trigger webhooks.	RabbitMQ, Redis, PostgreSQL.	Offloads long tasks; avoids API timeouts; supports retries/time limits.
Redis	1) Temporary CSV storage (csv_upload:{task_id}) with TTL. 2) Progress store (progress:{task_id}) for SSE.	FastAPI, Celery Worker.	Very fast reads/writes + TTL; ideal for progress updates & temp data.
PostgreSQL (Aiven)	Persistent storage: products, upload_tasks, webhooks. Tracks final counts/status and holds the actual product catalog.	FastAPI, Celery Worker.	Durable source of truth; powerful querying/indexing.

Railway cloud Architecture

Frontend Webpage Designs

• Home Page UI

• File upload progress tracker UI

• Products Tab

• Webhook tab

• Webhook response example with https://webhook.site

Feel free to explore the project using the link below:

https://product-importer-frontend-production.up.railway.app/