
Databases Projects
Looking for freelance Databases jobs and project work? PeoplePerHour has you covered.
opportunityurgent
Product Data Mapping Specialist Needed for 250,000 SKU EPOS File
Job Description: We are looking for a detail-oriented freelancer to support a structured data-mapping project for a large EPOS export containing approximately 250,000 products. Each product includes core fields such as SKU, description, brand, size, and other attributes. Your role is not to create new category structures, but to map each product accurately and consistently into a predefined hierarchy and tagging framework. This work is highly important as the mapped data will be used for reporting, analytics, and future automation, so accuracy, logic, and consistency are essential. Scope of Work Each product must be assigned to a fixed 3-level category hierarchy: Department (Level 1) Sub-Department (Level 2) Analysis Code (Level 3) Example: Department: ART Sub-Department: PAINT Analysis Code: WATERCOLOUR This means all watercolour paints would be mapped to: ART → PAINT → WATERCOLOUR We will provide: The approved list of Departments The approved Sub-Departments for each Department The approved Analysis Codes for each Sub-Department You must not create new categories, rename existing ones, or deviate from the supplied structure without approval. Existing Top-Level Departments Examples include: ART CRAFT STATIONERY JIGSAWS LEGO Additional departments will be included in the master file. Tagging Requirements In addition to category mapping, products must also be assigned tags in separate columns. Required tag groups include: Brand (for example: Winsor & Newton, Faber-Castell, LEGO) Size / Volume (for example: 12ml, A4, 500g, Pack of 10) Other clearly identifiable and consistently reusable attributes where appropriate Tags must be: Clean Standardised Reusable Free from unnecessary variations Mapping Rules Use the product name, description, brand, and available attributes to determine placement Similar products must always be mapped consistently If a product is unclear or ambiguous, flag it instead of guessing Do not make assumptions without a logical basis Output Required The final Excel output should include at minimum: Original SKU / Product ID Department Sub-Department Analysis Code Brand Tag Size Tag Notes / Flags (if applicable) Important Requirements No blank category fields unless clearly flagged No free-text category creation Strict adherence to the supplied structures Strong attention to detail and consistency throughout Validation Process Before full rollout, we would like the selected freelancer to complete a small sample batch for validation. We will review this first to ensure alignment before the full file is processed. Ideal Freelancer We are looking for someone with: Strong Excel skills Excellent attention to detail Experience with large product catalogues, categorisation, or data cleansing A logical and methodical approach to classification work If anything in the structure or logic is unclear, we would expect questions to be raised early. It is more important that this is done correctly than quickly. Please include relevant experience when applying, especially any examples of product mapping, taxonomy work, catalogue clean-up, or structured data classification.
2 days ago55 proposalsRemoteExpires in 28opportunity
1,000,000 UK business records scraped within 2 weeks 2
Hi there We need a database scraped of UK limited company names, their UK mobile number beginning 07, their email address, their website address, the Facebook business page URL and the link from where the details were obtained. The emails address needs to be generic such as info@businessname or hello@businessname We also need the category of industry from where each record relates to such as accountant, estate agent, clothes shop. We require 1,000,000 records within 2 weeks. If you are unable provide 1,000,000 in 2 weeks then please do not bid for the project. Please also do not bid on the project unless you have read the description and understand it completely. We have been contacted with numerous freelancers who state they can do it and then provide data which is nowhere near what we have asked for, so please, no time wasters. Thanks
8 days ago24 proposalsRemoteFreelance Data Entry Specialist
Project Overview: Seeking an experienced freelance specialist for a 6–8 week project to prepare Excel data and upload 700 plus product kit/variant codes into our ERP system. Responsibilities: • Structure and format Excel sheets for 700 plus codes, ensuring 100% accuracy. • Bulk upload codes to ERP and manually complete fields not supported by bulk upload (categories, warehouse, images, kit functions). • Assign photography to items without kit codes and configure Bill of Materials (BOM) with correct variant quantities. • Test and validate all codes, verifying descriptions, pricing, images, and kit functionality. Requirements: • Strong Excel skills (data structuring, validation, formatting). • Experience with stock databases or ERP systems (Orderwise preferred). • High attention to detail, accuracy, and ability to work independently. Deliverables: • Verified, upload-ready Excel sheets. • 700 plus completed and tested kit/variant codes with accurate pricing and imagery. Project Details: • Duration: 4–6 weeks • On-site project with attendance at our Balham Offices, SW12 9DJ, required every working day. • Monday to Friday 9am-6pm – one hour lunch break • £18 per hour
10 days ago22 proposalsRemoteI need to gain access to Zonal Aztec Zonal Admin
Hi there, We have installed a fresh install of Zonal that we only plan to use for devs but we dont know what the zonal admin passwords are and have tried resetting them but no luck
11 days ago6 proposalsRemoteI need someone help me access a zonal system
Hi there, We have installed a Zonal system on our local PC but unable to access the system as it creates a username but unable to change password we need someone to find a way to login to the AZTEC system Thanks
13 days ago9 proposalsRemoteopportunity
1,000,000 UK business records scraped within 2 weeks
Hi there We need a database scraped of UK limited company names, their UK mobile number beginning 07, their email address, their website address, the Facebook business page URL and the link from where the details were obtained. The emails address needs to be generic such as info@businessname or hello@businessname We also need the category of industry from where each record relates to such as accountant, estate agent, clothes shop. We require 1,000,000 records within 2 weeks. If you are unable provide 1,000,000 in 2 weeks then please do not bid for the project. Thanks
14 days ago35 proposalsRemoteIPhone Locked – Technical Diagnosis & Legitimate Guidance Needed
Job Description I purchased a used iPhone that is currently locked (likely Activation Lock or another type of device lock). I am looking for an experienced Apple device specialist who can: Analyze the situation based on screenshots and device details Identify exactly what type of lock is present Explain the legitimate options available Guide me step-by-step on how to properly contact official Apple support Advise whether it makes sense to pursue support, a dispute, or resell the device for parts I am not looking for illegal methods, hacks, or unauthorized bypass solutions. I only want professional and transparent technical guidance. I will provide: Exact iPhone model Screenshots of the lock screen Purchase details Budget: Open to proposals depending on expertise and clarity of assistance.
15 days ago6 proposalsRemoteopportunity
Microsoft 365 Administrator
I am looking for an experienced Microsoft 365 administrator to complete a one-off setup for a small organization (3–5 members of staff). This project is set up only—I am not looking for ongoing IT support or a managed service. The work can be completed remotely. We are based in Barking, London. What I need set up Microsoft 365 Business Standard for 3–5 users SharePoint configured as a shared drive (central document storage) Individual user accounts created Folder structure with permissions (restricted and shared access) Basic security enabled (strong passwords and two-factor authentication) Short handover showing how to add/remove users Skills & experience required Proven experience with Microsoft 365 and SharePoint Experience setting up shared drives for small teams Understanding of UK data protection/GDPR Ability to deliver as a fixed-price, one-off project Budget Please provide a fixed one-off price for the full setup. No ongoing support or contracts are required. When applying Please include: Brief details of similar Microsoft 365/SharePoint projects Confirmation this is a one-off setup Your fixed price and availability
a month ago34 proposalsRemoteopportunity
Database scraped of UK limited companies 2
Hi there We need a database scraped of UK limited company names, their UK mobile number beginning 07, their email address, their website address, the Facebook business page URL and the link from where the details were obtained. We require any amount up to 5,000,000 records. Thanks
a month ago50 proposalsRemoteurgent
Qlik Sense - Data checking and visualisations
We are looking for someone with Qlik expertise to work with my compnay probably for a period of 3 months on an hourly basis. We have a Qlik system in place but i need someone to check where some of the data is coming from in the clous data base and make sure the KPI's that are been reported are correct. We then want some to provide visualisations on a Dashboard
a month ago14 proposalsRemoteExpires in 3opportunity
API data reporting- Ecommerce marketplaces
Project Title Margin Reporting System – Multi-Source API Data Integration into On-Prem SQL Database Overview We want to build an automated margin reporting system that pulls commercial and operational data from multiple sources via API, standardises it, and stores it in a SQL database hosted on our on-site server. This database will then be used to report margins across products, customers, and orders. The goal is to replace manual reporting and create a reliable “single source of truth” for margin analysis. Objectives Pull data from multiple platforms via API on a schedule Store raw + cleaned data in a structured SQL database Calculate margin metrics consistently Produce reporting-ready tables/views for Power BI / Excel Data Sources (initial) - Shopware (orders, customers, products, pricing) - Exact Globe - Helm / Neuro by despatch company - Ebay / amazon and other marketplaces Key Outputs 1) SQL Database Schema Raw tables (staging layer) Cleaned tables (standardised layer) Reporting layer (margin-ready views/tables) 2) Automated Data Sync Scheduled API pulls (daily, or hourly depending on limits) Incremental updates (not full reload every time) Logging of sync success/failure 3) Margin Logic Margin calculation should support: Revenue (net of VAT) Discounts / vouchers COGS (purchase cost, supplier cost) Shipping income vs shipping cost Payment fees (optional) Returns / refunds / credit notes Deliverables Working data pipeline (API → SQL) Database schema + views Setup instructions for server deployment Documentation of API endpoints used Error handling + logs Handover session (1 hour)
a month ago55 proposalsRemoteBroken domain
We are experiencing significant issues with our email system, specifically concerning our domain email address, which has rendered Google Mail inoperable. As a result, we urgently require assistance to restore functionality to our office emails. We seek a skilled professional with expertise in email configuration and domain management to diagnose and resolve these issues promptly. Your prompt attention to this matter will be greatly appreciated, as we rely heavily on our email communications for daily operations. Please submit your proposals for consideration.
a month ago26 proposalsRemoteopportunity
Access Database wizzard required . must be UK based
we need an access database creating. we had one previously that was stored on a 3rd party provider (your office anywhere!!!) they didnt have proper security in place and they got hacked and the database corrupted. (your offrir we have the data on xcel and need someone to design (we know what design we want) so that we can move away from Xcel sheets and start working more productively. it is not complicated, but too complicated for us to put together!!
a month ago16 proposalsRemote
Past Projects
I need someone to fix my ASP formatted/Access DB run website.
I’m looking for someone who understands and can fix my old ASP format (local only) website which is run by an Access database, and make sure it will run on more than one PC (It is already on a My Passport Data Stick.)
opportunity
Apollo IO setup
Setup Apollo.io: create contact lists and implement a two- or three-step email sequence. Initial configuration for one email account, with ability to add users later. We will supply draft emails based on provided examples and an attached targeting framework. Deliverables: segmented contact lists, configured sequences, A/B testing suggestions, and setup documentation. Please propose a fixed price and timeline for completion.
Excel Spreadsheet
I have a spreadsheet with multiple worksheets. Each worksheet holds the data for an individual person. Some of the data is populated from text based drop down lists. I want to create an overview page which counts up each answer and returns a total for how many there are. For example, I want to find out how many times the same cell on each worksheet contains the drop down answer "Yes" returning 14 out of the 60.
opportunity
Recreation of an Access Database
I have a small database which manages our training courses. It is working but needs a few changes to keep pace with the changing business environment, However, our developer and maintainer has died and we have lost the password to the back end. The database manages Courses, Delegates, Memberships, examination bookings and provides a few simple reports. I need to recreate the database function with some minor changes. I have no preference about the final database system, except I prefer not to have to pay a regular subscription. I would like to import the data from the existing database as part of the project. I will then be looking for ongoing support and maintenance, which is not critical as part of this project. In addition, when we have a working system, I need some minor changes to be made to the current functionality. We are only a very small operation so our choice of who to proceed with must be based upon the costs of getting a functioning database that will replicate the current system. I would, also, accept proposals based upon breaking or removing the current database password. However, payment then to be on results, i.e. production of a copy of the unlocked back end data. I can provide copies of the front end so the database structure can be seen. I can also provide out-of-date copies of the back end data, following assurances of the protection of the confidentiality of the data.
Looking for a dynamic column for me in an excel spreadsheet
I have a buy to let property portfolio excel spreadsheet, i want to add some form of dynamic column that tells me what the early repayment charges are for each mortgage and when they kick in. i have multiple mortgages all starting and ending at different dates, and for different amounts. i want it to somehow automatically update, or even have a drop down, rather than having to create 5 new columns that state "year 1, year 2, year 3" etc. any help?! it's a small,, spreadsheet and only 15 rows of data and 5 columns
opportunity
QR database information collection database
I need to have a basic database we can host on our AWS server it will be so we can have a QR code in our events and exhbitions which can be scanned and in the phone or device they can complete, first name, surname, email, phone number, company, and any other notes box which will show in basic database we can view in a domain with logins which can be exproted to excel
Database needed
I am looking for someone to build a database asap for MATs in the UK, particularly Cambridgshire, Northants, Beds, Norfolk and Suffolk.