Keliqo with a CSV file
To connect a CSV file, put it at a public https address and paste that URL into Keliqo. The first row holds the column names in the Google Merchant format: id and title are required, and link, price, image_link, availability, description and brand make the answers better. Comma, semicolon and tab delimiters are all recognized.
Columns Keliqo reads
| Column | Use |
|---|---|
| id, title | Required. A row without them is skipped. |
| link, image_link | The product link in the answer and its picture. |
| price, sale_price | With currency, for example 19.90 EUR. The sale price wins when present. |
| availability | For example in_stock or out_of_stock. |
| description, brand, gtin, product_type, item_group_id | Details for searching and answering. |
| color, size, material, pattern, gender, age_group | Product parameters that become filters. |
Column names are not case sensitive, and "Image Link" or "g:image_link" also count as image_link. Quoted fields may contain delimiters and line breaks.
Steps
- Export your products to CSV with the columns above, and put the file at a public https address, for example on your web server.
- Open the try page, paste your site address and the file URL, and check the answers on a preview of your own site.
- To go live, copy one line of code into your site, usually before the closing </body> tag.
Facts
- What Keliqo reads
- A CSV or TSV file with Google Merchant column names at a public https address, plus up to 20 pages of your site.
- Catalog refresh
- Once a day, automatically. Replace the file at the same address to update the catalog.
- Price
- Free €0 (100 conversations a month), Start €19 (2,000), Pro €119 (20,000), Business €399 (100,000). Per month, excluding VAT, flat, no per-message fees. Pricing
- Trial
- 14 days with 1,000 conversations, no card. Then the Free plan unless you choose a paid one.
- Languages
- 17. Keliqo answers in the language the visitor writes in, or in one language you choose.
- Setup time
- A preview on your own site in about two minutes, without signup. Going live is one line of code.
No signup for the preview. Prices in EUR, excluding VAT.