# E-commerce Product Data Aggregator (`thriftykiwi/ecommerce-product-aggregator`) Actor

Aggregates product catalogue and live pricing data from three free commerce APIs - Open Food Facts, Open Prices and CheapShark - into one normalised dataset with name, brand, category, price, currency, store and image.

- **URL**: https://apify.com/thriftykiwi/ecommerce-product-aggregator.md
- **Developed by:** [Thrifty Kiwi](https://apify.com/thriftykiwi) (community)
- **Categories:** E-commerce
- **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet

## Pricing

$1.00 / 1,000 result items

This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.

Learn more: https://docs.apify.com/actors/running/actors-in-store.md#pay-per-event

## What's an Apify Actor?

An Actor is a serverless cloud program that runs on the Apify platform. It has two run modes.
In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours,
and optionally produces a well-defined JSON output, datasets with results, or files in key-value store.
In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server.

Apify vocabulary and the platform model are defined once, in the agent quickstart at https://apify.com/agents.md.

## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.

Do not guess an integration path. Every one of them is in the agent quickstart at https://apify.com/agents.md: the Apify MCP server, Agent Skills with the Apify CLI, the JavaScript and Python clients, the REST API, and the account-free path for an agent with no human to sign in. It also carries the rule on stating cost before the first paid run.

For examples already wired to this Actor's own input schema, see the [API](#api) section below.

Each client library has reference documentation the quickstart does not restate: [JavaScript/TypeScript](https://docs.apify.com/api/client/js/docs.md) (`npm install apify-client`) and [Python](https://docs.apify.com/api/client/python/docs.md) (`pip install apify-client`).

# README

**E-commerce Product Data Aggregator** pulls structured data from Open Food Facts, Open Prices & CheapShark and returns it as a clean dataset you can export as JSON, CSV or Excel. It pulls product records and real store prices from three free commerce APIs and normalises them into a single dataset with product name, brand, category, price, currency, store, barcode and image - useful for price monitoring and catalogue work.

No API key, no login. Click **Start** and it works with the prefilled input.

### What does E-commerce Product Data Aggregator do?

It queries [Open Food Facts, Open Prices & CheapShark](https://world.openfoodfacts.org) and returns one row per record, with only the fields that matter. Runs on the Apify platform, so you get an API endpoint, scheduling, monitoring and integrations (Zapier, Make, Google Sheets, webhooks) without maintaining any infrastructure.

### Why use it?

- **Open Food Facts, Open Prices & CheapShark data without the plumbing**: no proxy setup, no pagination code, no scraping maintenance.
- **Schedule it** to monitor changes daily or weekly and trigger alerts on new records.
- **Feed it straight into** a spreadsheet, database, or an AI agent via the Apify API or MCP server.
- Runs in seconds and returns a typed dataset that is ready for analysis.

### How to use it

1. Click **Try for free** / **Start**.
2. Leave the default input to see a sample run, or type your own values (see Input below).
3. Press **Start** and wait a few seconds.
4. Open the **Output** tab and download as JSON, CSV, Excel or HTML.

### Input

| Field | Type | Default | Description |
|-------|------|---------|-------------|
| `category` | string | `"en:coffee"` | Open Food Facts category tag for the catalogue search, e.g. en:coffee. |
| `query` | string | `"witcher"` | Title searched in the CheapShark game store price API. |
| `source` | string | `"all"` | Which commerce APIs to aggregate. 'all' interleaves every source. One of: 'all', 'openfoodfacts', 'openprices', 'cheapshark'. |
| `maxResults` | integer | `20` | Maximum number of normalised products to return. |

Example input:

```json
{
  "category": "en:coffee",
  "query": "witcher",
  "source": "all",
  "maxResults": 5
}
```

### Output

One item per record. Sample:

```json
{
  "source": "openprices",
  "product_name": "Yuriko Sushi",
  "brand": "REWE to go",
  "category": "seafood, meals",
  "price": 7.99,
  "currency": "EUR"
}
```

You can download the dataset in various formats such as JSON, HTML, CSV, or Excel.

### Data fields

| Field | Type | Meaning |
|-------|------|---------|
| `source` | string | Source |
| `product_name` | string | Product |
| `brand` | string | Brand |
| `category` | string | Category |
| `price` | number | Price |
| `currency` | string | Currency |
| `store` | string | Store |
| `product_id` | string | Product ID / Barcode |
| `image_url` | string | Image |
| `product_url` | string | Product URL |
| `country` | string | Country |
| `extra` | string | Extra |

### How much does it cost to run?

This Actor uses pay-per-event pricing: you pay per result item pushed to the dataset, and nothing for an empty run. Each run is a few seconds of compute, so typical costs are fractions of a cent per run, and the Apify free tier covers plenty of testing.

### Tips and advanced options

- Raise `maxResults` for a bigger pull; the Actor pages through the source for you.
- Schedule it (e.g. every morning) and combine with a webhook to get only the new records.
- Add the Actor to an AI agent through the Apify MCP server for natural-language queries.

### FAQ, disclaimers and support

- **Is this legal?** It uses publicly available data from Open Food Facts, Open Prices & CheapShark. You are responsible for how you use the data and for complying with the source's terms.
- **It returned nothing?** Use an Open Food Facts category tag such as en:coffee, en:cheeses or en:beers, and a game title for the store price search.
- **Something broken?** Open an issue on the Actor's **Issues** tab. Data sources change and get fixed quickly.
- Need a custom variant (extra fields, a different source, a scheduled report)? Get in touch through the Issues tab.

# Actor input Schema

## `category` (type: `string`):

Open Food Facts category tag for the catalogue search, e.g. en:coffee.

## `query` (type: `string`):

Title searched in the CheapShark game store price API.

## `source` (type: `string`):

Which commerce APIs to aggregate. 'all' interleaves every source.

## `maxResults` (type: `integer`):

Maximum number of normalised products to return.

## Actor input object example

```json
{
  "category": "en:coffee",
  "query": "witcher",
  "source": "all",
  "maxResults": 20
}
```

# Actor output Schema

## `results` (type: `string`):

No description

# API

You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup.

## JavaScript example

```javascript
import { ApifyClient } from 'apify-client';

// Initialize the ApifyClient with your Apify API token
// Replace the '<YOUR_API_TOKEN>' with your token
const client = new ApifyClient({
    token: '<YOUR_API_TOKEN>',
});

// Prepare Actor input
const input = {
    "category": "en:coffee",
    "query": "witcher",
    "source": "all",
    "maxResults": 20
};

// Run the Actor and wait for it to finish
const run = await client.actor("thriftykiwi/ecommerce-product-aggregator").call(input);

// Fetch and print Actor results from the run's dataset (if any)
console.log('Results from dataset');
console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
items.forEach((item) => {
    console.dir(item);
});

// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

```

## Python example

```python
from apify_client import ApifyClient

# Initialize the ApifyClient with your Apify API token
# Replace '<YOUR_API_TOKEN>' with your token.
client = ApifyClient("<YOUR_API_TOKEN>")

# Prepare the Actor input
run_input = {
    "category": "en:coffee",
    "query": "witcher",
    "source": "all",
    "maxResults": 20,
}

# Run the Actor and wait for it to finish
run = client.actor("thriftykiwi/ecommerce-product-aggregator").call(run_input=run_input)

# Fetch and print Actor results from the run's dataset (if there are any)
print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
for item in client.dataset(run.default_dataset_id).iterate_items():
    print(item)

# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

```

## CLI example

```bash
echo '{
  "category": "en:coffee",
  "query": "witcher",
  "source": "all",
  "maxResults": 20
}' |
apify call thriftykiwi/ecommerce-product-aggregator --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "type": "http",
            "url": "https://mcp.apify.com/?tools=fetch-actor-details,thriftykiwi/ecommerce-product-aggregator"
        }
    }
}
```

The hosted server signs you in with OAuth on first connect, so no API token belongs in this config. Clients without OAuth support can send an `Authorization: Bearer <APIFY_API_TOKEN>` header instead, using a token from API & Integrations in Apify Console (https://console.apify.com/settings/integrations).

## OpenAPI specification

Download the OpenAPI definition: https://api.apify.com/v2/actors/VyEcjIIrYgFQ50xcC/builds/TuPZWN6w9Gh5sy4sI/openapi.json