Make $25 - $35 Per Hour Doing Simple Jobs From Home.
What is your current level of experience in freelance work?
WooCommerce Image Optimization + Bulk Upload
WooCommerce Image Optimization + Bulk Upload Plan Overview: • Our WooCommerce store has ~45,000 products. Due to a plugin failure, many of the product images are inconsistent and were not imported: • Some have optimized images (properly compressed JPG/PNG). • Some images are unoptimized (resulting in bloated files). • Most have no images attached currently. We need a developer to create a reliable process to batch manage, optimize, and re-upload images using a spreadsheet-based method. Goals: 1. Clean up and optimize the media library (images tied to products). 2. Re-upload optimized images in a structured, accurate way. 3. Ensure every product either has an optimized image or is flagged for missing media. Two Possible Scenarios (you’ll help us decide which to go with): Option 1: Full Reset • Delete all product images (not product listings). • Start from a clean slate using a master spreadsheet with optimized images + local images folder. Option 2: Selective Cleanup • Write a script to: • Identify and keep optimized images (based on size, file name, or metadata). • Delete unoptimized images. • Prepare a spreadsheet for remaining/missing images to be reuploaded after optimization. Requirements: STEP 1: IMAGE AUDIT + SPREADSHEET EXPORT • Export all products to a CSV (can be via WP All Export or WooCommerce API). • Columns should include: • Product ID / SKU • Current image filename and URL (if any) • Image alt text (if available) • Product title STEP 2: LOCAL IMAGE PROCESSING • Download existing images (only those referenced in the export) to local storage. • Batch compress images: • JPGs using jpegoptim or mozjpeg • PNGs using pngquant or optipng • Strip EXIF data • Convert to WebP optionally (based on our decision) STEP 3: FILE STRUCTURE + NAMING • Rename images to match WooCommerce's expected format: • Preferably (SKU)-(image_position).jpg or (product-id).jpg • Organize optimized images in a flat folder or nested structure if needed. STEP 4: SPREADSHEET UPDATE FOR IMPORT • Append the cleaned spreadsheet with: • Correct file names • Local or final upload URLs • Identify rows missing images for later action STEP 5: RE-UPLOAD • Use a method like: • WooCommerce REST API (via batch image attachment) • CSV re-import with WP All Import or equivalent • Each image must be attached to the correct product and alt text. Qualifications Needed: • Strong experience with WooCommerce (CSV, API, media structure) • Comfortable writing scripts (Python, Node, or PHP) • Experience with image optimization tools • Able to manage large datasets (40k+ records) • Comfortable working with CSV manipulation and bulk upload workflows Helpful extras: • Recommend or implement a future-proof image optimization system (e.g., TinyPNG API, ShortPixel CLI) • Set up basic automation to catch broken or missing image links going forward Notes: • We’ll provide access to the WordPress backend • You will need your own hosting / ability to download, compress and optimize. Deliverables: • Script(s) used to clean, download, and reassign images • Final optimized image folder • Final import-ready spreadsheet • Log of skipped or errored images/products • Written documentation or video walkthrough of the process for future use