clean up database for product entries

₹1500-12500 INR

Closed

Posted

over 6 years ago

₹1500-12500 INR

Paid on delivery

We have a database that needs to be cleaned up and standardized. Here are the details: 1. We have a master list of around 20,000 product names. 2. We have another data set of around 8,500 product names. However these list of companies dont match with the master list. These need to be matched with the master list. In case they dont match suggestions need to be made to update the master list. Please note we have already used vlookup to match these records with the master list. We would need someone to do a vlookup and then look at each of the entries individually. Either you will have to edit the entry to align it with the product name or else suggest us to add it to the master list. Attention to detail is a must as every entry is important!

Project ID: 15223349

About the project

25 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

25 freelancers are bidding on average ₹7,856 INR for this job

@schoudhary1553

Hello Sir, I am the expert freelancer for this job . i have deliver more than 250 projects with 100% client satisfaction. so please give me chance to work on your job. Relevant Skills and Experience I have more than 5 years of experience in Clean Technology, Microsoft Access, MySQL, PHP, SQL Proposed Milestones ₹10000 INR - Final Milestone

₹10,000 INR in 3 days

4.9

(138 reviews)

7.3

@seemasit

Hi, Your job posting has caught my attention and I am keenly considering your job post. I have excellent experience in Mentioned skills. Looking Forward to hear you ..... Thanks Relevant Skills and Experience php Proposed Milestones ₹3500 INR - m1 ₹4277 INR - m1

₹7,777 INR in 3 days

4.6

(69 reviews)

7.2

@zu02

Hi, I'll try via Ms Access/vb/sql/ado etc Relevant Skills and Experience Access, Excel, vba, ado,sql Proposed Milestones ₹12345 INR - default

₹12,345 INR in 3 days

4.7

(65 reviews)

6.5

@vinaysinghh

A proposal has not yet been provided

₹3,333 INR in 1 day

4.8

(59 reviews)

5.4

@srikartiram

Hello, i can handle your project. If you have tried Vlookup, then we can try with batch wise (Matching phrases) using filter options. However its going to be a manual work end of the day ! Relevant Skills and Experience I've 4 people working in my office, we can manually process your items. Please describe your product types? Just to get an idea. Proposed Milestones ₹5500 INR - After project is completed successfully. You can pay Rs.1 per item matched with your master sheet. Just pay for the items that is matched alone. You can setup milestones too.

₹5,500 INR in 10 days

5.0

(41 reviews)

5.3

@bhupen2606

Hi, Attention to detail is the keyword here. Let's discuss what type suggestions you are looking for matching and non-matching entries. Relevant Skills and Experience Attention to detail Proposed Milestones ₹8000 INR - Match entries

₹8,000 INR in 3 days

5.0

(36 reviews)

4.6

@lokeshroyal27

Hi I am an open source expert with having 4+ years of experience I am pretty sure that I will do it within the stipulated time. I will provide you a sharp and excellent service of your requirement Relevant Skills and Experience PHP, MYSQL / Photoshop / CSS/HTML/eCommerce / Wordpress / opencart/ Magento /codeigniter/Prestashop/OSCommerce etc... Proposed Milestones ₹5000 INR - Final

₹5,000 INR in 3 days

4.8

(8 reviews)

3.7

@SayTechSolution

Hi there We have a team of 10+ well qualified people and providing cost effective and quality service to our clients. We assure to you that will deliver to you a quality work. Thank you Subhash Relevant Skills and Experience We are highly qualified for this project and would love to speak with you further about taking this project on. Proposed Milestones ₹12222 INR - project milestone

₹12,222 INR in 3 days

5.0

(3 reviews)

3.0

@akanksha13sep

A proposal has not yet been provided

₹11,111 INR in 10 days

5.0

(3 reviews)

2.4

@Naru2291

A proposal has not yet been provided

₹2,250 INR in 1 day

0.0

(0 reviews)

0.0

@Natheril

My most recent project involved data cleansing and ETL design and implementation. I am confident that I can do this project professionally and efficently. Relevant Skills and Experience SQL Server, TSQL, SSIS, Excel, C# Proposed Milestones ₹1000 INR - Getting a sense on the data structure and Data ₹5000 INR - Data cleansing ₹1777 INR - Master List Update Would you be confortable with approaching this project differently?

₹7,777 INR in 3 days

0.0

(0 reviews)

0.0

@moeedullah12

accurate results and client satisfaction is a priority. Relevant Skills and Experience Have done data base alteration work at university Local server sites and built a Clinical management system (back end + front end)for professional use Proposed Milestones ₹7777 INR - Sample will be submitted for client confirmation. Project completion in time is surety. Additional Services Offered ₹5777 INR - If some more help with data searching or alteration is required.

₹7,777 INR in 10 days

0.0

(0 reviews)

0.0

@sudiptachoudhury

Hi, I am interested in your project. Send me your both db. I can provide you a comparison list, as per your suggestion I will update. Relevant Skills and Experience I have 10+ years of experience in Access, vb, vb.net, asp.net, SQL Server development. Proposed Milestones ₹2000 INR - On submission of comparison list ₹3555 INR - On completion

₹5,555 INR in 10 days

0.0

(0 reviews)

2.4

@TacheAlex

A proposal has not yet been provided

₹13,888 INR in 5 days

0.0

(0 reviews)

0.0

@amritkar2014

This will be straightforward task which can be achieve through stored proc(Oracle /SQL) or macro(incase you are using excel). Can automate this task every month if you have new products in future. Relevant Skills and Experience Working on database design from 10+ years. Proposed Milestones ₹6000 INR - Undersatnd database structure and provide solutions Additional Services Offered ₹500 INR - Automation (monthly import of new products)

₹6,000 INR in 2 days