Hello I've imported products directly into the database with an insert/update query. All the information is there and everything works fine except for the product links. Non of the product links work if I don't first click the edit button for a product from within nopCommerce and then save the page. Otherwise the links are there and show as expected, but don't do anything. Does anyone know what property I have to update to make the links work? I'm using ver 4.0. Thanks
Without having an example of the SQL, I am limited in knowing what exactly is failing, or have the ability to compare differences after editing and saving.
However, I have encountered something similar in the recent past, and it was related to not having an entry in the UrlRecord table.
The urlRecord table doesn't have any links in it. If anyone can tell me where nopCommerce stores product links, that would probably fix the problem.
Jim,
I am having the same issue. I imported all of my products with an Excel file.
None of the product links work. The category links work OK. Like you said, if I go to a product edit and save it, then the link works fine on the public store.
If I put a product sku into the search box, it finds it, but when I click on it, it gives a "Page not found" error an the address bar shows "http://localhost:15536/null"
My UrlRecord table has 120 entries in it.
If you have resolved this issue, I would like to hear about it. Otherwise, if I come up with a resolution I will post it here.