Database Design Projects

opportunity

Concierge Website Build (Wix + WhatsApp + E-commerce)

Overview: I am building a concierge-style service business based in Samara and Carrillo, Costa Rica. The goal of this website is to provide a simple, clean, and high-converting platform where visitors can explore services, choose packages, and easily contact us via WhatsApp. This is NOT a traditional booking website. The focus is on simplicity, user experience, and converting visitors into WhatsApp conversations. Core Services to Include: Moped Rentals Daily, weekly, and monthly pricing Simple display (no complex calendar booking required) “Book Now” buttons leading to WhatsApp or inquiry form Beach Rentals Daily, weekly, monthly options Includes chairs, umbrella, cooler, towels Same booking flow (WhatsApp or form) Fridge Stocking (E-commerce functionality REQUIRED) Customers can order online and pay directly Includes: Pre-set packages (Arrival Pack, Premium Pack, etc.) Custom fridge stocking option Custom option should allow: Selection of preferences (e.g. drinks, dietary type) Grocery budget tiers ($100 / $150 / $200+) Custom text field for specific requests This is the ONLY service that requires full online checkout Packages (Bundles): Create package-style offerings that combine services, such as: Moped + Beach Kit Moped + Fridge Stocking Full Concierge Package (all services combined) These should be displayed cleanly (like pricing plans or cards), but treated as one-time purchases, not subscriptions. Additional Services / Upsells: Include sections or options for: Concierge support (WhatsApp-based support during stay) Tour / experience coordination (via partners) Private transport coordination Catering / in-house meals / private chef Premium meal kits (as an add-on or product) These do NOT require automated booking — they should lead to WhatsApp or inquiry. Booking & Communication Flow (VERY IMPORTANT): Primary conversion = WhatsApp Floating WhatsApp button on all pages Most services: Click → WhatsApp OR form → manual confirmation Fridge stocking: Can be ordered and paid online Follow-up handled via WhatsApp Design Requirements: Clean, modern, premium feel (not cluttered) Mobile-first design (most users on phone) Easy navigation Strong focus on: Simple sections Clear buttons Minimal friction Pages Needed: Home Services (individual services listed clearly) Packages (bundle deals) Fridge Shop (online ordering) Contact / Inquiry Key Features: WhatsApp integration (floating + buttons throughout) Simple forms for inquiries Wix Stores (or similar) for fridge stocking No complex booking calendars required Easy to update and scale Goal of Website: To make it extremely easy for visitors to: Understand what we offer Choose a service or package Contact us quickly via WhatsApp Book or request services with minimal effort Important Note: This is a concierge business, not a traditional rental platform. The experience should feel simple, premium, and personalized — not like a complicated booking system. Optional (Nice to Have): Ability to add more services/products later Basic SEO setup Fast loading speed Summary: I need a clean, conversion-focused website that: Highlights services and packages Allows online ordering for fridge stocking Uses WhatsApp as the main booking tool Feels premium and easy to use

Customer Service / 2nd Line Support Person

Here's a professional job advert version: --- **2nd Line Support Specialist** *Full-Time Position | Monday–Friday, 9am–5pm UK Time* We're seeking an exceptional 2nd Line Support Specialist to join our growing team and deliver outstanding customer experiences. **About the Role** You'll be the vital link between our customers and our CRM platform, providing expert technical support and ensuring seamless customer satisfaction. This varied role combines technical troubleshooting, customer service excellence, and campaign coordination. **Key Responsibilities** - Provide responsive, high-quality technical support directly to customers via ticket system and live chat - Troubleshoot and resolve CRM product queries with efficiency and expertise - Manage and coordinate customer marketing campaigns from brief to execution - Liaise with our design team to implement campaign requirements and schedule changes - Monitor and respond promptly to live chat requests throughout business hours - Maintain detailed records and ensure all deadlines are met **Essential Requirements** - Excellent written and verbal English communication skills - Strong technical aptitude with ability to learn complex systems quickly - Exceptional attention to detail and deadline management - Highly responsive with excellent time management skills - Commitment to consistent availability during core business hours (9am–5pm UK time) - Customer-focused mindset with a passion for problem-solving **What We're Looking For** The ideal candidate is a fast learner who thrives in a fast-paced environment, communicates clearly and professionally, and takes pride in delivering exceptional customer service. **Interested?** If you have the skills, dedication, and customer service excellence we're looking for, we'd love to hear from you.

