Magento – Skip import row, is not valid value “” for field “type”

I managed to reproduce the effect. If the status doesn't have the value "1" (enabled) or "2" (disabled), the product doesn't display at all.

You can fix this as follows. Create a PHP file in the base directory named "update_status.php". Paste the following contents:

<?php
require_once 'app/Mage.php';
Mage::app()->setCurrentStore(0);

$collection = Mage::getResourceModel('catalog/product_collection');
$collection->addAttributeToFilter('status', array(
    array('nin' => array(1,2)),
    array('null' => true)
), 'left');
foreach ($collection as $product) {
    $product->addAttributeUpdate('status', 1, 0);
}

This will set the status "1" to all products which don't have a correct status. Don't forget to delete the file afterwards.

Please check and make sure that you don't have extra carriage returns/line feeds on the end of your csv file. Open the file, and delete any blank lines/rows.

Often times, when you export from Excel, it will add extra rows to the export that are nothing more than blank lines.