The product data schema below lists all available fields in a product record. Note that actual product records (actually, most of them) may not have every field present.
Field Name
Example Value (in JSON)
Description
asins
"asins": "B0009XCFRE"
The ASIN (Amazon identifier) used for this product.
Field type: keyword
brand
"brand": "Sumsung Electronics"
The brand name of this product as presented by the data source.
Field type: text
A list of category keywords used for this product across multiple sources.
Field type: text
canonicalBrand
"canonicalBrand": "Sumsung"
The canonical brand name after normalizing the brand names from the source.
Field type: text
colors
"colors": [
"White",
"Black"
]
A list of colors available for this product.
Field type: text
count
"count": "30"
The number of units included in the product packaging. Can include a description of the unit.
Field type: keyword
dateAdded
"dateAdded": "2017-01-08T19:12:13Z"
The date this product was first added to the product database.
Field type: date
dateUpdated
"dateUpdated": "2017-01-08T19:12:13Z"
The most recent date this product was updated or seen by our system.
Field type: date
descriptions
"descriptions": [
{
"dateSeen": "2017-01-08T19:12:13Z",
"sourceURLs": [ "https://www.domain.com/p/123"
],
"value": "Now you can enjoy cooking
your favorite food."
},
{
"sourceURLs": [
"http://www.website.com/4567"
],
"value": "The Worthington Pro Grade 20 lb.
Empty Propane Tank goes with your gas barbecue grill
(sold separately) and accommodates 4.7 gallons of gas."
}
]
A list of descriptions for this product from various sources. Each description contains:
Field type: nested
dateSeen: The date when this description has been seen selling this product.
Field type: date
sourceURLs: A list of source URLs where this specific description was seen.
Field type: keyword
value: A unique description for this product.
Field type: text
A list of each unique domain found in the sourceURLs field.
Field type: domain
ean
"ean": [
"0014045125963",
"0014045125965"
]
The EAN codes for this product. There may be more than one EAN in the list when a product has multiple variations,
each using a different EAN. Learn more about EANs.
Field type: keyword
A list of features associated with this product. The feature list can be collected from specific feature sections available on product listings for the product. It can also serve as a catch-all field for miscellaneous characteristics of this product that don't make sense to include as top-level fields.
Field type: nested
Each feature contains:
key: A label for this feature.
Field type: text
replace: Flag indicating value field is replaced versus appended.
Field type: boolean
value: A list of possible values for this feature.
Field type: text
financingAndLeasing
"financingAndLeasing": [
{
"additionalDetails": [
"acquisitionFee: $925",
"mileOverageFee: $0.30/mile"
],
"apr": 4.15,
"currency": "USD",
"dateSeen": [
"2018-09-20T04:00:00Z"
],
"description": "Well equipped with features",
"disclaimers": "Offer not valid in Puerto Rico.
Lease financing available",
"dueAtSigningMax": 7694,
"dueAtSigningMin": 7694,
"milesPerYear": 22500,
"monthlyPaymentMax": 1269,
"monthlyPaymentMin": 1269,
"name": "2018 Civic Si Coupe 6
Speed Manual Featured Special Lease",
"offerStartDate": "2018-10-31T00:00:00.000Z",
"offerEndDate": "2018-09-05T00:00:00.000Z",
"term": "36 months",
"type": "leasing",
"securityDepositMax": 0,
"securityDepositMin": 0,
"sourceURLs": [
]
}
]
A list of financing or leasing terms associated with this product. Each term may contain:
Field type: text
additionalDetails: Any additional information related to this term.
Field type: text
apr: The annual percentage rate.
Field type: text
currency: The currency listed for any monetary values.
Field type: keyword
dateSeen: A list of dates when this term was seen.
Field type: date
description: The description provided for this term.
Field type: text
disclaimers: Any disclaimers associated with this term.
Field type: text
dueAtSigningMax: The maximum monetary amount due when purchasing this product under this term.
Field type: float
dueAtSigningMin: The minimum monetary amount due when purchasing this product under this term.
Field type: float
milesPerYear: Usually associated with vehicles, the maximum mileage allowed under this term.
Field type: float
monthlyPaymentMax: The maximum amount due each month under this term.
Field type: float
monthlyPaymentMin: The minimum amount due each month under this term.
Field type: float
name: The name for this term.
Field type: text
type: Either financing or leasing.
Field type: keyword
securityDepositMax: The maximum security deposit for this term.
Field type: float
securityDepositMin: The minimum security deposit for this term.
Field type: float
sourceURLs: A list of URLs where this term was seen.
Field type: keyword
flavors
"flavors": [
"Fruit Punch",
"Berry",
"Grape"
]
A list of flavors available for this product.
Field type: text
A list of all Global Trade Identifier Numbers for this product. Values will include all ean, isbn, and upc values. Learn more about GTINs.
Field type: keyword
imageURLs
"imageURLs": [
"https://i5.images.com/asr.jpeg"
]
A list of image URLs for this product.
Field type: keyword
A list of internal Datafiniti identifiers for this product. The keys field is used to merge raw data from individual sources into the master Datafiniti record. Learn how this works
Field type: keyword
manufacturer
"manufacturer": "Worthington"
The manufacturer of this product.
Field type: text
manufacturerNumber
"manufacturerNumber": "299581"
The manufacturer or model number of this product.
Field type: keyword
A list of available quantities for this product. Quantities indicate how many units of the product are available from a specific source at a given time.
Field type: nested
Quantity objects may contain:
dateSeen: A list of dates when this quantity was seen.
Field type: date
sourceURLs: A list of URLs where this quantity was seen.
Field type: keyword
value: The actual quantity value.
Field type: text
reviews
"reviews": [
{
"date": "2015-06-16T00:00:00Z",
"dateSeen": "2016-05-15T00:00:00Z",
"didPurchase": true,
"doRecommend": true,
"id": "1234"
"numHelpful": 4,
"rating": 4,
"sourceURLs": [
"http://www.website.com/4567"
],
"text": "Nice tank at a below
average cost for propane tanks.",
"title": "Solid Propane Tank",
"userCity": "...",
"username": "Cole33",
"userProvince": "..."
},
{
"date": "2015-01-06T00:00:00Z",
"dateSeen": [
"2016-05-15T00:00:00Z"
],
"rating": 5,
"sourceURLs": [
"https://www.domain.com/p/123"
],
"text": "Holds propane and does not leak.
Completed the given gift.",
"title": "tanked",
"username": "joel01"
}
]
A list of reviews for this product.
Field type: nested
Review objects may contain:
date: The date the review was posted.
Field type: date
dateSeen: The date when the review was seen by Datafiniti.
Field type: date
didPurchase: A true/false for whether or not the reviewer did purchase the product.
Field type: boolean
doRecommend: A true/false for whether or not the reviewer recommends the product.
Field type: boolean
id: The website ID associated with this review.
Field type: keyword
numHelpful: The number of people that found this review helpful.
Field type: integer
rating: A 1 to 5 start value for the review.
Field type: float
sourceURLs: A list of URLs where this review was seen.
Field type: keyword
text: The full (or available) text of the review.
Field type: text
title: The review's title.
Field type: text
userCity: The reviewer's city.
Field type: text
username: The reviewer's username.
Field type: text
userProvince: The reviewer's province or state.
Field type: text
Hierarchical classification(s) of a product.
Field type: taxonomy
taxonomyLevel1
"taxonomyLevel1" : [ "automotive" ]
Top level classification of a product.
Field type: keyword
taxonomyLevel2
"taxonomyLevel2" : [ "motorcycle & powersports" ]
Second level classification of a product.
Field type: keyword
taxonomyLevel3
"taxonomyLevel3" : [ "parts" ]
Third level classification of a product.
Field type: keyword
taxonomyLevel4
"taxonomyLevel4" : [ "wheels & tires" ]
Fourth level classification of a product.
Field type: keyword
taxonomyLevel5
"taxonomyLevel5" : [ "tires & accessories" ]
Fifth level classification of a product.
Field type: keyword
taxonomyLevel6
"taxonomyLevel6" : [ "tires & inner tubes" ]
Sixth level classification of a product.
Field type: keyword
taxonomyLevel7
"taxonomyLevel7" : [ "motorcycle & scooter" ]
Seventh level classification of a product.
Field type: keyword
taxonomyLevel8
"taxonomyLevel8" : [ "motorcycle" ]
Eighth level classification of a product.
Field type: keyword
taxonomyLevel9
"taxonomyLevel9" : [ "street" ]
Ninth level classification of a product.
Field type: keyword
upc
"upc": [
"014045125963",
"014045125961"
]
The UPC code for this product.
There may be more than one UPC in the list when a product has multiple variations,
each using a different UPC. Learn more about UPCs.
Field type: keyword
A list of website IDs for this product. Website IDs are tied to a specific online retailer. They are the unique identifier used by website. They are used by Datafiniti when other unique identifiers are not available for a product.
Field type: keyword
weight
"weight": "20 lbs"
The weight of the product. Units included.
Field type: text
