Introduction

FC Barcelona store is one of the futbol clubs with more online sellings all over the world, and consequently they deal every month with a lot of product returns and size changes. 

Objective

Making the management of all this operations easier for the ecommerce internal team. Sincronizing all the signups and notifications from the same shopify app platform, showing specific useful data information, and making it fast for them to manage some specific functions.

Data Analyst wants to see specific data

The fact of building an app from scratch with tailored functionalities allowed different departments of the client’s team to address their needs. From the team responsible for ordering new stock, to data analysts, to those in charge of ecommerce.

For example, the Data Analysis team was interested in quickly and easily viewing data such as the total number of signups per country or which products are in highest demand.

Signups per Country

The client needed to visually and quickly understand which countries the registrations were coming from, with the ability to filter by time. Since some products are launched in one country before others, this could help organize future launches.

Understanding the exact metrics (e.g., total signups, registrations per product variant, or demand trends) was crucial to avoid overloading the chart with irrelevant data, ensuring it remained clear and actionable. The client emphasized quick and easy interpretation, so prioritizing key metrics like registrations by country and time was essential.

Since the client wanted to evaluate product launches, which might occur at different times across countries, flexible time filters (e.g., custom date ranges or predefined intervals like monthly/quarterly) were necessary to analyze launch performance and product overlap effectively.

Most Wanted Products

The client needed to quickly see which products were in highest demand.

At first, a bar chart seemed like an interesting solution for this case, as it needed to show the products with the most registrations and the number of registrations each of them had.

But as we worked on it and understood the client’s needs, we realized that the data was not very relevant, as each product has size variants, and what a customer registers for is not the product notification, but a specific variant of that product. This insight made us realize that we needed to display more information than what the bar chart allowed.

So, we opted for a table that would allow us to expand the number of registrations by product variant.

Products Management

One of the main functions they needed to address with the app was the management of products that allow back-to-stock signups and those that do not allow customer registrations, either because they will not be restocked or because they have already received many customer registrations.

In this case, they needed a product list that would allow them to intuitively find a specific product and include or exclude it from the product list.

To achieve this, several alternatives were likely considered and discarded. The following are some examples with it’s reasoning why these options were not chosen:

1. Single List with Toggle Switch
   A single product list with a toggle to enable/disable signups.
   Why Discarded: Unwieldy for large catalogs, lacks clear category separation, and toggling is error-prone for bulk actions.
   –
2. Manual Entry System
   Users manually enter product IDs/names into signup-allowed or signup-excluded lists.
   Why Discarded: Time-consuming, error-prone, and inefficient for large catalogs; lacks visual feedback.
   –
3. Drag-and-Drop Interface
   Move products between signup-allowed and signup-excluded columns via drag-and-drop.
   Why Discarded: Cumbersome on mobile, performance issues with large lists, and less intuitive for some users.
   –
4. Filter-Based Interface
   A single list with filters to view signup-allowed or signup-excluded products.
   Why Discarded: Complex workflow, high cognitive load from filter management, and less direct for bulk actions.
   –

Final Solution:
We created a dual-list submenu with two product lists: the products that do allow signups, from which you can select the products you want to exclude and move them to the list of products that do not allow signups. And the list of excluded products, from which you can select those products you want to move to the list of products that do allow signups.

It is intuitive, scalable, and device-friendly, offering clear separation, easy product selection, and immediate feedback, addressing the shortcomings of the discarded options.