Magento Forum

   
Importing data with SQL scripts - URL paths
 
Hilmar A8
Jr. Member
 
Total Posts:  1
Joined:  2007-11-30
Reykjavik, Iceland
 

I have this weird problem:

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.

Best regards,
Hilmar

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top