Skip to main content

Add Bazaarvoice export

Add Bazaarvoice export in Productsup.

Introduction

Bazaarvoice is a platform brands can use to integrate user-generated content such as product reviews, ratings, Q&As, and visual and social content. Our Bazaarvoice integration enables you to syndicate your product catalog to Bazaarvoice to map the UGC to the correct products. The export generates an XML file and sends it to Bazaarvoice's SFTP.

Note

If your product catalog is above 750,000 products, Bazaarvoice sometimes recommends splitting it into multiple XML files. You should confirm with your Bazaarvoice contact whether you should do this in your case. Productsup provides the Split feed feature in the Bazaarvoice destination setup page, which lets you split the feed into multiple files.

Prerequisites

To add the Bazaarvoice export, you need to:

  1. Create or have a Bazaarvoice account.

  2. Have the SFTP credentials for Bazaarvoice.

Set up Bazaarvoice export

  1. Go to Exports from your site's main menu and select ADD EXPORT.

  2. Search for Bazaarvoice, hover over it, and select Add.

    Bazaarvoice export

  3. Go to Dataflow from the site's main menu and choose the added export from the drop-down menu in the top ribbon on the left.

  4. Map the attributes from import to export. See Map your product data for more information. Bazaarvoice mapping has the following peculiarities:

    • This export supports custom attributes. You need to set them up individually. The attribute name should start with Attribute@. See Filter catalog data based on custom product attributes for more information. For example, to pass the custom attribute example, create the custom attribute Attribute@example on the export stage and map the relevant attributes to this attribute from the previous stages.

    • Bazaarvoice has a concept of product families and bundles. See Configure product families for more information. You need to map the family and bundle name to the BV_FE_FAMILY and BV_FE_EXPAND attributes respectively.

    • Starting from the Bazaarvoice version 15.1, the Currency attribute accepts prices with currency such as 19.99 EUR. The output on XML may look as follows: 

      <Currency Price="19.99" CurrencyCode="USD"/>

    • The EAN, UPC, MPN, and ModelNumber attributes accept multiple values separated by comma. For example, mapping of 123456789101,123456789102,123456789103 to the EAN attribute results in the following XML:

      <EANs>
    <EAN>123456789101</EAN>
    <EAN>123456789102</EAN>
    <EAN>123456789103</EAN>
</EANs>

    • If you have localized brand and category names, create custom attributes for them in the following format: ATTRIBUTENAME@ATTRIBUTEVALUE.

      For example, if you create the attributes:

      • BrandName_locale@en_CA with value Second Brand CA

      • BrandName_locale@fr_CA with value Deuxième marque CA

      along with the standard attributes:

      • BrandExternalId with value BBB

      • BrandName with value Second Brand,

      the platform creates the following output in XML:

      <Brand>
      <ExternalId>BBB</ExternalId>
      <!-- Default brand name -->
      <Name>Second Brand</Name>
      <!-- Localized brand names -->
      <Names>
         <Name locale="en_CA">Second Brand CA</Name>
         <Name locale="fr_CA">Deuxième marque CA</Name>
      </Names>
   </Brand>

  5. Go to Exports and select Bazaarvoice.

  6. Select Add Destination.

  7. Select Bazaarvoice from the Destination drop-down menu, and choose Save.

  8. In XML Feed name, enter the feed name of generated file.

  9. In SFTP Host, provide your server host.

  10. In SFTP Port, enter 22.

  11. In SFTP Directory, enter the directory where the platform should export the file. By default, it is /import-inbox.

  12. Provide you your SFTP credentials in SFTP Username and SFTP password. If you don't know your SFTP credentials or your file location, contact Bazaarvoice Support.

  13. In Remote File Name, enter the name of the generated XML file. By default, it is bazaarvoice.xml.

  14. In Product Feed Version, enter your feed version or leave the default http://www.bazaarvoice.com/xs/PRR/ProductFeed/14.7. See XML feed for more information.

  15. Optionally, in Category file URL, enter your category file URL.

  16. Optionally, in Category File Delimiter, select a delimiter.

  17. Leave the Encoding Fix toggle On to ensure the data is UTF-8 encoded. Toggle it to Off if you want to export the data with default encoding.

  18. Leave the Splits feed toggle On to split the files containing over 750,000 products into separate XML files, as required by Bazaarvoice.

  19. Toggle Active to On to activate the destination.

  20. Select Save.

  21. If your data is ready, select Run or Export this export in the upper right corner of the page.

In this section: