Freelance Excel Jobs

Medical Admin Assistant

We're looking for a Medical Admin Assistant to join our growing team at HELM! You'll be working with our client in the medical industry in a fully remote capacity. In this role, you will be responsible for ensuring seamless patient experiences and efficient billing operations. You will be the linchpin in managing patient benefits, claims submissions, and client support, enabling the practice to focus on delivering outstanding health services. Responsibilities: Act as the primary point of contact for day-to-day administrative tasks and patient coordination. Take ownership of billing and administrative tasks, communicating with the bookkeeper regarding claims and payments, and resolving issues independently with minimal escalation. Verify out-of-network benefits for new clients during the onboarding process. Maintain a separate spreadsheet, accessible via Slack, to track all clients’ benefits. Submit claims through the designated platform following established protocols, such as after payments are received from clients. Send W9 forms to all insurance companies for new therapists to ensure proper credentialing. Review Explanation of Benefits (EOBs). Conduct consistent follow-ups with both insurance companies and patients regarding claims and outstanding information. Keep track of payments received and efficiently handle any discrepancies. Provide additional assistance, such as helping the CEO coordinate virtual open house events. Arrange and coordinate gift-giving for employees and other specified individuals and make small office-related purchases independently and with discretion. Requirements and Qualifications: Excellent spoken and written English communication skills. Must possess excellent attention to detail, demonstrating the ability to be ultra-organized, highly reliable, and proactive in supporting operations. Highly assertive and proactive, with the ability to take full ownership of tasks and drive solutions independently. High Discretion & Confidentiality, ability to handle sensitive information and maintain confidentiality. An understanding of HIPAA compliance. Excellent phone skills with a cheerful disposition. Possess a warm, enthusiastic, hospitable, and empathetic demeanor. Tools You'll Use: Sessions Health (EHR system) Slack Simple Practice Valant Excel Location: Remote (contractor basis) Weekly Hours: 30 - 40 p/w depending on business requirements and between 8am - 5pm EST Pay Range: $12 - $15 p/h Equipment: BYO Devices If you are interested in this opportunity, please submit your CV and share why! A bit about us... Helm is a staffing agency that exists to help people achieve freedom. Our staffing team (a.k.a. dream merchants) seeks A-Players. Does the following describe you: Superb written and spoken English (we assess skills unassisted by AI Tools, Grammarly, and ChatGPT). We look for C2 proficiency, or native-level English. Entrepreneurial, attentive to others, curious, and hungry for growth! If so, let’s talk!

Need an accountant asap

