Updating the Product Catalog
    • Dark
      Light

    Updating the Product Catalog

    • Dark
      Light

    Article summary

    Products


    Reviews

    Supported plans

    Starter, Pro, Premium, Enterprise

    eCommerce Platform

    Shopify, Shopify Plus, Adobe Commerce (Magento), BigCommerce, WooCommerce, Volusion, Salesforce Commerce Cloud, Custom

    In this article, you'll learn how to update products in the catalog that you have already imported into your Yotpo Account. 

    If you're using Shopify as your eCommerce platform, please see Keeping your Shopify Yotpo product catalogs updated. If you want to add products, see Importing Product Catalogs.

    Getting Started

    • You can choose to upload the whole product catalog file each time, or you can just upload a file with the products you updated. Products that have not been modified will not be updated. 

    • Syndicating reviews? Updating product specs (SKU, UPC, MPN, Brand, or ISBN) might affect review syndication since product matching is done according to the specs.
      If you're not sure, contact Yotpo support before proceeding.

    Tip

    Yotpo strongly recommends that you add the Product Image URL information so your product images will show in Yotpo's social features, for promoted products, and so on.

    Preparing Your File

    • If you are using Excel, see this article for more information

    • Be sure that the CSV file does not contain any empty rows between products. The rows of data must be continuous

    • If you are using a spreadsheet program, import the CSV file. Do not open it as numbers may not be preserved correctly

    Product tagging

    If you're including product tags in your CSV import file, be sure to check out the guidelines and best practices here:

    Updating the Product Catalog

    All that's required is to download the product catalog as a CSV (comma-separated value) file, update it, and re-upload it. You'll get a confirmation email when the updates have been processed.

    There is no limit to the number of rows you can include in the CSV file.

    To download the file:

    1. In Yotpo Reviews, click the Profile icon at the top right corner.

    2. Click Account Settings > Product Catalog.

    3. Choose the Update Products tab.

    4. To generate a full product catalog including products on your blocklist, check the Include blocklisted products box. To generate a product catalog that excludes products on your blocklist, leave the box unchecked.

    5. Enter your email address.

    6. Click Send Catalog. Yotpo will generate your existing catalog and send it to the email specified.  Please note that this may take some time for larger files. 

    7. Make the required updates with the product catalog and save the file as a UTF-8 CSV file.

      • Ensure the file encoding is in UTF-8

      • Ensure you do not have duplicate IDs

      • Ensure that you only include IDs for products you want to modify

      • Ensure you have added any products you don't want to send review requests for to your blocklist

      • Check that the URLs are formatted correctly, for example with http:// or https:// at the start

      • Ensure there are no empty rows between the data in the catalog

      • Make sure that product tags do not contain commas and that you have not included more than one tag per field

    8. Click Upload Catalog and upload your updated catalog file. You'll receive a success email once your catalog is updated in the Yotpo system.

    Important

    • Product IDs cannot be modified. Once a Product ID is added to the Yotpo product catalog, it cannot be changed. If you attempt to update an existing Product ID, the system will treat it as a new or duplicate Product ID rather than replacing the original.

    • New products should only be created via the Import Products tab.

    • Products cannot be deleted from the Yotpo catalog. However, you can blocklist products to manage their visibility and prevent them from being included in review requests.

    • If you're using Microsoft Excel, please refer to this guide.

    Tip

    We recommend using LibreOffice or Google Sheets when working with the downloaded file.

    Field

    Value

    Description

    Example

    Product ID
    (Required)

    String/Unique ID

    This string is used to identify the product in the catalog. It is used both for review syndication and for Google Shopping review feeds. Learn more about unique identifiers
    Product specification values support alphanumeric (a...z, A...Z, 0...9), "_" and "-" characters only.

    2134234

    Product Name
    (Required)

    Text

    The name of the product

    T-shirt

    Product Description

    Text

    Description of the product

    Stylish Yotpo-branded T-shirt

    Product URL
    (Required)

    Full URL 

    The URL of the product on your store

    http://magento.yotpo.com/index.php/
    yotpo-products/yotpo-t-shirt.html

    Product Image URL

    Full URL

    The URL of the product image

    http://magento.yotpo.com/media/catalog/
    product/cache/1/image/
    9df78eab33525d08d6e5fb8d27136e95/2/0/
    .jpeg

    Product Price

    Integer

    The price of the product

    15

    Currency

    Currency type/abbreviation

    The currency according to the ISO 4217 format

    USD

    Spec UPC


    Universal Product Code


    Spec SKU


    Stock-Keeping Unit


    Spec Brand


    Brand


    Spec MPN


    Manufacturer Part Number (MPN)


    Spec ISBN


    International Standard Book Number (ISBN)


    Product Tag


    The tag for the product used in custom forms. This field can accept one tag per product and cannot contain commas.
    Learn more in Custom Questions


    Blacklisted

    Boolean

    Send (false) or do not send (true) review requests for this product.
    The text must be lowercase.

    true/false

    Product Group

    Text

    The group you want to assign the product to.

    You can assign a maximum of 1,000 products to a group.
    Learn more in Grouping Products
    Product Group Names cannot contain spaces and must not exceed 100 characters.
    Only lowercase alphanumeric characters (a...z, 0...9) and the "_" and "-" symbols.

    v-neck_tshirt

    Product Collections

    Text

    Assign products to collections according to store categories.

    There is no limit to the number of products you can add to a collection.

    T-Shirts, Summer Collection, Sale, Clearance, Black Friday

    Troubleshooting

    Any products that were not updated correctly will be flagged with an error message.

    Issue

    Cause

    Solution

    "There are one or more invalid inputs. Check product details and try again" message appears in the CSV file

    The data is invalid, for example, a mandatory value is missing.

    Check the rows with the error code and re-upload the data.

    "Cannot create products on update mode"

    Some of the products you are trying to update don't yet exist in your Product Catalog 

    Please see the Importing your Product Catalog article for more information 

    "We’ve partially processed your product updates"

    Some of the products you are trying to update do not yet exist in your Product Catalog

    Please see the Importing your Product Catalog article for more information

    "The data is uploaded but is incorrect"

    The same product ID may appear more than once in the CSV file. The data from the last entry is used.

    Remove duplicate data and re-upload the product.

    "We failed to group your product. Please make sure that all the data provided is according to the requirements" 

    A group name can only contain up to 100 characters. This error indicates that the group name you chose has over 100 characters

    Shorten/change the group name

    "Failed to validate import file"

    The file wasn't saved as a Comma Separated Sheet

    Make sure to select the correct file formatting when saving the file. For more information, click here

    CSV file errors

    • Trailing spaces in product specification values are automatically stripped.

    • Any combination of leading zeros (“0”), leading spaces, and leading dashes (“-“) are automatically stripped from the product specification values.

    • Product specification values support alphanumeric (a...z, A...Z, 0...9), "_" and "-" characters only.

    • Product specifications values are case-sensitive.

    • Product tags cannot contain commas.

    • An “N/A” value for product specifications is invalid in any case and is ignored.

    Updating Product Catalog per Platform

    If You’re Using Shopify

    The integration between Yotpo and Shopify keeps your Yotpo product catalog up-to-date automatically.

    • Updates are pushed directly from your Shopify catalog to your Yotpo catalog.

    • If errors are detected with your product attribute configurations, Yotpo will notify you in the Admin.

    Your Yotpo catalog is automatically updated with the following Shopify data:

    • Product name

    • Description

    • Product page URL

    • Image URL

    • Price and currency

    • SKU

    • Barcode (GTIN)

    For more information, read how to Keep your Shopify and Yotpo product catalogs updated.

    If You’re Using Magento 2 / Adobe Commerce 2 (Yotpo Reviews Extension 4.0.0+)

    Enable the catalog sync to automatically push updates from your Adobe Commerce catalog to Yotpo.

    By default, catalog sync is disabled. Turn it on if you want to:

    • Add custom attributes (e.g., product group, unique identifiers)

    • Use retail syndication

    • Display reviews in Google Shopping ads

    To read more, go to Adobe Commerce 2 – Setting Up Yotpo Reviews Extension 4.0.0+

    If You’re Using Any Other Platform

    You’ll need to manually update your Yotpo product catalog.

    Download the Product Catalog

    1. In Yotpo Reviews, click the Profile icon.

    2. Go to Account Settings > Product Catalog.

    3. Select the Update Products tab.

    4. Enter your email address and click Send Catalog.

    5. You’ll receive your current catalog file via email.

    Update the Catalog File

    1. Open the CSV file.

    2. Update the Product.

    3. Save the file as a UTF-8 encoded CSV.

    Upload the Updated Catalog

    1. Return to Yotpo Reviews.

    2. Click Upload Catalog and select your updated file.

    3. You’ll receive a confirmation email once processing is complete.

    Best Practices

    • Ensure no duplicate product IDs or empty rows in the CSV.

    • Only include IDs for products you want to modify.

    • Note: Product IDs cannot be changed once added to the catalog.

    Note

    Updates may take up to 24 hours to reflect in your Yotpo catalog.


    Was this article helpful?