GET /price-drops

Price Drops

List Mercadona products currently on a price drop for any Spanish postal code, with the discount in euros and percent.

Mercadona API

Returns the Mercadona products that are currently cheaper than their previous price at the warehouse that serves a postal code. Each row is a full product row plus discount_value (EUR) and discount_percent. Price drops are calculated from the product’s previous price (previous_price_value), not from Mercadona’s own flag. Use it to build deal alerts, track promotions per city or feed a price history.

HTTP Request

GET /price-drops

Parameters

ParameterTypeRequiredDefaultDescription
warehousestringNovlc1Hub or 4-digit store code (see Warehouses ). Ignored when postal_code is given. Numeric store codes are served live: brand, ean, category_path and popularity_score may be null on their rows, and a brand or level-1/2 category_id filter returns 400 for them
postal_codestringNo-Spanish 5-digit postal code, resolved to the warehouse that serves it. Takes precedence over warehouse
pageintegerNo11-indexed page
per_pageintegerNo20Items per page, max 20
category_idintegerNo-Category id at any level (see Category Tree )
brandstringNo-Exact brand name as Mercadona writes it (see Brands ). Several brands comma-separated are OR-ed (Danone,Puleva)
min_pricenumberNo-Lowest price_value in euros, inclusive, 0 to 10000 (e.g. 2 or 1.5). total counts only products in the range; products without a price are left out when a bound is set
max_pricenumberNo-Highest price_value in euros, inclusive, 0 to 10000. Must be greater than or equal to min_price
sortstringNodiscount_percentdiscount_percent (biggest cut in % first), discount_value (biggest saving in euros first), popularity, price_asc, price_desc. Ties are broken by product_id. When the answer has source: live, popularity keeps Mercadona’s own price-drop order
freshbooleanNofalseBypass the 15-minute cache. Only affects answers with source: live; catalog_index answers come from the daily catalog snapshot (snapshot_date) and refresh once a day
languagestringNoesLanguage for product and category names: es, en or ca

Response

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153

{
  "status": true,
  "request_id": "8ca32b7d-b494-d012-9dab-145fdc6d",
  "cached_at": null,
  "data": {
    "items": [
      {
        "product_id": "12151",
        "name": "Chocolate con leche Milka",
        "slug": "chocolate-con-leche-milka-tableta",
        "url": "https://tienda.mercadona.es/product/12151/chocolate-con-leche-milka-tableta",
        "thumbnail": "https://prod-mercadona.imgix.net/images/e6cbab042ce93bc6756ef45ff91a19bc.jpeg?fit=crop&h=300&w=300",
        "packaging": "Tableta",
        "main_feature": null,
        "is_water": false,
        "requires_age_check": false,
        "category": {
          "category_id": 9,
          "name": "Azúcar, caramelos y chocolate"
        },
        "availability": {
          "in_stock": true,
          "status": null,
          "unavailable_from": null,
          "unavailable_weekdays": [],
          "order_limit": 999
        },
        "price": "1.25",
        "price_value": 1.25,
        "previous_price": "1.95",
        "previous_price_value": 1.95,
        "is_price_drop": true,
        "unit_price": "8.334",
        "unit_price_value": 8.33,
        "unit_price_format": "kg",
        "bulk_price_value": 8.33,
        "size_format": "kg",
        "unit_size": 0.15,
        "is_pack": false,
        "pack_size": null,
        "total_units": null,
        "unit_name": null,
        "iva_percent": 10,
        "approx_size": false,
        "drained_weight": null,
        "currency": "EUR",
        "color_variants": null,
        "warehouse": "mad3",
        "ean": "7622201024277",
        "brand": "Milka",
        "category_path": [
          [
            {
              "category_id": 9,
              "name": "Azúcar, caramelos y chocolate",
              "level": 0
            },
            {
              "category_id": 92,
              "name": "Chocolate",
              "level": 1
            }
          ]
        ],
        "popularity_score": 1943.0,
        "discount_value": 0.7,
        "discount_percent": 35.9
      },
      {
        "product_id": "18234",
        "name": "Refresco Fanta naranja",
        "slug": "refresco-fanta-naranja-botella",
        "url": "https://tienda.mercadona.es/product/18234/refresco-fanta-naranja-botella",
        "thumbnail": "https://prod-mercadona.imgix.net/images/ecdd7174b4d7ae6300d1e8c4d461e2e5.jpg?fit=crop&h=300&w=300",
        "packaging": "Botella",
        "main_feature": null,
        "is_water": false,
        "requires_age_check": false,
        "category": {
          "category_id": 18,
          "name": "Agua y refrescos"
        },
        "availability": {
          "in_stock": true,
          "status": null,
          "unavailable_from": null,
          "unavailable_weekdays": [],
          "order_limit": 999
        },
        "price": "1.00",
        "price_value": 1.0,
        "previous_price": "1.55",
        "previous_price_value": 1.55,
        "is_price_drop": true,
        "unit_price": "0.800",
        "unit_price_value": 0.8,
        "unit_price_format": "L",
        "bulk_price_value": 0.8,
        "size_format": "l",
        "unit_size": 1.25,
        "is_pack": false,
        "pack_size": null,
        "total_units": null,
        "unit_name": null,
        "iva_percent": 21,
        "approx_size": false,
        "drained_weight": null,
        "currency": "EUR",
        "color_variants": null,
        "warehouse": "mad3",
        "ean": "5449000028938",
        "brand": "Fanta",
        "category_path": [
          [
            {
              "category_id": 18,
              "name": "Agua y refrescos",
              "level": 0
            },
            {
              "category_id": 159,
              "name": "Refresco de naranja y de limón",
              "level": 1
            }
          ]
        ],
        "popularity_score": 207.0,
        "discount_value": 0.55,
        "discount_percent": 35.48
      }
    ],
    "total": 150,
    "page": 1,
    "per_page": 2,
    "total_pages": 75,
    "has_next_page": true,
    "sort": "discount_percent",
    "source": "catalog_index",
    "snapshot_date": "2026-10-14",
    "resolved_filters": {
      "warehouse": {
        "input": "28001",
        "resolved": "mad3",
        "source": "postal_code"
      }
    },
    "language": "es"
  },
  "request_params": {
    "postal_code": "28001",
    "per_page": "2"
  }
}

