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.
System & App Demo Video Category: Adobe Premiere Pro, After Effects, Animation, Motion Graphics, Video Ads, Video Conferencing, Video Editing, Video Post Editing, Video Production, Video Services Budget: $10 - $30 USD
01-Jun-2026 04:01 GMT
Social Media Creative Design Category: Adobe Creative Cloud, Content Creation, Graphic Design, Illustration, Logo Design, Photoshop, Social Media Marketing, Video Editing Budget: ₹12500 - ₹37500 INR
Energetic Football Academy Ad Category: Adobe Premiere Pro, DaVinci Resolve, Social Media Marketing, Video Ads, Video Editing, Video Production, Video Services, Voice Over Budget: $15 - $25 USD
30-Second Promotional Video Editing Category: Adobe Premiere Pro, After Effects, Animation, Video Ads, Video Editing, Video Post Editing, Video Services Budget: $250 - $750 USD
Retail Store Design for Expansion Category: 3D Modelling, 3D Rendering, Architectural Visualization, Furniture Design, Graphic Design, Interior Design, Lighting Design, Project Management, Visual Merchandising, Web Design Budget: $250 - $750 AUD
01-Jun-2026 03:55 GMT
YouTube Narrative Video Editor Needed Category: Adobe Premiere Pro, DaVinci Resolve, Final Cut Pro, Motion Graphics, Video Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
01-Jun-2026 03:53 GMT
Rewrite AI Real Estate Content Category: Article Rewriting, Article Writing, Content Development, Content Writing, Copy Editing, Copywriting, Editing, Ghostwriting, Proofreading, Real Estate Budget: $10 - $30 USD
01-Jun-2026 03:53 GMT
Penulis & Desainer Bergaji Harian Category: Adobe Illustrator, Canva, Content Writing, Graphic Design, Illustration, Logo Design, Photoshop, Social Media Marketing Budget: $15 - $25 USD
01-Jun-2026 03:52 GMT
TikTok Engagement Video Editing Category: Adobe Premiere Pro, After Effects, CapCut, Motion Graphics, TikTok, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: £10 - £20 GBP
01-Jun-2026 03:51 GMT
Digital Marketing for Asia Kitchen Category: Content Strategy, Content Writing, Digital Marketing, Facebook Marketing, Graphic Design, Instagram Marketing, Social Media Marketing, Twitter Budget: ₹12500 - ₹37500 INR