Key Responsibilities: Financial Reporting & Management: Prepare monthly, quarterly, and annual financial statements for multiple business entities, ensuring compliance with UK GAAP and IFRS where applicable. Prepare consolidated financial statements for the group of entities, ensuring accurate elimination of intercompany transactions and balances. Ensure that all financial transactions are properly recorded, reconciled, and documented across different business units. Prepare management accounts and provide business leaders with key financial insights and recommendations. Tax Compliance & Planning: Prepare and submit timely UK corporation tax returns and manage VAT returns for each business entity. Oversee PAYE and National Insurance contributions for the business, ensuring compliance with HMRC regulations. Ensure compliance with tax laws, including identifying opportunities for tax relief, allowances, and deductions. Cash Flow Management & Forecasting: Manage cash flow across multiple business entities, ensuring adequate liquidity and operational efficiency. Provide regular cash flow forecasts for each entity, including managing working capital needs and projections for future periods. Budgeting & Financial Planning: Assist in the preparation of annual budgets for each entity and ensure alignment with the company’s financial goals. Monitor budget performance across business units, highlighting variances and recommending corrective actions where necessary. Multi-Entity Accounting: Manage intercompany transactions, ensuring accurate recording and reconciliation between entities. Ensure proper consolidation of financial results from subsidiaries or related businesses. Provide insights on the financial health of each entity, advising on cost-saving strategies, revenue growth opportunities, and financial risk management. Software & System Management: Utilize cloud-based accounting software (e.g., Xero, QuickBooks, Sage) to record, process, and report financial data for multiple entities. Manage integration of financial systems across different business entities to ensure smooth operations and accurate reporting. External Relationships & Compliance: Liaise with auditors, tax advisors, and HMRC to ensure timely audits and tax filings. Work with external stakeholders to address any financial queries or concerns and maintain strong relationships with banks and financial institutions. Remote Collaboration & Communication: Regularly communicate with management, department heads, and other stakeholders via video calls, emails, and collaborative tools (e.g., Slack, Zoom). Work independently and efficiently, managing time across multiple entities and meeting deadlines in a remote environment. Key Skills & Qualifications: ACA / ACCA / CIMA Qualification (or equivalent) with significant experience in accounting and financial management. Proven experience managing finances for multiple business entities, ideally in a multi-entity or group structure. Strong understanding of UK accounting standards (UK GAAP), corporation tax, VAT, PAYE, and National Insurance. Expertise in cloud-based accounting software (e.g., Xero, QuickBooks, Sage) and ERP systems (e.g., SAP, NetSuite). Experience with intercompany transactions, consolidation of financial statements, and multi-currency accounting. Strong analytical skills with the ability to produce detailed financial reports and provide actionable insights. Experience with budgeting, forecasting, and cash flow management for multiple entities. Knowledge of data security protocols and GDPR compliance when handling sensitive financial information. Excellent communication skills and the ability to collaborate effectively with remote teams and stakeholders. High level of attention to detail and ability to work independently with minimal supervision. Strong time management skills and the ability to manage multiple priorities in a remote work environment. Preferred Qualifications: Experience in remote work or managing finances for remote teams. Knowledge of international tax regulations if any business entities are based outside the UK. Advanced Excel skills for financial modeling, data analysis, and report generation. Experience with financial auditing and external audits.

Build or configure a online bookstore template Nextjs + React

Looking for an experience web designer to build or configure ready made template super quick within 7 days. You will also connect the database with supplier using FTP ONIX 3.2 for both physical and digital book sales Scope of Work ============ ONIX 3.1.2 FTP Integration • Establish FTP connection to receive ONIX 3.1.2 XML feeds (physical + digital books). • Parse ONIX metadata (title, ISBN, format, author, categories, price, availability, etc.). • Automate mapping of ONIX fields to Magento product attributes. • Handle media links (e.g., cover images) and ensure correct association. • Set up scheduled data refresh and error reporting (e.g., nightly or on FTP update). Magento Product Sync & Categorisation • Automatically create or update products in Magento based on ONIX data. • Assign products to correct categories, tags, and custom filters for user navigation. • Validate products with missing data and create logic to flag for manual review. • Ensure full compatibility with simple and downloadable product types. Front-End Setup & UX Flow • Create elegant, responsive product listings and detail pages. • Filter systems for format (eBook, paperback, hardcover), genre, publisher, and price range. • Implement breadcrumb navigation and clean SEO-friendly URLs. Full Site Completion • Customise theme for your brand (colors, fonts, layout). • Build all pages: Home, Shop, About, Contact, Terms, Privacy, etc. • Set up customer account area, checkout flow, newsletter signup, search bar, and footer menus. For a site like Waterstones.com, I'd recommend: **Next.js + TypeScript + PostgreSQL + Stripe** ### **Frontend Layer:** ```plaintext Languages: TypeScript, HTML5, CSS3 Framework: Next.js 14 UI Library: React 18 Styling: Tailwind CSS or Styled Components State Management: Zustand or Redux Toolkit Forms: React Hook Form Validation: Zod or Yup ``` ### **Backend Layer:** ```plaintext Runtime: Node.js 18+ Framework: Next.js API Routes Language: TypeScript Authentication: NextAuth.js or Auth0 API Style: REST or GraphQL (with Apollo) Validation: Zod File Upload: Uploadthing or AWS S3 ``` This stack provides: - Excellent performance and SEO - Type safety with TypeScript - Scalable architecture - Modern development experience - Strong community support - Easy integration with payment systems **You will be required to demonstrate experience by completeing 50% of the first milestone before you will be assigned the work and your proposal accepted due to dissapointment by other freelance** Only apply if you have necessary experience

opportunity

VA – Studio Systems, Workflow Setup & Daily Support

