Update Product Link?

Posted: April 10, 2018 at 10:47 AM Quote #203019
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
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: April 10, 2018 at 3:34 PM Quote #203026
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
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: April 10, 2018 at 3:50 PM Quote #203027
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.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: May 15, 2018 at 6:47 PM Quote #204347
jimkoh1 wrote:
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.

Thanks,
Tony
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: May 16, 2018 at 5:21 PM Quote #204412
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
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.
eCommerce CONFERENCE 2018
Learn more