I have been using EP (paid version for years) I upload patches of thousands of products with no problems and I can assign the product_id before I add them. (EP tell you the last number in database so you don't have conflict).

Some things are easier done in phpmyadmin but adding a product isn't one of them since there are multiple tables associated with products. Just my 2 cents.