Prices and availability
Prices and availability across websites.
GET https://api.deepscout.ai/v1/exports/prices_and_availability_by_website
Authorization: Bearer YOUR_API_KEYWho gets it: managed customers only. Self-service projects do not have it. You get the same data when you join the Matches and Products datasets on website_id and product_id.
Derived dataset based on the base datasets all_products_with_details and matches: an overview table of prices and availability across all tracked websites. It contains only a subset of fields — the complete data is in the base datasets.
Each row is one product of your website with its matched competitors' prices and availability in per-website columns (price_*, availability_*).
Fields
| Field | Type | Description |
|---|---|---|
website_id | string | Identifier of your website |
product_url | string | Product URL |
image_url | string | Image URL |
own_product_id | string | ID of the product in the database of your website |
name | string | Product name |
price_{website_id} | number | Price on the given website |
availability_{website_id} | string | Availability on the given website |
__url_{website_id} | string | Matched product URL |
__sku_{website_id} | string | Matched product SKU |
competitors_count | number | Number of websites with a price for this product, your website included. The value 1 means that no competitor has a price. |
Dynamic columns (price_*, availability_*, __url_*, __sku_*) are generated for each website in your project.
Empty values
The value null in a competitor column means that we have no matched product with a price from this competitor. Either the competitor does not sell the product, or the matching did not connect it (for example, a different name or no EAN). Thus null does not prove that the competitor does not have the product.
As a result, calculations on the competitor columns apply only to the matched products.
Example
{
"website_id": "eshop-a.cz",
"product_url": "https://eshop-a.cz/produkt",
"name": "Product name",
"own_product_id": "SKU-001",
"price_eshop-a.cz": 399,
"price_eshop-b.cz": 449,
"price_eshop-c.cz": null,
"availability_eshop-a.cz": "IN_STOCK",
"availability_eshop-b.cz": "IN_STOCK",
"availability_eshop-c.cz": "OUT_OF_STOCK",
"__url_eshop-b.cz": "https://eshop-b.cz/produkt",
"__url_eshop-c.cz": "https://eshop-c.cz/produkt",
"competitors_count": 2
}