List Projects

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

Build SEO Landing Page for Accountancy Website (WordPress)

PROJECT DESCRIPTION We are an established UK accountancy practice expanding our brand My Office Accountant (myofficeaccountant.co.uk) into a national online service. We need an experienced WordPress developer/implementer to build out a structured library of SEO landing pages in three tiers: Tier 1 — Industry pages (25 pages). e.g. /accountants-for/contractors, /accountants-for/landlords, /accountants-for/ecommerce Tier 2 — Location pages (25 pages). e.g. /locations/manchester, /locations/birmingham, /locations/enfield Tier 3 — Intersection pages (approx. 15-25 pages). e.g. /accountants-for/contractors/manchester Important: we supply the content. Every page's copy, title tag, meta description, H1 and FAQ text will be provided by us in a structured content document, built from master templates we already have. Your job is implementation, not copywriting. Do not generate, spin or AI-write page content — any submission containing content we did not supply will be rejected at milestone review. Scope of work Reusable page template(s). Build one flexible landing-page template (or one per tier if cleaner) in the site's existing theme/page builder, matching our current branding — hero with dual CTA buttons, tick-list strip, content sections, FAQ accordion, CTA block, internal-links footer. Mobile-responsive, fast-loading (target 90+ mobile PageSpeed on template pages). Page build. Populate all ~30–33 pages from our content document into the templates, with correct URL slugs exactly as specified. Technical SEO per page: title tags, meta descriptions, single H1, correct heading hierarchy, FAQPage schema on FAQ blocks, breadcrumb schema on intersection pages, Service/Organization schema sitewide, canonical tags, all pages added to the XML sitemap. Internal linking exactly as mapped in our content document (industry ↔ location ↔ intersection three-way pattern), plus navigation/footer entries where specified. Site plumbing: ensure clean URL structure (no pattern mixing), 301 redirects if any existing pages are superseded, no orphan pages, submit updated sitemap in Google Search Console. Handover: a short screen-recorded walkthrough (10–15 min) showing how we add the next wave of pages ourselves using the template, plus documentation of any plugins/settings added. Milestones & payment M1 (25%): Template(s) approved on staging — one fully built sample page per tier, matching brand and passing mobile PageSpeed check. M2 (35%): All Tier 1 + Tier 2 pages built, schema validating (Google Rich Results Test), internal links in place. M3 (30%): Tier 3 pages built; full crawl check (Screaming Frog or similar) showing no broken links, duplicate titles or missing meta; sitemap submitted. M4 (10%): Handover video + documentation delivered. Requirements — please confirm each in your proposal Proven WordPress experience (or confirm ability on our platform after viewing the site) with landing-page/programmatic-SEO builds — include 2–3 live examples of multi-page SEO builds you've implemented Comfortable with schema markup and validating it Experience with Elementor / WPBakery / Gutenberg (state which — we'll confirm what the site uses) Basic Search Console familiarity (sitemap submission) UK English; UK working-hours overlap preferred but not essential You will be given limited-role site access (Editor/custom role) — not full admin — and staging access where available To apply, please answer these three questions (proposals that don't will be skipped) Link to one multi-page SEO/landing-page system you built: what was your role, and how many pages? How would you implement FAQPage schema on a repeatable template so non-developers can add pages later? What's your realistic timeline for M1 and M2, and your total fixed price? What we provide Full content document (all copy, metadata, slugs, FAQ text, link map) Brand assets (logo, colours, fonts) and access to the existing site One point of contact with fast turnaround on approvals (24–48h) What this is NOT Not a redesign of the whole site (template must fit existing branding) Not a copywriting job Not ongoing SEO/link-building (may be discussed separately after delivery)

Email Copywriter for Warm Leads — Paid Test + Performance Bonus

We are looking for a sharp, conversion-focused email copywriter to help us write and optimize email campaigns for a large list of warm inbound creator leads. We currently have a database of 6,000+ people who have already shown interest in working with us, asking questions, getting started, or learning how to grow their online presence. A small percentage are already established creators who may be a fit for higher-level partnership conversations. This is not a generic newsletter role. We need someone who understands persuasive email copy, follow-up sequences, objection handling, and how to turn warm leads into replies, calls, and qualified opportunities. What You’ll Be Doing -You will help create and improve email campaigns that: -Re-engage old warm leads -Turn curious leads into booked calls -Educate new creators on how we can help them grow -Follow up with people who showed interest but never took action -Segment messaging based on lead quality and intent -Improve reply rates, booked-call rates, and overall conversion -Initial Paid Test Project For the first project, we will provide background on the offer, lead types, and current messaging. Your task will be to create: -1 main reactivation email -1 short follow-up email -1 objection-handling follow-up -1 higher-intent email for more established creators Suggested subject lines for each email A short explanation of your strategy behind the sequence If the test goes well, this can turn into an ongoing role where you help write, test, and optimize multiple email sequences across the full lead database. Who We’re Looking For The ideal person has experience with: -Email copywriting -Direct-response copy -Creator economy, influencer, coaching, agency, SaaS, or online business offers -Warm lead reactivation campaigns -Appointment-setting email funnels -High-ticket or partnership-based offers -Writing emails that sound human, not robotic or overly corporate -Improving campaigns based on reply rate and booked-call data -You do not need to be a designer. This is primarily a copywriting and strategy role. Important: We Care About Results We are not looking for pretty writing only. We want someone who understands conversion. You should be able to think through: -Why someone would reply -Why someone would ignore the email -What objections they may have -What angle makes the offer feel relevant -How to make the message feel personal without sounding fake -How to create curiosity without overpromising Compensation Structure This role starts with a paid fixed-price test project. For ongoing work, compensation may include: -Base pay per email sequence or campaign -Performance bonuses for campaigns that generate qualified replies, booked calls, or successful partnerships -Long-term monthly work for someone who proves they can consistently improve results -Strong performers can earn significantly more over time as we scale campaigns. We are looking for someone who wants to build a long-term partnership, not just complete a one-time project. This role will start with a paid starter project and performance-based bonuses so we can make sure it is a strong fit on both sides. If the partnership goes well and you are consistently producing results, we are open to adding a more stable base compensation structure after 3–6 months of successful work, while still keeping performance bonuses in place. Our goal is to work with people who are hungry, reliable, and results-driven. If you perform well, communicate clearly, and help generate real opportunities, there is room to grow with us long term. Please include: -Examples of email campaigns, outreach copy, or direct-response copy you’ve written -Your experience with warm lead reactivation or appointment-setting campaigns -A short explanation of how you would approach a 6,000-person warm lead list Any results you’ve helped generate, such as reply rates, booked calls, sales calls, conversions, or revenue Please do not send a generic AI-written proposal. We are looking for someone who can think strategically, write clearly, and improve based on real campaign performance. Best Fit This is a great fit for someone who enjoys performance-based copywriting and wants a long-term opportunity with upside based on results.

opportunity

Linkedin Content Strategist & Daily Engagement Partner

I’m the Retail Director at a UK-based freight forwarding company. I want to build a strong, authentic personal brand on LinkedIn in the freight, logistics and supply chain space — with a particular focus on retail sector challenges and solutions. My goals: • Become a recognised voice and thought leader • Grow my follower base with the right people (retailers, supply chain/procurement professionals, logistics peers, decision-makers) • Increase meaningful engagement and inbound opportunities • Stay super active and visible in a smart, sustainable way I already create my own posts and graphics. I’m looking for a strategic partner who will guide the “what” and “when”, while also handling the heavy lifting on daily engagement. What you’ll be responsible for: 1. Content Strategy & Storyboarding Develop clear content pillars tailored to a Retail Director in freight forwarding. Create weekly/bi-weekly content calendars with post ideas, recommended formats (carousels, text, polls, short video, documents, etc.), strong hooks, and calls-to-action. Provide outlines or suggested copy (I will write the final versions and create all graphics). 2. Posting Schedule & Activations Recommend the best days/times for a UK B2B audience in 2026. Advise on LinkedIn algorithm best practices, what “activations” actually move the needle (polls, carousels, series, commenting strategies, etc.), and how to maximise reach and engagement. 3. Daily Niche Engagement (core part of the role) Thoughtfully comment on 20–50 relevant LinkedIn posts per day in the freight, logistics, supply chain, retail, and import/export space. Comments must be high-quality, value-adding and non-spammy (sharing insights, asking smart questions, adding perspective). This is manual work only. The goal is visibility, relationship-building and algorithm love. You’ll report on activity and results. 4. Follower Growth & Overall Strategy Give ongoing advice on profile optimisation, networking, content repurposing, and how to best use my current Botdog automation tool alongside organic activity. Help me market myself effectively and accelerate follower growth in a compliant way. 5. Reporting & Collaboration Weekly or fortnightly check-ins (Zoom or async) to review LinkedIn analytics, discuss what’s working, refine the strategy, and plan ahead. Track progress against clear KPIs (follower growth, engagement, profile views, quality of comments, etc.). What I will handle: • Writing and publishing all final posts + creating graphics • Day-to-day posting on my profile • Giving you any sector-specific insights you need Ideal freelancer: • Proven experience helping B2B executives or professionals grow their LinkedIn presence through content strategy + daily engagement (please share real results or case studies). • Strong understanding of current LinkedIn best practices (2026 algorithm, personal branding, what actually works for B2B service/industry profiles). • Excellent at crafting professional yet conversational B2B content ideas — especially in freight, logistics, supply chain or retail (prior experience in these sectors is a big plus). • Reliable and disciplined with daily engagement work. You enjoy being active on LinkedIn and know how to comment in a way that builds genuine connections. • Comfortable working with or advising on tools like Botdog. • UK/EU timezone preferred (or very flexible). • 100% committed to staying within LinkedIn’s Terms of Service (manual, high-quality commenting only — no automation for comments). How we’ll work: This is an ongoing role. I’d like to start with a 4-week trial, then move to a monthly retainer if it’s a good fit. Please include in your proposal: • Why you’re the right person for this (and any relevant niche experience) • Your approach to daily commenting (include 2–3 examples of strong vs weak comments in a B2B context) • 3–5 suggested content pillar/theme ideas specifically for a Retail Director in freight forwarding • A sample 1-week content idea list (5–7 post concepts) • Your proposed weekly time commitment and rate (hourly or monthly package) • Links to relevant work, portfolio, or your own LinkedIn profile so I can see your style and results Indicative budget: £800 – £1,100 per month (depending on experience, hours and results). Quality and reliability are more important than the lowest price. Realistic proposals welcome. I’m looking for a long-term partner who is proactive, strategic, and excited about helping me become consistently visible and valuable on LinkedIn. Looking forward to your proposals

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.