# Prices and availability (/en/datasets/prices-and-availability)

```
GET https://api.deepscout.ai/v1/exports/prices_and_availability_by_website
Authorization: Bearer YOUR_API_KEY
```

**Who gets it:** managed customers only. Self-service projects do not have it. You get the same data when you join the [Matches](/en/datasets/matches.md) and [Products](/en/datasets/products.md) datasets on `website_id` and `product_id`.

Derived dataset based on the base datasets [`all_products_with_details`](/en/datasets/products.md) and [`matches`](/en/datasets/matches.md): 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 [#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 [#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 [#example]

```json
{
  "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
}
```