I import all the products with SQL scripts, since my customer needs connection with his inventory program he has been using.
Everything imports great. On one place I take the SKU, strip all the illegal characters from it and make it an URL path and URL key. So I will have for example, product named: 265/75 R16 BF Goodrich AT, with SKU: HJ62675-BFG and URL key: hj62675-bfg.
My problem is, that when I try to use the direct URL path to access products from a web to the Magento store, I get the Oooops error. If I then go into the product, add a letter to the URL key, delete it again and then save the product, the same link will now get me to the store.
Any ideas why this is happening ? I have tried URL Encode the string before I store it in the database, but nothing seems to work.