E-commerce

A Chatbot for a Large Product Catalog: How AI Answers from Thousands of Products

Your store has thousands of products and traditional bots cannot cope? A plain-language explanation of how semantic search and knowledge bases work, how the catalog syncs automatically from Salla, Zid, and Shopify, and real examples of customer questions and bot answers.

July 11, 20268 min readInboxy
A Chatbot for a Large Product Catalog: How AI Answers from Thousands of Products

The Problem: Button Bots Collapse at 5,000 Products

Traditional chatbots are built on menus and buttons: "Press 1 for prices, 2 for shipping, 3 for products." That design works for a restaurant with 20 items, but it collapses completely for an online store with 3,000 or 10,000 products. It is impossible to build a button tree covering every product, and impossible to write a canned reply for every possible question.

And customers do not ask in an organized way anyway. They ask: "Do you have white sports shoes, size 43, under 500 EGP?" — one question with four conditions: category, color, size, and price. The traditional bot replies "I did not understand your question," and the customer goes to another store.

The solution that emerged in recent years and genuinely matured in 2025-2026 is connecting generative AI to a live knowledge base containing your full catalog. Let us explain how it works without technical complexity.

How Does Answering from Thousands of Products Work? (Plain-Language Explanation)

The technology behind this is called Retrieval-Augmented Generation (RAG), and the idea is much simpler than its name. Imagine a very smart new sales employee who does not memorize the catalog. Instead of memorizing, he has a magic index: for any question he hears, he opens the index and pulls the ten products closest to the question in a fraction of a second, then composes a natural answer from them.

In practice, the system goes through three steps with every question:

  • Indexing: When you connect your store, the system reads every product — name, description, price, sizes, colors, availability — and converts it into a numerical "meaning fingerprint." Products that are similar in meaning end up with similar fingerprints.
  • Retrieval: When a customer asks "I want a gift for a 10-year-old girl," the system converts the question itself into a meaning fingerprint and fetches the closest products — even if no product description literally contains "gift for a 10-year-old girl." This is the fundamental difference from keyword search: searching by meaning, not by letter matching.
  • Generation: The AI receives the retrieved products and composes a natural reply in your customer's dialect: "We have 3 excellent options for that age..." with prices and links.

The crucial point: the bot answers from your catalog only, not from general internet knowledge. If a product does not exist in your store, it says it is unavailable — it does not invent imaginary products.

Automatic Sync: A Living Catalog, Not a Dead Copy

The biggest mistake in older solutions: uploading an Excel file of products once. A week later, prices have changed and products are out of stock, and the bot is selling things that do not exist. The correct solution is a direct sync with your store platform:

  • Salla and Zid: A direct connection to your account — products, prices, and inventory sync automatically. Added a new product in Salla? The bot knows it within minutes with zero intervention from you.
  • Shopify and WooCommerce: The same principle for global platforms — a price update in the store is reflected in the bot's answers immediately.

This includes stock status: when a specific size runs out, the bot stops offering it or suggests the available alternative. See the full list of supported platforms on the integrations page.

Real Examples: Customer Questions and Bot Answers

These are the types of questions a catalog-connected bot handles daily:

Multi-Condition Search

Customer: "I want a black crepe abaya under 300 SAR"
Bot: Retrieves abayas matching all three conditions and presents the top 3 results with images, prices, and direct purchase links.

The Comparison Question

Customer: "What is the difference between the 1200 blender and the 1800 one?"
Bot: Pulls both products' specifications from the catalog and summarizes the actual differences: power, capacity, accessories, and warranty.

The Compatibility Question

Customer: "Does this case fit the iPhone 15 Pro or not?"
Bot: Checks the product specifications and gives a definitive answer, suggesting the correct case if it is incompatible.

The Exploratory Request

Customer: "I cannot decide on a gift for my fiancé, my budget is 500 EGP"
Bot: Asks a smart clarifying question (his interests?) then recommends suitable products from different categories within budget.

Notice the common thread: not one of these questions can be answered by a button bot, and all of them are answered within seconds by an AI agent connected to the catalog.

Beyond Answering: The Bot as a Sales Employee

