I agree with 3Rotor. Years ago, zooms were inferior, but now there are superb ones.
I think 3Rotor's questions are on target. If you have very small objects, you will want a macro lens, and even though many zooms are labeled "macro", none really are. So if you want a zoom for small stuff, check the maximum magnification of the lens.
I do flower close-ups and macros, which have a lot in common with indoor (small) product photography. I have to use a macro lens. the drawback is that with any prime, you can only change the size of the product in the frame by moving either the product or the tripod. It's a lot easier to zoom.