Response Fields

FieldTypeDescription
statusbooleantrue on success
request_idstringUnique request identifier
cached_atstring | nullISO timestamp when the answer came from cache, null when fetched for this request
dataobjectResponse payload
data.items[]array of objectsProducts currently on a price drop
data.items[].product_idstringMercadona product id. Pass it verbatim: decimal ids like 81241.3 exist
data.items[].namestringProduct name, translated with language
data.items[].slugstringURL slug of the product
data.items[].urlstringProduct URL on tienda.mercadona.es
data.items[].thumbnailstringProduct image URL (imgix)
data.items[].packagingstring | nullPackaging, e.g. "Tableta", "Botella", "Pieza"
data.items[].main_featurestring | nullHighlighted feature shown under the name
data.items[].is_waterbooleanWater product flag
data.items[].requires_age_checkbooleanAlcohol or other age-restricted product
data.items[].categoryobjectLevel-0 category of the product
data.items[].category.category_idintegerLevel-0 category id
data.items[].category.namestringLevel-0 category name, translated with language
data.items[].availabilityobjectAvailability at the resolved warehouse
data.items[].availability.in_stockbooleanIn stock at the resolved warehouse
data.items[].availability.statusstring | nullRestriction status, null when there is none
data.items[].availability.unavailable_fromstring | nullDate the product stops being available
data.items[].availability.unavailable_weekdaysarrayWeekdays the product can’t be delivered
data.items[].availability.order_limitintegerMaximum units per order (e.g. 999)
data.items[].pricestringDisplay price in EUR, e.g. "1.25"
data.items[].price_valuefloatNumeric price in EUR
data.items[].previous_pricestring | nullPrevious display price, null when there is none
data.items[].previous_price_valuefloat | nullPrevious numeric price in EUR
data.items[].is_price_dropbooleantrue when the current price is below previous_price. Computed from the previous price, not Mercadona’s own flag
data.items[].unit_pricestringDisplay unit price, e.g. "0.800"
data.items[].unit_price_valuefloatNumeric unit price
data.items[].unit_price_formatstringUnit the unit price refers to, e.g. "L", "kg", "ud"
data.items[].bulk_price_valuefloatBulk price
data.items[].size_formatstringSize unit, e.g. "l", "kg"
data.items[].unit_sizefloatSize in size_format units
data.items[].is_packbooleanWhether the product is a pack
data.items[].pack_sizefloat | nullSize of each unit in the pack
data.items[].total_unitsinteger | nullUnits in the pack
data.items[].unit_namestring | nullUnit name, e.g. "ud.", "briks"
data.items[].iva_percentintegerVAT percentage
data.items[].approx_sizebooleanSize is approximate (e.g. fruit sold by the piece)
data.items[].drained_weightfloat | nullDrained weight
data.items[].currencystringAlways "EUR"
data.items[].color_variantsarray | nullColour variants
data.items[].warehousestringWarehouse that answered
data.items[].eanstring | nullEAN barcode. Can be null (always possible on numeric store codes)
data.items[].brandstring | nullBrand name as Mercadona writes it. Can be null, e.g. for unbranded fresh produce
data.items[].category_patharray of arraysCategory paths. Each path is a list of {category_id, name, level} objects from level 0 down. Can be empty
data.items[].category_path[][].category_idintegerCategory id
data.items[].category_path[][].namestringCategory name, translated with language
data.items[].category_path[][].levelintegerCategory level: 0, 1 or 2
data.items[].popularity_scorefloat | nullMercadona’s internal popularity score. null on numeric store codes
data.items[].discount_valuefloatSaving in EUR: previous_price_value minus price_value
data.items[].discount_percentfloatSaving as a percentage of previous_price_value
data.totalintegerProducts on a price drop (within the price range, if set)
data.pageintegerCurrent page (1-indexed)
data.per_pageintegerItems per page
data.total_pagesintegerTotal number of pages
data.has_next_pagebooleanWhether another page follows
data.sortstringSort order applied
data.sourcestringData origin: catalog_index (daily catalog snapshot) or live
data.snapshot_datestringDate of the catalog snapshot used
data.resolved_filters.warehouseobjectThe warehouse that answered
data.resolved_filters.warehouse.inputstring | nullThe postal_code or warehouse you sent, null if none
data.resolved_filters.warehouse.resolvedstringWarehouse code used, e.g. mad3
data.resolved_filters.warehouse.sourcestringHow it was chosen: postal_code, param or default
data.languagestringLanguage used for names: es, en or ca
request_paramsobjectThe query parameters you sent, echoed back as strings

