bulk load logic