Product catalog data specification

Read through the section to find out the Product specification requirement to upload the data in to Acoustic Personalization - Product Recommendations

The following table contains the list of attributes you can upload. You must provide the product attributes data in the right format to display the recommendations on your website. Product recommendation models use the required fields. You can use optional fields to create business rules to filter the recommendations returned by the models.

The attributes are used in the following scenarios:

  • Used in business rules
  • Used for rendering recommendations in Preview
  • Used for rendering recommendations on your channel

CSV file specification

The following table describes the format of CSV file to be used for product catalog upload.
Note: By default, the CSV file uses comma (,) as the delimiter for the fields. Alternatively, you can also use the Pipe symbol (|) as the delimiter. Irrespective of whether you use comma or pipe symbol as the delimiter for the fields, you must save the file with .csv extension.

To add multiple values within the fields that support multiple values, only use comma as the separator.

Table 1. Product catalog Attributes
Name Name as it appears in Acoustic Personalization Format Required Description
id Product ID
Product’s unique identifier
Example: VS-234HD-Q
Syntax: Max 50 characters
 Yes
  • Unique identifier for each product
  • Supports valid Unicode characters
  • Product ID is case sensitive
title Product name
Your product’s name
Example: DC1080 Digital camera - SLR - 20.5 MP - 1080p
Syntax: Max 150 characters
 Yes
  • Provide the product name that matches the title of the product on your website.
description Product description
Your product’s short description
Example: MicroPixel technology with a 18-55 mm lens for high definition pictures
Syntax: Max 5000 characters
 Yes
  • Provide the description of your product that matches the description of the product on your website.
image_link Image URL
Your product’s main image URL
Example: https://samplewebsite.com/xyz.jpg
 Yes
  • Provides link to the main image of your product.
product_category Category
Category for your product
Example: camera
Syntax: Max 50 characters
 Yes
  • Ensure that you provide the main category of the product
  • You can specify multiple categories using comma (,)
brand Brand
Your product’s brand name
Example: XYZ
Syntax: Max 50 characters
 No
  • Provide the brand name of the product
inventory Inventory
Count of your product's stock
Example: 37
 No
  • Provides total number of products in stock
  • Provide a numeric value
availability Availability
Your product's availability
Example: TRUE,FALSE
 No
  • Provide the product's availability
price Price
Your product’s price
Example: 139.99 USD
 No
  • Provide the product's price and currency
  • Don't enter 0 in the price
sale_price Sale price
Your product's sale price
Example: 110.00 USD
 No
  • Provide the sale_price in addition to the price attribute with the non-sale price
margin Margin
Profit margin for your product
Example: 20
 No
  • Provide as a percentage
  • Provide this field to create product recommendation strategy based on margin
product_rating Product rating
Overall rating of the product
Example: 3.3
 No
  • Provide a numeric or decimal value