Create MySQL Database filter prior to import

AWARDED
Bids
15
Avg Bid (USD)
$126
Project Budget (USD)
$30 - $250

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

Skills required:
Data Processing, MySQL, PHP, Software Architecture
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire zeke
$ 100
in 1 days
Hire thelogicgates1
$ 98
in 15 days
$ 100
in 2 days
$ 100
in 2 days
Hire billfinnegan
$ 200
in 1 days
Hire triadb
$ 125
in 0 days
Hire ozspeed
$ 60
in 1 days
Hire CheapGoodWork
$ 50
in 2 days
Hire harryinfotech55
$ 200
in 1 days
Hire kamalooay
$ 30
in 0 days