Amazon Bulk Upload File – Automate Variation Creation (Parent-Child Relationship)
Budget: ₹600 – ₹1,500 INR
We are looking for a Python developer with experience in handling Amazon Seller Central bulk upload files. The objective is to automate the creation of parent-child variations (based on attributes like size, color, etc.) in an Amazon bulk upload Excel file. We will provide:
A file with individual product listings (no variations).
A sample file with correct variation format (with parent-child SKUs created).
Your task:
1. Analyze both files to understand the logic of variation grouping.
2. Create a Python script that:
Identifies similar products (based on title, SKU pattern, or attributes).
Automatically inserts parent SKUs above the relevant child SKUs.
Updates all required fields for proper Amazon recognition.
3. Deliver the updated file and the script with proper documentation.
Skills Required:
Python (Pandas, OpenPyXL or xlrd/xlsxwriter)
Amazon Seller Central knowledge (variation logic)
Excel file manipulation
Attention to detail
Expected Deliverables:
Python script (well-documented)
Output Excel file with correct variation structure
Quick demo or explanation on usage
A file with individual product listings (no variations).
A sample file with correct variation format (with parent-child SKUs created).
Your task:
1. Analyze both files to understand the logic of variation grouping.
2. Create a Python script that:
Identifies similar products (based on title, SKU pattern, or attributes).
Automatically inserts parent SKUs above the relevant child SKUs.
Updates all required fields for proper Amazon recognition.
3. Deliver the updated file and the script with proper documentation.
Skills Required:
Python (Pandas, OpenPyXL or xlrd/xlsxwriter)
Amazon Seller Central knowledge (variation logic)
Excel file manipulation
Attention to detail
Expected Deliverables:
Python script (well-documented)
Output Excel file with correct variation structure
Quick demo or explanation on usage