We will be undergoing planned maintenance on January 16th, 2026 at 1:00pm UTC. Please make sure to save your work.

Switch Market

AI That Keeps Shelves Clear and Profits High

Comment

Inspiration

Every year, billions of dollars’ worth of goods go unsold and often end up heavily discounted or dumped as waste. At the same time, those very products might be in demand in other regions. We were inspired by this disconnect and wanted to solve the mismatch between surplus and demand. Our vision: a system that keeps shelves clear, maximizes revenue, and prevents products from turning into landfill.

What it does

Switch Market is an AI-powered inventory and sales management platform that:

  • Forecasts product demand to prevent overstocking.
  • Identifies slow-moving products before they expire or lose value.
  • Suggests redistribution to regions where demand is higher.
  • Provides intelligent discounting strategies to boost clearance sales.
  • Uses Gemini API for natural language interaction with databases, so users can ask inventory questions in plain English instead of writing complex queries. user can simply ask: “Which products had the highest unsold stock last quarter?”

How we built it

  1. Inventory System: Used WordPress + WooCommerce as the backbone for managing products, stock levels, and transactions.
  2. Data Pipeline: Pulled inventory and sales data into a structured database.
  3. Forecasting Models: Implemented ARIMA, Prophet, and LSTM models for demand prediction.
  4. Natural Language Database Queries: Integrated Gemini API so users can query inventory in plain English.
  5. Dashboard: Built an interactive web interface that combines forecasts, redistribution suggestions, discount strategies, and insights.

Challenges we ran into

  1. Data integration between WooCommerce, databases, and Gemini API.
  2. Limited access to real retail datasets, so we simulated realistic sales data.

Accomplishments that we're proud of

  1. Successfully combining forecasting, e-commerce integration, and LLM-powered queries into one system.
  2. Building a seamless link between WooCommerce inventory and AI-powered analytics.
  3. Enabling non-technical users to manage inventory and gain insights without writing SQL queries.
  4. Creating an end-to-end prototype in a short timeframe.

What we learned

  1. How to integrate AI with existing e-commerce platforms like WordPress and WooCommerce. 2.How LLMs like Gemini can turn complex data interactions into natural conversations.
  2. The importance of balancing technical complexity with usability for business adoption.
  3. That sustainability can also mean business sustainability reducing waste while protecting profits.

What's next for Switch Market

  1. Expand Gemini integration for voice-driven inventory management.
  2. Pilot with real retailers using WooCommerce for live data testing.
  3. Add multi-market redistribution optimization, factoring in transport and timing.
  4. Develop a mobile-first app to make it accessible for small and medium businesses.
Share this project:

Updates