Hi,
Regarding your website and the URL of your products, it looks partially good.
In HikaShop I think that you're using the canonical URLs ; so the link that you generated for the product is not the right one because the last part is based on the "product name" (in a SEF mode) and not on the "product code".
So I think it will be easier for you to use
http://www.clubamadeusny.com/{product.product_canonical}
to get the real URL of the product.
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.