1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 20-Oct-2025 22:12 GMT
View Project
View this project in detail (Note: you will be redirected to external marketplace)
Project title: CSV Manipulation & Import Products (Woo, Python, CSV)
Posted by: External project from PeoplePerHour
Started: 18-Jul-2025 20:52 GMT
Description: Expected duration: 1 - 2 weeks
Project: WooCommerce CSV Restructure, SKU Cleanup, Stock Sync & Elementor Removal

Description:

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
Project ID: 3441247
Project category:
Project budget:
View this project in detail (Note: you will be redirected to external marketplace)
Last Projects / Browse Projects
  Project Started
Regular Online hindi or punjabi to English Coaching Needed
Category: Audio Services, Business Coaching, English Tutoring, Hindi Translator, Language Tutoring, Punjabi Translator, Voice Talent
Budget: $30 - $250 CAD
20-Oct-2025
22:02 GMT
Riset Harga iPhone Terbaik
Category: Data Analysis, Market Research, Product Research
Budget: $2 - $8 USD
20-Oct-2025
22:01 GMT
Réalisation d’une vidéo de présentation courte et percutante pour mon centre de formation -- 2
Category: After Effects, French Translator, Graphic Design, Startups, Video Editing, Video Services
Budget: €30 - €250 EUR
20-Oct-2025
22:01 GMT
Basic Online English School Website
Category: Backend Development, HTML, JavaScript, PHP, Video Conferencing, Web Design, Web Development
Budget: €2 - €6 EUR
20-Oct-2025
22:00 GMT
NETLAB VM CTF Coaching
Category: Cisco, Computer Security, Documentation, Linux, Network Administration, Network Security, Penetration Testing, Technical Writing
Budget: $15 - $25 USD
20-Oct-2025
21:59 GMT
SLA-Ready Character Model Base
Category: 3D Animation, 3D CAD, 3D Design, 3D Layout, 3D Modelling, 3D Printing, 3D Rendering, 3ds Max
Budget: $30 - $250 AUD
20-Oct-2025
21:59 GMT
ESP32 Timer via QR Payments (debe residir en buenos aires , argentina)
Category: Android, API Integration, Bluetooth, Electrical Engineering, Embedded Systems, Mobile App Development, PHP, Software Architecture
Budget: $30 - $250 USD
20-Oct-2025
21:59 GMT
Figma to Live Website Conversion (Framer or Webflow Preferred)
Category: CSS, Figma, Framer, Graphic Design, HTML, JavaScript, Web Design, Web Development, Webflow
Budget: ₹12500 - ₹37500 INR
20-Oct-2025
21:57 GMT
Moomintroll Swift Art
Category: Character Illustration, Creative Design, Digital Art, Graphic Design, Illustration, IPhone, Painting, Photoshop
Budget: $30 - $250 USD
20-Oct-2025
21:57 GMT
Human Pose Annotation (Skeleteon provided, Single Person per sample please watch example video) (strictly $300aud per 2000 samples)
Category: Computer Graphics, Computer Vision, Data Entry, Data Management, Data Processing, Deep Learning, Image Analysis, Image Processing, Web Scraping, Web Search
Budget: $250 - $750 AUD
20-Oct-2025
21:56 GMT
Facebook and Instagram Ad Campaign for Lead Generation
Category: Content Writing, Copywriting, Facebook Marketing, Internet Marketing, Marketing
Budget: $50 - $100 USD
20-Oct-2025
21:56 GMT
LinkedIn Construction Management Banner *ASAP*
Category: Adobe Illustrator, Photoshop, Banner Design, Corporate Identity, Figma, Graphic Design, Logo Design, Typography, Visual Design
Budget: $10 - $30 USD
20-Oct-2025
21:55 GMT
Senior-Level Resume Overhaul
Category: Business Writing, Content Writing, Creative Writing, Editing, Graphic Design, Microsoft Office, Microsoft Word, Technical Writing, Visual Design, Word Processing
Budget: $30 - $250 USD
20-Oct-2025
21:55 GMT
3D Model Conversion for Prototyping -- 2
Category: 3D CAD, 3D Design, 3D Modelling, 3D Printing, 3D Rendering, AutoCAD, CAD / CAM, Solidworks
Budget: $30 - $250 AUD
20-Oct-2025
21:54 GMT
Dynamic Social Media Designer & Content Manager
Category: Adobe Creative Suite, Banner Design, Canva, Content Creation, Graphic Design, Photoshop, Photoshop Design, Social Media Management
Budget: $250 - $750 USD
20-Oct-2025
21:53 GMT
Browse All Projects
Projects by Skills ...
Projects for 'android'
Projects for 'ajax'
Projects for 'asp'
Projects for 'aspnet'
Projects for 'cms'
Projects for 'cpp'
Projects for 'csharp'
Projects for 'css'
Projects for 'delphi'
Projects for 'design'
Projects for 'drupal'
Projects for 'excel'
Projects for 'facebook'
Projects for 'flash'
Projects for 'html'
Projects for 'java'
Projects for 'javascript'
Projects for 'joomla'
Projects for 'iphone'
Projects for 'mysql'
Projects for 'photoshop'
Projects for 'php'
Projects for 'python'
Projects for 'ruby'
Projects for 'seo'
Projects for 'sql'
Projects for 'sysadm'
Projects for 'translate'
Projects for 'typing'
Projects for 'twitter'
Projects for 'vbnet'
Projects for 'xml'
Projects for 'wordpress'
Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android'
RSS feed for 'ajax'
RSS feed for 'asp'
RSS feed for 'aspnet'
RSS feed for 'cms'
RSS feed for 'cpp'
RSS feed for 'csharp'
RSS feed for 'css'
RSS feed for 'delphi'
RSS feed for 'design'
RSS feed for 'drupal'
RSS feed for 'excel'
RSS feed for 'facebook'
RSS feed for 'flash'
RSS feed for 'html'
RSS feed for 'java'
RSS feed for 'javascript'
RSS feed for 'joomla'
RSS feed for 'iphone'
RSS feed for 'mysql'
RSS feed for 'photoshop'
RSS feed for 'php'
RSS feed for 'python'
RSS feed for 'ruby'
RSS feed for 'seo'
RSS feed for 'sql'
RSS feed for 'sysadm'
RSS feed for 'translate'
RSS feed for 'typing'
RSS feed for 'twitter'
RSS feed for 'vbnet'
RSS feed for 'xml'
RSS feed for 'wordpress'
RSS feed for 'writing'
New!
Проекты на русском
(Projects in Russian)

Short URL:
1001fp.com
Mobile version:
m.1001freelanceprojects.com
Copyright © 2005-2024 1001 Freelance Projects