# Schuurman Schoenen - Awin Feed Analysis

**Date:** 2026-02-23
**Feed ID:** 19187 (Awin)
**File:** `D:\sneakerpicks-feeds\schuurman-schoenen.csv.gz` (2.8MB)

## Summary

| Metric | Value |
|--------|-------|
| Total products | 37,165 |
| Sneakers (detected) | 9,477 |
| Sneaker % of feed | 25.5% |
| EAN coverage (sneakers) | 8,836/9,477 (93.2%) |
| GTIN coverage | 0% (not populated) |
| Price range (sneakers) | €14.99 - €209.99 |
| Average price (sneakers) | €83.66 |
| model_number filled | 100% (merchant SKU, not model name) |
| mpn filled | 100% (same as model_number) |
| Fashion:size filled | 99.8% |
| Fashion:suitable_for filled | 100% |
| Already in SneakerPicks? | **No** (not found in shops table) |

## Sneaker Brand Distribution (Top 20)

| Brand | Count |
|-------|-------|
| Sub55 | 1,163 |
| Puma | 1,040 |
| Skechers | 985 |
| Cruyff | 745 |
| New Balance | 443 |
| Gabor | 346 |
| Vans | 341 |
| Steve Madden | 284 |
| Hub | 263 |
| Guess | 242 |
| Rieker | 233 |
| Fila | 232 |
| Kaotiko | 217 |
| Sun68 | 202 |
| Tamaris | 185 |
| Mustang | 182 |
| Replay | 175 |
| Cycleur de Luxe | 161 |
| Lacoste | 156 |
| Marco Tozzi | 155 |

## Category Structure

Sneakers are cleanly categorized:
- `schoenen>dames>sneakers>lage sneakers` (3,297)
- `schoenen>heren>sneakers>lage sneakers` (2,697)
- `schoenen>meisjes>sneakers>lage sneakers` (943)
- `schoenen>jongens>sneakers>lage sneakers` (601)
- Plus high sneakers and some in "veterschoenen" (lace-ups) containing sneaker keywords

## Product Name Quality

**Good** - Real model names used: "Puma - Suede Classic+", "Vans - Old Skool", "Skechers - Og 85 - Gold'n Gurl", "Puma - Carina L". Format is consistent: `Brand - Model Name`.

## Data Quality Notes

- **EAN:** 93.2% filled for sneakers — good for matching
- **model_number / mpn:** Both contain merchant internal SKUs (e.g., "2600017742344"), NOT actual model numbers — not useful for product matching
- **category_name / product_type:** Empty for all products (only merchant_category is populated)
- **size_stock_status:** Not populated
- **Fashion:size:** Individual sizes per product row (each size = separate row)
- **GTIN:** Not populated, but EAN is available which serves the same purpose
- **custom_1-9:** Not populated for sneakers

## Recommendation

**✅ YES — Add this feed.**

### Pros:
- **9,477 sneaker products** — large catalog
- **93% EAN coverage** — excellent for product matching/deduplication
- **Good brand mix** — Puma, Skechers, New Balance, Vans, Cruyff, Fila, Lacoste
- **Unique brands** — Sub55, Hub, Cycleur de Luxe, Kaotiko, Sun68 not commonly found
- **Clean category paths** — easy to filter sneakers programmatically
- **Real model names** — good for display and search
- **Size data available** — per-size rows with Fashion:size field
- **New shop** — not yet in SneakerPicks database

### Cons:
- **Many non-sneaker brands mixed in** — Gabor, Rieker, Tamaris, Marco Tozzi are traditional shoe brands; their "sneakers" may be fashion/comfort shoes rather than true sneakers
- **model_number is merchant SKU** — can't use for model matching
- **Per-size rows** — need deduplication by parent_product_id or product name+color

### Expected Impact:
- After deduplication (grouping by name+color): ~2,000-3,000 unique sneaker models
- Strong coverage of mid-range Dutch sneaker market (€35-€120)
- Good complement to SikSilk (streetwear-focused) — Schuurman is more mainstream/family
