Ciovita | Automated, AI-Driven Return Management System
Project Showcase

Ciovita | Automated, AI-Driven Return Management System

Redefining the return experience through intelligence and automation.

By: Qiraan Christians , Tim Gultig , Glen Okech , Onthatile Mabe

Supervised by: Dirk Snyman

In partnership with: Ciovita


About

Abstract

The Ciovita Integrated Returns System is a full-stack web application designed to streamline and modernize the product returns workflow for Ciovita, a cycling apparel company. The primary business requirement was to replace a manual, inefficient returns process with a centralized system that integrates directly with Shopify. This new system aims to improve return accuracy, reduce the returns turnaround time, and increase the speed at which returns are processed. 

Our proposed solution is a robust, containerized application with a secure, JWT-based authentication system for staff and administrators. The system features a user-friendly interface for processing returns and exchanges, searching for customer orders in real-time, and managing inventory. A key component is the administrative dashboard, which offers powerful tools for managing stores and user accounts, as well as a suite of analytics for tracking return trends, identifying frequently returned products, and understanding the reasons for returns. 

The application is built on a modern tech stack, with a FastAPI backend that utilizes GraphQL for efficient data queries and a PostgreSQL database managed by SQLAlchemy and Alembic. The frontend is a responsive Next.js application, ensuring a fast and intuitive user experience. The entire system is containerized with Docker, which simplifies both development and deployment. 

Major features of the system include: 

  • Seamless integration with the Shopify API. 

  • A comprehensive returns and exchange management dashboard. 

  • An advanced analytics suite to provide actionable insights into return data. 

  • A customer-facing portal for initiating returns. 

  • A machine learning model for predicting future return volumes. 

In conclusion, the Ciovita Integrated Returns System provides a scalable and maintainable solution that successfully streamlines the returns process. By centralizing returns management and leveraging data analytics, the system has drastically reduced the time to log a return from 7 minutes to approximately 30 seconds. This significant improvement in efficiency, combined with enhanced data accuracy and valuable insights, ultimately leads to a better customer experience and more informed business decisions. 

 

Videos 1

Watch presentations, demos, and related content

Documents 1

Downloadable resources and documentation

Click "View Full" to open documents in a new window

Gallery 2

Explore the visual story of this exhibit