Thank you very much Raymond, that solve the problems.

However, if I want to do it the other way round and let the manager
jobs to succeed by locking all the items being updated so that those
items cannot be sold until the SP commits, what setting do I need?

Kenneth