I have a DB with many products. (Magento ver. 1.7.0.2)
Some products are linked to a specific designer (a custom sub-category configured in magento). I would like to snatch the designer name from the related designer of a product and prepend this to the product title.
From which table/field should I grab the designer(category) name? Where within the product row would the ID of the relevant category be stored?
To which field would I prepend the data?
Are there multiple fields I would need to update for DB integrity?
I would use PHP to perform an automated query, one product at a time.
Thanks in advance for any guidance offered :)