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

Attribute

Requirement

Type

Max length

Example

sku

mandatory

text

191

IP12345

name

mandatory

text

191

Apple iPhone 8 -64GB Gold

product_category

mandatory

text

191

Smart Phones

image_url

mandatory

text

2000

https://brain-images-ssl.cdn.dixons.com/2/5/10185952/u_10185952.jpg

manufacturer

optional

text

40

Apple

model

mandatory*

text

40

iPhone 8

mpn

mandatory*

text

40

1234MPN56789

ean

mandatory*

text

40

EA123456789

product_description

optional

text

191

Apple iPhone 8, 64GB internal storage in gold colour

product_group_id

optional

text

191

IP864

product_group_name

optional

text

191

Apple 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