Full Stack Developer Projects

CSV Manipulation & Import Products (Woo, Python, CSV)

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

opportunity

Editing of video course 'how to be God'

Introduction I am a life and business coach, an entrepreneur, and the leader of a political party in the UK called ‘Everyone is God’. My life & political mission is to: Empower Everyone, Solve Everything, and Fulfil Every Dream. A far as I am aware this course in 'How to be God' is the first course of it's nature in human history, and as such the successful freelancer will have a sense of excitement and enthusiasm in carrying out this project. Scope of the project The video course will consist of approximately 40 videos varying in length from about 5 – 30 mins each. I will film and supply the raw footage of me speaking in my studio with a plain background, there will also be some channelled footage with me and my partner in the studio (A-roll). The format and editing of each video will need to be fully professional in all aspects, and follow a consistent pattern as follows: • Professional, clean, simple, and inspiring feel. • Consistent intro and outro. (simple logo animation and graphics) • Use of text to introduce each section. • Occasional use of simple info graphics. • Simple clean dynamic editing and dynamic cuts to the raw footage and to stock photos and video (B-roll) to give calm feeling to the videos. Additionally, to this I will need simple editing of the logo animation and graphics so they are a suitable format for other digital requirements such as my YouTube channel and websites, for consistency of branding across all media. How we will work together Phase 1 – Building a working relationship. The successful freelancer will need to work with me closely and speak good English, you will need to be entirely happy regularly talking on video calls and screen sharing. Phase 2 – Exploring and clarifying the format and style of the editing, and the working process. It is crucial that we have the time needed to develop and achieve a presentation of the material that works perfectly, i.e. unlimited revisions. The purpose of phase 2 is also to make phase three 3 (batch post production) as efficient as possible, and to a standard repeated pattern. It is important to understand that I fully intend to provide you with quality video that needs little or no colour correction, image stabilisation, audio clean-up, etc with a ratio of raw footage to final being around 1.25 to 1 or less. We will make sure you have everything you need, in the simplest and best possible format, so your work is straightforward, and you will need to advise me on what makes your job easy. Phase 3 – Batch post production Video editing should then run smoothly and quickly, as essentially every video should be of a similar format and require a repeated editing procedure. Further information My life coaching: www.every1isgod.com My political party: www.everyoneisgod.co.uk My YouTube channel: www.youtube.com/@every1isgod Please note that this work is amateur and does not demonstrate the quality of work I am wishing to achieve, hence my seeking a video editor. Time schedules There is no fixed deadline for completion, however clearly the project needs to be finished in a timely manner. The time scale I propose below is most likely a best-case scenario if everything goes smoothly (something that is rare). Phase 1 and 2 - Mid July to mid August 2025 Phase 3 - Mid August to end November 2025 Payment terms TBC I propose that a 6% deposit would be paid prior to phase 1, and then stage payments on completion of each phase of work. Future Work If the project is successful I intend to produce further video courses. How to express your interest and the selection process If this project resonates with you, please feel free to express your interest. Please do not make a proposal to me unless you are able to meet all of the following: 1. You resonate with the subject matter and mission. 2. You are fully skilled and experienced. 3. You are confident to make creative suggestions on all aspects of the footage and editing, take on responsibility, and complete all work. 4. Easily and regularly available on phone and video call, with screen sharing. 5. Happy to share your knowledge & answer technical questions about all aspects of your work. 6. You are prepared to be interviewed by video call. I will therefore read any proposals that are sent, along with your profiles. I will then short list a number of applicants for video interviewing (approximately 3 depending on the suitability of the applicants). I will then decide upon the freelancer. I hope this gives you a clear picture of what is required. Thank you for considering this project. I look forward to hearing from you, and good luck! Marcus White M.A. (Oxon)