Overview: We are a Europe-based creative studio working across collectible design, art, and interiors. We are looking for a reliable, detail-oriented virtual assistant to help set up the internal systems, tools, and workflows that support both our creative and operational work. This is a fixed-term, part-time project ideal for someone who is calm, structured, and enjoys building organisation within creative environments. In addition to building internal systems, you’ll also assist with ongoing, day-to-day admin and studio support tasks during the project period. There is potential for this role to grow into a longer-term support position once the initial contract is complete. Project Scope: • Organise Google Drive/Dropbox and shared folders with consistent naming and structure • Build and format spreadsheets for pricing and quotations, supplier details, invoice tracking, and commissions • Create and manage Trello or Notion boards to track creative and procurement workflows • Write SOPs and templates for regular studio processes (project tracking, procurement follow-ups, file sharing) • Support daily admin tasks such as inbox management, file sorting, packing lists, invoicing, etc. • Assist with batching and scheduling social content using Canva and Planoly • Help coordinate calendars and weekly planning blocks for creative work • Integrate AI tools into everyday workflows, including: o ChatGPT for captions, templates, and planning o remove.bg / WEGIC for image editing o Midjourney and Hyper3D.ai for moodboarding and concept visualisation What We’re Looking For: • Excellent written English • Strong organisational and admin skills • Confident with Google Docs, Sheets, Calendar, and Drive • Familiarity with Canva, Trello, or Notion • Calm, proactive communicator who works independently • Bonus if you’ve worked in or supported a creative business Deliverables: • Complete studio file system in Google Drive • Spreadsheet dashboards for tracking pricing, suppliers, and commissions • Trello or Notion boards for project and collection planning • Email and admin templates • AI tool prompt library and basic workflow setup • Weekly task checklists and simple calendar integration • Clear documentation of all systems created for future use To Apply: Please include: • A short introduction and your approach to setting up workflows and systems • Examples of similar tools or templates you’ve built • A brief summary of your admin or assistant experience • Your availability to begin in July We’re looking for someone supportive, methodical, and kind — someone who enjoys bringing structure to creative projects and helping a small studio run smoothly. If it’s a good fit, there’s potential to continue with us beyond the initial project period.

opportunity

Photographer needed for theatre project New Orleans

