1 Projects

Brand & Brochure Designer Needed for Child Development Brand

I am looking for an experienced designer to create a refined, cohesive visual identity and client-facing brochure materials for my new Child Development & Family Consultant practice. My consultancy focuses on child development, sleep, routines, nutrition and family wellbeing. I already have the core content, package structure, pricing and a draft logo direction. I now need a strong designer to turn this into a polished, premium and fully editable Canva brand package. Canva only so I can edit it later myself. Happy if you have other options too. Scope of work I am looking for someone who can help with both brochure design and supporting brand collateral, including: 1) Refine my existing logo direction * Refine and elevate my current seedling logo concept * Ensure it feels premium, calm, warm and professional * Prepare it in a way that works consistently across PDFs and future brand materials e.g. letterheadsetc. 2) Design the first two client-facing PDFs in Canva I need two polished, fully editable Canva PDFs: PDF 1 – Introductory brochure / overview This will introduce my work and provide an intuitive overview of what I offer, including: * introduction to my consultancy * my approach / philosophy * overview of ways to work together * contact details PDF 2 – Detailed services guide This will provide more detailed information on my services and packages, including: * package breakdowns * pricing * what is included * deliverables / support structure I already have the content drafted. I need a designer who can structure, lay out and present it beautifully, rather than someone who needs to invent the business model from scratch. 3) Create branded stationery / supporting document templates I would also like branded Canva templates for client-facing follow-up materials, for example: * recommendation / summary PDFs * follow-up documents * ongoing support / review documents * branded simple email / PDF style assets where relevant The goal is to create a consistent visual identity across my brochures and the materials I send to families afterwards. Style / design direction I am looking for a design style that feels: * calm * refined * premium * warm * family-oriented * editorial rather than corporate * not childish, cartoonish or overly “cute” * not generic wellness-coach branding The visual direction should feel thoughtful, soft and high-end, while still being approachable and family-focused. I am drawn to: * soft neutrals / warm ivory / beige / muted sage / earthy tones * elegant typography * clean spacing and hierarchy * a boutique consulting feel rather than a loud commercial brand Important notes * I already have the content, structure and package information. This is primarily a design / layout / brand refinement project, although light copy polishing where needed is welcome. * I want the final materials to feel cohesive, not like text dropped into a generic Canva template. * I need the final files to be fully editable in Canva, so I can update wording, prices or follow-up materials myself later. Again open to a different program. Deliverables Please include in your proposal whether you can provide: * refined logo files * 2 fully designed Canva PDFs * branded Canva templates for follow-up / stationery materials * all files in fully editable Canva format Please apply if you have experience with: * brochure / editorial PDF design * Canva presentations / brochures / service guides * boutique brand identity design * premium service-based businesses * clean, elegant, understated visual branding If possible, please send examples of: * brochures / service guides / brand decks you have designed * Canva-based projects * premium or editorial-style client-facing PDFs

opportunity

Proven Creator Affiliate Growth Manager

