E-Commerce Assistant for Shopify & WooCommerce with GPT-4o, Gemini & RAG

🤖 Universal E-Commerce AI Assistant (Shopify, WooCommerce & RAG)

This powerful n8n workflow deploys a sophisticated, multi-talented AI chatbot designed to streamline your e-commerce and customer support operations. The AI ​​assistant can intelligently understand user queries and route them to the correct specialized agent, whether it's for Shopify , WooCommerce , or general knowledge questions answered by a Retrieval-Augmented Generation (RAG) system.

This template automates responses to a wide range of inquiries, from checking Shopify order statuses with GraphQL to fetching product lists from WooCommerce, and even answering general questions by looking up information in a Pinecone vector database.

How It Works ⚙️

The workflow operates in a series of logical steps, starting from the moment a user sends a message.

1. 💬 Chat Trigger: The workflow activates when a user sends a message in the n8n chat interface. It captures the user's input and a unique session ID to track the conversation.

2. 🧠 Intelligent Routing: The user's query is first sent to a Router Agent powered by GPT-4o-mini. This agent's sole purpose is to classify the intent of the message and output one of three keywords: SHOPIFY , WOOCOMMERCE , or None of them .

3. 🔀 Conditional Branching: Based on the Router's output, a series of IF nodes direct the conversation down one of three paths:

   • General Queries Path
   • Shopify Path
   • WooCommerce Path

4. 📚 General Queries (RAG): If the query is not about e-commerce, it's handled by a RAG agent.

   • Embedding: The user's question is converted into a vector embedding using AWS Bedrock .
   • Retrieval: The workflow searches a Pinecone Vector Store to find the most relevant information from your knowledge base.
   • Generation: A GPT-4o-mini agent receives the context from Pinecone and generates a comprehensive, helpful answer.

5. 🛍️ E-Commerce Specialists: If the query is about Shopify or WooCommerce, it's passed to a dedicated agent.

   • Shopify Agent: This agent uses Google Gemini and has a suite of tools to manage Shopify tasks. It can Get Order info , Fetch All Products , or run complex queries using the powerful GraphQL tool.
   • WooCommerce Agent: This agent also uses Google Gemini and is equipped with tools to Fetch Order Details and Fetch All Products from a WooCommerce store.

6. 🗣️ Conversation Memory: Each agent (Router, General, Shopify, WooCommerce) is connected to its own Memory node. This allows the chatbot to remember previous parts of the conversation for a more natural and context-aware interaction.

7. 🏁 Merge & Respond: All three paths converge at a final Merge node. This ensures that no matter which agent handled the request, the final answer is streamlined into a single output and sent back to the user in the chat.

Nodes Used 🔗

• Triggers:
  • Chat Trigger : Starts the workflow when a chat message is received.
• AI & Agents:
  • AI Agent : Four separate agents for Routing, Shopify, WooCommerce, and General Queries.
  • OpenAI Chat Model : Uses GPT-4o-mini for the Router and General Queries agent.
  • Google Gemini Chat Model : Uses Google Gemini for the Shopify and WooCommerce agents.
• Tools & Data:
  • Shopify Tool : To get products and order information from Shopify.
  • WooCommerce Tool : To get products and order information from WooCommerce.
  • GraphQL Tool : For advanced, custom queries to the Shopify API.
  • Pinecone Vector Store : To retrieve context for the RAG agent.
  • AWS Bedrock Embeddings : To create vector embeddings for Pinecone.
• Logic & Memory:
  • IF Node : To conditionally route the workflow.
  • Merge Node : To consolidate the different branches before ending.
  • Window Buffer Memory : Four nodes to provide conversational memory to each agent.

Setup Guide 🛠️

To use this workflow, you'll need to configure several nodes with your own credentials and settings.

1. AI Model Credentials

• OpenAI: Create an API key in your OpenAI Platform dashboard. Add this credential to the Router Model and GPT-4o-mini nodes.
• Google Gemini: Create an API key in your Google AI Studio dashboard. Add this credential to the Shopify Chat Model and WooCommerce Chat Model nodes.

2. E-Commerce Platform Credentials

• Shopify: You will need a Shopify Access Token. Follow the n8n documentation to generate one. Add the credential to the Fetch All Products and Get Order info nodes.
• WooCommerce: Create API credentials from your WordPress dashboard. Add the credential to the Fetch All Products2 and Fetch Order Details nodes.

3. RAG System Credentials (Pinecone & AWS)

• Pinecone:
  • Sign up for a Pinecone account and create an API key.
  • Add your Pinecone credentials in n8n.
  • In the Pinecone Vector Store node, set the pineconeIndex to the name of your index. You must have a pre-existing index with data for the RAG to work.
• AWS:
  • Create an AWS account and an IAM user with programmatic access to Amazon Bedrock .
  • Add your AWS credentials in n8n.
  • Select your AWS credentials in the AWS Bedrock Embeddings node.

4. GraphQL Node Configuration

• In the GraphQL node, you must update the endpoint URL. Replace the placeholder https://{subdomain}.myshopify.com/admin/api/2025-04/graphql.json with your own Shopify store's GraphQL API endpoint.