SQL Server data import form another database into NopCommerce database

Hello,

First time post, please be gentle.

We have created SQL job to import data, including images from another database into NopCommerce. The only issue we have is that the imported products are not indexed for search and when you click a product in the store. It will not go to the product details page and cannot add to cart.

Any help would be appriciated!

search the forums about Slugs with SQL
https://www.google.com/search?q=site%3Anopcommerce.com+slug+sql

Thanks for the quick reply. That did the job!!
We can now import and create products directly through SQL.

[email protected] wrote:

This is awesome (y)

Hi, we have updated our database for Nopcommerce 4.1 using the SQL script. Now we can no longer add products to the shopping basket. The site works as before but when we try to add a product to the shopping basket, nothing happens. Are there additiona fields required after the update to make the SQL import work correctly in version 4.1 for products?
Thanks in advance.

@RicoAtSlewOf
(I think you should have created a new topic post.  This update to 4.10 does not seem to be related to your original  post about import from another system.)

Check the System > Log for any messages.
Also, use the browser's 'developer mode' and see if any JavaScript errors are being thrown (look in the console tab).
Did you do any customization?

Hello,
I am in te same situation: import in fast way (every night deleting previous) product data from one nop db to another. Have you already script ready for this? It will save a lot of time :-)

Thanks in advance

BR

I on the local computer created two nopCommerce project: 1st draft: version 3.30  Wanted to migrate entire database with the first project second project using the. using the import wizard and export, you can run in SQL Server Express, Web, Is it possible to add data columns of English and Russian in file: products.xlsx



https://www.mcdvoice.us

RE: "using the import wizard and export"
Are you aware that you can upgrade a DB with the SQL Upgrade Scripts?

RE: "Is it possible to add data columns of English and Russian in file: products.xlsx"
Not out of the box.  Maybe this helps