Skip to main content

Import Google Merchant Store Data

info

AI SmartTalk allows seamless integration of Google Merchant Store data to enhance e-commerce chatbot capabilities. This guide explains how to prepare and upload your product feed.

File Format Requirements​

Prepare your file with the following columns:

  • product-id (Required): Unique identifier for each product (used for updates).
  • product-name: Name of the product.
  • price: Price of the product.
  • description: Detailed product description.
  • Additional Columns (Optional): Include any other attributes relevant to your store, such as category or stock level.

Example​

product-id,product-name,price,description,category
12345,Wireless Mouse,19.99,High-precision wireless mouse.,Electronics
67890,Mechanical Keyboard,49.99,Durable mechanical keyboard with RGB lighting.,Accessories
warning

The product-id column is mandatory and must be unique for each product to ensure proper tracking and updates.

Steps to Import Google Merchant Data​

Step 1: Upload the File​

  1. Navigate to the Knowledge Base section in AI SmartTalk.
  2. Click Upload File and select your Google Merchant Store feed file (Excel or CSV).
  3. Verify the file format:
    • The product-id column is present.
    • All required fields are filled.
  4. Click Upload to process the file.

Step 2: Map Columns (if needed)​

  1. If the system prompts you to map columns:
    • Match product-id to the corresponding column in your file.
    • Repeat for product-name, price, and other attributes.
  2. Confirm the mapping and proceed.

Step 3: Configure Settings​

  1. Assign tags to categorize products (e.g., "Electronics," "Accessories").
  2. Mark the feed as Active to make product data available for chatbot queries.

Default Behavior​

  • The chatbot searches the product-name and description columns to answer product-related queries.
  • Use the product-id column for tracking and updating specific products in future imports.

Example Use Case​

Scenario: Managing Product Inventory​

  1. Prepare a CSV file with product data:
    • product-id: 12345
    • product-name: Wireless Mouse
    • price: 19.99
    • description: High-precision wireless mouse.
  2. Upload the file to the Knowledge Base.
  3. Assign tags like "Popular Products" or "Under $20."
  4. The chatbot can now respond to queries like:
    • "What wireless mouse do you have?"
    • "Do you have products under $20?"

Troubleshooting​

Common Issues​

  • Error: Missing product-id Column

    • Ensure the file includes a unique product-id for each product.

  • Error: Unsupported File Format

    • Save the file as .xlsx or .csv.

  • Error: Parsing Issues

    • Check for missing or incorrectly formatted data.
danger

Uploading duplicate or invalid product-id values can cause errors in product tracking and updates.

Next Steps​

After importing your product data:

  • Learn how to import FAQs for common e-commerce queries.