Product Data Schema
The product data schema below lists all available fields in a product record. Note that actual product records may not have every field present.
Classification Fields
A list of category keywords used for this product across multiple sources.
Example:
"categories": [
"Home Improvement",
"Heating, Cooling, & Air Quality",
"Heaters",
"Propane Heaters"
]
A list of standardized categories to which this product belongs. Category values can be found in the possible values documentation.
Example:
"primaryCategories": [
"Electronics"
]
A list of second-level standardized categories to which this product belongs.
Example:
"secondaryCategories": [
"Cell Phones"
]
Hierarchical classification(s) of a product.
Example:
"taxonomy": [
"automotive > motorcycle & powersports > parts > wheels & tires > tires & accessories > tires & inner tubes > motorcycle & scooter > motorcycle > street"
]
Top level classification of a product.
Example:
"taxonomyLevel1": [
"automotive"
]
Second-level classification of a product.
Example:
"taxonomyLevel2": [
"motorcycle & powersports"
]
Third-level classification of a product.
Example:
"taxonomyLevel3": [
"parts"
]
Fourth-level classification of a product.
Example:
"taxonomyLevel4": [
"wheels & tires"
]
Fifth-level classification of a product.
Example:
"taxonomyLevel5": [
"tires & accessories"
]
Sixth-level classification of a product.
Example:
"taxonomyLevel6": [
"tires & inner tubes"
]
Seventh-level classification of a product.
Example:
"taxonomyLevel7": [
"motorcycle & scooter"
]
Eighth-level classification of a product.
Example:
"taxonomyLevel8": [
"motorcycle"
]
Ninth-level classification of a product.
Example:
"taxonomyLevel9": [
"street"
]
Financing Fields
A list of financing or leasing terms associated with this product. Each term may contain:
Example:
"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": []
}
]
Generic Fields
The date this product was first added to the product database.
Example:
"dateAdded": "2017-01-08T19:12:13Z"
The most recent date this product was updated or seen by our system.
Example:
"dateUpdated": "2017-01-08T19:12:13Z"
A list of descriptions for this product from various sources. Each description contains:
Example:
"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 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.
Each feature contains:
Example:
"features": [
{
"key": "Count",
"replace": "true",
"value": [
"1"
]
},
{
"key": "Included",
"value": [
"Batteries"
]
}
]
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.
Example:
"keys": [
"014045125963",
"0014045125963",
"worthington/299581"
]
Merchant Fields
A list of merchants selling this product. These are typically third-party merchants found on e-commerce websites.
Example:
"merchants": [
{
"address": "2801 S Ih 35",
"availability": "...",
"city": "Austin",
"country": "US",
"dateSeen": "2017-01-08T19:12:13Z",
"isPrivateSeller": false,
"name": "Zappysales",
"phone": "5127131234",
"postalCode": "78701",
"province": "TX"
},
{
"dateSeen": [
"2017-01-08T19:12:13Z"
],
"name": "Next Day Mro, Llc"
}
]
The product's name.
Example:
"name": "Worthington 20-lb Tank"
Pricing Fields
The product's availability based on the most recent price.
Example:
"mostRecentPriceAvailability": "true"
The product's most recent price amount that was scraped.
Example:
"mostRecentPriceAmount": 85
The currency listed for mostRecentPriceAmount.
Example:
"mostRecentPriceCurrency": "USD"
The most recent price date of the product record.
Example:
"mostRecentPriceDate": "2022-03-29T19:26:49.157Z"
The most recent color(s) available for this product when being sold at this price.
Example:
"mostRecentPriceColor": "Torrid - coral with shimmer"
The condition most recently scraped of the product when being sold at this price.
Example:
"mostRecentPriceCondition": "Used"
A true/false for whether or not this price is a sale/discounted price.
Example:
"mostRecentPriceIsSale": "true"
The size associated with this mostRecentPrice.
Example:
"mostRecentPriceSize": "M"
A list of prices of this product by each domain source. These are typically third-party merchants found on e-commerce websites.
Example:
"mostRecentPriceByDomain": [
{
"amount": 79.95,
"availability": "true",
"currency": "USD",
"isSale": "true",
"domain": "www.nordstrom.com",
"sourceURL": "https://www.nordstrom.com/s/sea-level-multifit-cross-front-bikini-top/5746068",
"date": "2022-03-29T16:43:23.440Z",
"firstDateSeen": "2022-03-29T16:59:38.617Z"
},
{
"amount": 89.95,
"availability": "true",
"currency": "USD",
"isSale": "false",
"domain": "www.sephora.com",
"sourceURL": "https://www.sephora.com/s/5746068",
"date": "2022-03-29T16:40:43.440Z"
}
]
The domain of the most recent price scraped by Datafiniti.
Example:
"mostRecentPriceDomain": "www.nordstrom.com"
The most recent URL used to generate data for this product.
Example:
"mostRecentPriceSourceURL": "https://www.nordstrom.com/s/ara-gloria-gore-tex-waterproof-bootie-women/5684497"
A list of prices for this product.
Price objects may contain:
Example:
"prices": [
{
"amountMin": 59.96,
"amountMax": 59.96,
"availability": "true",
"color": "Red",
"condition": "New",
"count": "15",
"currency": "USD",
"dateSeen": [
"2016-06-10T00:00:00Z"
],
"flavor": "Cherry",
"isSale": "false",
"isSold": "false",
"merchant": "domain.com",
"offer": "22% off",
"returnPolicy": "90-Day",
"shipping": "FREE shipping",
"size": "S",
"sourceURLs": [
"https://www.domain.com/p/123"
],
"warranty": "..."
},
{
"amountMin": 62.06,
"amountMax": 72.06,
"condition": "new",
"currency": "USD",
"dateSeen": [
"2016-10-28T00:00:00Z"
],
"merchant": "MRO - website.com",
"sourceURLs": [
"http://www.website.com/4567"
]
}
]
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.
Quantity objects may contain:
Example:
"quantities": [
{
"dateSeen": [
"2013-06-02T16:00:00Z",
"2014-05-01T14:00:00Z"
],
"sourceURLs": [
"http://www.website.com/4567"
],
"value": 20
}
]
Product Attribute Fields
A list of colors available for this product.
Example:
"colors": [
"White",
"Black"
]
The number of units included in the product packaging. Can include a description of the unit.
Example:
"count": "30"
The length, width, and height of this product. Units included.
Example:
"dimension": "23 in x 43.7 in x 30 in"
A list of flavors available for this product.
Example:
"flavors": [
"Fruit Punch",
"Berry",
"Grape"
]
A list of URLs that lead to SDS for the given record.
Example:
"sdsURLs": [
"https://images.homedepot-static.com/catalog/pdfImages/8c/8c72c7b4-1d29-41a3-b8ba-43699e42d44b.pdf"
]
A list of sizes available for this product.
Example:
"sizes": [
"Large",
"Medium",
"Small"
]
The weight of the product. Units included.
Example:
"weight": "20 lbs"
Product Branding Fields
The brand name of this product as presented by the data source.
Example:
"brand": "Sumsung Electronics"
The canonical brand name after normalization of the name from the source.
Example:
"canonicalBrand": "Sumsung"
The manufacturer of this product.
Example:
"manufacturer": "Worthington"
Product Identifier Fields
The ASIN (Amazon identifier) used for this product.
Example:
"asins": "B0009XCFRE"
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.
Example:
"ean": [
"0014045125963",
"0014045125965"
]
The EAN-13 code for this product.
Example:
"ean13": "0014045125963"
The EAN-8 code for this product.
Example:
"ean8": "96385074"
A list of all Global Trade Identifier Numbers for this product. Values will include all ean, isbn, and upc values.
Example:
"gtins": [
"0014045125963",
"0014045125965",
"014045125963",
"014045125961",
"425261",
"3882215542"
]
The ISBN code for this product.
Example:
"isbn": "3882215542"
The manufacturer or model number of this product.
Example:
"manufacturerNumber": "299581"
A list of SKUs for this product. SKUs are typically specific to individual retailers or websites.
SKU objects may contain:
Example:
"skus": [
{
"sourceURLs": [
"http://www.web.com/p/123"
],
"value": "1234XK6"
}
]
The stock number that corresponds to a product.
Example:
"stockNum": "15365711"
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.
Example:
"upc": [
"014045125963",
"014045125961"
]
The UPC-A code for this product.
Example:
"upca": "014045125963"
The UPC-E code for this product.
Example:
"upce": "425261"
Review Fields
A list of reviews for this product.
Review objects may contain:
Example:
"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"
}
]
Source Fields
A list of each unique domain found in the sourceURLs field.
Example:
"domains": [
"www.domain.com",
"www.website.com"
]
A list of image URLs for this product.
Example:
"imageURLs": [
"https://i5.images.com/asr.jpeg"
]
A list of URLs for the primary images taken from each domain sourced in this record. This list will only contain 1 URL per domain.
Example:
"primaryImageURLs": [
"https://www.amazon.com/i/123.jpg",
"https://www.target.com/i/abc.jpg"
]
A list of URLs used to generate data for this product.
Example:
"sourceURLs": [
"https://www.domain.com/p/123",
"http://www.website.com/4567"
]
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.
Example:
"websiteIDs": [
"domain.com-123",
"website.com-4567"
]
Vehicle Fields
The VIN code for this product. This is specific to car listings.
Example:
"vin": "1FTMF1ET8EFB00361"