Visualizzazione dei risultati da 1 a 2 su 2
  1. #1

    ho un problema con magento e l'import di xml e csv

    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

  2. #2
    Riuscito nell'impresa?
    Arjuna

    finding solutions

Permessi di invio

  • Non puoi inserire discussioni
  • Non puoi inserire repliche
  • Non puoi inserire allegati
  • Non puoi modificare i tuoi messaggi
  •  
Powered by vBulletin® Version 4.2.1
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved.