I have a csv file containing 18,261 products. I need somebody experienced with Excel that can create rules to look for certain keywords in the data, and then change the value of a category_id cell. I think this can be done using IF statements, but you may know of other methods.
At the moment, all the products in the file have the same category_id. The aim is to find all products for women and give them a new category_id, and then do the same for products for men.