Case Study

Devox: Product Return Management Desktop App

Devox is a software created to manage the returns of products in DHL warehouse, through a system that manages and manages the Database of products, customers, returns and everything related to it.

My role

Developer & Designer

Team

Juan Capiz Castro and me

Time

From January 2016 to March 2017

What I used here

MySQL DB, Java (Back-end), Java Swing (Front-end)

Motivations

Abbot Laboratories in Mexico City needed a system in their storage location (DHL Mexico City Warehouse) to administrate their returned items. Before Devox, they used MS Access to admin their database outputs and inputs.

The warehouse is located in Mexico City

Research

After doing Interviews directly in DHL with users that manage the returning process directly in the warehouse, I found out the following process:

  • There is only one type of user.
  • The user receives certain boxes with products. This user must capture with his code-reader the code bar in the product. The system must save it in an specific order for its future track
  • New Refund. Open a new panel to create a new return page and insert products.
  • Returns. Open a panel with the list of the last 10 returns. You can see more returns and look for some in particular by folio number. The sum of returns per state is also displayed.
  • Reports. Shows listings and counts of the segregated returns by day (today), current week and current month. You can generate reports segregated by dates and export them.
  • Status. Returns segregated by state. You can change status and print reports.
  • Prices. Open a panel with the list of current prices of products. There are also options to see prices per page, insert new prices and update prices.
  • Platforms. Shows and administers the returns items.
  • Catalogs. It opens a panel with the option to view and manage the entities of the system, such as Clients, Products, Lots, Warehouses, Sales channels, Divisions, Reasons and Transports.

Design

For this project, I developed an on-site application in Java (backend) and Java Swing (front-end). This made my journey to bring up a project a real nightmare! Nevertheless, I tried to use Java Swing to give a web-alike UI for the user and make it as clean as possible.

Mail me
Made in Webflow