Coles Price Scraper: how to get Specials, Unit Prices as JSON/CSV (API, Python, no code)

Scrape Coles Australia products by department, category or the specials pages: price, was price, unit price, half price and multibuy offers, stock, purchase limits and aisle. This guide shows the output fields, a working input, and Python, JavaScript and cURL code for the Actor v0iddo/coles-scraper on Apify.

Open Coles Price Scraper on Apify

What data you get

One row per result. Every row can be downloaded as JSON, CSV, Excel or HTML, or read through the API.

Input example

This is the input that is pre-filled on the Actor page. Change the values for your own run.

{
  "categories": [
    "dairy-eggs-fridge/yoghurt"
  ],
  "maxItems": 20
}

Output sample

Real rows from a run of the Actor. Fields that name people are left out of the sample.

[
  {
    "source": "dairy-eggs-fridge/yoghurt",
    "page": 1,
    "position": 1,
    "productId": "1935919",
    "name": "Greek Nas Protein Yoghurt Pouch Mixed Berries",
    "brand": "Farmers Union",
    "size": "150g",
    "description": "FARMERS UNION GREEK NAS PROTEIN YOGHURT POUCH MIXED BERRIES 150G",
    "price": 1.9,
    "wasPrice": 2.9,
    "currency": "AUD",
    "onSpecial": true,
    "onlineOnlySpecial": false,
    "saveAmount": 1,
    "offerText": "save $1.00",
    "isNew": false,
    "unitPrice": 1.27,
    "unitMeasure": "100g",
    "unitPriceText": "$1.27/ 100g",
    "soldByWeight": false,
    "available": true,
    "availableQuantity": 424,
    "retailLimit": 20,
    "promotionalLimit": 12,
    "department": "Dairy, Eggs & Fridge",
    "category": "Yoghurt",
    "aisle": "Single Serve",
    "image": "https://cdn.productimages.coles.com.au/productimages/1/1935919.jpg",
    "url": "https://www.coles.com.au/product/farmers-union-greek-nas-protein-yoghurt-pouch-mixed-berries-150g-1935919",
    "chargeUnits": 1
  },
  {
    "source": "dairy-eggs-fridge/yoghurt",
    "page": 1,
    "position": 2,
    "productId": "1935894",
    "name": "Nas Protein Yoghurt Pouch Tropical",
    "brand": "Farmers Union",
    "size": "150g",
    "description": "FARMERS UNION NAS PROTEIN YOGHURT POUCH TROPICAL 150G",
    "price": 1.9,
    "wasPrice": 2.9,
    "currency": "AUD",
    "onSpecial": true,
    "onlineOnlySpecial": false,
    "saveAmount": 1,
    "offerText": "save $1.00",
    "isNew": false,
    "unitPrice": 1.27,
    "unitMeasure": "100g",
    "unitPriceText": "$1.27/ 100g",
    "soldByWeight": false,
    "available": true,
    "availableQuantity": 1203,
    "retailLimit": 20,
    "promotionalLimit": 12,
    "department": "Dairy, Eggs & Fridge",
    "category": "Yoghurt",
    "aisle": "Single Serve",
    "image": "https://cdn.productimages.coles.com.au/productimages/1/1935894.jpg",
    "url": "https://www.coles.com.au/product/farmers-union-nas-protein-yoghurt-pouch-tropical-150g-1935894",
    "chargeUnits": 1
  }
]

Code: Python, JavaScript and cURL

Get your API token in Apify Console under Settings, then Integrations. The Actor id is v0iddo/coles-scraper.

Python (apify-client)

from apify_client import ApifyClient

client = ApifyClient("YOUR_APIFY_TOKEN")

run_input = {'categories': ['dairy-eggs-fridge/yoghurt'], 'maxItems': 20}

run = client.actor("v0iddo/coles-scraper").call(run_input=run_input)
for item in client.dataset(run["defaultDatasetId"]).iterate_items():
    print(item)

JavaScript (apify-client)

import { ApifyClient } from 'apify-client';

const client = new ApifyClient({ token: 'YOUR_APIFY_TOKEN' });

const input = {
  "categories": [
    "dairy-eggs-fridge/yoghurt"
  ],
  "maxItems": 20
};

const run = await client.actor('v0iddo/coles-scraper').call(input);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
console.log(items);

cURL

curl -X POST "https://api.apify.com/v2/acts/v0iddo~coles-scraper/run-sync-get-dataset-items" \
  -H "Authorization: Bearer YOUR_APIFY_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"categories": ["dairy-eggs-fridge/yoghurt"], "maxItems": 20}'

Price

$0.50 per 1,000 results. You pay per result row. There is no separate charge per run. Higher Apify plans pay less per result, down to $0.35 per 1,000. See the pricing tab for your plan. A new Apify account gets $5 of platform credit every month.

Good to know

• Reads Coles' public department, category and specials pages. Its search box is closed to automated access in robots.txt, so the actor takes departments and categories, not keywords.
• Prices, specials and stock are those Coles shows a visitor who has not chosen a store (its default online store); prices are in Australian dollars.
• Sponsored tiles are left out, so a category gives the products Coles counts for it, each once.
• Include details opens each product's page: barcode (GTIN), ingredients, allergens, dietary notes, country of origin and nutrition per 100 g where Coles shows them. A row with details counts as 10...

FAQ

What data does the Coles Price Scraper return?

Each result is one row in an Apify dataset. Fields include productId, name, brand, size, price, wasPrice, unitPrice, unitMeasure, and more. The table above shows every field with an example value.

How do I use the Coles Price Scraper from Python?

Install the apify-client package, create a client with your Apify API token, call the Actor v0iddo/coles-scraper with an input like the one above, and read the rows from the run's dataset. The Python snippet above does exactly that.

Can I use it without writing code?

Yes. Open the Actor page on Apify, fill in the input form (an example is already filled in), press Start, and download the results as JSON, CSV, Excel or HTML. You can also schedule runs there.

How much does it cost?

$0.50 per 1,000 results. You pay per result row. There is no separate charge per run. Higher Apify plans pay less per result, down to $0.35 per 1,000. A new Apify account gets $5 of platform credit every month.

How do I limit the number of results?

Set the maxItems input field to the number of results you need; the run stops there, so it also caps the cost of one run. You can also set a maximum cost for a run in the run options on Apify, and the run stops when it is reached.

Can I send the results to Google Sheets, Make, Zapier or n8n?

Yes. Apify datasets connect to Google Sheets, Slack, Make, Zapier and n8n, and a webhook can call your own service when a run finishes. You can also export the dataset as JSON, CSV or Excel.

Open Coles Price Scraper on Apify

Related guides

• Alibaba Scraper: Scrape Alibaba.com product offers by keyword: title, price range and quantity price tiers, minimum order, u...
• Vinted Product Scraper: Collect public Vinted listings by search word or catalog link: title, brand, size, condition, price with cu...
• TikTok Shop Scraper: Scrape TikTok Shop product pages in the United States from product links or IDs: title, price, original pri...