batch product load and optimize the searching