We are looking for an experienced Affiliate Growth Manager to launch a measurable creator-affiliate programme for Givrr, a live direct fan-messaging app for 18+ adult-friendly creators. This is NOT a basic lead-generation, social-media-management or mass-messaging role. We need someone who has previously recruited and activated affiliates, creators or performance-based partners and can show measurable results. GOAL Build a repeatable programme that generates: * Active affiliates * Qualified creator referrals * Attributed registrations * Paying subscriptions * Renewals and measurable revenue Givrr is already live. We are now completing unique referral links/codes, install-to-registration attribution, subscription/renewal/refund reporting, affiliate reports and creator research. No outreach may begin until Givrr approves the tracking, offer, target list and messages. RESPONSIBILITIES * Create an affiliate recruitment and activation strategy * Identify qualified affiliate partners * Recommend channels and priority markets * Prepare personalised outreach and follow-ups * Design affiliate onboarding and activation * Track results from contact to revenue * Report objections and programme improvements Suitable partners may include creator educators, legitimate managers/agencies, webcam-industry professionals, community operators, adult-industry marketers, relevant micro-influencers and proven affiliate marketers. Priority markets include Latin America, Spain, Portugal, Romania, Eastern Europe, UK and USA. You do not need to cover every market. FIRST PAID TEST Quote a fixed price for: * Short affiliate launch strategy * 25 manually researched affiliate prospects * Public evidence and contact route * Market, language and partner category * Individual fit reasoning and risk notes * Priority score * One first-contact message and two follow-ups * Affiliate onboarding/activation flow * Measurable 14-day pilot plan * Funnel-tracking spreadsheet structure This milestone is research and preparation only. Do not contact anyone without written approval. EVIDENCE REQUIRED Provide anonymised but verifiable evidence from at least one programme: * Programme type/industry * Your exact role * Partners recruited and activated * Registrations and paying users/sales generated * Revenue where available * Time period * Supporting screenshots, reports or dashboard extracts Confidential names may be removed, but the results must remain understandable. Applications without specific evidence will not be shortlisted. RULES * Only clearly verified 18+ creators * No minors or questionable accounts * No spam or automated mass outreach * No fake identities, testimonials, reviews or engagement * No purchased lists or private data * No pretending to be an independent user * No unauthorised community posting * No outreach before written approval * Respect all platform/community rules * Use public, lawful business information only * Track every approved action All research, messages, tracking sheets and programme assets created for the project will belong to Givrr. WHEN APPLYING, ANSWER: 1. Which affiliate/creator programme have you helped grow? 2. What was your exact role? 3. How many partners did you recruit and activate? 4. How many registrations, paying users or sales resulted? 5. What evidence can you provide? 6. Which markets and languages do you know? 7. How would you find and activate Givrr affiliates? 8. Which KPIs would you use in the first 14 days? 9. Do you accept that outreach requires written approval? 10. What is your fixed test price and delivery time? Start your proposal with “EVIDENCE INCLUDED” and state your strongest measurable result in the first three lines. Generic proposals will be rejected.

opportunity

Amazon DE Marketplace Manager - Launch & Grow a Pet Health Brand

PROJECT OVERVIEW _______________________________________________________ We are a fast-growing European pet health company looking for an experienced Amazon Marketplace Manager to help us successfully launch and grow our brand on Amazon Germany. This is not a one-off listing project. We are looking for a long-term partner who can initially build everything correctly and then help us grow sales month after month. Our products are premium pet health products under our own-brand. Our eCommerce platform is WooCommerce and we already have professional product photos, product descriptions and branding assets. WHAT WE NEED _______________________________________________________ Initially, we need someone to set up and optimize our Amazon Germany presence. Responsibilities include: Phase 1 – Amazon Launch - Create and optimize Amazon Seller Central account - Guide us through Brand Registry - Product listing creation and optimization - Amazon SEO (titles, bullet points, backend keywords) - A+ Content creation - Amazon Brand Store setup - Category recommendations - Pricing recommendations - FBA preparation guidance - Inventory setup - Shipping settings (if required) - Review of compliance requirements for Germany Advice regarding VAT, EPR and LUCID (we can work with external tax/compliance providers if needed) Phase 2 – Growth Once we are live, we would like ongoing support with: - PPC campaign management - Keyword research - Ranking improvements - Listing optimization - Competitor monitoring - Promotions - Coupons / Deals - Reporting - Sales growth strategy WHAT WE ALREADY HAVE ___________________________________ WooCommerce store High-quality product images Product descriptions & Brand assets Stock available Internal marketing team WHAT WE ARE LOOKING FOR ___________________________________ We are looking for someone who: - Has proven experience managing Amazon DE accounts - Has launched brands from scratch - Has experience with health, wellness, beauty, supplements or pet products - Understands Amazon SEO - Has strong PPC experience - Can provide examples of successful Amazon launches - Speaks fluent English Bonus points if you have experience with: - Amazon Vine - Amazon DSP - Amazon Brand Analytics - Premium A+ Content - Expanding to other EU marketplaces (France, Italy, Spain, Netherlands, Poland) ENGAGEMENT _________________________________ We are looking for a long-term freelance collaboration. After launch, we expect ongoing monthly collaboration (approximately 10-15 hours per month). PLEASE INCLUDE IN YOUR PROPOSAL _________________________________ - Links to Amazon brands you currently manage - Your experience with Amazon Germany - Similar projects you've completed - Your PPC management approach - Your hourly rate - Your estimated hours for the initial setup - Your availability - Any certifications or Amazon Partner credentials IMPORTANT _________________________________ We are not looking for an agency. We prefer working directly with an experienced Amazon Marketplace Manager who will become an extension of our team and help us build internal knowledge over time. Long-term collaboration is much more important to us than simply completing the initial setup. BUDGET _________________________________ Our budget is split in setup phase and grow phase. Pls include your offer for both phases.

