Portfolio Case Study

Pipo Hub

Internal business application built to replace a fragmented product creation workflow with a clear, structured and scalable platform.

Python Dash SQL Database JavaScript Fabric.js
Application Demo

A short walkthrough showing the complete workflow: authentication, product creation, supplier setup, logistics, media management, image editing, pricing and validation.

The Challenge

Product information was spread across too many tools.

Before Pipo Hub, product information was spread across Excel files, supplier documents, product images, PDF documentation and internal back-office systems.

This fragmented process created repetitive manual work, increased risk of data-entry errors, lack of consistency between products and longer product creation times.

Before Pipo Hub workflow
Before Pipo Hub workflow

The Solution

A centralized platform for the full product creation process.

Guide users through a structured workflow
Reduce manual errors
Standardize product information
Improve productivity
Ensure data quality before publication
Pipo Hub home dashboard
Home dashboard

Architecture

Interactive architecture showcase.

Selected system layer

    Main Features

    Clear modules for each business need.

    Secure Authentication

    Access to the platform is protected through a dedicated authentication system.

    Login page screenshot

    Supplier Management

    Manage suppliers, purchase prices, supplier references and sourcing information directly from the application.

    Supplier section screenshot

    Logistics Configuration

    Configure VAT, eco-fees, logistics costs, delivery lead times and barcodes.

    Logistics section screenshot

    Product Content Management

    Centralize descriptions, categories, technical attributes, media files and Google Shopping content.

    Content section screenshot

    Integrated Image Editor

    Preview, crop, resize, reposition and automatically name image files, powered by Fabric.js.

    Image editor screenshot

    Pricing & Margin Calculator

    Simulate selling prices, calculate margins, manage marketplace pricing and apply commercial rounding rules.

    Pricing calculator screenshot

    SQL Database & Product History

    Store products in a centralized SQL database with modification history, traceability and version tracking.

    Product history screenshot

    My Contribution

    End-to-end project ownership.

    Product Design

    Designed the complete product workflow and business structure.

    95%

    Backend Development

    Built business logic, validations and workflow orchestration.

    95%

    Frontend Development

    Created the guided interface, custom styling and user feedback.

    90%

    Database Design

    Structured SQL storage, product history and traceability.

    88%

    UX/UI Design

    Designed readable screens, cards, progression and layout logic.

    92%

    Business Analysis

    Translated operational pain points into product features.

    90%

    Automation

    Reduced manual actions with structured rules and calculations.

    85%

    Image Processing

    Integrated media preview, editing and automatic file naming.

    87%

    Impact

    Business value dashboard.

    Products Created

    0 Centralized product records created and managed through the platform.

    Creation Speed

    0 Faster average product creation compared with the previous fragmented workflow.

    Modification Speed

    0 Faster product updates thanks to centralized data and structured forms.
    0%

    Data Entry Errors

    Reduced manual entry issues through validations and guided workflows.
    0%

    User Adoption

    Strong adoption due to a clearer interface and centralized workflow.
    0%

    Data Completeness

    Improved quality thanks to mandatory fields and final validation checks.

    Pipo Hub transformed a fragmented workflow into a centralized product creation platform, improving speed, reliability, data quality and long-term scalability.