Import/Export Issues

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
7 years ago
Sergei-k wrote:

Delete products option just marks the product as deleted while the product itself remains in the database. Therefore, the import goes on without errors, and the data is updated, you just can’t see the result, because the import goes through SKU, and product with this SKU was marked as deleted.


Thank you very much for replying, this was very helpful.
If products are only marked as deleted, is there a way to restore these deleted products?
0
7 years ago
danlev wrote:

Thank you very much for replying, this was very helpful.
If products are only marked as deleted, is there a way to restore these deleted products?


Recovering of  Deleted products is possible only using the database tools. It's not possible  in nopCommerce.
If you do not know how to write queries, you can use on of the following:
update [Product] set Deleted=0
where sku = 'SKU'

This one will restore the one product by specified SKU
update [Product] set Deleted=0
where sku in ('SKU1', 'SKU2', '...')

And this one will restore all by SKU list

Or you can look at the commit that solves the import problem
Interested in the dedicated Premium support services provided by core developers? Please visit https://www.nopcommerce.com/nopcommerce-premium-support-services

Regards,
Sergey Koshelev
1
7 years ago
Great, thank you very much for helping out.
0
7 years ago
This works if you know the range of products by ID and have a lot of products to recover.

UPDATE dbo.Product
Set Deleted=0
Where ID between BeginningID and EndingID
0
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.