opportunity

I Need Social Media Manager & Short-Form Video Editor (6 weeks)

I’m looking for a fast, creative and highly organised social media manager and short-form video editor to support an upcoming 30-day online challenge. This will initially be a **six-week role**, covering the campaign preparation, launch and delivery of the challenge. There is strong potential for the position to continue on an ongoing basis after the initial campaign if we work well together. I already have a large library of existing videos, Instagram Lives, teaching content and testimonials. I will also be filming new content throughout the challenge. Your role will be to turn this content into engaging, ready-to-post short-form videos for Instagram and Facebook. ### What You’ll Be Doing * Reviewing and organising my existing video library * Identifying the strongest hooks, moments and teaching points * Cutting long videos and Lives into short-form Reels * Creating multiple edits from existing content for trial Reels and content testing * Adding captions, on-screen text and simple, polished edits * Writing or refining captions for each post * Preparing, scheduling and publishing content across one or two social media accounts * Repurposing previous videos, testimonials and campaign content * Editing new videos filmed throughout the 30-day challenge * Creating content quickly from live sessions and newly recorded material * Keeping the content calendar and files organised so that posts are ready in advance * Monitoring which trial Reels and content angles are performing well This is not primarily a brand strategy role. The offer, messaging, visual direction and overall campaign strategy are already being developed. I need someone who can take the content, recognise what will make a strong Reel, edit it quickly, package it properly and get it ready to publish. ### You Should Be * Experienced in Instagram Reels and short-form video editing * Comfortable cutting longer videos into several strong pieces of content * Able to identify compelling hooks without needing detailed instructions for every clip * Familiar with trial Reels and testing different versions of content * Strong at writing natural, engaging social media captions * Fast, reliable and highly organised * Able to match an existing voice and visual style * Comfortable working with wellness, transformation, fasting, spirituality or personal-development content * Available consistently for the full six-week campaign period * Able to work quickly while the 30-day challenge is running Experience with CapCut, OpusClip, Canva, Instagram and Meta Business Suite would be helpful. ### Initial Six-Week Project The six-week role will include: * Repurposing and cutting existing videos * Preparing a bank of trial Reels and ready-to-post campaign content * Supporting the launch of the 30-day challenge * Managing content throughout the live challenge * Editing and posting new content as it is filmed * Writing captions and organising the publishing schedule * Potentially managing one or two related social media accounts The role may continue beyond the initial six weeks as an ongoing social media management and content-editing position. ### To Apply Please send: 1. Examples of Reels or short-form videos you have edited 2. Examples of social media accounts or campaigns you have managed 3. The editing and scheduling tools you use 4. Your usual turnaround time for a Reel 5. How many Reels you can realistically produce each week 6. Your availability for the next six weeks 7. Whether you are also available for ongoing work after the campaign 8. Your proposed price for: * the full six-week project, or * a weekly package Please begin your application with the word **AIR*so I know you have read the complete brief. I’m looking for someone who can begin immediately.

opportunity

Full-Stack Developer for AI SEO & GEO Workflow Platform

