WooCommerce Thumbnail Remapping for The Retailer Theme

Urgent WooCommerce Image Fix: Remap Featured + Gallery Thumbnails – Must Have Experience with The Retailer Theme Budget: $100–$200 (fixed price – negotiable based on your exact plan and timeline) Job Type: Fixed-Price / One-time Project Description: WordPress + WooCommerce site using The Retailer theme (with child theme active) on SiteGround hosting. After a large image migration from legacy CommerceHQ, main product images are partially fixed, but gallery thumbnails and many products still show broken/no images. Current Status (already done – no need to redo): ~25,890 images imported as WP attachments (new IDs: 1,000,121 – 1,039,412) Legacy images in /wp-content/uploads/nc/ Thumbnails regenerated Database paths corrected (no 404s) Batch SQL fixed _thumbnail_id for 7,457 rows (main featured images show on those products) Diagnostics confirm remaining 2,902 unique old IDs are orphans (no filename match) Problems to solve: Main featured images show only on ~7,457 products; ~4,529 rows still broken (orphans) Gallery thumbnails (_product_image_gallery – comma-separated IDs) broken on 1,202 products → only main image appears, no additional thumbnails Goal: Fix all product images and thumbnails – make featured images + gallery thumbnails visible on as many products as possible (ideally 100%) Must understand how The Retailer theme renders product images, galleries, shop loops, quick view, etc. (theme-specific classes, lazy loading, image sizes, etc.) Required Tasks: Investigate why remaining featured images are orphans and see if any can be recovered (manual check of sample paths/filenames) Remap old IDs in _product_image_gallery to new attachment IDs (using filename matching or other reliable method) Batch-safe PHP/WP-CLI script preferred Or use Better Search Replace plugin (paid version already installed) Ensure compatibility with The Retailer theme (no conflicts with theme's image handling, retina support, zoom, etc.) Implement fallback for true orphans (e.g., use first gallery image as featured, or custom placeholder) Test thoroughly: Single product pages (main image + gallery thumbnails) Shop/archive pages (product thumbnails) Mobile/responsive views Any quick-view or lightbox features in The Retailer Clear all caches (SG Optimizer, object cache, etc.) Provide short report: how many fixed, any permanent orphans and why Must-Have Experience: Proven work with The Retailer theme (by GetBowtied) – please mention specific fixes you've done with it Strong WooCommerce product image handling (_thumbnail_id, _product_image_gallery) Expert SQL/PHP for large postmeta tables (~874k rows) Safe batch processing (avoid timeouts/locks) WP-CLI, SSH, phpMyAdmin, Better Search Replace WooCommerce migrations / attachment remapping Access Provided: SSH (WP-CLI ready) phpMyAdmin SiteGround panel Full recent backups Timeline: ASAP – 1–4 days ideal Deliverables: All achievable images/thumbnails fixed Report: # fixed (featured + gallery), remaining issues Screenshots before/after (5–10 products, desktop + mobile) Any custom code/scripts (for future reference) In your proposal please include: Your experience with The Retailer theme (specific examples if possible) Proposed approach (SQL + PHP script? Plugin? Combination?) Estimated time & price Any questions about the setup Serious applicants only – this is a live e-commerce site. Looking for someone who can finish this cleanly and quickly. Thank you!

Projektin tunnus (ID): 40266280