I have a CSV file and it takes ages to import it with magento standard interface, import is ok. I tried to use open source solution called "Magmi" which imports the same file in seconds when magento takes days. The problem is that if the file is imported with magmi, products are not visible on the website, even though they show in admin panel. Does somebody know the CSV structure (obligatory fields) for a successful Magmi import to happen?
You need to reindex (System -> Index Management) after importing with magmi: not sure exactly which indexes are required, one I know for sure is Product Flat Data, even if you don't use the flat catalog.
As for the csv structure, export all products to have an example.