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
Updated over 1 year ago