# OTTO.de Scraper (`datascrapers/otto-de-scraper`) Actor

Delivers structured OTTO.de product, product-detail, and review records, queried by search term or category/product URL, with optional product details and per-review records.

- **URL**: https://apify.com/datascrapers/otto-de-scraper.md
- **Developed by:** [Farhan Ali](https://apify.com/datascrapers) (community)
- **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet

## Pricing

from $1.38 / 1,000 products

This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.
Since this Actor supports Apify Store discounts, the price gets lower the higher subscription plan you have.

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

**OTTO.de Scraper** creates a structured dataset of OTTO.de product and review records collected from search queries and category, search, or product URLs. Each dataset item can include the product name, brand, price, suggested price, discount label, rating, review count, availability, category, and identifiers, or one customer review with its rating, title, text, reviewer, and review date. Query the source using a search term or URL with optional filters, control the result limit with `maxItems`, and retrieve records through the Apify Dataset API or export them as JSON, CSV, Excel, or XML.

### Dataset at a glance

| Property | Value |
|---|---|
| Source | otto.de |
| Record unit | One product, product detail, or customer review |
| Input methods | Search queries, start URLs, optional filters |
| Main identifiers | `productId`, `variationId`, `articleNumber`, `url` |
| Delivery | Apify Dataset and API |
| Export formats | JSON, CSV, Excel, XML |
| Update model | Fresh records per Actor run |
| Pricing | Pay per event, from $1.50 per 1,000 events |

### Coverage and available records

The Actor returns three record types:

- **`product`** — product listing records from search or category pages.
- **`product-details`** — fuller product records when `includeProductDetails` is enabled, adding description, identifiers, selected size, stock, and shipping.
- **`product-review`** — one dataset row per customer review when `includeReviews` is enabled.

The Actor supports a wide set of OTTO filters including brand, color, size, shoe size (EU/UK/US), target group, promotion, minimum discount percent, price range, rating, material, seller, season, style, and additional custom filters via `additionalFilters`. Results can be sorted with `sortBy`.

### Data dictionary

Product and product-detail fields:

| Field | Type | Nullable | Description | Example |
|---|---:|---|---|---|
| `recordType` | string | No | `product` or `product-details` | `product` |
| `imageUrl` | string | No | Product image | `https://i.otto.de/...` |
| `name` | string | No | Product name | `Nike Air Max 270` |
| `brand` | string | Yes | Brand name | `Nike` |
| `price` | number | No | Current price in EUR | `129.99` |
| `currency` | string | Yes | Currency code | `EUR` |
| `suggestedPrice` | number | Yes | List/suggested price | `149.99` |
| `discountLabel` | string | Yes | Discount label | `-13%` |
| `rating` | number | Yes | Average rating | `4.6` |
| `reviewCount` | integer | Yes | Number of reviews | `128` |
| `availability` | string | Yes | Availability status | `Lieferbar` |
| `color` | string | Yes | Color | `schwarz` |
| `category` | string | Yes | Category name | `Sneaker` |
| `url` | string | No | Product page URL | `https://www.otto.de/...` |
| `productId` | string | No | OTTO product identifier | `12345678` |
| `variationId` | string | Yes | Variation identifier | `87654321` |
| `articleNumber` | string | Yes | Article number | `ABC123` |
| `detailsIncluded` | boolean | Yes | Whether details were fetched | `true` |
| `description` | string | Yes | Product description (details) | — |
| `gtin` | string | Yes | GTIN (details) | — |
| `selectedSize` | string | Yes | Selected size (details) | `42` |
| `inStock` | boolean | Yes | Stock status (details) | `true` |
| `shippingPrice` | number | Yes | Shipping price (details) | `3.95` |

Review fields:

| Field | Type | Nullable | Description | Example |
|---|---:|---|---|---|
| `recordType` | string | No | `product-review` | `product-review` |
| `productName` | string | Yes | Reviewed product name | `Nike Air Max 270` |
| `rating` | number | Yes | Review rating | `5` |
| `title` | string | Yes | Review title | `Toller Schuh` |
| `text` | string | Yes | Review body | — |
| `verifiedPurchase` | boolean | Yes | Verified purchase flag | `true` |
| `reviewer` | string | Yes | Reviewer name | `Anna` |
| `location` | string | Yes | Reviewer location | `Berlin` |
| `reviewedAt` | string | Yes | Review date | `2025-03-14` |
| `variantSize` | string | Yes | Reviewed variant size | `42` |
| `variantColor` | string | Yes | Reviewed variant color | `schwarz` |
| `seller` | string | Yes | Seller name | `OTTO` |
| `helpfulVotes` | integer | Yes | Helpful votes | `12` |
| `helpfulVotesTotal` | integer | Yes | Total helpful votes | `15` |
| `productUrl` | string | Yes | Reviewed product URL | `https://www.otto.de/...` |
| `reviewId` | string | Yes | Review identifier | — |
| `productId` | string | Yes | Product identifier | `12345678` |

### Example dataset record

```json
{
  "recordType": "product",
  "imageUrl": "https://i.otto.de/i/otto/12345678",
  "name": "Nike Air Max 270",
  "brand": "Nike",
  "price": 129.99,
  "currency": "EUR",
  "suggestedPrice": 149.99,
  "discountLabel": "-13%",
  "rating": 4.6,
  "reviewCount": 128,
  "category": "Sneaker",
  "url": "https://www.otto.de/p/nike-air-max-270-12345678",
  "productId": "12345678",
  "variationId": "87654321"
}
```

The record above was produced by the input in the next section: search query `shoes` with product details and reviews enabled.

### Query and input reference

| Input | Type | Required | Default | Accepted values | Description |
|---|---:|---|---|---|---|
| `searchQueries` | array | No | — | Search terms | Keywords to search |
| `startUrls` | array | No | — | OTTO.de URLs | Category, search, filtered, or product URLs |
| `sortBy` | string | No | `topseller` | `topseller`, `preis-aufsteigend`, `preis-absteigend`, `hoechste-reduzierung`, `neuheiten`, `bewertung` | Result sort order |
| `brands` | array | No | — | Brand slugs | Brand filter |
| `colors` | array | No | — | Color slugs | Color filter |
| `sizes` | array | No | — | Size slugs | Clothing size filter |
| `shoeSizesEu` / `shoeSizesUk` / `shoeSizesUs` | array | No | — | Size slugs | Shoe size filters |
| `targetGroups` | array | No | — | Audience slugs | Target group filter |
| `promotions` | array | No | — | Promotion slugs | Promotion filter |
| `minDiscountPercent` | integer | No | — | `0`–`90` | Discount filter |
| `reducedOnly` | boolean | No | `false` | `true` / `false` | Reduced items only |
| `minPrice` / `maxPrice` | integer | No | — | EUR | Price range filter |
| `minRating` | string | No | — | `5-sterne`, `ab-4-sternen`, `ab-3-sternen`, `ab-2-sternen`, `ab-1-stern` | Rating filter |
| `materials`, `sellers`, `seasons`, `styles`, `soleProfiles`, `sustainability`, `pronations`, `features`, `covers`, `surfaces`, `upholstery`, `rooms`, `services`, `seatCounts`, `dimensions` | array | No | — | Filter slugs | Additional OTTO filters |
| `additionalFilters` | object | No | `{}` | Filter id → slug(s) | Custom filters |
| `maxItems` | integer | No | `20` | `0` = unlimited | Maximum products (reviews excluded) |
| `includeProductDetails` | boolean | No | `false` | `true` / `false` | Fetch product details |
| `includeReviews` | boolean | No | `false` | `true` / `false` | Store each review as its own row |
| `maxReviewsPerProduct` | integer | No | `0` | `0` = all | Cap reviews per product |
| `proxyConfiguration` | object | No | Residential | Apify proxy settings | Proxy configuration |

Minimal request:

```json
{
  "searchQueries": ["shoes"],
  "maxItems": 20
}
```

Advanced request:

```json
{
  "searchQueries": ["shoes"],
  "sortBy": "topseller",
  "brands": ["nike"],
  "minDiscountPercent": 20,
  "minPrice": 20,
  "maxPrice": 150,
  "maxItems": 100,
  "includeProductDetails": true,
  "includeReviews": true,
  "maxReviewsPerProduct": 10
}
```

### Retrieve the data through the API

1. Start the Actor with a JSON input containing `searchQueries` and/or `startUrls`.
2. Wait for the run to finish.
3. Read records from the run's default dataset.
4. Paginate or export the dataset.

```python
from apify_client import ApifyClient

client = ApifyClient("YOUR_API_TOKEN")
run = client.actor("datascrapers/otto-de-scraper").call(
    run_input={
        "searchQueries": ["shoes"],
        "maxItems": 20,
        "includeProductDetails": True,
    }
)
for item in client.dataset(run["defaultDatasetId"]).iterate_items():
    print(item["recordType"], item.get("name"), item.get("price"))
```

Apify's generated API tab documents the equivalent calls for other languages.

### Data quality and record handling

- **Completeness** — detail fields (description, identifiers, sizes, shipping) are conditional on `includeProductDetails`; review fields are conditional on `includeReviews`.
- **Source changes** — prices, availability, and discounts reflect the response at scrape time.
- **Deduplication** — the Actor does not deduplicate across runs; use `productId` (and `variationId`) as the stable key.
- **Retry/error behavior** — products or reviews that cannot be resolved are skipped; the run continues.
- **Normalization** — prices are numbers in EUR; ratings are numeric.

### Export and pipeline examples

| Destination | Recommended method | Typical use |
|---|---|---|
| PostgreSQL/Supabase | Dataset API or webhook consumer | Product and price history |
| Google Sheets | Apify integration | Competitive price tracking |
| S3/cloud storage | Scheduled export or integration | Catalog snapshots |

### Pricing and cost examples

Billing is **pay per event**: each record pushed is one charge, and each event type is priced the same. Platform compute is included in the actor usage fee.

| Event | What counts | Price |
|---|---|---|
| `product` | Product listing record | $1.50 / 1,000 |
| `product-details` | Product detail record | $1.50 / 1,000 |
| `product-review` | Customer review record | $1.50 / 1,000 |

| Records | Estimated base cost |
|---:|---:|
| 1,000 | $1.50 |
| 10,000 | $15.00 |
| 100,000 | $150.00 |

Estimates depend on the verified pricing model and which options you enable.

### Limitations and responsible data use

- Only publicly accessible OTTO.de product and review data is returned.
- Prices, availability, and discounts change frequently and reflect the moment of collection.
- Fields may be missing or conditional depending on the product and options enabled.
- No historical snapshots are stored unless you keep them yourself.
- You are responsible for complying with OTTO's terms and applicable laws.

### Dataset questions

#### What does one dataset item represent?

One product, product detail, or customer review record, depending on the options enabled.

#### Which field should I use as a unique identifier?

Use `productId` for products and `reviewId` for reviews.

#### Are fields nullable or conditional?

Yes. Detail fields are conditional on `includeProductDetails`, and review fields are conditional on `includeReviews`.

#### Can I retrieve the records as CSV or JSON?

Yes. Export the default dataset as JSON, CSV, Excel, or XML, or read it through the Apify Dataset API.

#### How do I paginate large datasets?

Set `maxItems` to cap products, or paginate the dataset through the Dataset API.

#### What counts as a billable result?

Each product, product-detail, or review record pushed to the dataset is one event charge.

### Related datasets from Data Scrapers

- **[Zalando Scraper](https://apify.com/datascrapers/zalando-scraper)** — German fashion product records for the same apparel market.
- **[Zara Scraper](https://apify.com/datascrapers/zara-scraper)** — fashion product records that join with OTTO for cross-retailer pricing.
- **[Nike Scraper](https://apify.com/datascrapers/nike-scraper)** — brand product records for footwear and apparel analysis.
- **[Amazon Scraper](https://apify.com/datascrapers/amazon-scraper)** — general merchandise records for broader price benchmarking.

### Data Scrapers support

Need an additional field, record type, or export workflow? Contact Data Scrapers at stardustspotlight@gmail.com. Include a sample source URL, required fields, expected record volume, and preferred delivery format.

# Actor input Schema

## `searchQueries` (type: `array`):

Keywords to search on OTTO.de, for example shoes or winterjacke damen.

## `startUrls` (type: `array`):

Category, search, filtered, or product URLs on www.otto.de. e.g. "https://www.otto.de/schuhe/sneaker/?aktion=super-sale\&rabatt=30\&reduziert\&zielgruppe=herren".

## `sortBy` (type: `string`):

Result order. topseller, preis-aufsteigend, preis-absteigend, hoechste-reduzierung, neuheiten, or bewertung.

## `brands` (type: `array`):

Brand filter (marke). Use the OTTO slug, for example adidas-originals or nike.

## `colors` (type: `array`):

Color filter (farbe), for example schwarz, grau, or blau.

## `sizes` (type: `array`):

Clothing size filter (groesse), for example m, 42, or 128.

## `shoeSizesEu` (type: `array`):

EU shoe size filter (schuhgroesse-eu), for example 44 or 37-1-3.

## `shoeSizesUk` (type: `array`):

UK shoe size filter (schuhgroesse-uk).

## `shoeSizesUs` (type: `array`):

US shoe size filter (schuhgroesse-us).

## `targetGroups` (type: `array`):

Audience filter (zielgruppe), for example herren, damen, or kinder.

## `promotions` (type: `array`):

Promotion filter (aktion), for example super-sale, restgroessen, or otto-days.

## `minDiscountPercent` (type: `integer`):

Discount filter (rabatt). OTTO uses steps such as 10, 20, 30, 40, 50, 60, or 70.

## `reducedOnly` (type: `boolean`):

Keep only reduced products (reduziert).

## `minPrice` (type: `integer`):

Lowest price in euros, inclusive.

## `maxPrice` (type: `integer`):

Highest price in euros, inclusive.

## `minRating` (type: `string`):

Rating filter (bewertung).

## `materials` (type: `array`):

Upper material filter (obermaterial), for example leder or textil.

## `sellers` (type: `array`):

Seller filter (verkaeufer), for example otto.

## `seasons` (type: `array`):

Season filter (jahreszeit), for example sommer, winter, or ganzjaehrig.

## `styles` (type: `array`):

Style filter (stil).

## `soleProfiles` (type: `array`):

Sole profile filter (laufsohlenprofil).

## `sustainability` (type: `array`):

Article-standard filter (nachhaltigkeit).

## `pronations` (type: `array`):

Pronation filter (pronation), for example neutral.

## `ottoUpOnly` (type: `boolean`):

Limit results to OTTO UP delivery (up-liefer-flat).

## `features` (type: `array`):

Feature filter (ausstattung), mostly used on furniture.

## `covers` (type: `array`):

Cover filter (bezug), for example cord.

## `surfaces` (type: `array`):

Surface filter (oberflaeche).

## `upholstery` (type: `array`):

Upholstery filter (polsterung).

## `rooms` (type: `array`):

Room filter (room).

## `services` (type: `array`):

Service filter (service).

## `seatCounts` (type: `array`):

Seating filter (sitzplaetze), for example 3.

## `dimensions` (type: `array`):

Measurement filter (vermassung).

## `additionalFilters` (type: `object`):

Any other OTTO filter id mapped to a slug or a list of slugs. Example: {"sitzplaetze": \["3"], "bezug": \["cord"]}. A true value sends the filter as a flag.

## `maxItems` (type: `integer`):

Maximum number of products to store. Reviews do not count toward this cap. 0 means no cap.

## `includeProductDetails` (type: `boolean`):

Open each product page and add description, identifiers, sizes, and shipping. Charged once per product as product-extra. Off by default.

## `includeReviews` (type: `boolean`):

Store each customer review as its own dataset row. Charged once per review as product-review. Off by default.

## `maxReviewsPerProduct` (type: `integer`):

Cap reviews stored for each product when reviews are enabled. 0 means every review.

## `proxyConfiguration` (type: `object`):

Apify proxy settings. Residential proxies are used by default.

## Actor input object example

```json
{
  "searchQueries": [
    "shoes"
  ],
  "startUrls": [
    {
      "url": "https://www.otto.de/moebel/sofas/"
    }
  ],
  "sortBy": "topseller",
  "reducedOnly": false,
  "ottoUpOnly": false,
  "additionalFilters": {},
  "maxItems": 20,
  "includeProductDetails": false,
  "includeReviews": false,
  "maxReviewsPerProduct": 0,
  "proxyConfiguration": {
    "useApifyProxy": true,
    "apifyProxyGroups": [
      "RESIDENTIAL"
    ]
  }
}
```

# Actor output Schema

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

Dataset rows. Products use recordType product. Reviews use recordType review.

## `runStats` (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 = {
    "searchQueries": [
        "shoes"
    ],
    "startUrls": [
        {
            "url": "https://www.otto.de/moebel/sofas/"
        }
    ],
    "additionalFilters": {}
};

// Run the Actor and wait for it to finish
const run = await client.actor("datascrapers/otto-de-scraper").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 = {
    "searchQueries": ["shoes"],
    "startUrls": [{ "url": "https://www.otto.de/moebel/sofas/" }],
    "additionalFilters": {},
}

# Run the Actor and wait for it to finish
run = client.actor("datascrapers/otto-de-scraper").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 '{
  "searchQueries": [
    "shoes"
  ],
  "startUrls": [
    {
      "url": "https://www.otto.de/moebel/sofas/"
    }
  ],
  "additionalFilters": {}
}' |
apify call datascrapers/otto-de-scraper --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "type": "http",
            "url": "https://mcp.apify.com/?tools=fetch-actor-details,datascrapers/otto-de-scraper"
        }
    }
}
```

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/swlgaBxTSKdXlm7xL/builds/dO2CiJvT9qQ8fMjQa/openapi.json