We are looking for an experienced full-stack developer to help complete Tessy, an internal AI-powered platform for managing SEO and GEO client delivery. The frontend has already been built in Lovable and is being moved into Replit. We now need a developer to review the existing code, complete the application architecture and build the backend, database, integrations and production workflows. Core Phase 1 Features * Secure login and role-based access for admins, account managers, delivery staff and clients * Client onboarding and account setup * Separate but connected SEO and GEO workflows * AI-generated strategy drafts based on client data and templates * Automated “Critic” review before human approval * Inline editing and approval by account managers * Automatic generation of a rolling three-month task plan * Task assignment, statuses and review workflows * Client approval and delivery through Tessy * PDF or portal-based deliverables * Logging of publication dates and live URLs * Recording account manager edits as before-and-after data * Capturing performance results two and four weeks after publication Tessy should manage the delivery workflow from onboarding through to release and performance tracking. The detailed PRD and Lovable prototype will be provided. Developer Responsibilities * Review the Lovable and Replit codebase * Recommend a suitable production architecture * Build the backend and database * Connect the existing frontend to live data * Integrate AI APIs and structured outputs * Implement authentication and user permissions * Build the workflow, task and approval logic * Add file storage and PDF generation * Test, deploy and document the application We are open to recommendations on the final stack. Relevant experience may include React, TypeScript, Supabase, PostgreSQL, Node.js, OpenAI or Anthropic APIs, Lovable and Replit. When Applying Please include: * Examples of similar applications you have built * Your experience taking AI-generated prototypes into production * Your experience with Lovable and Replit * Your recommended technical approach * Your availability * An estimated timeline and budget * Any major risks or questions you would raise before starting Please begin your proposal with “Tessy” so we know you have read the brief. We prefer milestone-based delivery with regular demonstrations and access to the working code. NB: We have a PRD if requested and can provide access to loveable FE.

Developer to test & harden a local-first automation CLI (paid)

We're looking for a developer (ideally a few) to help test and improve RailCall, a local-first, developer-grade automation tool. This is real paid work, broken into small fixed-price tasks. Start with one; if it's a good fit, there's a steady stream of more. About the tool (so you can scope your proposal accurately): RailCall runs on your own machine. You describe an automation in plain English and it builds a real, governed workflow that runs locally - not in a vendor cloud. Nothing executes until you approve it (dry-run by default), and every run is sealed with a signed receipt you can verify offline. Keys, data and logs stay on your machine. There's a free tier (500 flows/month, no card) so you can install and start straight away. - Site: https://railcall.ai - Docs: https://railcall.ai/docs.html - Install (macOS/Linux): curl -fsSL https://railcall.ai/install.sh | bash - then run: railcall studio The tasks we're paying for (fixed price, per accepted deliverable): 1. A reproducible bug report or actionable feedback - approx £8 each. Accepted when we can reproduce the issue from your write-up (clear steps, expected vs actual, environment) or directly act on the feedback. 2. A shipped fix, or a genuinely useful workflow you've built - approx £20 each. Accepted when the fix is verified working, or the workflow runs and you supply its signed receipt (via "railcall verify"). 3. A standout build, a written how-to guide, or a short demo video - approx £40 each. Accepted when it's clear, accurate, and something we'd be happy to share with other developers. Every milestone is agreed, awarded and paid through PeoplePerHour. These are paid tasks - not spec work, not a free contest. What we're after: - Comfortable on the command line, with git, and installing a CLI on macOS or Linux - Can write a clear, reproducible report (steps, expected vs actual, environment) - Bonus: experience with MCP, agent tooling, or workflow automation How to propose: Send a proposal here on PeoplePerHour. Tell us which task you'd like to start with, a rough delivery timeline, and anything relevant you've built before. We agree the milestone, award it, and release payment on delivery through PPH. Reliable contributors will be first in line for more of the same work - this is ongoing, and the longer-term arrangement is still taking shape, so no promises beyond the paid tasks named above.

opportunity

Set Up "Book In Beautiful" System & Website for Beauty Salon

