Skip to main content

Product Feed Module

Introduction​

Present the products of your external data feed to customers. An external data source can be connected to LoyJoy using a connector.

Typical Use Cases​

The Product Feed module is a powerful tool for displaying a list of up to 12 products that best match your customer's preferences, as determined by a preceding chat flow. The module's key advantage lies in its integration of a recommender, which automatically pulls content from various connectors. This continuous update ensures that your customers receive the most up-to-date and relevant product listings.

How to Use the Module​

To use the module, you first have to upload your products or provide them as a Google Sheet or JSON API. Then, the products can be displayed in the chat. To control, which products are shown, there are two primary options: the tag recommender and SQL-based filters in the connectors. The tag recommender is a simple way to filter products based on tags assigned to the customer during the chat flow. For most use-cases you should use SQL-based filters as they offer more fine-grained control. Check out the guide for more information on how to set up a product database and use it for different use cases, such as location search or contact search.

Connectors​

To use the Product Feed module, you need to connect your external data source. LoyJoy supports three types of connectors: Database, JSON, and Google Sheets. Learn how to use a connector here.

For assistance with the configuration, please reach out to our support team.

Example of a Google Sheets Connector​

To use the Module Product Feed effectively, you should structure your data in Google Sheets as follows:

  1. Start with the "title," which represents the product name.
  2. Provide a "description" to offer a brief overview of your product.
  3. You may want to add a "header" which appears right above the title as a topline.
  4. Include "tags" with all relevant tags assigned to the customer during a chat flow, separated by commas.
  5. Specify the "price" of the product.
  6. Include the "image_url," which should contain the direct link to the product image.
  7. Finally, insert the "url" that directs the customer to your website for product purchase. While the "description," "price," "image_url," and "url" fields are not mandatory, they are highly recommended for an optimal user agent.

See here for an example Google Sheet. As described, the first row is expected to hold the column names.

Example sheet

Using Database and JSON Connectors​

For Database and JSON connectors, ensure your data source includes similar fields (title, description, header, tags, price, image_url and url). These fields allow the recommender to function correctly and provide the best product matches to your customers.

Configuring SQL Query​

To define a filter for the product selection, you can configure an SQL query in your connector. This query is used to filter products based on the selected tags and other criteria. You can see all SQL filters here.

Connectors

Show add to cart button​

To enable the add to cart button, you need to add a new field named button_url to your products. If you are using shopify, you can use the shopify add-to-cart button link: https://yourstore.com/cart/add/{variant_id}.

Additional Information​

  • Connectors: You can use Database, JSON, and Google Sheets as connectors. Multiple connectors can be added.
  • No Products Found: If no products are selected, a custom text can be displayed by entering it in the "If no products are found" section.