Product Data Mapping Specialist Needed for 250,000 SKU EPOS File

Job Description:
We are looking for a detail-oriented freelancer to support a structured data-mapping project for a large EPOS export containing approximately 250,000 products.

Each product includes core fields such as SKU, description, brand, size, and other attributes. Your role is not to create new category structures, but to map each product accurately and consistently into a predefined hierarchy and tagging framework.

This work is highly important as the mapped data will be used for reporting, analytics, and future automation, so accuracy, logic, and consistency are essential.

Scope of Work

Each product must be assigned to a fixed 3-level category hierarchy:

Department (Level 1)

Sub-Department (Level 2)

Analysis Code (Level 3)

Example:
Department: ART
Sub-Department: PAINT
Analysis Code: WATERCOLOUR

This means all watercolour paints would be mapped to:
ART → PAINT → WATERCOLOUR

We will provide:

The approved list of Departments

The approved Sub-Departments for each Department

The approved Analysis Codes for each Sub-Department

You must not create new categories, rename existing ones, or deviate from the supplied structure without approval.

Existing Top-Level Departments

Examples include:

ART

CRAFT

STATIONERY

JIGSAWS

LEGO

Additional departments will be included in the master file.

Tagging Requirements

In addition to category mapping, products must also be assigned tags in separate columns.

Required tag groups include:

Brand (for example: Winsor & Newton, Faber-Castell, LEGO)

Size / Volume (for example: 12ml, A4, 500g, Pack of 10)

Other clearly identifiable and consistently reusable attributes where appropriate

Tags must be:

Clean

Standardised

Reusable

Free from unnecessary variations

Mapping Rules

Use the product name, description, brand, and available attributes to determine placement

Similar products must always be mapped consistently

If a product is unclear or ambiguous, flag it instead of guessing

Do not make assumptions without a logical basis

Output Required

The final Excel output should include at minimum:

Original SKU / Product ID

Department

Sub-Department

Analysis Code

Brand Tag

Size Tag

Notes / Flags (if applicable)

Important Requirements

No blank category fields unless clearly flagged

No free-text category creation

Strict adherence to the supplied structures

Strong attention to detail and consistency throughout

Validation Process

Before full rollout, we would like the selected freelancer to complete a small sample batch for validation. We will review this first to ensure alignment before the full file is processed.

Ideal Freelancer

We are looking for someone with:

Strong Excel skills

Excellent attention to detail

Experience with large product catalogues, categorisation, or data cleansing

A logical and methodical approach to classification work

If anything in the structure or logic is unclear, we would expect questions to be raised early. It is more important that this is done correctly than quickly.

Please include relevant experience when applying, especially any examples of product mapping, taxonomy work, catalogue clean-up, or structured data classification.