Request for Proposal: Specialist New Orleans Photographer We are a UK-based production company seeking a highly skilled, New Orleans based photographer for a critical project: capturing the essence of a renowned New Orleans theatre. This project aims to showcase the venue as a world-class destination, highlighting its architectural beauty and vibrant atmosphere with patrons during an evening performance. Our work will align with a specific artistic style established across 50+ venues in Europe. We prioritise a reliable, precise photographer who can execute a detailed shot list and and collaborate well. We have one chance to get this right at this specific venue, requiring a truly safe pair of hands. Project Details & Deliverables Location: A specific theatre in New Orleans, Louisiana. Shoot Date/Time: At night, mutually agreed upon. The shoot is 4-5 hours, capturing evening ambiance, patron arrival, and moments during performance/intermission. Crucial Limitation: No on-stage production elements are permitted; focus is solely on the venue and patron experience. Creative Vision: Depict the theatre as grand, bustling, and inviting, from pre-show quiet to post-show applause. Shot List Phases: Interior (Empty Theatre - Pre-Arrival): Wide, architectural shots of auditorium, lobby, public spaces before patrons. Focus on grandeur, design, ambiance. Requires swift, efficient execution (limited access). Exterior & Interior (Patron Arrival & Buzz): Exterior Arrival: Wide shots of theatre exterior at night, with people entering. Showcase location, lit façade, dynamic energy. Interior Atmosphere (with patrons): Wide shots conveying energy, without recognisable faces in close-up. Staff Interaction (Arrival): Candid "action shots" of staff serving customers (e.g., box office, bars). Requires flexibility. During Show & Intermission: Interior During Show: Capture interior during performance in a very dark environment. Expertise in extreme low-light conditions is paramount (e.g., 30+ second exposures). Discretion is Key: Highly discreet, silent, minimal time inside during show. Accompanied by staff. Intermission Photos: Capture staff serving in bars/concessions, and additional interior shots. Staff Setup (Styled): Styled shots of staff in bar areas, aiming for a "perfect bar" look. "Money Shot" - Applause/Standing Ovation: Wide shot of entire theatre interior with audience applauding at finale. Key hero shot, though not always guaranteed. Artistic & Technical Requirements World-Class Depiction: Images must elevate theatre's perception to a premier global entertainment destination; photos must be "amazing." Style & Shot List Adherence: Meticulous execution of our vision and detailed shot list is primary. Natural Lighting (No Flash): Only available ambient light; no flash permitted. Non-negotiable for consistency and atmosphere. Must excel in extreme low-light. Anonymity of Patrons/Customers: Crowd Shots: Faces not recognisable in close-up. Staff Interaction: Focus on backs of customers' heads/hands, or angles obscuring faces. Equipment & Deliverables Full-Frame Camera: Professional model essential (e.g., Canon R5 or equivalent) for low-light/long exposures. Versatile Lens Kit: Comprehensive fast lenses (e.g., 11mm-200mm) for diverse scenes. Tripod: Sturdy tripod mandatory for sharp, low-light images. RAW Files Only: Delivered unedited. Our team handles all post-processing for consistency. Image Quantity: To be discussed, expect comprehensive set. Your Experience & Skills Exceptional low-light photography expertise: Especially architectural, event, in-show theatre (no flash, 30+ sec exposures). Strong portfolio: Showcasing similar high-quality, atmospheric imagery (interiors, dynamic crowds, styled setups). Demonstrated ability to follow direct instructions and detailed shot lists precisely. Comfortable working efficiently & discreetly in dynamic theatre environments. Familiarity with discreet shooting techniques for natural environment/patron privacy. Excellent communication & professional demeanour. Collaboration & Application We provide detailed coaching & guidance (based on 50+ European venues) and examples. We handle all client liaison & booking logistics. Collaborate smoothly with on-site theatre staff. RAW files transferred via Google Drive within [X, e.g., 24-48 hours]. To Apply: Submit your proposal including: Relevant portfolio: Highlight low-light, architectural, event, or theatre work (no flash, dark conditions, stylistic adherence). Experience overview: Describe similar project experience, approach to low-light, discretion, and following briefs. Equipment list: Confirm full-frame camera(s), lens kit, and tripod suitability. Proposed fee for a 4-5 hour shoot. We look forward to collaborating with a talented photographer to bring this world-class venue to life through stunning imagery. Kind regards, Alex

opportunity

Photographer needed for Broadway Theatre project in New York

