Node.js + MySQL Bulk Product & Campaign Excel Import Feature for eCommerce Platform
Budget: $250 – $750 USD
We are looking for an experienced developer to implement advanced bulk product management features for a high-end eCommerce platform built with Node.js backend, React admin dashboard, and MySQL database.
The implementation must be done very carefully to ensure existing product data integrity is never affected except for the fields explicitly modified through the uploaded Excel files.
# Feature 1: Bulk Edit Product Details via Excel
Requirements:
* Export product details from the admin dashboard under the Product Bulk Upload & Edit section.
* Exported Excel must contain:
* Product ID
* Product Name
* Category
* Brand
* Variants
* Variant Cost
* Variant Price
* Variant Special Price
* Variant Special Price Date Range
* Variant Shop SKU
* Variant Seller SKU
* Variant Weight
* Variant Status (Active / Inactive)
Import & Update Logic:
* Admin should be able to modify the Excel file and re-upload/import it through the dashboard.
* System must update only modified values.
* Blank cells or unchanged values must be ignored completely.
* Editable fields:
- Variant Cost
- Variant Price
- Variant Special Price
- Variant Special Price Date Range
- Variant Weight
# Feature 2: Bulk Add Products to Sales Campaign via Excel
Requirements:
* Export active product details from within the Campaign section.
* Export structure should be similar to the product bulk edit file.
Additional Columns:
* Campaign Price (per variant)
* Campaign Stocks (Flash Sale only)
Import Logic:
* Re-upload Excel file to add/update products into campaigns in bulk.
* Products and variants should be mapped accurately using IDs/SKUs.
* Campaign stock handling should apply only for Flash Sale campaigns.
## Critical Requirements
* Must not break or overwrite existing product data.
* Only fields modified in Excel should be updated.
* Must handle large datasets efficiently.
* Proper validation, error handling, and transaction safety required.
* Experience with Node.js, MySQL bulk operations, Excel parsing, and complex eCommerce systems is required.
Please share:
* Relevant past experience
* Similar projects completed
* Proposed implementation approach
* Estimated timeline and cost
The implementation must be done very carefully to ensure existing product data integrity is never affected except for the fields explicitly modified through the uploaded Excel files.
# Feature 1: Bulk Edit Product Details via Excel
Requirements:
* Export product details from the admin dashboard under the Product Bulk Upload & Edit section.
* Exported Excel must contain:
* Product ID
* Product Name
* Category
* Brand
* Variants
* Variant Cost
* Variant Price
* Variant Special Price
* Variant Special Price Date Range
* Variant Shop SKU
* Variant Seller SKU
* Variant Weight
* Variant Status (Active / Inactive)
Import & Update Logic:
* Admin should be able to modify the Excel file and re-upload/import it through the dashboard.
* System must update only modified values.
* Blank cells or unchanged values must be ignored completely.
* Editable fields:
- Variant Cost
- Variant Price
- Variant Special Price
- Variant Special Price Date Range
- Variant Weight
# Feature 2: Bulk Add Products to Sales Campaign via Excel
Requirements:
* Export active product details from within the Campaign section.
* Export structure should be similar to the product bulk edit file.
Additional Columns:
* Campaign Price (per variant)
* Campaign Stocks (Flash Sale only)
Import Logic:
* Re-upload Excel file to add/update products into campaigns in bulk.
* Products and variants should be mapped accurately using IDs/SKUs.
* Campaign stock handling should apply only for Flash Sale campaigns.
## Critical Requirements
* Must not break or overwrite existing product data.
* Only fields modified in Excel should be updated.
* Must handle large datasets efficiently.
* Proper validation, error handling, and transaction safety required.
* Experience with Node.js, MySQL bulk operations, Excel parsing, and complex eCommerce systems is required.
Please share:
* Relevant past experience
* Similar projects completed
* Proposed implementation approach
* Estimated timeline and cost