VBV Trading — FBA order-to-ship pipeline and carrier integration
End-to-end shipping automation: Excel (FBA orders) → carrier creation → labels and tracking, with split workflows and DPD conversion.
NextLogica delivered an end-to-end shipping automation system for VBV Trading. The FBA Order-to-Ship Pipeline takes Amazon FBA order data from Excel, creates shipments in the carrier system, downloads shipping labels, maps tracking numbers, and can convert carrier tracking numbers to DPD format. It supports full, partial (split), and selective processing of orders.
Main components: Full automation (Excel → carrier → labels → tracking mapping); split automation so users can select which boxes to process and get separate processed vs exception sheets; DPD converter to map carrier tracking numbers to DPD via the DPD site; template manager that uses existing carrier templates and fills reference fields from Excel; and a FastAPI web dashboard for uploads, workflows, downloads, and system health.
Tech stack: Backend — FastAPI, Uvicorn, Jinja2. Automation — Selenium with undetected ChromeDriver. Data — openpyxl, pandas. PDF — PyPDF2, ReportLab. Auth — HTTP Basic Auth, sessions, middleware. Infra — AWS Lightsail, Docker, systemd.
Portfolio highlights: Full-stack workflow (web UI → API → background automation); multi-workflow design (full, split, and DPD conversion); process safety with concurrency protection and locking; health monitoring and alerts; cloud deployment on AWS Lightsail with deployment docs; workflow diagrams (Mermaid), READMEs, and deployment guides; real-world carrier and DPD integrations; Excel and PDF parsing, generation, and tracking mapping.
