Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email

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,

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