Freelancer Needed to Set Up "Book In Beautiful" System & Website for Beauty Salon Job Description: Hi there! I am a busy salon owner looking for a tech-savvy freelancer or virtual assistant to completely set up and configure my Book In Beautiful account from scratch. I want to focus entirely on my clients and hand the technical heavy lifting over to an expert who can get this done efficiently and correctly. Key Responsibilities: Payment & Account Setup: Connect the payment processor (Stripe) to enable secure, automatic monthly recurring billing, configure salon hours, and sync calendars. Service Menu Configuration: Input our treatment menu with strict attention to service durations (30-minute and 45-minute/1-hour blocks). Membership Architecture: Build a 3-tier monthly recurring membership program within the system based on specific pricing and credit rules I will provide. Website Design: Customize the built-in Book In Beautiful website template using our branding, logos, and photos, ensuring a dedicated, high-converting section for our new Membership Club. Data Migration & Testing: Cleanly import our existing client database and run a live test transaction to ensure the membership automation works flawlessly before launch. Requirements: Proven experience setting up salon booking software (Book In Beautiful experience is a massive plus, but strong experience with Fresha, Timely, Phorest, or Mindbody is acceptable). Basic web design/customization skills to make the template look beautiful and premium. Excellent attention to detail, especially regarding pricing logic and automated billing settings. Please reply with your typical turnaround time, and any examples of booking systems or websites you have set up in the past. Look forward to working with you!

Full-Stack Developer for Business Operations

Summary Project Overview We are a manufacturing company with our own delivery fleet, supplying our products to customers across the island. We are looking for an experienced developer (or small team) who can analyze our existing workflow and build a modern solution to automate and simplify our operations. Our Current Workflow 1. Customers place their orders via WhatsApp, usually one day before delivery. 2. A staff member manually copies every order from WhatsApp onto paper. 3. Orders are grouped by delivery region. 4. The processing department receives the handwritten orders and prepares the products for each region. 5. Once processing is completed, invoices are manually created. 6. All invoices are written and handed to the drivers before deliveries. 7. At the end of the day, drivers return with payments collected from customers. 8. Payments (cash, cheque, or bank transfer) are then manually reconciled. Product Pricing & Weight Calculation We deal primarily in fresh chicken products, and our pricing is based on net weight (kg). However, customers may place their orders either by pieces (pcs) or kilograms (kg), depending on their preference. Each customer may also have their own negotiated pricing, so the system must support customer-specific price lists. During processing, the products are packed into crates before dispatch. Each crate has a different tare weight (typically 1 kg, 1.9 kg, 2 kg, 3 kg, or 4 kg). For example, if a customer orders 50 pieces of chicken, the order may be packed into 6 or 7 crates with varying tare weights. The processing staff records the gross weight and the tare weight of the crates, and the system must automatically calculate the net product weight (Gross Weight − Total Tare Weight). The customer is then invoiced based on the net weight, using their agreed price per kilogram. Order Complexity We currently manufacture and sell approximately 50 different chicken products. The system must support customers ordering any combination of these products in a single order. As our business grows, the solution should efficiently handle large multi-line orders while ensuring accurate order processing, production planning, invoicing, and delivery. The application should remain fast, reliable, and easy to use even when processing complex orders with many different product lines. Delivery Adjustments & Exceptions As we deal with fresh chicken products, the invoiced quantities may occasionally need to be adjusted during delivery. Some customers choose to verify the weight of the products upon receipt. If the measured weight is lower than the invoiced net weight, the driver contacts the office and the invoice must be adjusted so that the customer is charged only for the weight actually received. If the delivered weight is higher than the invoiced weight, no adjustment is required. In addition, there are occasions where a driver may inadvertently leave one or more items at the factory. In such cases, the driver contacts the office from the customer's location, and the missing items must be removed from the invoice so that the customer is billed only for the products that were successfully delivered. The system should make these delivery-time adjustments simple, fully traceable, and synchronized with the final invoice and payment records. Our workflow involves many real-world operational exceptions that cannot always be anticipated. We are looking for a developer who can design a flexible system capable of handling these scenarios without requiring manual workarounds or software changes each time a new business rule arises. While this process works, it requires a significant amount of manual work, duplicate data entry, printed paperwork, and repetitive administrative tasks. What We Are Looking For We are looking for someone who can study our workflow, understand our business processes, and propose a modern, scalable solution. We are open to suggestions if there are better ways to improve our operations.

Google Ads Assistant – 3 Hours Per Day, Monday to Friday

