Hi
I'm having a similar issue, but need a little more elucidation - I'm not great with Database Queries!

To turn domain/component/hikashop/classic-click---our-latest-dutch-style-bicycle

where "classic click - our latest dutch style bicycle" is the Hikashop Product Name

To become our prefered SEF url domain/electric-bikes/classic-click-dutch-style-electric-bicycle

where "classic-click-dutch-style-electric-bicycle" is the Hikashop Product Alias

What do I need to change in the settings?

Help would be greatly appreciated to help a lot of contrived work in sh404sef and hikashop, which don't work well together!
Cheers
Bob