Error Responses

Invalid input returns HTTP 400, and error is a plain string:

1
2
3
4
5
6
7
8

{
  "status": false,
  "request_id": "b757e855-4127-3b96-509a-8b573904",
  "error": "Invalid parameter 'warehouse': String should match pattern '^(?:[a-z]{3}[0-9]|[0-9]{4})$'",
  "request_params": {
    "warehouse": "xyz"
  }
}
Status CodeCauseDescription
400Invalid parameterMalformed warehouse, per_page above 20, min_price or max_price outside 0 to 10000, or max_price lower than min_price
400Filter on a store codePer the RapidAPI docs, a brand or level-1/2 category_id filter returns 400 when the warehouse is a numeric store code. Use a hub or a postal code that resolves to one

An unknown brand is not an error: you get an empty items list.

Code Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19

import requests

url = "https://mercadona-api.p.rapidapi.com/price-drops"

params = {
    "postal_code": "28001",
    "sort": "discount_percent"
}

headers = {
    "X-RapidAPI-Key": "YOUR_API_KEY",
    "X-RapidAPI-Host": "mercadona-api.p.rapidapi.com"
}

response = requests.get(url, headers=headers, params=params)
data = response.json()["data"]

for item in data["items"]:
    print(f"{item['name']}: {item['price_value']} EUR (-{item['discount_percent']}%)")

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18

const url = "https://mercadona-api.p.rapidapi.com/price-drops";

const params = new URLSearchParams({
  postal_code: "28001",
  sort: "discount_percent"
});

const response = await fetch(`${url}?${params}`, {
  headers: {
    "X-RapidAPI-Key": "YOUR_API_KEY",
    "X-RapidAPI-Host": "mercadona-api.p.rapidapi.com"
  }
});

const { data } = await response.json();
data.items.forEach(item => {
  console.log(`${item.name}: ${item.price_value} EUR (-${item.discount_percent}%)`);
});

1
2
3
4
5

curl -G "https://mercadona-api.p.rapidapi.com/price-drops" \
  --data-urlencode "postal_code=28001" \
  --data-urlencode "sort=discount_percent" \
  -H "X-RapidAPI-Key: YOUR_API_KEY" \
  -H "X-RapidAPI-Host: mercadona-api.p.rapidapi.com"
  • Product Details : full sheet (ingredients, allergens, photos) for a discounted product
  • Brands : exact brand names to use in the brand filter
  • Resolve Warehouse : check which warehouse a postal code maps to
  • Campaign Products : the price-drop carousel as Mercadona shows it on its home page
Previous New Products
Next Brand Products
Start building today

Get your API key and make your first request in under a minute.

Get Your API Key on RapidAPI