Helping a Retail Team Gain Data Insights with an AI-Enabled Solution

The project equipped Claudia&Julia with a scalable data foundation connecting Shopify, Supabase, and Julius.ai. Through automation and intuitive AI-enabled analytical tools, the retail team at Claudia&Julia can now monitor, understand, and optimize inventory and other data-related operations without requiring a dedicated data scientist.

Client

Claudia&Julia is an online retailer specializing in premium kitchenware and home goods. Founded in 2012, the brand has built a loyal following thanks to its focus on quality, design, and customer trust.

The team wanted to improve how they managed and analyzed stock data across multiple product categories. Without an in-house data scientist, they engaged Agent Studio to design and implement an automated, AI-powered data infrastructure capable of centralizing, synchronizing, and analyzing their e-commerce transactional data using AI to extract actionable insights with minimal manual effort.

Objective

A flexible and easy-to-maintain architecture was required so that Claudia&Julia could operate it independently, with minimal dependency on Agent Studio.

After evaluating several alternatives and approaches, the AI analytics platform best suited to the client’s needs was selected: Julius.ai proved to be the optimal fit between functionality and ease of use.

In parallel, an integrated data workflow was created to connect Shopify and Supabase. This setup was designed independently of the analysis layer, allowing future replacement of Julius.ai if necessary.

Work

1. Shopify connection with Supabase via n8n
   A secure, automated pipeline was built using n8n workflows to link Shopify APIs with Supabase.

2. Historical e-commerce transactional data ingestion
   Two years of Shopify transactional history were imported, ensuring clean field mapping and consistent data structure.

3. Automation and data synchronization workflows
   n8n workflows were designed to continuously update and maintain Supabase as a single source of truth, synchronizing transactional, pricing, and inventory data every 24 hours.

4. Initial Julius.ai implementation and configuration
   Julius.ai was configured with Supabase as a connected data source, enabling the team to analyze e-commerce and inventory data through natural language queries.

5. Creation of the first test notebooks in the client’s Julius account
   Initial notebooks were developed for exploratory analysis of stock levels and recommended orders, helping the team extract insights without coding.

6. Training on Julius.ai best practices
   Personalized sessions were held to help the team learn the best ways to use the tool effectively and identify its current limitations based on extensive testing.

Results

• Full automation between Shopify and Supabase, eliminating manual steps.
• Daily data validation ensuring up-to-date and consistent stock information.
• Historical visibility across two years of e-commerce transactional data.
• Analytics access for non-technical team members via Julius.ai notebooks.
• Operational efficiency enhanced through proactive, data-driven insights.

Testimonial

“We’re extremely happy with how the project with Agent Studio has gone. They perfectly understood our needs from the very beginning, and we felt fully supported throughout the entire process. The delivered solution exceeds our expectations; it’s going to be incredibly useful for our operations and will add great value to the company. We’re very satisfied with the collaboration and look forward to continuing to develop new projects together.”

Jordi Manero

Co-founder - Claudia&Julia

👉 Do you have issues answering questions about your own e-commerce? Maybe we could help!