How to create a CSV file for product catalog

This feature is included in the Free, Plus, Premium, Advanced, and Enterprise plans.

Want to add your products to your product catalog? Follow this guide to create a CSV file in the right format.

What's a product catalog?

A product catalog is a list of all your business’s products that collect reviews. It includes details like product name, photo, and Global Trade Item Number (GTIN).

To set it up, you'll need to create a spreadsheet that contains your products’ details, using a program like Google Sheets or Microsoft Excel.

If you're sending product review invitations via our ecommerce integrations, avoid setting up your catalog manually. Instead, when a product is purchased, it’ll automatically upload to your catalog.

Prepare your spreadsheet using Google Sheets

To prepare your file, follow these steps:

  1. Open a new, blank worksheet in Google Sheets.

  2. Enter your product data in the following order. If you don’t have corresponding data, just leave the space blank.

    • Product SKU (required)
    • Product name (required)
    • Product URL
    • Product image URL
    • Price
    • Currency 
    • GTIN
    • Brand
    • MPN
    • Google Merchant Center product ID

    • Google product category ID

    • Variant group ID

    • Variant size

    • Variant color

    • Variant material

    • Variant pattern

    • Variant age group

    • Variant gender/sex
      Prepare your spreadsheet using Google Sheets

    If your products don’t have a GTIN or MPN, we recommend that you add your business name as Brand and the products SKU as MPN. If you do this, it’s very important that these identifiers match and are the same in both the feed you send to Google AND the product catalog that you send to us.

  1. Save the file in CSV format. From the File menu, go to Download, and select Comma-separated values (.csv, current sheet).
    Save the file in CSV format

Prepare your spreadsheet using Microsoft Excel

If you’re using Excel, the steps for creating the spreadsheet are the same, but you’ll need to make sure that you’re saving your file using UTF-8 format.

Submit your catalog

Now that your sheet is ready to go, you can upload it to Trustpilot. 

  1. In Trustpilot Business, go to Manage reviews > Product reviews > Product catalog. Click Import products.
  2. You can either drag and drop your CSV file into the pane or select Or upload a file from your computer.
  3. Your file will be uploaded. Check the data to make sure all your information is correct. If there are any errors, you'll need to click Go back and upload a new CSV file with the relevant corrections. 
  4. Once everything looks good, click Confirm import. 

To read more about managing your product catalog, check out this article.

Related articles