I don't do much product video, but I'd suggest something with as much of a close focus range as possible. The Batis 40mm seems to be popular in that field. The Sony 90mm Macro is another option.
Otherwise, you could use extension tubes on anything you've got, to reduce the minimum focal distance.