opportunity

Luxury Mattress Image Editing / Compositing for Premium Beds

Hello, I run a UK luxury bedding brand called Bello Luxury Living and I’m currently refreshing the visual presentation of our mattress collection across the website. I’m looking for a skilled image editor / compositing designer who can create premium product images for our mattress catalogue. The goal is to present each mattress in a consistent luxury bedroom environment while keeping the mattress as the main focus of the image. This is NOT simply placing the mattress onto a random stock background. I am looking for someone who understands luxury product presentation and can create a clean, high-end aesthetic similar to premium bedding brands. VISUAL DIRECTION The desired look is a minimal luxury bedroom setting similar to high-end hotel interiors: • Elegant neutral bedroom environment • Soft natural or studio lighting • Upholstered bed base or minimal bed frame • Luxury wall panels or simple modern background • Mattress clearly visible and centred as the main subject The room should support the product without distracting from it. Every mattress should be presented using the SAME camera angle, room style, lighting and bed frame so the entire collection looks uniform and premium. TEST PROJECT To begin, I would like to run a small test project to find the right creative partner. The test will consist of editing 3 mattress images using the same camera angle but placing them into the same luxury bedroom environment so I can see how the visual direction works. The goal of the test is to confirm the visual style before applying it across the full mattress collection. Once we confirm the direction, there will be a larger project to edit the rest of the mattress range. WHAT I WILL PROVIDE • High resolution mattress images • Visual references of the style I’m aiming for • Clear feedback during the process WHAT I AM LOOKING FOR • Strong Photoshop compositing skills • Experience with product or furniture imagery • Attention to lighting, shadows and realism • Ability to create clean, luxury visuals suitable for ecommerce If the test goes well, I’m looking to build a longer-term working relationship as there will be many more images to complete. Please include examples of similar product or interior compositing work in your proposal. Thank you and I look forward to working together.

opportunity

WordPress / WooCommerce Development (SEO-critical + CRM)

We are looking for an experienced WordPress/WooCommerce developer to build a new website on a staging environment, based on an existing website with strong SEO performance. This is not a simple website build. The main challenge is: - preserving SEO rankings - correctly integrating a custom CRM plugin - ensuring a smooth migration and launch ______ Project context The business rents out party and decoration items. ± 2,000 products ± 40 categories Products can belong to multiple categories Clear structure, filtering and scalability are essential ______ Project Scope - Build a new WordPress/WooCommerce website on a staging environment - Use an existing theme (no need to design from scratch) - Integrate a custom-built plugin that connects a CRM with WordPress - Structure products and data based on CRM input - Prepare full migration to live environment ______ Key Functional Requirement (Important) - This is not a traditional webshop. - There is no payment / checkout process - Products are added to a quote request (cart as quotation) - Guests can submit their selected products as an inquiry/request - The “cart” functions as a quotation request system So: - No payment gateways needed - No transactional checkout ____ Key Requirements (Critical) 1. CRM Plugin Integration - Products and data must be automatically retrieved from the custom plugin - Ensure correct mapping between CRM data and WooCommerce products - Products must support multiple category assignments - Stability and performance are crucial 2. SEO Preservation (Highest Priority) This project will fail if SEO rankings drop. You must ensure: - Existing URL structure is preserved (or properly redirected) - All 301 redirects are correctly implemented - Metadata, headings, and internal linking are maintained - XML sitemap and robots.txt are correctly configured - No indexation issues during staging/live transition ______ Process & Collaboration This is a long-term, iterative project: Build → test → feedback → improve (multiple rounds) - Close communication required - You must be comfortable working in structured feedback cycles ______ Launch & Aftercare The freelancer is also responsible for: - Supporting the go-live - Monitoring the website after launch Fixing any issues related to: - SEO drops - Broken links - Plugin/data sync issues - Performance ______ We will only consider serious candidates. Please include: - Your approach - How would you handle SEO-safe migrations? - How do you ensure rankings are preserved? - Experience - Examples of similar projects are a big plus (WordPress + WooCommerce + migrations) - Experience with custom plugins / API / CRM integrations ______ Technical approach - How you handle staging → live deployment - How you test data integrity and SEO Risk management - What are the biggest risks in this project? - How do you prevent them? ______ Important Notes - Budget is fixed. - This is not a quick build: quality and stability matter more than speed! - Communication must be clear and structured - We are looking for a long-term collaboration partner. Also for maintenance in future