Answering questions is half the story. A bot connected to your store completes the full sales cycle:

  • Order tracking: "Where is my order?" — the bot pulls the shipment status from the store and replies with the tracking number directly.
  • Abandoned cart recovery: An automatic WhatsApp message to the customer who left their cart, with their product details and a checkout link.
  • Smart upselling: A customer asks about a camera? The bot suggests the compatible memory card and tripod alongside it.
  • Post-purchase notifications: Order confirmation, shipping, and delivery — automatically on WhatsApp.

All of these flows are built with a visual editor in the automation platform without any coding.

Practical Questions Before Choosing a Solution

  • What catalog size is supported? Ask directly: has the system been tested with catalogs your size (1,000? 10,000? 50,000 products?).
  • What is the sync delay? When you change a price in the store, when does it reflect in the bot? Minutes are acceptable; days are not.
  • Does it understand Arabic and dialects? Your catalog is in Arabic and your customers ask in dialect — semantic search must work in Arabic as well as it does in English.
  • What happens under uncertainty? A good bot, when it cannot find a reliable answer, hands off to a human instead of guessing.

Where Do You Start If Your Catalog Is a Mess?

A reasonable question stops many store owners: "My product descriptions are incomplete and my images are disorganized — should I postpone the bot until I clean up the catalog?" The practical answer: do not postpone — reverse the order. Connect the catalog as it is, run the bot on general questions (shipping, returns, working hours) and the well-described products, and within two weeks the conversation reports will hand you a golden list: the products customers actually ask about where the bot stumbles due to missing data.

That list is your correct catalog cleanup plan — ordered by real demand, not guesswork. Instead of blindly cleaning 10,000 products, you improve the descriptions of the fifty products that represent 80% of the questions. One month of this cycle (connect, monitor, improve the most requested) gives you a cleaner catalog and a more accurate bot at the same time.

A Real-World Scenario: A Spare Parts Store with Ten Thousand SKUs

The hardest test for large catalogs is the spare parts and electronics sector, because the customer rarely knows the exact product name. Imagine an auto parts store with 10,000 SKUs: a customer messages on WhatsApp "I need an oil filter for a 2017 Lancer" — without knowing the part number or its code.

The catalog-connected bot handles the request in three stages: first, it understands that "2017 Lancer" means a Mitsubishi Lancer 2017 model; then it retrieves the oil filters compatible with that model from the compatibility data in the catalog; and finally it presents the available options: the original at its price and the commercial alternative at its price, with a smart question: "Want me to add the air filter? Most customers replace them together." The customer confirms, and the bot creates the order and sends the payment link — a complete sales conversation done in three minutes with no employee, at 10 PM on a Friday.

The same logic applies to pharmacies (brand name versus active ingredient), building supply stores (dimensions and specifications), and electronics stores (device compatibility). The bigger and more complex the catalog, the clearer the gap between a traditional bot and a semantic one.

Frequently Asked Questions About Large-Catalog Bots

Do my product descriptions need to be perfect before connecting?

Good descriptions undoubtedly improve results, but semantic search is forgiving of gaps because it derives meaning from the combination of fields: name, category, and attributes. Start with your catalog as it is, then improve the descriptions of the most-asked-about products based on real conversation reports.

What about products with multiple sizes and colors?

Variants are part of the sync data: the bot knows the t-shirt is available in red size M and out of stock in blue, and answers at the variant level, not just the product level.

Can the bot give discounts or negotiate prices?

No — and that is intentional. The bot sticks to the prices synced from your store, and discount or negotiation requests transfer automatically to the sales team. The last thing you need is a bot handing out discounts at its own discretion.

My catalog mixes Arabic and English — is that a problem?

The opposite — it is an advantage. Semantic search is multilingual: a customer asks in Arabic about a product whose description is written in English, and the bot finds it, because matching happens at the level of meaning, not letters.

Test It on Your Real Catalog

The best test is your own catalog: connect your store (Salla, Zid, Shopify, or WooCommerce) to Inboxy in minutes, and try asking the bot the hardest questions your customers actually ask. Start your free trial now and see the difference yourself with the complete e-commerce solutions.

Ready to try Inboxy?

Start your 7-day free trial

Get Started