In pratica ho un file così strutturato:

versione CSV
codice:
"store","websites","attribute_set","type","sku","category_ids","has_options","name","meta_title","meta_description","image","small_image","thumbnail","url_key","url_path","custom_design","options_container","gift_message_available","codice_prodotto","status","visibility","tax_class_id","weight","price","cost","special_from_date","description","short_description","meta_keyword","custom_layout_update","qty","min_qty","use_config_min_qty","is_qty_decimal","backorders","use_config_backorders","min_sale_qty","use_config_min_sale_qty","max_sale_qty","use_config_max_sale_qty","is_in_stock","low_stock_date","notify_stock_qty","use_config_notify_stock_qty","manage_stock","use_config_manage_stock"
"admin","base","Default","simple","20","15,21","0","Bouquet colori pastello","Bouquet colori pastello","Bouquet colori pastello","","","","bouquet-colori-pastello-2","bouquet-colori-pastello-2.html","default/default","Block after Info Column","Use config","001b","Enabled","Catalog, Search","Taxable Goods","10.0000","40.0000","13.0000","2008-10-15 14:05:35","Bouquet colori pastello","Bouquet colori pastello","sentimenti amore sentimenti felicitazioni","","10.0000","0.0000","1","0","0","1","1.0000","1","0.0000","1","1","0000-00-00 00:00:00","","1","0","1"
"admin","base","Default","simple","20","15,4","0","Bouquet con rose  rosse","Bouquet con rose  rosse","Bouquet con rose  rosse","","","","bouquet-con-rose-rosse-3","bouquet-con-rose-rosse-3.html","default/default","Block after Info Column","Use config","002b","Enabled","Catalog, Search","Taxable Goods","10.0000","50.0000","13.0000","2008-10-15 14:05:35","Bouquet con rose  rosse","Bouquet con rose  rosse","sentimenti amore occasioni anniversario","","10.0000","0.0000","1","0","0","1","1.0000","1","0.0000","1","1","0000-00-00 00:00:00","","1","0","1"
versione XML
codice:
<?xml version="1.0"?><?mso-application progid="Excel.Sheet"?><Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet"><OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"></OfficeDocumentSettings><ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"></ExcelWorkbook><Worksheet ss:Name="Sheet 1"><Table><Row><Cell><Data ss:Type="String">store</Data></Cell><Cell><Data ss:Type="String">websites</Data></Cell><Cell><Data ss:Type="String">attribute_set</Data></Cell><Cell><Data ss:Type="String">type</Data></Cell><Cell><Data ss:Type="String">sku</Data></Cell><Cell><Data ss:Type="String">category_ids</Data></Cell><Cell><Data ss:Type="String">has_options</Data></Cell><Cell><Data ss:Type="String">name</Data></Cell><Cell><Data ss:Type="String">meta_title</Data></Cell><Cell><Data ss:Type="String">meta_description</Data></Cell><Cell><Data ss:Type="String">url_key</Data></Cell><Cell><Data ss:Type="String">url_path</Data></Cell><Cell><Data ss:Type="String">options_container</Data></Cell><Cell><Data ss:Type="String">gift_message_available</Data></Cell><Cell><Data ss:Type="String">codice_prodotto</Data></Cell><Cell><Data ss:Type="String">status</Data></Cell><Cell><Data ss:Type="String">visibility</Data></Cell><Cell><Data ss:Type="String">tax_class_id</Data></Cell><Cell><Data ss:Type="String">weight</Data></Cell><Cell><Data ss:Type="String">price</Data></Cell><Cell><Data ss:Type="String">cost</Data></Cell><Cell><Data ss:Type="String">special_from_date</Data></Cell><Cell><Data ss:Type="String">description</Data></Cell><Cell><Data ss:Type="String">short_description</Data></Cell><Cell><Data ss:Type="String">meta_keyword</Data></Cell><Cell><Data ss:Type="String">custom_layout_update</Data></Cell><Cell><Data ss:Type="String">qty</Data></Cell><Cell><Data ss:Type="String">min_qty</Data></Cell><Cell><Data ss:Type="String">use_config_min_qty</Data></Cell><Cell><Data ss:Type="String">is_qty_decimal</Data></Cell><Cell><Data ss:Type="String">backorders</Data></Cell><Cell><Data ss:Type="String">use_config_backorders</Data></Cell><Cell><Data ss:Type="String">min_sale_qty</Data></Cell><Cell><Data ss:Type="String">use_config_min_sale_qty</Data></Cell><Cell><Data ss:Type="String">max_sale_qty</Data></Cell><Cell><Data ss:Type="String">use_config_max_sale_qty</Data></Cell><Cell><Data ss:Type="String">is_in_stock</Data></Cell><Cell><Data ss:Type="String">low_stock_date</Data></Cell><Cell><Data ss:Type="String">notify_stock_qty</Data></Cell><Cell><Data ss:Type="String">use_config_notify_stock_qty</Data></Cell><Cell><Data ss:Type="String">manage_stock</Data></Cell><Cell><Data ss:Type="String">use_config_manage_stock</Data></Cell></Row>
<Row><Cell><Data ss:Type="String">default</Data></Cell><Cell><Data ss:Type="String">base</Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String">simple</Data></Cell><Cell><Data ss:Type="Number">20</Data></Cell><Cell><Data ss:Type="String">15,,21</Data></Cell><Cell><Data ss:Type="Number">0</Data></Cell><Cell><Data ss:Type="String">Bouquet colori pastello</Data></Cell><Cell><Data ss:Type="String">Bouquet colori pastello</Data></Cell><Cell><Data ss:Type="String">Bouquet colori pastello</Data></Cell><Cell><Data ss:Type="String">bouquet-colori-pastello-2</Data></Cell><Cell><Data ss:Type="String">bouquet-colori-pastello-2.html</Data></Cell><Cell><Data ss:Type="String">Block after Info Column</Data></Cell><Cell><Data ss:Type="String">Use config</Data></Cell><Cell><Data ss:Type="String">001b</Data></Cell><Cell><Data ss:Type="String">Enabled</Data></Cell><Cell><Data ss:Type="String">Catalog, Search</Data></Cell><Cell><Data ss:Type="String">Taxable Goods</Data></Cell><Cell><Data ss:Type="Number">10.0000</Data></Cell><Cell><Data ss:Type="Number">40.0000</Data></Cell><Cell><Data ss:Type="Number">13.0000</Data></Cell><Cell><Data ss:Type="String">2008-10-15 14:05:38</Data></Cell><Cell><Data ss:Type="String">Bouquet colori pastello</Data></Cell><Cell><Data ss:Type="String">Bouquet colori pastello</Data></Cell><Cell><Data ss:Type="String">sentimenti amore sentimenti felicitazioni</Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="Number">10.0000</Data></Cell><Cell><Data ss:Type="Number">0.0000</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="Number">0</Data></Cell><Cell><Data ss:Type="Number">0</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="Number">1.0000</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="Number">0.0000</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="String">0000-00-00 00:00:00</Data></Cell><Cell><Data ss:Type="Number">0.0000</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="Number">0</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell></Row>
<Row><Cell><Data ss:Type="String">default</Data></Cell><Cell><Data ss:Type="String">base</Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="String">simple</Data></Cell><Cell><Data ss:Type="Number">20</Data></Cell><Cell><Data ss:Type="String">15,,4</Data></Cell><Cell><Data ss:Type="Number">0</Data></Cell><Cell><Data ss:Type="String">Bouquet con rose  rosse</Data></Cell><Cell><Data ss:Type="String">Bouquet con rose  rosse</Data></Cell><Cell><Data ss:Type="String">Bouquet con rose  rosse</Data></Cell><Cell><Data ss:Type="String">bouquet-con-rose-rosse-3</Data></Cell><Cell><Data ss:Type="String">bouquet-con-rose-rosse-3.html</Data></Cell><Cell><Data ss:Type="String">Block after Info Column</Data></Cell><Cell><Data ss:Type="String">Use config</Data></Cell><Cell><Data ss:Type="String">002b</Data></Cell><Cell><Data ss:Type="String">Enabled</Data></Cell><Cell><Data ss:Type="String">Catalog, Search</Data></Cell><Cell><Data ss:Type="String">Taxable Goods</Data></Cell><Cell><Data ss:Type="Number">10.0000</Data></Cell><Cell><Data ss:Type="Number">50.0000</Data></Cell><Cell><Data ss:Type="Number">13.0000</Data></Cell><Cell><Data ss:Type="String">2008-10-15 14:05:38</Data></Cell><Cell><Data ss:Type="String">Bouquet con rose  rosse</Data></Cell><Cell><Data ss:Type="String">Bouquet con rose  rosse</Data></Cell><Cell><Data ss:Type="String">sentimenti amore occasioni anniversario</Data></Cell><Cell><Data ss:Type="String"></Data></Cell><Cell><Data ss:Type="Number">10.0000</Data></Cell><Cell><Data ss:Type="Number">0.0000</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="Number">0</Data></Cell><Cell><Data ss:Type="Number">0</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="Number">1.0000</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="Number">0.0000</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="String">0000-00-00 00:00:00</Data></Cell><Cell><Data ss:Type="Number">0.0000</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="Number">0</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell></Row>
Ora quando vado a importare uno dei 2 file, che ha 315 prodotti, il sistema mi crea un solo prodotto e lo aggiorna per tutta la durata dell'import con i dati di ciò che sta importando..
in pratica,
mentre sto importando vedo
bouquet con fiori bianchi,
poi se aggiorno la pagina vedo
bouquet con fiori rossi

ora non so credo che faccia l'update sempre dello stesso row, o cancella e ricrea di volta in volta...mi sapete aiutare? u.u