transaction add soft deletion