In pratica ho un file così strutturato:
versione CSV
versione XMLcodice:"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"
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..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>
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