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
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