opportunity

Illustrator and animator for TikTok content

We are looking for a freelance content creator to help us turn a bank of fun content ideas into engaging TikTok content. This is not just an illustration brief. We need someone who can take rough ideas and direction from our team, develop them into simple but effective cartoon-led content, create the assets, and help us manage the process through to post-ready delivery. Depending on the setup, this may also include uploading and posting content to TikTok with guidance from our side. The concept may sit under a standalone TikTok identity rather than an obvious agency brand, so we are looking for someone who understands how to create content that feels natural to the platform rather than overly polished or corporate. What the role involves You would be expected to: take rough ideas, prompts or loose scripts from us and shape them into short-form content concepts create cartoon-style visual assets, including static cartoon cells, character scenes and simple illustrated formats ideally animate those assets into short videos or light-motion content suitable for TikTok add captions, pacing and simple editing so the content feels native to the platform work with light creative and editorial guidance from our team help organise the content creation process from idea through to finished assets potentially support with scheduling or posting content to TikTok once agreed What we are looking for We are looking for one person who is: creatively strong and visually sharp tuned into TikTok and understands what performs on the platform able to work independently and take ownership of the process comfortable with humour, character-led content and repeatable content formats fast, practical and not prone to overcomplicating things affordable and open to ongoing freelance work ideally based in or near Surrey, UK, as there may be value in occasional in-person collaboration fluent in English, with strong written and spoken communication Nice to have experience creating content for TikTok or Instagram Reels character design skills simple 2D animation or motion graphics ability experience writing captions or shaping content for social confidence suggesting improvements to ideas rather than only executing briefs experience posting directly to TikTok Please include in your application examples of relevant cartoon, illustrated or animated content links to any TikTok or short-form social content you have created or managed your rates, whether per piece, per batch or per day a short note on how you would turn rough ideas into a repeatable TikTok content series your location and whether you are available for occasional in-person collaboration in Surrey. Additional notes We are not looking for a large studio or expensive production setup. We are looking for one reliable freelance creator who can think creatively, move quickly and help run the process end to end. There is potential for ongoing work for the right person.

Short Form Editor

