We are currently involved in a project were we have a constantly changing set of product data in a MySql database it contains something like 3 mio products with titles prices and sometimes descriptions (we call these offers).
We also have a list of about 80k products that are unique here we ONLY have a product title (we call these the meta products).
What i need is someone who can automatically on the fly match the 80k meta products with our database of offers.
An example of what i need the script to do:
iPod nano 16 GB sølv
Match with offers (title+description)
Ipod nano 16GB
Apple ipod nano 16 Gigabyte
Ipod nano 16GB silver
Nano, ipod Sølv 16gb (7th generation)
Nano, ipod Sølv 16gb 7G
Basically i need you to help me come up with some good ideas as to how this can be done, i need it to match the products as good as possible.
The above is just an example hope someone can help me on this, and please bear in mind that it needs to be a script that can run at least once a day on at least 5 mio records