Magento – Full Product Catalog Import Possible

Option 1: Use AvS_FastSimpleImport directly; http://avstudnitz.github.io/AvS_FastSimpleImport/options.html

Set the option 'Support Nested Arrays for Import' to Yes and use the nested arrays. Example:

$data = array(
    array(
        'sku' => '1234567',
        '_type' => 'simple',
        '_attribute_set' => 'Default',
        '_product_websites' => array('de', 'en', 'fr'),
        'name' => 'Default',
        'price' => 0.99,
        'description' => 'Default',
        'short_description' => 'Default',
        'colors' => array('green', 'silver')
        'weight' => 0,
        'status' => 1,
        'visibility' => 4,
        'tax_class_id' => 2,
        'qty' => 76,
    ),
);

Option 2:

To transform files to a different format, I personally use https://github.com/ho-nl/Ho_Import, others use https://github.com/AOEmedia/Aoe_Import. Where Ho_Import offers download options etc, Aoe_Import is multi threaded and has better logic for parsing XML.

From memory, I think your syntax may be wrong. I don't believe you need the " quote mark's around color,size.

Also I think 1048 refers to the row number in your csv file, not sure if this takes into account the first row of column names in your csv but look around row 1047,1048 & 1049 for any syntax errors.

Hope this helps