I am looking for someone with experience in matching a long list of products from 2 different providers. Each provider has named the product differently, but they have similarities. I guess there must be a way to make an SKU match between the 2 lists.
I need to able to apply the solution myself, so I can match the products when new products comes along.
Attach is an example of each list. Take for example the attach screen shots. The SKU of Provider 1 "10001AZ" is the same product as SKU of Provider 2 "L182811". How do I now ?
- First, I filtered by Manufacturer.
- Second, I lookup for similar "name"
- Third, I check up with image:
I don't know what is the best approach. Is picture software recognition necessary ?
Please propose solutions.