Annulé

Compare a list of product names and return most similar products

We have a list of 10.000 rows that is constanlty updating. So this must be done automatically in excel or php. It will take every row and compare it with all the others. then it will return the most similar results.

Those similar results will have some common text. This text must be returned in another column in order to match them.

For example:

Azzaro Chrome Eau De Toilette 100ml

Azzaro Chrome Eau De Toilette 100ml & 100ml Aftershave

Azzaro Chrome Eau De Toilette 100ml & 200ml Shower Gel

Azzaro Chrome Sport Eau De Toilette 100ml

Azzaro Chrome Sport Eau De Toilette 30ml

Azzaro Chrome Sport Shower Gel 50ml

Xpel Tea Tree 100% Pure Tea Tree Oil 10ml

Xpel Tea Tree 100% Pure Tea Tree Oil 30ml

Xpel Tea Tree Anti-bacterial Handwash 500ml

Xpel Tea Tree Facial Scrub 250ml

Xpel Tea Tree Foaming Face Wash 200ml

The manufacturer will be given in another column and it should be subtracted from the product name. for the examples above the manufactures are Azzaro and Xpel. So the final product names for similarity comparison will be

Chrome Eau De Toilette 100ml

Chrome Eau De Toilette 100ml & 100ml Aftershave

Chrome Eau De Toilette 100ml & 200ml Shower Gel

Chrome Sport Eau De Toilette 100ml

Chrome Sport Eau De Toilette 30ml

Chrome Sport Shower Gel 50ml

Tea Tree 100% Pure Tea Tree Oil 10ml

Tea Flower 100% Pure Tea Tree Oil 30ml

Tea Tree Anti-bacterial Handwash 500ml

Tea Tree Facial Scrub 250ml

Tea Tree Foaming Face Wash 200ml

We must get the most similar results for each row. Do not ask us how. If we knew how we would have done it ourselves. Similarity is the key word.

Some first thoughts is to order them by name and check word by word.

Clarification:
The similarity percentage will define which products should be matched. The 5 or 10 most similar will be matched and their common text will be the keyword so we can match them.

Compétences : Excel, PHP

Voir plus : ikea list product names, list product names health fitness diet exercise, product names list csv, list similar products wordpress, ikea product names list, list product names, oscommerce product listing similar products, ajax product compare, actress names list photo, similar products vicidial, list product craig list, product compare ajax, virtuemart product compare, list product tag lines, list product ebay

Concernant l'employeur :
( 20 commentaires ) Σέρρες, Greece

N° du projet : #12713860

Décerné à :

arielaleksander

I read your bid, I can do this using Power pivot and some Macros. If you give me the job I can start it after 6PM Est time. January 11, 2017 Dear Hiring Manager I am 20 years old guy and live in Brazil Plus

17 € EUR en 1 jour
(3 Commentaires)
0.7

45 freelance ont fait une offre moyenne de 32 € pour ce travail

xtremewebtech

>>>>>>>>>>>>>>>> Preferred freelancer here <<<<<<<<<<<<<<<<<<<<< Hi there – Saqib from Xtreme web tech. I’ve read your brief and can see that you’d like to. Compare a list of product names and return most similar Plus

29 € EUR en 1 jour
(163 Commentaires)
8.1
100 € EUR en 1 jour
(256 Commentaires)
7.6
schoudhary1553

Aquaholix Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same Plus

200 € EUR en 1 jour
(198 Commentaires)
7.1
sy3d

please check my profile, i've no incomplete project we can perform this task in excel as well as PHP please share file, i'll show demo before you hire me i assure you, i'll complete this task as per your requiremen Plus

30 € EUR en 1 jour
(272 Commentaires)
7.2
23 € EUR en 1 jour
(3494 Commentaires)
6.7
BitLabs

Hello, I have gone through your outsourced requirements "Compare a list of product names and return most similar products" and have analyzed that I have right skills (Excel, PHP) to execute your esteemed project. Plus

35 € EUR en 1 jour
(110 Commentaires)
6.6
20 € EUR en 1 jour
(135 Commentaires)
5.9
Harun1986

Hello, Sir, I will send the quick sample. I will fill in a spreadsheet with data for you. I have using tactically use many things but Google for finding keyword relented companies, Email, address, Person name, phone, e Plus

23 € EUR en 1 jour
(136 Commentaires)
6.1
30 € EUR en 1 jour
(130 Commentaires)
5.8
23 € EUR en 1 jour
(10 Commentaires)
5.1
testotorko

Hi, I read carefully your project, and I wanna do it for you. If you wanna work together, send me a message to discuss details. I am an experienced Web Developer and Web Designer, and have worked with wide variety of s Plus

30 € EUR en 3 jours
(40 Commentaires)
5.0
14 € EUR en 1 jour
(11 Commentaires)
4.8
teeares

I have created many macros in Excel, I will be able to do this task. Would the first word be always the manufacturer? There may be more complications if the manufacturer,s name consists of two words. Any way let me hav Plus

19 € EUR en 1 jour
(49 Commentaires)
4.9
LidijaP

My name is Lydia, I'm working on the computer last 15 years. My Top Skills Excel, Microsoft Office,Internet Research.

34 € EUR en 1 jour
(12 Commentaires)
4.5
27 € EUR en 1 jour
(19 Commentaires)
4.3
ljnath

Hello, I am a professional software developer.. I have read your project requirement, and i solve your problem. I understand it and i have solution to for that too. I am free and can start immediately. Please contac Plus

50 € EUR en 0 jours
(18 Commentaires)
4.4
ksinghrajeev

Hello There, Below are few examples of my work. Project Report Automation - [url removed, login to view] Log Report Automation - [url removed, login to view] Plus

45 € EUR en 1 jour
(15 Commentaires)
4.2
Diliphero

Greetings, I would like to submit my proposal for your project on Excel. I Understand the importance of this project due to my educational background and I will do this job with great care and responsibility. I am a Plus

30 € EUR en 1 jour
(6 Commentaires)
3.5
ChinmoySarker

Hi! Being attracted with your declaration of program, I feel tempted to have the chance to make your work complete carefully and sincerely. I would like at present to have your kind-mind and as soon as possible. S Plus

14 € EUR en 1 jour
(14 Commentaires)
3.6
microservices

Hi, Please consider us for this project and give us an opportunity to showcase our work to you. We can assure you on time we will deliver a bug free application . So we will discuss more on it in near future . B Plus

24 € EUR en 3 jours
(10 Commentaires)
3.3