Create MySQL Database filter prior to import

This project received 15 bids from talented freelancers with an average bid price of $126 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

We are looking for someone to create a Mysql database filter that works before we import products to our website.

At the present time we have a keyword filter but it is not as sophisticated as we need it.

At present we can filter the products prior to import in the following manner

i.e keywords,

Women's natural dress

Our present database filter will delete all products that do not have

The words women's, natural, dress

The words do not need to be in the any order they just have to be in either the product title, features or descriptions field. We have already set this up

One of the problem with our present filter is that in the above example we are

Also deleting all products that say women instead of women's

So we need to also create a way to handle plurals, or ideally

Be able to use women or women's and then also still look for natural and dress

The second thing we need is to be able to also filter by negative keywords

i.e -skirt -jeans -baby -gap etc

When using a - before a keyword the script should delete all products that have that keyword,

We are presently using prestashop, and want to create these other filters before import. We have all the import scripts and they are functioning coreclty, but does not do the above new filter aspects.

In summary, we need to be able to also filter our database prior to import and add

Example women or women's and still filter for dress and natural

Keeping all products that have these words

Secondly, create negative keywords for products to be not included in the database if they have

Negative keywords -baby if a product has baby in the title, features or description Fields it will be deleted

Well that is what we are looking for . Remember we already have all the import scripts, just need to add the two additional aspects mentioned above. Thanks. Also you must be able to complete this job in the next 48 hours. Thanks

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online