Wednesday, 21 March 2012

How to import Up sell and Cros sell Products through CSV file in magento

Go to the below link and download the module through magento connect manager

http://www.magentocommerce.com/magento-connect/itib-mass-import-product-relations-upsell-and-cross-sell.html


Follow the instructions in the page

xml file for the given module is

<action type="dataflow/convert_adapter_io" method="load">
<var 
name="type">file</var>
<var 
name="path">var/import</var>
<var 
name="filename"><![CDATA[product_relations.csv]]></var>
<var 
name="format"><![CDATA[csv]]></var>
</
action>

<
action type="dataflow/convert_parser_csv" method="parse">
<var 
name="delimiter"><![CDATA[,]]></var>
<var 
name="enclose"><![CDATA["]]></var>
<var name="
fieldnames">true</var>
<var name="
store"><![CDATA[0]]></var>
<var name="
number_of_records">1</var>
<var name="
decimal_separator"><![CDATA[.]]></var>
<var name="
adapter">Itib_MassImportProductRelations/Convert_Adapter_Productimport</var>
<var name="
method">parse</var>
</action>
 
 
Sample csv format is 
 
link function,sku1,sku2,link type
assign,A,D,related  

No comments:

Post a Comment