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": []
}
]
Any additional information related to this term.
The annual percentage rate.
The currency listed for any monetary values.
A list of dates when this term was seen.
The description provided for this term.
Any disclaimers associated with this term.
The maximum monetary amount due when purchasing this product under this term.
The minimum monetary amount due when purchasing this product under this term.
Usually associated with vehicles, the maximum mileage allowed under this term.
The maximum amount due each month under this term.
The minimum amount due each month under this term.
The name for this term.
Either financing or leasing.
The maximum security deposit for this term.
The minimum security deposit for this term.
A list of URLs where this term was seen.
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."
}
]
The date when this description has been seen selling this product.
A list of source URLs where this specific description was seen.
A unique description for this product.
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 label for this feature.
Flag indicating value field is replaced versus appended.
A list of possible values for this feature.
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 merchant's physical address.
A description of the product's availability with this merchant.
The merchant's city.
The date when this merchant has been seen selling this product.
True if the merchant is an individual. False if it's a company.
The merchant's name.
The merchant's phone number.
The merchant's postal or zip code.
The merchant's province or state.
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 price amount of the product by this domain.
A true or false if this product is available at this price.
The currency listed for amount.
The color associated with this price.
The condition of the product when being sold at this price.
The date when this price was seen.
The domain sourceURL of the product's price.
The date of when the record was first scraped by Datafiniti.
A true/false for whether or not this price is a sale/discounted price.
The size associated with this price.
A list of URLs.
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"
]
}
]
The minimum price value listed.
The maximum price value listed. This is typically the same as amountMin, except in cases where a price range is listed.
A true or false if this product is available at this price.
The color associated with this price.
The condition of the product when being sold at this price.
The number of units being sold at this price.
The currency listed for amountMin and amountMax.
A list of dates when this price was seen.
The flavor associated with this price.
A true/false for whether or not this price is a sale/discounted price.
A true/false for whether or not the product has been sold at this price, typically reserved for vehicle listings.
The merchant and/or website selling at this price.
Any special offer associated with this price.
The return policy associated with this price.
The shipping terms associated with this price.
The size associated with this price.
A list of URLs where this price was seen.
The warranty associated with this price.
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
}
]
A list of dates when this quantity was seen.
A list of URLs where this quantity was seen.
The actual quantity value.
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"
}
]
A list of URLs where this SKU was seen.
The actual SKU.
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"
}
]
The date the review was posted.
The date when the review was seen by Datafiniti.
A true/false for whether or not the reviewer did purchase the product.
A true/false for whether or not the reviewer recommends the product.
The website ID associated with this review.
The number of people that found this review helpful.
A 1 to 5 star value for the review.
A list of URLs where this review was seen.
The full (or available) text of the review.
The review's title.
The reviewer's city.
The reviewer's username.
The reviewer's province or state.
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"
Last updated 3 days ago
Built with Documentation.AI