Reinstate deleted products
- 174
- 1769
- 05.08.2014
- Romania
Hello,
I'm not sure if a product has other related entities that should be un-deleted, but for the products themselves you could do:
You could try for one product, and see if anything else is needed.
Regards
--- Update ---
I just looked in the source code and it seems that the Delete product method only updates that Deleted flag, so the above script should do just fine. See the method below:
I'm not sure if a product has other related entities that should be un-deleted, but for the products themselves you could do:
UPDATE [dbo].[Product] SET Deleted = 0 WHERE Deleted = 1
You could try for one product, and see if anything else is needed.
Regards
--- Update ---
I just looked in the source code and it seems that the Delete product method only updates that Deleted flag, so the above script should do just fine. See the method below:
/// <summary>
/// Delete a product
/// </summary>
/// <param name="product">Product</param>
public virtual void DeleteProduct(Product product)
{
if (product == null)
throw new ArgumentNullException("product");
product.Deleted = true;
//delete product
UpdateProduct(product);
}