WooCommerce SKUs Auto-Updater and Importer
Budget: ₹1,500 – ₹12,500 INR
1. Read all SKUs from the uploaded Excel file.
* The file may contain anywhere from 100 to 20,000 SKUs.
* If there are any duplicate SKUs, the system should skip or ignore them automatically to prevent redundant processing.
2. Check each SKU on my WooCommerce website:
* If the SKU already exists, the system should update the price, stock quantity, and other product detailsbased on the Excel file.
* If the SKU does not exist, the system should:
* Fetch the complete product data (title, description, metadata, and high-resolution images) from Amazon or other specified sources.
* Import the product automatically into my WooCommerce website with updated metadata and optimized images.
3. The platform should also include:
* A dashboard interface showing real-time progress, such as “Updated 5,210 SKUs”, “Fetched 280 new SKUs”, and “Skipped 12 duplicate SKUs”.
* Integration options for APIs like Amazon, Flipkart, Meesho, or any custom source I define.
* Support for scheduled auto-syncs (daily, weekly, or manual).
* Scalability to handle very large Excel files (up to 20,000 SKUs) efficiently without timeouts.
* The file may contain anywhere from 100 to 20,000 SKUs.
* If there are any duplicate SKUs, the system should skip or ignore them automatically to prevent redundant processing.
2. Check each SKU on my WooCommerce website:
* If the SKU already exists, the system should update the price, stock quantity, and other product detailsbased on the Excel file.
* If the SKU does not exist, the system should:
* Fetch the complete product data (title, description, metadata, and high-resolution images) from Amazon or other specified sources.
* Import the product automatically into my WooCommerce website with updated metadata and optimized images.
3. The platform should also include:
* A dashboard interface showing real-time progress, such as “Updated 5,210 SKUs”, “Fetched 280 new SKUs”, and “Skipped 12 duplicate SKUs”.
* Integration options for APIs like Amazon, Flipkart, Meesho, or any custom source I define.
* Support for scheduled auto-syncs (daily, weekly, or manual).
* Scalability to handle very large Excel files (up to 20,000 SKUs) efficiently without timeouts.
Related categories:
PHP
Data Processing
Excel
WordPress
Product Management
WooCommerce
Automation
Database Management
API Integration