Hey. We are Bogar Tech Designs — a fast-growing automotive accessories brand that sells pre-cut, vehicle-specific film kits directly to car enthusiasts. Chrome deletes. Headlight and taillight tints. Paint protection film. Window tint. Every product is precision-cut in-house for a specific make, model, and trim. We do the hard part before the order ever ships so our customers can focus on the fun part — the transformation. We are a small, passionate team that genuinely cares about the product, the content, and each other. We move fast, we communicate openly, and we celebrate wins together. If that sounds like a place you want to work, keep reading. THE OPPORTUNITY: We are building a short form content machine and we need an editor who wants to grow with it. This starts freelance. If it clicks — and we think it will with the right person — it becomes full time. We are looking for someone who wants to be part of what we are building. WHAT WE MAKE Our content lives on TikTok, Instagram Reels, and YouTube Shorts. We run multiple content types simultaneously and each one has its own personality. You will not be editing the same style of video on repeat. Here is what the mix looks like: • Founder videos — Juan (Owner) on camera. Scripted, direct-to-consumer, conversion-focused. Confident and conversational, not corporate. • UGC installs — real installs shot on iPhone. Natural, raw, satisfying to watch. The kind of content that makes someone think, "I could do that." • Challenge and entertainment-style content — think high-energy car builds. Fun, built to be rewatched and shared. • Transformation montages — this is where you get to flex. Full blackout builds shot cinematically. Before and after reveals. Split screens. Component callouts. These videos need to make a viewer stop mid-scroll and think, "I need my car to look like that right now." Tracked, sound-synced edits that feel like a flex every time they play. • Customer UGC — real customers filming their own installs. Light polish, add a lower third, format for platform. Quick turnaround. Brands we look to for inspiration: Carpe, Dr. Squatch, Dollar Shave Club, Overnight Oats. Study them if you have not already. We are building something in that lane for the automotive world. THE ROLE You will work directly with our Creative Director. You will receive raw footage, a direction brief, and any scripts or on-screen text. You return publish-ready files. The relationship is collaborative — you are not just executing, you are contributing. If you see a better way to open a video, say so. If a brief is missing something, flag it. We want your editing voice in this content, not just your hands on the timeline. THE VOLUME The target is 100 to 150 videos per week at full capacity — roughly 30 per day, structured however works best across the week. We know that is a big number. It is also very achievable with the right batching system and clear briefs, which we provide. We are building the infrastructure to make your job as smooth as possible. THE ONE THING WE WILL NEVER STOP TALKING ABOUT Hooks. The first two seconds of every video is everything. It is the reason someone keeps watching or keeps scrolling. We need an editor who treats the opening frame with the same obsession a cinematographer treats lighting. It has to be intentional. It has to stop the scroll. For transformation content especially, a great hook is visual before it is anything else. Show the problem first and the viewer is already invested before the install starts. If you are the kind of editor who gets the first cut perfect before moving on to anything else, you will fit right in here. WHAT YOU BRING The Essentials: • Premiere Pro or DaVinci Resolve — fast and comfortable • After Effects required — motion graphics, split screen compositing, rotoscoping, masking, color isolation, camera tracking (2D and 3D) • Strong instinct for short form pacing • Music selection and audio sync • Clean on-screen text and title work • Organized file management • Deep understanding of hooks • Ability to work across multiple content styles What will make you stand out: • Experience with automotive, lifestyle, or product content • You study strong DTC brands and understand why their content works • You contribute creatively, not just technically • Experience editing at volume • Cinematic transformation edits • Ability to adapt editing voice across formats

opportunity

Tidy the server from X-ransom attack

Hello, Our Wordpress website was attacked by x-ransom. We have a backup of the WP and the database dump. We have detected some corrupted files there but it seems that there are still some left that were not detected. It has to be tidy after the attack. It’s an internet shop with uploads files of around 100GB. It’s stored on a private hosting in LV. What is done do far: 1. Update WordPress Version 2. Use z’d updateSecure WP-Admin Login Credentials 3. Set Up Safelist and Blocklist for the Admin Page 4. Use Trusted WordPress Themes 5. Install SSL Certificate 6. Remove Unused WordPress Plugins and Themes 1. Enable Two-Factor Authentication for WP-Admin 2. Back Up WordPress 3. Limit Login Attempts 4. Change the WordPress Login Page URL 5. Log Idle Users Out Automatically 6. Monitor User Activity 7. Check for Malware - found several none-Wordpress specious files and plugins. Deleted them. 1. Disable PHP Error Reporting 3. Turn File Editing Off 4. Restrict Access Using the .htaccess File 5. Change the Default WordPress Database Prefix - not done 6. Disable XML-RPC 7. Hide the WordPress Version 8. Block Hotlinking - not done 9. Manage File Permissions not done After making the list, we received another x-ransome attack. I suspect he has a server level access not only wp level. If you apply, you need to be a server security and a Wordpress specialist. Please, quote for the job.

Increase organic reach to my website https://maidenventures.co/

Hi, We are looking for help with three specific tasks increase traffic to www.maidenventures.co design update a general website optimisation to increase the speed When anyone in Sydney type the following words I would like the website to come up Technology in construction Energy saving Solar loans Building energy audits Electricity savings Gas Savings Utility bills