bundle product import in magento

Question

I have installed magento 1.7.2 version, now my requirement is to import Bundle products but by default magento won't provide these feature.

So can anyone know that how can I import the bundle product from CSV file or if have any alternative solution then please advise.

Thank you for your time and consideration.

CSV Files contains:

Fields:

sku , _store , _attribute_set, _type, _category , _root_category , _product_websites , description , enable_googlecheckout , has_options , image , image_label , msrp_enabled name , bundle_options , bundle_selections , price , required_options , short_description , small_image , small_image_label , special_from_date , special_price , special_to_date , status , tax_class_id , thumbnail , thumbnail_label , updated_at , url_key , url_path

Values:

bb2 , Default , bundle , Furniture , Default , Category , base , This is 2 bundle product , 1 , 1 , no_selection , No , BB , RAM,radio,1,0 , ram:0:0.0000:1:1.0000:0 , 1 , Bundle Test Product 2 , no_selection , 01-10-13 0:00 , 30-10-13 0:00 , 1 , no_selection , 07-10-13 14:38 , bb2 , bb.html

you would have to create products one by one. Read the Magento's API on how to add products and categories pragmatically. — Arfeen

aynber aynber · Accepted Answer · 2013-10-07T13:29:39

You'll need to use the Magento Dataflow (System -> Import/Export -> Dataflow - Advanced Profiles). Create a new profile, and add in the following for your Profile Actions XML:

<action type="dataflow/convert_adapter_io" method="load">
    <var name="type">file</var>
    <var name="path">var/import</var>
    <var name="filename"><![CDATA[name_of_file.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">catalog/convert_adapter_productimport</var>
    <var name="method">parse</var>
</action>

Next you'll want to create a CSV file with the following fields: store, websites, attribute, type, sku, name, price, bundle_options, bundle_selections and any other fields you want to upload.

Now comes the tricky part: filling in those fields. The bundle options are in the following format: product1_name,selection_type,default_qty,position|product2_name,selection_type,default_qty,position. So it will look like product1,radio,1,0|product2,radio,1,0

Bundle_selections is a bit tougher, but looks like this:

product1_sku:0:0.0000:1:1.0000:0|product2_sku:0:0.0000:1:1.0000:

Edit:

Example CSV File

store,websites,attribute_set,type,category_ids,sku,name,price,short_description,description,value_offer,image,small_image,thumbnail,guarantee,weight,tax_class_id,po_box,status,visibility,grouped,bundle_options,bundle_selections,price_type,sku_type admin,"base",Default,bundle,7,product_sku,My Product Name,,"Really long description here","Another description bit here","value offer here",/image.png,/image.png,/image.png,"more text",19,None,no,Enabled,"Catalog, Search",,"Name1,radio,1,0|Name2,radio,1,0",Sku1:0:0.0000:1:1.0000:0|Sku2:0:0.0000:1:1.0000:,0,1

bundle product import in magento

Fields:

Values:

2 Answers