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.
|