Hard deletes a uCommerce product. When a product is deleted from the back office it is only soft deleted, there is no way to hard-delete a product from the back office.

uCommerceDeleteProduct.sql

BEGIN TRANSACTION

BEGIN TRY

	DECLARE @ProductId int;
	SET @ProductId = 142;

	DELETE FROM uCommerce_PriceGroupPrice
	where ProductId = @ProductId

	DELETE FROM uCommerce_ProductRelation
	where ProductId = @ProductId

	DELETE FROM uCommerce_CategoryProductRelation
	where ProductId = @ProductId

	DELETE FROM uCommerce_ProductProperty
	where ProductId = @ProductId

	DELETE FROM uCommerce_ProductDescription
	where ProductId = @ProductId

	DELETE FROM uCommerce_Product
	where ProductId = @ProductId

END TRY

BEGIN CATCH

	ROLLBACK TRANSACTION

END CATCH

IF @@TRANCOUNT > 0

	COMMIT TRANSACTION

GO