Question

when's the cross product becomes zero

Answer 1

either one of your vector is zero vector or the angle between the vectors is 0 degree

Answer 2

Cross product = |a| × |b| sin A
For it to be zero, sin A has to be 0°
So, if vectors are parallel to each other, cross product is zero.