Product catalog

Bazaarvoice Contextual Commerce pairs product catalog data with behavioral data from shoppers to power its various messaging techniques. Contextual Commerce also relies on product data to inform its decision engine. The more robust data you can provide, the better the engine can optimize and personalize messages to customers. 

  • Existing Bazaarvoice customers (Social Commerce or Vibe)
    Your current product catalog feed may already contain the necessary data fields optimized for Contextual Commerce. Check with your Bazaarvoice representative.
  • New customers
    Create a product catalog feed file and transfer it to Contextual Commerce.

Catalog feed best practices

Before getting started, ensure you:

  • Upload a single TSV or CSV feed file that includes all of your catalog. Providing a well-formed structured product feed is critical for success.
  • Use key authentication, not password authentication.
  • Compress the file.
  • Give each file name a timestamp in the following format YYYYMMDDTHHMM (e.g. 20240810T2345 corresponds to August 10, 2024 11:45 PM).
  • Avoid special characters aside from underscore (_) or hyphen (-) (adheres to S3 object naming guidelines).

Catalog data points

The following section provides information about required and optional catalog feed data points for full product and feature support.

Data point
Priority
Data type
Description
product_id
Required

Text, Max 255 chars

Identifies a grouping of related SKUs (product variants). Typically has its own web page.
image_url
Required
URL
URL to the image of the product.
product_url
Required
URL
URL where the product may be viewed. SKUs with the same product_id often share a product_url.
name
Required

Text, Max 240 chars

Name of the product.
current_price
Required
Decimal 8.2
Current price of the product. If on sale, current_price is less than regular_price.
inventory
Highly recommended
Integer
Number of items in stock. in_stock can be inferred from inventory.
regular_price
Highly recommended
Decimal 8.2
Regular price of the product. Example: 123.45
sku
Highly recommended
Text, Max 255 chars

Identifies a product variant, for example, the blue variation of a suede shoe product. Must be unique in the catalog.

review_count
Highly recommended
Positive integer 
Number of reviews for the product that count toward its average review rating. 
short_description
Highly recommended

Text, Max 1000 chars

Description of the product. Ideally less than 255 chars.
category_level_1
Highly recommended

Text, Max 80 chars

Top level category name for the item like Beauty, Electronics, or Home. A full category path like Beauty:Makeup:Lips can be parsed into separate category levels.

category_level_2
Highly recommended
Text, Max 80 chars
Second level category name.
category_level_3
Highly recommended
Text, Max 80 chars
Third level category name.
category_level_4
Highly recommended
Text, Max 80 chars

Fourth level category name.

in_stock
Highly recommended
Y/N
The product is currently available. If this data point is not present, we assume it is available.
review_average
Highly recommended
Decimal 2.1
Average review rating, typically 1 - 5.
Currency
Nice to have
Text, Max 6 chars

Currency code. Examples: USD, GBP, CAD, EUR, BRL, MXN. 

long_description
Nice to have
Text
Long description of the product.
manufacturer_product_id
Nice to have

Text, Max 255 chars

Manufacturer’s identifier for a product. Typically the same as product_id.
brand
Nice to have

Text, Max 80 chars

Brand of the product.
new_arrival
Nice to have
Y/N
This is a newly stocked product. The duration of "new" is set by each retailer by using the difference between supplied launch_date and the current date.
on_sale
Nice to have
Y/N
This product is on sale. This can be calculated based on whether current_price is less than regular_price.
clearance
Nice to have
Y/N
This product is on clearance.
launch_date
Nice to have
Text, Max 80 chars
Date the product was launched at retail. 
category_level_5
Nice to have
Text, Max 80 chars
Fifth level category name.
category_level_6
Nice to have
Text, Max 80 chars
Sixth level category name.
category_level_7
Nice to have
Text, Max 80 chars
Seventh level category name.
color
Nice to have
Text
Color of the product.
keywords
Nice to have

Text, Max 255 chars

A list of keywords used for search engine optimization.
featured
Nice to have
Y/N
The product is being promoted. 
age_group
Nice to have
Text, Max 10 chars Retailer defined age group.
gender
Nice to have
Text, Max 10 chars
Retailer defined gender.
price_code
Nice to have
Text, Max 255 chars
Code used for product discounts.

Provide feedback button