Hi,
Would it be possible to know more about your Joomla menu "store" configuration and your HikaShop SEF configuration.
It looks like a SEF issue because if you generate a non-SEF url, the page is working.
emotorwerks.com/newsitetest/emotorwerks/...e-with-24-foot-cable
Afterwards, it could be also link to the "canonical" configuration of your products and your HikaShop settings for the canonical management.
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.