Add products (or other data) directly in SQL Server

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
Hace 13 años
Hi,

I'm new to nopCommerce, still busy exploring all the features, but so far I think it's great!
Compliments to the nopCommerce team!

Maybe somebody can help me out with the following issue:
I just tried to add some products with a query that inserts some rows in de nop_product table. The rows are identical to an existing product manually added in nopC administration, except for the name. Field ProductId is succesfully auto generated. Product data seems fine in SQL Server

However the products dont appear in the productlist, tried clearing cache, restarting site, to no avail...
I know i can import the products via Excel in the administration, but later on I want to automate product and pricing updates. Did i forget something? And is it safe to import data like product, prices, customers, ect straight in SQL Server?
Hace 13 años
i figured it out; need to add rows to table Nop_ProductVariant.
sorry for my ignorance.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.