changes the status meaning 0 means up for sale, 1 means not for sale 2 means deleted but remains in db for record. cannot be retrieve