HLP DataRetail and FMCGPortugalCollected 2026-10-12GROCERY-PLP schema
Auchan Portugal retail and fmcg snapshot
54,542 products from auchan.pt in the GROCERY-PLP schema, with a free sample, the full column list and the share of rows that carry each value.
Total products54,542100% unique IDs
Departments27Top level of the category tree
Brands4,648Distinct brand values
Collected2026-10-12One-off snapshot
Sample rows
Real rows cut from the file you buy, spread across the dataset. Same columns and encoding as the full snapshot.
Loading sample rows. If nothing appears, download the CSV.
Schema and fill rates
31 columns in the GROCERY-PLP layout. Fill rate is the share of the 54,542 rows that carry a value, measured on the delivered file.
| Field | Type | Fill rate | Description |
|---|---|---|---|
| website_name | String | 100% | Source website |
| competence_date | ISO Date | 100% | Collection date (YYYY-MM-DD) |
| country_code | ISO 3166-1 | 100% | PRT |
| currency_code | ISO 4217 | 100% | EUR |
| store_id | String | not collected | |
| product_code | String / ID | 100% | Shop product identifier, 100% unique |
| product_std_code | String | not collected | |
| std_type | String | not collected | |
| brand | String | 88.3% | Manufacturer brand or private label |
| product_title | String | 100% | Product name as published |
| category1 | String | 100% | Department, 27 values |
| category2 | String | 100% | Second level of the category tree |
| category3 | String | 97.1% | Third level of the category tree |
| category4 | String | 44.1% | |
| category5 | String | 4.8% | |
| category6 | String | not collected | |
| category7 | String | not collected | |
| category8 | String | not collected | |
| category9 | String | not collected | |
| category10 | String | not collected | |
| package_desc | String | 52.3% | Package size or weight |
| full_price | Float | 100% | List price before any promotion |
| price | Float | 100% | Asking or selling price, median €7 |
| ppu | Float | 86.5% | Unit price where the shop shows one |
| unit_type | Enum | 86.5% | Unit of ppu (kg, lt, un...) |
| promotion_type | String | 85.3% | Promotion tag at collection time |
| promotion_end_date | ISO Date | not collected | |
| additional_tags | String | 5% | Product tags as published |
| additional_content | String | 100% | Availability text as published |
| itemurl | URL | 100% | Canonical page URL |
| imageurl | URL | 100% | Primary image URL |
Known limits
Read these before you buy. They are the reasons a file might not fit your use.
- Not collected for this source, columns kept empty to preserve the schema: category10, category6, category7, category8, category9, product_std_code, promotion_end_date, std_type, store_id.
- No personal data: no private names, phone numbers or personal email addresses.
Licence and delivery
For analysts who need this market in one file.