Provide personalized pricing recommendations


Thanks to Datafiniti's robust query system, you can construct very specific searches across a wide number of fields, including price. This can be helpful when trying to provide users or customers with information on which products match their budgets.

Available pricing data

There are handful of fields to know about when searching Datafiniti for pricing information:

mostRecentPriceAmountThe product's most recent price amount scraped.
mostRecentPriceAvailabilityThe product's most recent price availability scraped.
mostRecentPriceByDomainA list of Prices of this product by each domain source. These are typically third-party merchants found on e-commerce websites.
mostRecentPriceCurrencyThe currency listed for mostRecentPriceAmount.
mostRecentPriceDateThe most recent price date of the product record.
mostRecentPriceDomainThe domain of the most recent price scraped by Datafiniti
mostRecentPriceSourceURLThe most recent URL used to generate data for this product.
pricesA list of prices for this product.

The mostRecent fields will help you search for the most up-to-date price of a product, while the prices array will give you a full price history to search on.

Here are the fields within a single prices object:

amountMinThe minimum price value listed.
amountMaxThe maximum price value listed. This is typically the same as amountMin, except in cases where a price range is listed.
availabilityA true or false if this product is available at this price.
colorThe color associated with this price.
conditionThe condition of the product when being sold at this price.
countThe number of units being sold at this price.
currencyThe currency listed for amountMin and amountMax.
dateSeenA list of dates when this price was seen.
flavorThe flavor associated with this price.
isSaleA true/false for whether or not this price is a sale/discounted price.
isSoldA true/flase for whether or not the product has been sold at this price (typically reserved for vehicle listings).
merchantThe merchant and/or website selling at this price.
offerAny special offer associated with this price.
returnPolicyThe return policy associated with this price.
shippingThe shipping terms associated with this price.
sizeThe size associated with this price.
sourceURLsA list of URLs where this price was seen.
warrantyThe warranty associated with this price.

You can use any of the above fields when searching on prices.

Searching on prices

Let's learn how to search on prices in different ways.

We can start with a very basic search that return any products in a given category with a price:

  "query": "categories:electronics AND prices:*

If we want to search for products within a certain price range, we can do this, which will return all products priced between $100 and $200.

  "query": "categories:electronics AND {prices.amountMin:>=100 AND prices.currency:USD} AND {prices.amountMin:<=200 AND prices.currency:USD}"

If we want to find products that are recently on sale, we can do this, which will return all products on sale since April 1, 2023:

  "query": "categories:electronics AND {prices.isSale AND prices.dateSeen:[2023-04-01 TO *]}"

If we want to make sure we return products that have a warranty:

  "query": "categories:electronics AND prices.warranty:*

You can use any number of combination of fields to find exactly the pricing data you want. With this information, you can provide information back to customers that gives them the exact insight they need.

Example files

Here are example bulk download files of our previous query:


With the knowledge of how to pull records with product pricing, you can provide users or customers with information on which products match their budgets.