Account email used for TiDB serverless: [email protected]

Inspiration

Running a Shopify store can be overwhelming. Store owners juggle product listings, customer support, marketing, and inventory—all while trying to grow their business. We realized there wasn’t a simple, intelligent tool that could handle these day-to-day tasks and let store owners focus on what really matters: growth.

What it does

ShopifyAssistant is an AI-powered tool that automates tedious tasks:

  • Can answer questions about inventory by querying Shopify or the data saved into TiDB
  • Tracks inventory and alerts owners when stock is low through the chat interface
  • Suggests promotions and marketing optimizations

How we built it

We integrated with the Shopify API to access store data, then layered an AI agent on top that can:

  • Analyze product information
  • Generate human-like text for descriptions and customer support
  • Make data-driven suggestions for inventory and marketing
  • We built the frontend as a simple dashboard for easy setup, so store owners can start using it in minutes.

Challenges we ran into

  • Ensuring AI-generated content was accurate and aligned with brand voice
  • Handling edge cases in inventory management across different product types
  • Making the system fast enough for real-time customer queries

Accomplishments that we're proud of

  • The AI assistant can fully automate product descriptions for a store in under 5 minutes

What we learned

  • AI can significantly reduce operational overhead for small businesses
  • Clear, concise UI is essential—store owners don’t want to spend hours learning a new tool
  • Testing edge cases in e-commerce is critical to prevent errors that affect sales

What's next for ShopifyAssistant

  • Add Gmail integration so an agent can send emails to respond to customers
  • Integrate marketing automation (email campaigns, ad suggestions)
  • Add predictive analytics for inventory and sales trends
  • Allow the agent to execute tasks

Built With

Share this project:

Updates