Retail/Regulated Industries Product Fields

Detailed descriptions of the attributes (fields) available for use within each of the required data feeds can be found below. Mandatory attributes are marked accordingly. Issues with the data feed processing will occur if any of the fields are missing.

It is important to provide as many recommended (optional) columns as possible. The more data a client provides about a product and customer, the better we will be able to manage the reviews that we collect for the client.

Summary

AttributeRequirementTypeMax lengthExample
skumandatorytext191IP12345
namemandatorytext191Apple iPhone 8 -64GB Gold
product_categorymandatorytext191Smart Phones
image_urlmandatorytext2000https://brain-images-ssl.cdn.dixons.com/2/5/10185952/u_10185952.jpg
manufactureroptionaltext40Apple
modelmandatory*text40iPhone 8
mpnmandatory*text401234MPN56789
eanmandatory*text40EA123456789
product_descriptionoptionaltext191Apple iPhone 8, 64GB internal storage in gold colour
product_group_idoptionaltext191IP864
product_group_nameoptionaltext191Apple iPhone 8 64GB

*Mandatory to have at least one of them for aggregating Reviews & Ratings

sku


Definition

Unique product identifier, or SKU.

Usage

The SKU is used to link the Product feed with Purchaser feed (customer sales data) so that our platform can identify products and services that customers purchased. This way, we can ask consumers questions relevant to their purchases in the questionnaires we email to them.

SKUs are also used for purposes of aggregation, and to ensure we can show the right reviews in the right places on your websites. Failure to provide information regarding a particular SKU in your Product feed that later appears in your Purchaser feed, will mean we're unable to collect reviews from consumers who have bought those products or services.

Constraints

  • Alphanumeric
  • Dashes and underscores
  • No spaces or symbols

Examples

  • DR26BBA1234
  • 234_172
  • ss-124

name


Definition

Name of the product

Usage

To identify the name of the product associated with the SKU value.

Constraints

  • Must not contain SKU value
  • Must not be in URL or similar format

Examples

  • Apple iPhone XS Max
  • Bose QC35
  • Car Insurance Comprehensive 1

product_category


Definition

To identify the category of each product.

Usage

Reevoo system will use the product category value to map the correct questionnaire, which will be sent to the purchaser to complete. Therefore, it's crucial to send the correct category for the associated product. Failing to do this will send the incorrect questionnaire to the purchaser.

Constraints

  • Must not include product name
  • Must not include the manufacturer name
  • Must be related to the product

Examples

  • Mobile Phones
  • Headphones
  • Car Insurance

image_url


Definition

Image of the specific product.

Usage

This is used mainly in review e-mails and questionnaires, but also for the review displaying purposes

Constraints

  • JPG or PNG
  • Min size 200x200px
  • No break space in URL
  • URL must start with https:// (Hypertext Transfer Protocol Secure)

Examples

manufacturer


Definition

Name of the manufacturer of the product

Usage

To identify the manufacturer of the product. Reevoo will use this for reporting and review aggregational purposes

Constraints

  • Must be related to the product
  • Must not include product name

Examples

  • Reevoo
  • Apple
  • Bose

model


Definition

Model range of the specific product

Usage

Model is used as one of the key parameters to aggregate reviews into Reevoo's retailer network, where retailers with reviews for products that are matching models will be aggregated

Constraints

  • Must not include the manufacturer name
  • Must not be identical to MPN

Examples

  • Google Home Mini Grey
  • Bose QC35 II
  • iPhone 8 plus 128gb grey

mpn


Definition

MPN (Manufacturer Part Number) is a unique code that is issued by the manufacturer and set to an individual product.

Usage

MPN is used as one of the key parameters to aggregate reviews into Reevoo's retailer network, where retailers with reviews for products that are matching MPN will be aggregated

Constraints

  • Must not be identical to the model name
  • Must not be identical to the EAN code

Examples

  • 12536283
  • 1234ABCD
  • JSsdhisSDJs

ean


Definition

EAN (European Article Number) s a unique number that is issued by the manufacturer and set to an individual product.

Usage

EAN is used as one of the key parameters to aggregate reviews into Reevoo's retailer network, where retailers with reviews for products that are matching EAN will be aggregated

Constraints

  • Must not be identical to the model name
  • Must not be identical to the MPN code

Examples

  • 26352ahsudgEE
  • thefdhtu12345

product_description


Definition

Description of the product

Usage

This could be used for reporting purposes or other tools provided by Reevoo

Constraints

  • Max length 191 characters
  • No special characters
  • No HTML tags

Examples

  • iPhone X Max Special Edition, 128GB
  • Bose QC 35 - The QC35 headphones let you focus on your music, movies and videos. And they reduce what you don't want to hear. Like a crowded city street, cabin noise inside an aeroplane or a busy office.
  • Sony WF-100XM3 Noise Cancelling TRUE Wireless Bluetooth NFC in-Ear Headphones with Mic/Remote, Black

product_group_id


Definition

Usage

Constraints

Examples

product_group_name


Definition

Usage

Constraints

Examples