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.
video maker for ayurvedic products promotion Category: Amazon, Conversion Rate Optimization, EBay, ECommerce, Keyword Research, SEO, Shopify, Video Editing, Video Production, Web Design Budget: ₹1500 - ₹12500 INR
I need a influencer marketing executive Category: Account Management, Brand Management, Facebook Marketing, Influencer Marketing, Social Media Management, Social Media Marketing, Social Networking, Twitter Budget: ₹12500 - ₹37500 INR
10-Mar-2026 04:57 GMT
Excel Data Cleaning & Formatting Category: Analytics, Data Analysis, Data Entry, Data Processing, Data Visualization, Excel, Google Sheets, Power BI, SQL Budget: ₹750 - ₹1250 INR
Word Document Data Entry Category: Copy Typing, Data Entry, Excel, Google Sheets, Microsoft Word, Transcription, Typing, Word Budget: ₹12500 - ₹37500 INR
10-Mar-2026 04:52 GMT
XAUUSD Movement Prediction with ML Category: Backtesting, Data Analysis, Deep Learning, Financial Markets, Machine Learning (ML), R Programming Language, Statistical Analysis, Statistics Budget: ₹12500 - ₹37500 INR
AI Specialist for Microsoft Copilot Project Category: AI Chatbot Development, AI Consulting, AI Development, AI Model Development, Conversational AI, Natural Language Processing Budget: $25 - $50 AUD
10-Mar-2026 04:51 GMT
Instagram Engagement & Content Management Category: Content Creation, Creative Writing, Facebook Marketing, Instagram Marketing, Photo Editing, Social Media Management, Social Media Marketing, Social Networking Budget: ₹750 - ₹1250 INR
10-Mar-2026 04:50 GMT
TikTok Storytelling Plushy Videos Category: After Effects, Animation, Content Creation, Social Media Marketing, TikTok, Video Editing, Video Services, Videography Budget: $30 - $35 USD
10-Mar-2026 04:48 GMT
High Energy Promo Video Category: After Effects, Animation, Motion Graphics, Sound Design, Video Editing, Video Post Editing, Video Services, Video Streaming Budget: ₹75000 - ₹150000 INR