So I am adding products programmatically, in my csv I have the category path which would look like,
Clothing/Shirts/Sweaters
Now using this how do I look up the category id? As far as I know the only way to assign a product a category is using,
->setCategoryIds(array(1));
Pulling the data from the database looks very tedious, as my above example is three sub categories deep. Is there a builtin Magento function that will make this possible?