Skip to main content

Products CSV Sync

While vector search is excellent for finding paragraphs of text (like policies and FAQs), it is not optimized for exact-match filtering (like finding a product that costs exactly $49 or filtering by a specific category).

If you are an e-commerce brand, you want your chatbot to be able to recommend specific products, display their images, and link directly to the checkout page. You can achieve this using the Products CSV Sync feature.

Why Use CSV Sync for Products?​

When a customer asks, "Do you have any red running shoes under $100?", a standard document search might fail because "red" and "running shoes" might appear in different paragraphs of a PDF.

By uploading a structured CSV catalog, Sentrup indexes your products into a structured database. This allows the AI to:

  1. Filter Accurately: Query exact columns like Price, Category, and Color.
  2. Display Rich UI Cards: Instead of just outputting text, the chatbot can display beautiful Product Cards featuring the product image, title, price, and a "Buy Now" button.

Formatting Your CSV​

To ensure the AI understands your product catalog, you must upload a .csv file containing the following columns.

Note: The exact column headers can vary slightly, as Sentrup's AI will attempt to auto-map them, but using these exact names guarantees the best results.

  • Title (Required): The name of the product.
  • Description: A brief summary of the product features.
  • Price: The numerical price (e.g., 49.99).
  • Image URL: A direct link to the product's image (used to render the Rich UI Card).
  • Product Link: The URL where the customer can buy the product.
  • Category (Optional): Useful for filtering (e.g., Shoes, Electronics).

How to Upload​

  1. Navigate to Knowledge Base > Products CSV in your Sentrup dashboard.
  2. (Optional) Click Download CSV Template to get a perfectly formatted starter file.
  3. Select your completed .csv file.
  4. Click Upload Products CSV.

Warning: Uploading a new CSV will overwrite your existing CSV products catalog to ensure your inventory stays perfectly synced with your latest upload.