Smart duplicate fetching from list of product titles from table

  • Status: Closed
  • Hadiah: $60
  • Penyertaan diterima: 9
  • Pemenang: gmdwivedi

Ringkasan Peraduan

Update *****Only thing added is mysql code in first line****

We want to write a mysql code that will return list of smart duplicates NOT identical duplicates. The “Smart duplicate titles will be returned from a list of 1000s of product titles.” Below are some examples of smart duplicates from 1000s of product titles..

(1) Beautiful Nail polish made from the best sourced materials.
(2) Sourced material of various elements for our beautiful polish.
(3) Beautiful Nail Polish with various elements
(4) 2020 Nail polish with best sourced materials beautiful.
(5) Excellent Nail polish with best sourced material.

All the above 5 product are the same, notice common words in all product titles. How will you go about solving this problem if you are provided with a database with the product titles shown above along with 1000s of other products that is unique. Again we are not looking for identical titles. We already have a solution for that already. We also have a solution for smart duplicate but we want to see if there are better ideas out there.

Below is our technology stacks.
Stack: LAMP
Language: PHP (7.2)
Framework: Laravel
Platform: Shopify
API: Shopify Admin API


Thank you.

In your response, although it is highly appreciated and will increase your odds of winning, we are not really looking for you to write the code but clues, apis of the technology stacks we use or even code will be highly appreciated to allow us to solve this problem.

Kemahiran Disyorkan

Maklum balas Majikan

“good working with you sir”

Gambar Profil ResiliencyLLC, United States.

Penyertaan teratas dari peraduan ini

Lihat Lagi Entri

Papan Penjelasan Umum

  • abdulrazakZakieh
    abdulrazakZakieh
    • 1 minggu yang lalu

    Dear Sir
    I would be pleased if you have the time to check my entry #11 . You can notice that the script I wrote had placed the phrases you mentioned in the first automatically among many others. We can extend this concept to your whole data. The code intelligently chooses the relevant titles.

    • 1 minggu yang lalu
  • way2logic
    way2logic
    • 4 minggu yang lalu

    check entry #7 read description

    • 4 minggu yang lalu
  • dataexpert18
    dataexpert18
    • 1 bulan yang lalu

    Do you already have the data or want to search the duplicate from web.?

    • 1 bulan yang lalu
    1. ResiliencyLLC
      Penganjur Peraduan
      • 1 bulan yang lalu

      Yes we have the data in our database, our app imports the data and store it in our database and thats where the data manipulation starts. Please make a submission on how you will solve it with the 5 listings provided in the problem definition. thanks.

      • 1 bulan yang lalu
  • dataexpert18
    dataexpert18
    • 1 bulan yang lalu

    if you provide the data i can write script for your required task.

    • 1 bulan yang lalu
  • shuvoroy990088
    shuvoroy990088
    • 1 bulan yang lalu

    o ho

    • 1 bulan yang lalu

Tunjukkan lebih banyak komen

Bagaimana mula dengan peraduan

  • Paparkan peraduan anda

    Paparkan Peraduan Anda Cepat dan mudah

  • Dapatkan berjuta penyertaan

    Dapatkan Bertan-tan Penyertaan Dari serata dunia

  • Anugerahkan penyertaan terbaik

    Anugerahkan penyertaan terbaik Muat turun fail-fail - Mudah!

Paparkan Peraduan Sekarang atau Sertai kami Hari Ini!