Normalizing product feeds from multiple e-shops to identify unique product models

[afiliere_itmc]

I need help for normalizing product feeds from multiple e-shops to identify unique product models. Can somebody help with this topic?

Thanks
Catalin

[alexnajm]

Can you go deeper into what you mean by "normalizing product feeds" with examples & data as well?

[afiliere_itmc]

Here is some sample of the feed for Tablete category. I want to be able to identify tablet model no matter how it is named in each shop (Apple iPad Air 3 (2019), Tableta Apple iPad Air 3 (2019), iPad Air 3 (2019)) and no matter which are it secondary caracteristics (color, memory, screen size, etc). THis model should be filled in column A

[alexnajm · Accepted solution]

Looks like a case for the  Fuzzy Match Tool! Check out this Tool Mastery article: Tool Mastery | Fuzzy Match correspondance partielle fuzzyübereinstimmung

In this case you'd use the Purge mode, and likely just use "title" as your column to fuzzy match