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.
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.