Request for Proposal: Specialist Broadway Theatre Photographer (NYC) We are a UK-based production company seeking a highly skilled, NYC-based photographer for a critical project: capturing the essence of a renowned Broadway theatre. This project aims to showcase the venue as a world-class destination, highlighting its architectural beauty and vibrant atmosphere with patrons during an evening performance. Our work will align with a specific artistic style established across 50+ venues in Europe. We prioritize a reliable, precise photographer who can execute a detailed shot list and and collaborate well. We have one chance to get this right at this specific venue, requiring a truly safe pair of hands. Project Details & Deliverables Location: A specific theatre on Broadway, New York. Shoot Date/Time: At night, mutually agreed upon. The shoot is 4-5 hours, capturing evening ambiance, patron arrival, and moments during performance/intermission. Crucial Limitation: No on-stage production elements are permitted; focus is solely on the venue and patron experience. Creative Vision: Depict the theatre as grand, bustling, and inviting, from pre-show quiet to post-show applause. Shot List Phases: Interior (Empty Theatre - Pre-Arrival): Wide, architectural shots of auditorium, lobby, public spaces before patrons. Focus on grandeur, design, ambiance. Requires swift, efficient execution (limited access). Exterior & Interior (Patron Arrival & Buzz): Exterior Arrival: Wide shots of theatre exterior at night, with people entering. Showcase location, lit façade, dynamic Broadway energy. Interior Atmosphere (with patrons): Wide shots conveying energy, without recognizable faces in close-up. Staff Interaction (Arrival): Candid "action shots" of staff serving customers (e.g., box office, bars). Requires flexibility. During Show & Intermission: Interior During Show: Capture interior during performance in a very dark environment. Expertise in extreme low-light conditions is paramount (e.g., 30+ second exposures). Discretion is Key: Highly discreet, silent, minimal time inside during show. Accompanied by staff. Intermission Photos: Capture staff serving in bars/concessions, and additional interior shots. Staff Setup (Styled): Styled shots of staff in bar areas, aiming for a "perfect bar" look. "Money Shot" - Applause/Standing Ovation: Wide shot of entire theatre interior with audience applauding at finale. Key hero shot, though not always guaranteed. Artistic & Technical Requirements World-Class Depiction: Images must elevate theatre's perception to a premier global entertainment destination; photos must be "amazing." Style & Shot List Adherence: Meticulous execution of our vision and detailed shot list is primary. Natural Lighting (No Flash): Only available ambient light; no flash permitted. Non-negotiable for consistency and atmosphere. Must excel in extreme low-light. Anonymity of Patrons/Customers: Crowd Shots: Faces not recognizable in close-up. Staff Interaction: Focus on backs of customers' heads/hands, or angles obscuring faces. Equipment & Deliverables Full-Frame Camera: Professional model essential (e.g., Canon R5 or equivalent) for low-light/long exposures. Versatile Lens Kit: Comprehensive fast lenses (e.g., 11mm-200mm) for diverse scenes. Tripod: Sturdy tripod mandatory for sharp, low-light images. RAW Files Only: Delivered unedited. Our team handles all post-processing for consistency. Image Quantity: To be discussed, expect comprehensive set. Your Experience & Skills Exceptional low-light photography expertise: Especially architectural, event, in-show theatre (no flash, 30+ sec exposures). Strong portfolio: Showcasing similar high-quality, atmospheric imagery (interiors, dynamic crowds, styled setups). Demonstrated ability to follow direct instructions and detailed shot lists precisely. Comfortable working efficiently & discreetly in dynamic theatre environments. Familiarity with discreet shooting techniques for natural environment/patron privacy. Excellent communication & professional demeanor. Collaboration & Application We provide detailed coaching & guidance (based on 50+ European venues) and examples. We handle all client liaison & booking logistics. Collaborate smoothly with on-site theatre staff. RAW files transferred via Google Drive within [X, e.g., 24-48 hours]. To Apply: Submit your proposal including: Relevant portfolio: Highlight low-light, architectural, event, or theatre work (no flash, dark conditions, stylistic adherence). Experience overview: Describe similar project experience, approach to low-light, discretion, and following briefs. Equipment list: Confirm full-frame camera(s), lens kit, and tripod suitability. Proposed fee for a 4-5 hour shoot. We look forward to collaborating with a talented photographer to bring this world-class venue to life through stunning imagery. Kind regards, Alex

UK ONLY: WordPress Developer - Monthly Retainer

Experience Level: Expert We are a 12-year-old six-figure UK-based digital marketing agency seeking a highly skilled and experienced WordPress developer to join our team on a month-to-month retainer contract up to 20 hours per month. The primary focus of this role is to provide ongoing technical support, maintain website performance, and implement SEO-focused technical improvements for one of our key clients. The ideal candidate will have a proven track record in WordPress development and the ability to work collaboratively with our internal SEO team to deliver measurable results. Key Responsibilities: Technical Support & Maintenance: Resolve technical issues promptly and efficiently, ensuring minimal downtime and optimal website performance for our client's WordPress site. Website Updates & Optimisation: Keep the website current with plugin updates, security patches, and performance optimisations whilst maintaining site stability and functionality. SEO Technical Implementation: Work directly with our SEO team to execute technical improvements based on detailed briefs, including site speed optimisation, schema markup, and technical SEO improvements. Project Management: Collaborate with the team using ClickUp for task management, progress tracking, and client communication (full training provided if required). Quality Assurance: Conduct thorough testing of all changes and updates to ensure compatibility and functionality across different devices and browsers. Documentation: Maintain clear records of all technical changes, updates, and improvements for client reporting and future reference. Requirements: - Proven experience as a WordPress developer with a strong portfolio demonstrating technical expertise and problem-solving capabilities. - Excellent knowledge of WordPress core, themes, plugins, and custom development with PHP, HTML, CSS, and JavaScript. - Strong understanding of website performance optimisation, security best practices, and SEO technical requirements. - Experience with debugging tools, staging environments, and version control systems. Ability to work collaboratively with SEO specialists and implement technical recommendations effectively. - Strong communication skills and ability to explain technical concepts to non-technical team members. - Proactive approach to identifying and resolving potential issues before they impact website performance. Familiarity with project management tools and ability to work within established workflows. What We Offer: - A fully remote and flexible working environment - Competitive monthly retainer based on experience and qualifications - Ongoing work with a rapidly expanding agency - Collaborative team environment with opportunities for professional growth - Comprehensive training on our systems and processes Project Details: Location: Remote. UK-based candidates only. We will decline any proposals from other territories. Contract Duration: Month-to-month retainer, with the possibility of extension based on performance and business needs. Start Date: Immediate Hours: Up to 20 hours per month (flexible scheduling) Compensation: Competitive monthly retainer, based on experience and qualifications -- To confirm you have read the brief, and for interview, please share your contact number in your proposal.

