Color-variant level product data from fashiondays.ro — 314K+ rows covering pricing, images, descriptions, categories, and promotional data across 2,925 brands and all fashion departments in Romania.
|One row per product × color combination. Here's what that means in practice.
One row. You lose per-color pricing, stock status, and individual image sets. Colors are invisible.
Three rows. Per-color stock, images, and price captured separately — each variant is trackable independently.
Figures from the 2026-05-03 delivery.
5 rows from the latest delivery. Prices in RON.
| brand | product_title | color_info | category1 | category2 | category3 | full_price | price | promotion_type | additional_tags | in_stock |
|---|---|---|---|---|---|---|---|---|---|---|
| Tommy Hilfiger | Pantofi sport de piele cu logo, Auriu/Alb optic | Auriu/Alb optic | Femei | FOOTWEAR | PERFORMANCE SHOES AND SNEAKERS | 644.21 | 384.99 | 40% discount | PREMIUM | 1 |
| Tommy Hilfiger | Pantofi sport din piele intoarsa cu insertii din material textil | Alb/Gri deschis | Femei | FOOTWEAR | PERFORMANCE SHOES AND SNEAKERS | 581.60 | 269.99 | 53% discount | ULTIMELE MARIMI | 1 |
| Tommy Hilfiger | Pantofi sport flatform de piele cu logo, Negru/Argintiu | Negru/Argintiu | Femei | FOOTWEAR | PERFORMANCE SHOES AND SNEAKERS | 641.99 | 339.99 | 47% discount | PREMIUM | 1 |
| Tommy Hilfiger | Camasa slim fit din material pique cu logo discret | Alb/Albastru lavanda | Femei | CLOTHING | SHIRTS | 544.99 | 399.99 | 26% discount | PREMIUM | 1 |
| Tommy Hilfiger | Espadrile cu detaliu logo, Alb murdar | Alb murdar | Femei | FOOTWEAR | ESPADRILLES | 143.00 | 143.00 | 0% discount | PREMIUM | 1 |
The output is a flat .txt file. Two separator characters are used at different levels.
.txt), one row per product-color variant, UTF-8 encoded; (semicolon) — separates every field in the row| (pipe) — used within a field when that field holds multiple items|all_images — pipe-separated list of image URLsadditional_content → availability_id sub-field — pipe-separated per-size availability countsadditional_content → is_consignment sub-field — pipe-separated yes/no per size1,000 chars to comply with validator constraints99,999,999.99 — matches DBQ validator type NUMERIC(10,2). Values exceeding this are nulled (13 rows affected in latest delivery).YYYY-MM-DD for competence_date and promotion_end_date
Example — all_images field:
https://fdcdn.akamaized.net/.../res_940599d3.jpg|https://fdcdn.akamaized.net/.../res_9f5f6286.jpg
Each URL separated by | — split on pipe to get the full image list per variant.
Based on 314,421 rows in the 2026-05-03 delivery.
Every field in the E0005r schema and its collection status.
Fields that exist on fashiondays.ro but aren't yet collected.
availability_id sub-field in additional_content already captures per-size availability codes (e.g. 5 | 3 | 3 | 5 | 5). Mapping these codes to labeled sizes would elevate this to a proper per-size stock field.additional_content as a JSON sub-field. Promoting it to a top-level column would make cross-currency comparison instant without JSON parsing on the buyer's side.price (current selling price) and full_price (pre-discount RRP) are collected and will differ whenever a promotion is active. The discount percentage is also delivered in promotion_type.
Delivered to S3 on each competence date.
Reach out to discuss pricing, trial data, or custom field additions.