Hi everyone, We are looking for a reliable, proactive and hands-on Google Ads Assistant to support the daily management and optimisation of multiple lead-generation accounts. This is an ongoing, part-time role requiring approximately three hours per day, Monday to Friday. We will agree on a consistent daily working window together. During the first one to two months, these hours should overlap with our team to allow regular communication, training and priority reviews. Our key priorities are: * Excellent communication * Proactivity and a hands-on approach * Security and confidentiality * Reliable availability * Attention to detail * Willingness to learn and follow established processes About the role You will work under the guidance of an experienced Google Ads Manager, supporting campaigns for local service businesses. All accounts focus on generating enquiries through website forms, and the main systems are already in place. Your responsibilities will include: * Monitoring spend, leads and cost per lead. * Identifying accounts requiring urgent attention. * Reviewing search terms and adding relevant negative keywords. * Identifying expensive or underperforming keywords, adverts and assets. * Adding relevant search terms as keywords using suitable match types. * Creating and improving Responsive Search Ads. * Updating sitelinks, callouts and structured snippets. * Reviewing and replacing underperforming image assets. * Checking location targeting and out-of-area postcodes. * Reviewing device, demographic and audience performance. * Checking budgets, conversion goals and campaign settings. * Updating adverts when offers or landing pages change. * Investigating discrepancies between Google Ads and CRM leads. * Documenting completed optimisations. * Providing a clear daily summary of completed work and any issues requiring attention. Strategic changes - including major budget adjustments, bidding strategy changes, conversion tracking changes and campaign launches - must be approved by the Google Ads Manager. Experience and skills: * At least one year of hands-on Google Ads experience is required. * Two or more years would be preferred. * Experience with Search and Performance Max campaigns. * Lead-generation experience is preferred but not essential. * Confidence working across multiple accounts and priorities. * Good written and spoken English. * Clear, responsive and professional communication. * Strong attention to detail. * Confidence to ask questions when instructions or approvals are unclear. * Availability for three agreed hours each weekday. Communication and availability: Communication is a major part of this position. We do not expect all-day availability, but we require a reliable three-hour daily window. During the first one - two months, this window should overlap with our working hours so we can review priorities, discuss high CPLs, clarify requests, provide feedback and establish consistent processes. Security and confidentiality: You will receive a company email address, which must be used for all company communication, platform access and account management. You will be expected to: * Keep all login details, client information and campaign data confidential. * Use secure passwords and two-factor authentication. * Never share account access or credentials. * Never transfer client data to unauthorised accounts or devices. * Report suspected security issues immediately. * Remove or return access when requested. You must complete the work personally. Subcontracting or sharing work is not permitted without prior written approval. Trial period: The engagement will begin with a paid two-week trial. We will assess: * Communication and responsiveness * Google Ads knowledge * Accuracy and attention to detail * Ability to follow instructions * Quality of documented work * Proactivity and time management * Compliance with security requirements How to apply: Please include: 1. A short introduction and details of your Google Ads experience. 2. Examples of Search, Performance Max or lead-generation accounts you have supported. 3. The typical monthly advertising spend you have worked with. 4. Your location and time zone. 5. The three-hour daily window you can consistently offer. 6. Your hourly rate. 7. How you would approach a Search campaign with a rising CPL, including how you would determine whether seasonality or a campaign issue caused the increase. 8. An example of an irrelevant search term you excluded, why you excluded it and the negative match type used. 9. Confirmation that you can document optimisations and communicate daily during the initial period. 10. Confirmation that you will use a company email address and follow strict security requirements. Please begin your application with “Google Ads Lead Gen” so we know you have read the full description. We are looking for someone interested in a dependable, long-term collaboration and developing alongside our team.

Build webscraper to collect data from outlet menus

