Update Product Link?

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

Jim

Hi Jim,

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.

Hope this helps,
RJ

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.

jimkoh1 wrote:

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.

Thanks,
Tony

Jim,

If you are following this post or if anyone else would like to know, I figured out why this issue was occurring.

The problem was that the Product\Seo tab\Search engine friendly page name, needed to be populated.

In my Excel import file, I populated that field with a short product name.

After doing that all links worked.

I hope this helps.

Tony