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 magento.stackexchange.com, 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 community@magento.com.

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