Personal Guarantee and ILA for 2 directors in company

Looking for cheap ILA for personal guarantee document , Guarantee and Indemnity and Certificate of Confirmation of Independent Legal Advice to the Guarantor. The Guarantor is a company incorporated in the United Kingdom. The Guarantor has requested that the Company provide a guarantee and indemnity in respect of the obligations of the Guarantor under the terms of the Loan Agreement. The Guarantor has also requested that the Company provide a certificate of confirmation of independent legal advice to the Guarantor in respect of the guarantee and indemnity. The Company has engaged the services of a law firm to provide the guarantee and indemnity and the certificate of confirmation of independent legal advice to the Guarantor. The law firm has provided the Company with a draft of the guarantee and indemnity and the certificate of confirmation of independent legal advice. The Company is seeking to engage a freelance lawyer to review the draft of the guarantee and indemnity and the certificate of confirmation of independent legal advice and to provide the Company with a final version of the documents that are compliant with the requirements of the Loan Agreement. The freelancer will be required to review the draft of the guarantee and indemnity and the certificate of confirmation of independent legal advice and to identify any issues or concerns that may arise. The freelancer will then be required to provide the Company with a detailed report of their findings and recommendations. The freelancer will also be required to provide the Company with a final version of the guarantee and indemnity and the certificate of confirmation of independent legal advice that is compliant with the requirements of the Loan Agreement. The freelancer will be required to ensure that the final version of the documents is clear, concise, and easy to understand. The freelancer will be required to work closely with the Company to ensure that the final version of the documents is delivered on time. The freelancer will be required to provide the Company with regular updates on the progress of the project and to address any concerns or questions that the Company may have. The freelancer will be required to have a strong understanding of the law and to have experience in drafting legal documents. The freelancer will also be required to have excellent communication skills and to be able to work effectively with the Company. The freelancer will be paid a fixed fee for the project. The freelancer will be required to submit a proposal outlining their fees and the scope of the project. The freelancer will be required to provide the Company with a copy of their qualifications and experience. The freelancer will be required to sign a confidentiality agreement before starting work on the project. The confidentiality agreement will protect the Company's confidential information and will prevent the freelancer from disclosing any information to third parties. The freelancer will be required to work remotely and to provide the Company with access to their computer and other necessary equipment. The freelancer will be required to be available to work during the Company's business hours. The freelancer will be required to comply with all applicable laws and regulations. The freelancer will be required to ensure that the final version of the documents is compliant with the requirements of the Loan Agreement. In conclusion, the Company is seeking to engage a freelance lawyer to review the draft of the guarantee and indemnity and the certificate of confirmation of independent legal advice and to provide the Company with a final version of the documents that are compliant with the requirements of the Loan Agreement. The freelancer will be required to have a strong understanding of the law and to have experience in drafting legal documents. The freelancer will be paid a fixed fee for the project and will be required to sign a confidentiality agreement before starting work on the project. The freelancer will be required to work remotely and to provide the Company with access to their computer and other necessary equipment. The freelancer will be required to comply with all applicable laws and regulations."

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

