Why is the product catalog important?
Why is the product catalog so important? Consider the following features that are powered by the product catalog:
- Syndication—because retailers and brands often use different identifiers and metadata to describe the same product, a complete and accurate product catalog enables Bazaarvoice to match products offered by brands and retailers, and then share (syndicate) user-generated content (UGC) based on product matches. In particular, brand names, UPCs, EANs, and MPNs are key to enabling syndication.
- Content—this includes review requests (formerly post-interaction email or PIE), social media alerts and notifications, and Bazaarvoice-hosted elements on your website, such as review submission pages. Data elements such as the IDs, names, and URLs of brands, categories, and products help power this content.
- Reports and Insights—the quality of data available from your product catalog directly impacts generated reports and insights. Make sure your product catalog is up-to-date. Refer to Integration health for more information.
- Integration with other Bazaarvoice products—key elements must be defined in your product catalog to support integration with Ratings & Reviews, Connections, Advertising, and Sampling. For example, suppliers who subscribe to Connections rely on brand names and vendor IDs. See Required product data section for more details and examples.
- Moderation accuracy—keep the product catalog updated to ensure moderators have complete visibility and context so they are able to fully understand if the submitted consumer feedback is relevant and appropriate to the product under review.
Supported formats
Bazaarvoice accepts the following feed file formats:
- XML (recommended) – The XML feed follows a specific structure. Use the Product feed generator as a starting point for creating your XML-based product catalog feed.
-
CSV or TXT - If creating an XML feed is difficult, you can send your catalog feed in a flat file format (CSV or TXT). However, these formats are only supported for single-locale implementations.
Required product data
High-quality feed content is required for successful syndication, notifications, reporting, insights, and integration with other Bazaarvoice solutions or features. Bazaarvoice relies primarily on an automated matching technique that depends on globally unique product identifiers. The completeness and accuracy of your product feed determine how well products can be matched.
The following Bazaarvoice features and solutions rely on accurate identifiers in your product feed to ensure maximum value:
The following sections provide information about key feed components that are required for product and feature support (some exceptions are noted below). For XML feeds, they are elements. For text feeds, they are column names.
Product name
Name should consist of attributes and descriptors that most uniquely identify the product. Examples of useful product name attributes include brand names, model numbers, sizes, and colors.
Product ID/External ID
-
Product ID /
External IDconsist of alphanumeric characters, hyphens (-), and underscores (_) that most uniquely identify the product (common product identifier). The product ID is defined within thedivtag where the data-bv-show attribute appears on your product page. If your current implementation uses the scout file (bvapi.js), you can set the product ID in the$BV.uiconfigure call on your product page. In the product feed, you must specify the value of the product ID inExternalId. -
Within Bazaarvoice,
ExternalIdis especially important. Without it, product matching across features cannot occur. Product ID is also used in submission form links (productId) and in the integration code on product display pages (PDPs), and it is used byskuin BV Pixel transactions.
Brand name
Brand represents the most important data item to provide for each product in the feed. Brands are used for more than product matching; in Bazaarvoice reporting systems, they also help you get the most benefit from your syndication and Connections programs.
In an XML feed, use the household brand name for the product for the brand's <Name> element, rather than the supplier’s or manufacturer’s brand name. This is particularly true for retailers that may carry multiple brands from a single supplier. Products without brands often appear “invisible” with respect to these reporting systems.
Example:
Supplier BrandOne markets the identically-named BrandOne brand bleach. The supplier BrandOne also markets BrandTwo brand charcoal and BrandThree brand salad dressing. In this case, we recommend that both supplier BrandOne and the retailers that carry these products use BrandThree, BrandTwo, and BrandOne as brands for the respective salad dressing, charcoal and cleaning products. It is not recommended that all products use BrandOne in the brand field, even though the company supplies all of the products.
Category
Category defines a category that is represented by products in your feed using the following child elements. You can also use this element to define a category hierarchy.
GTINs: UPC, EAN, and ISBN (common product identifiers)
UPC, EAN, and ISBN are the most commonly used product identifiers (GTINs). The product category you manufacture or sell and your region determine which identifiers are relevant. If more than one value applies to a product item, we recommend providing all relevant values. For example, electronics or consumer packaged goods (CPG) products might be assigned a UPC and an EAN.
Without these common product identifiers, Bazaarvoice cannot match products to vendors or catalogs as quickly, making the likelihood of mismatches higher. Because of poorer product data quality, the confidence level of the matches declines. This lack of confidence forces more manual reviews of the matches, slowing down the process. Due to delays caused by the lack of automated matching tools, newly introduced products will not syndicate immediately.
-
Use letters.
-
Include values with character lengths that deviate from the defined global standards for UPC, EAN, or ISBN.
However, depending on your system's capabilities, you may be required to include a placeholder value when adding products to your catalog. In this situation, enter a string of zeros (0) that matches the identifier’s standard character length. Bazaarvoice does not store the null values, but their inclusion will not produce errors during validation.
Data type and format:
-
UPC: 6- or 12-digit value whose last digit provides a verifiable checksum of the number. Some systems internally store only the leading 11-digit product code, so make sure to include the checksum digit in the feed. Products sold in the US and Canada primarily use UPCs. -
EAN: 8- or 13-digit value whose last digit provides a verifiable checksum of the number. Products sold outside the US and Canada primarily use EANs. -
ISBN: 10- or 13-character value used predominantly for media products such as books, music, and videos. The last character provides a checksum that helps validate the product identifier. Most ISBNs are composed only of digits, except for some 10-character ISBN values that use an X for the checksum.
Required elements:
-
UPCandEAN: At least one for all relevant categories. We recommend that global companies supply both. -
ISBN: For books, movies, music, and media.
Normalized GTINs
Bazaarvoice now normalizes GTINs, auto-generating a 14-digit GTIN for each product identifier (UPCs, EANs and ISBNs).
By making all product identifiers 14-digit GTINs, products can be automatically matched even if this means matching a UPC to an EAN or vice versa. These GTINs are auto-generated in the matching system, but will not appear in the client’s catalog.
Manufacturer part number (MPN)
The second most useful product identifier for syndication is the manufacturer part number (MPN). Use the MPN in conjunction with the manufacturer’s name to match products accurately and automatically. In your feed, provide MPNs using ManufacturerPartNumber, and make sure each product's Brand uses the name of the manufacturer responsible for the MPN. Your feed can have multiple MPN values for a single product, so provide all MPNs applicable to a product.
Product description
Description provides a description of the product.
Product image URL
ImageUrl acts as a very important differentiator in the manual matching process. Provide an image that is accurate and meaningful for identifying the product. The primary reason for including these images is that they will appear on your submission form.
Product page URL
The link to the product page on your website, which is specified by ProductPageUrl, enables manual matchers to access the full context of your product. This method represents the least preferred way to match products manually because it is so time consuming. The primary reason for including a PDP URL is that they route SSURLs to the correct product pages.
Supplier or vendor ID
Bazaarvoice uses a supplier or vendor ID to determine which questions and product reviews to send to the supplier. This data is required by all feature and product integration, though it is required for retailers only for Ratings & Reviews Collect-Distribute and Connections integration.
Use a custom attribute to provide a supplier or vendor ID in the feed by specifying an id="VendorID" attribute for the <Attribute> element. Example:
If you are a retailer using Connections, Bazaarvoice provides two options for suppliers (also referred to as "brands" or "vendors") to use when signing up for Connections Basic and Connections Premium:
-
Supplier or vendor ID—Provides a guaranteed mapping to the supplier and avoids confusion for large suppliers, which may supply products in different categories. To provide a supplier or vendor ID, add the VendorID attribute to existing
<Attribute>elements of a product feed. This option also proves very useful for private labels that may be supplied by different manufacturers. This is the recommended option. -
Brand name—Provides the brand or vendor name using the
<Brand>element. The drawback to using this option is that all vendors that supply products for the specified brand will receive questions about all of the products, including those they do not supply.
After sign-up, Bazaarvoice uses this value to determine which questions and product reviews to send to the supplier.
Multi-category supplier example
Retailer A carries products from Vendor V in three categories: small appliances, televisions, and mobile phones. A different division of the vendor manufactures and markets each product. Retailer A provides Bazaarvoice the vendor ID for each product and then uses the ID for Connections sign-up. Bazaarvoice can now send questions for the small appliances products to only that division of Vendor V. This process makes it easier and faster for Vendor V to respond. Without the supplier or vendor ID, the television and mobile phone divisions would also receive the small appliances questions.
Private label example
Retailer A has a private label called Brand XYZ. This retailer sells packaged food, toiletries, and cleaning supplies under the Brand XYZ name, but each product type has its own vendors. If Retailer A’s product feed contains vendor IDs, Bazaarvoice can determine which questions go to which vendor. If the product feed does not contain vendor IDs, then Bazaarvoice uses only the <Brand> element to determine where to route questions. Without vendor IDs, all vendors for Brand XYZ’s products will receive questions about all Brand XYZ products, including those they do not supply.
Learn about the requirements for your product catalog and how to build it for the first time with the Optimize Your Bazaarvoice Product Catalog course at Bazaarvoice University.

