We’re launching a WooCommerce drop shipping store with a supplier file of 5,000 rows and require expert help restructuring the supplier data and importing it into our product catalogue, cleaning up SKUs, automating stock syncing from an XML feed, and replacing Elementor with the WordPress block editor.
A previous developer implemented workarounds that now need to be reversed, particularly the use of ‘P- 'prefixed SKUs on parent products, which breaks stock synchronisation and creates maintenance and stock control issues. The supplier provides a flat CSV file for product data, which does not link parent-child relationships or variations; however, sorting the data by brand, SKU and Product Title in Excel makes it easy to spot the groupings.
Key Problems: • Incorrect Parent SKUs (P- prefix): • Parent products were given prefixed SKUs like P-12345, while the supplier uses 12345. This causes SKU mismatches during scripted stock sync and import automation. • Flat Product File Structure: • The supplier CSV contains no clear parent-child relationships. Some variants (e.g. colour, size) are embedded in product titles or attributes, requiring structured parsing with Pandas and mapping to WooCommerce variation attributes. • Stock & Availability Management:
As a dropshipping business, we need: • Real-time or scheduled stock updates from the supplier’s XML feed • Proper use of WooCommerce stock status, stock quantity, and managing stock flags
• Elementor Cleanup: The site currently uses Elementor and a lot of CSS, which we’d like to entirely remove and replace with native WordPress blocks (Gutenberg). This applies especially to product templates and page layouts.
Tasks & Deliverables:
1. CSV Restructuring & SKU Cleanup • Standardise all SKUs by removing P- prefixes and revert to supplier SKU’s • Restructure flat supplier data into WooCommerce-compatible format to be imported by WP All Import: • Identify parent/child relationships in CSV file • Extract variant attributes (e.g. size/colour) from titles or attribute columns • Retain and correctly apply product categories, and attribute mappings
2. Product Import Into WooCommerce • Import using WP All Import Pro or WooCommerce REST API • Maintain parent-child structure, category/tag assignments, SEO fields, ACFs, etc. • Avoid duplication, and preserve image galleries where available
3. Stock Synchronisation & Automation • Use the supplier’s XML or csv feed to update stock levels • Match by supplier SKU Only • Set “Manage Stock”, stock quantity, and stock status properly • Set up cron job for regular (hourly/daily) sync with supplier • Optional: Automatically hide/discontinue products when unavailable from supplier.
4. Elementor Removal & Block Migration • Remove all Elementor dependencies from pages and templates • Rebuild key product layouts using Gutenberg blocks • Optimise for performance, speed, and mobile friendliness • Ensure a clean, block-based, future-proof setup
5. (Optional Bonus) Cleanup Tasks • Identify and remove any redundant ACF fields or orphaned metadata • Suggest structural improvements for long-term scaling
Store Details: • Platform: WooCommerce on WordPress ( products are sex toys & accesories) • Hosting: Cloudways (PHP 8+) • Product count: 4,000+ (CSV + XML) • Theme: Shoptimizer (compatible with blocks) • Tools Installed: WP All Import Pro, ACF Pro
Ideal Freelancer: • Proven experience with large WooCommerce product catalogues • Strong skills in data manipulation, CSV and XML processing, preferably with Python & rest API or WP All Import • Knowledge of WooCommerce variable product structure and stock syncing. • Comfortable with Gutenberg block editor and removing Elementor • Clean coder and confident working on an almost complete store with staging access ( site is not live yet)
Access Provided: • Staging + live environments • Sample supplier CSV and XML feed • WooCommerce REST API credentials (if needed) • Elementor pages/templates for conversion
Please include examples of similar WooCommerce import/migration projects, especially involving: • SKU restructuring • Stock sync automation • Elementor removal • Dropshipping or XML-based product updates
Social Graphics for Instagram & Facebook Category: Adobe Illustrator, Photoshop, After Effects, Canva, CapCut, Digital Marketing, Graphic Design, Social Media Marketing Budget: $1500 - $3000 USD
31-Jan-2026 05:02 GMT
Lally Column Removal Category: Architecture, AutoCAD, Building Architecture, Building Design, Construction, Structural Engineering Budget: $10000 - $20000 USD
31-Jan-2026 05:02 GMT
Textos para Instagram Envolventes Category: A / B Testing, Article Writing, Content Writing, Copywriting, Facebook Marketing, Instagram Marketing, Social Media Management, Social Media Marketing Budget: $250 - $750 USD
31-Jan-2026 05:01 GMT
Innovative Tech Automation Logo Design Category: Adobe Illustrator, Photoshop, Branding, Digital Art, Graphic Design, Illustration, Logo Design, Vector Design Budget: $30 - $250 USD
Modern Home Interior Design Category: 3D Modelling, 3D Visualization, Architecture, AutoCAD, Building Architecture, Interior Design, Revit, SketchUp Budget: ₹12500 - ₹37500 INR
31-Jan-2026 04:58 GMT
AI Swarm Defence Drone Models Category: 3D Modelling, AI Agents, AI Development, CAD / CAM, Drone Photography, Manufacturing Design, Product Design, Solidworks Budget: $30 - $250 USD
Fix Mystery Gift RNG Bug Category: Debugging, Game Design, Game Development, Game Testing, Programming, Reverse Engineering, Software Development, Software Engineering Budget: $30 - $250 USD
31-Jan-2026 04:56 GMT
Fire-Damaged Laundromat Full Rebuild Category: Building Architecture, Building Design, Building Engineering, Construction, Electrical Engineering, HVAC, Mechanical Engineering, Project Management, Roofing, Structural Engineering Budget: $250 - $750 USD
31-Jan-2026 04:55 GMT
Modern Minimalist Logo & Business Card Category: Branding, Business Card Design, Graphic Design, Icon Design, Logo Design, Photoshop, Typography, Visual Design Budget: $30 - $250 AUD
31-Jan-2026 04:55 GMT
Elegant Instagram Reels Editing Category: Photoshop, Adobe Premiere Pro, After Effects, Animation, Graphic Design, Motion Graphics, Video Editing, Video Production Budget: ₹12500 - ₹37500 INR
31-Jan-2026 04:55 GMT
Facebook & Instagram | Long Term Role | New Freelancer Welcome Category: Facebook Ads, Facebook Development, Facebook Marketing, Instagram, Instagram Marketing, Social Media Management, Social Media Marketing, Social Networking, Video Editing, YouTube Budget: ₹400 - ₹750 INR
31-Jan-2026 04:54 GMT
Projection Dome Design Category: 3D Design, 3D Rendering, Architecture, AutoCAD, Building Architecture, Building Design, Interior Design, Structural Engineering Budget: ₹12500 - ₹37500 INR
31-Jan-2026 04:54 GMT
Instagram Brand Awareness Post Series - 26/01/2026 22:22 EST Category: Adobe Creative Cloud, Animation, Content Creation, Digital Marketing, Graphic Design, Instagram Marketing, Logo Design, Photoshop, Social Media Management, Social Media Marketing Budget: ₹400 - ₹750 INR