Freelance Administrative/Executive Assistant for Elite Concerts

Location: Remote, with optional in-office work at St. Mary’s Chambers, Rossendale, Lancashire, UK Hourly Rate: £15–£22 (depending on experience and suitability) Hours: Flexible, 10–15 hours per week initially, with potential to scale to full-time or remain part-time Contract Type: Freelance, via PeoplePerHour ABOUT ELITE CONCERTS INTERNATIONAL Elite Concerts International is a leading concert promotions company based in the heart of Rossendale, Lancashire, delivering unforgettable live entertainment across the UK and beyond. With over 300 theatre and concert dates annually, we tour a diverse roster of artists and shows, from original artists to world-leading tribute shows. Our passion for live performance also shines through at our own venue, St. Mary’s Chambers (www.stmaryslive.com), a vibrant hub for music, events, and community engagement in East Lancashire. Operating from our office at St. Mary’s Chambers, our team thrives on creativity and a shared love for the entertainment industry. We’re now seeking a talented Freelance Administrative/Executive Assistant to join our fast-paced, exciting operation. This is a fantastic opportunity for an organised, proactive professional to support our director and team, helping us keep the shows on the road! THE ROLE We are seeking a Freelance Administrative/Executive Assistant to support our day-to-day operations by ensuring smooth organisation and communication with venues, artists, production teams, and others. You will work closely with our director and a small, dedicated team to provide high-level administrative support and manage our busy schedule. This role is ideal for someone who excels in a flexible, remote work environment. For candidates based locally, occasional work from our Rossendale office at St. Mary’s Chambers may be beneficial, though this is not mandatory. KEY RESPONSIBILITIES General Administration: Handle day-to-day admin tasks with efficiency and accuracy, keeping our operations seamless. Executive Support: Assist the director by managing emails, scheduling meetings, and organising their calendar to maximise productivity. Financial Oversight: Monitor payments in and out, action invoices, and chase overdue payments to maintain healthy cash flow. Marketing Coordination: Support the team by checking that marketing tasks (e.g., social media, promotional campaigns) are completed on time and flagging any overdue items. Potentially also setting up campaigns directly, for candidates with experience or a keen interest in marketing (though not essential). Ad-Hoc Tasks: Jump in to support various projects, from event planning to artist coordination, as needed in our fast-moving industry. WHO WE'RE LOOKING FOR We’re after a reliable, detail-oriented professional who can keep up with the high-energy world of concert promotions. You don’t need to be a music buff, but a passion for organisation and a can-do attitude are a must! ESSENTIAL SKILLS & EXPERIENCE Proven experience as an administrative or executive assistant, ideally in a fast-paced environment. Excellent communication skills, with the ability to manage emails and interact professionally with clients, suppliers, and team members. Strong organizational skills and a proactive approach to managing multiple tasks and deadlines. Comfortable with basic financial tasks, such as invoicing and payment tracking. Proficiency in standard office software (e.g., Microsoft Office, Google Workspace) and quick to learn new tools. DESIRABLE (But Not Essential): Experience in the entertainment, events, or concert touring industry – a bonus, but we’re happy to train the right candidate! Familiarity with basic bookkeeping or accounts management (e.g., using Xero, QuickBooks, or similar). Knowledge of digital marketing, such as social media scheduling or campaign tracking. WHY WORK WITH US? Flexible Hours: Start with 10–15 hours per week, with the potential to scale up to full-time or stay part-time based on your availability. Exciting Industry: Be part of the thrilling world of live music and events, working with a passionate team. Hybrid/Remote Work: Enjoy the freedom of remote work, with the option to collaborate in-person at our stunning St. Mary’s Chambers venue if local. Competitive Pay: Earn £15–£20 per hour, depending on your experience and skills. Growth Opportunities: As we grow, so can your role. HOW TO APPLY Please submit your proposal through PeoplePerHour, including: A brief cover letter outlining your relevant experience and why you’re excited about this role. Your CV or a link to your PeoplePerHour profile showcasing your skills. Any examples of previous admin, bookkeeping, or marketing work (if applicable). We’re looking to onboard someone ASAP, so don’t miss your chance to join the Elite Concerts International team.