I have a list of appr. 50.000 outlets, of which I want to have the menu information scraped cleansed and organised (see FACT DIM below). Assignment is to receive a working and tested code for doing that, perphaps for a smal sample of 100 outlets or so to see that it's working. Lump sum proposal please, needs to be ready asap. Best regards, Sander -------------- CREATE TABLE public.outlet ( outlet_id bigint GENERATED ALWAYS AS IDENTITY NOT NULL, naam text NOT NULL, plaats text, website_url text, segment text, status text NOT NULL DEFAULT 'actief'::text CHECK (status = ANY (ARRAY['actief'::text, 'inactief'::text])), created_at timestamp with time zone NOT NULL DEFAULT now(), updated_at timestamp with time zone NOT NULL DEFAULT now(), CONSTRAINT outlet_pkey PRIMARY KEY (outlet_id) ); CREATE TABLE public.menu_source ( source_id bigint GENERATED ALWAYS AS IDENTITY NOT NULL, outlet_id bigint NOT NULL, pagina_type text, url text NOT NULL, domain text, bestandstype text CHECK (bestandstype = ANY (ARRAY['html'::text, 'pdf'::text, 'image'::text])), confidence real, is_active boolean NOT NULL DEFAULT true, created_at timestamp with time zone NOT NULL DEFAULT now(), CONSTRAINT menu_source_pkey PRIMARY KEY (source_id), CONSTRAINT menu_source_outlet_id_fkey FOREIGN KEY (outlet_id) REFERENCES public.outlet(outlet_id) ); CREATE TABLE public.crawl_run ( run_id bigint GENERATED ALWAYS AS IDENTITY NOT NULL, source_id bigint NOT NULL, crawled_at timestamp with time zone NOT NULL DEFAULT now(), http_status integer, etag text, last_modified text, sha256 text, parse_status text NOT NULL DEFAULT 'pending'::text CHECK (parse_status = ANY (ARRAY['pending'::text, 'ok'::text, 'partial'::text, 'failed'::text, 'not_modified'::text])), parser_version text, raw_ref text, CONSTRAINT crawl_run_pkey PRIMARY KEY (run_id), CONSTRAINT crawl_run_source_id_fkey FOREIGN KEY (source_id) REFERENCES public.menu_source(source_id) ); CREATE TABLE public.menu_item ( menuitem_id bigint GENERATED ALWAYS AS IDENTITY NOT NULL, run_id bigint NOT NULL, categorie text, product text NOT NULL, beschrijving text, prijs numeric, valuta text NOT NULL DEFAULT 'EUR'::text, volume text, merk text, merkeigenaar text, positie integer, confidence real, CONSTRAINT menu_item_pkey PRIMARY KEY (menuitem_id), CONSTRAINT menu_item_run_id_fkey FOREIGN KEY (run_id) REFERENCES public.crawl_run(run_id) ); CREATE TABLE public.change_event ( event_id bigint GENERATED ALWAYS AS IDENTITY NOT NULL, outlet_id bigint NOT NULL, source_id bigint, oud_menuitem_id bigint, nieuw_menuitem_id bigint, detectiedatum timestamp with time zone NOT NULL DEFAULT now(), event_type text NOT NULL CHECK (event_type = ANY (ARRAY['product_toegevoegd'::text, 'product_verwijderd'::text, 'prijs_verhoogd'::text, 'prijs_verlaagd'::text, 'brand_switch'::text, 'menu_redesign'::text])), oude_waarde text, nieuwe_waarde text, ai_interpretatie text, impact text CHECK (impact = ANY (ARRAY['hoog'::text, 'midden'::text, 'laag'::text])), opportunity_score integer CHECK (opportunity_score >= 0 AND opportunity_score <= 100), aanbevolen_actie text, bevestigd_runs integer NOT NULL DEFAULT 1, status text NOT NULL DEFAULT 'nieuw'::text CHECK (status = ANY (ARRAY['nieuw'::text, 'bekeken'::text, 'afgehandeld'::text, 'false_positive'::text])), CONSTRAINT change_event_pkey PRIMARY KEY (event_id), CONSTRAINT change_event_outlet_id_fkey FOREIGN KEY (outlet_id) REFERENCES public.outlet(outlet_id), CONSTRAINT change_event_source_id_fkey FOREIGN KEY (source_id) REFERENCES public.menu_source(source_id), CONSTRAINT change_event_oud_menuitem_id_fkey FOREIGN KEY (oud_menuitem_id) REFERENCES public.menu_item(menuitem_id), CONSTRAINT change_event_nieuw_menuitem_id_fkey FOREIGN KEY (nieuw_menuitem_id) REFERENCES public.menu_item(menuitem_id) );

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.