Wednesday 21 March 2012

How to import custom options through CSV file

http://www.magentocommerce.com/boards/viewthread/67259/

Follow the instructions in the above link page, download the import.zip folder and place the files in the respective magento folders.

Create a new profile in system->import/export->Dataflow-Advanced Profiles, copy and paste the xml in the new profile.

Create a csv file var->import as options.csv.

Example csv format is

“sku”,"option_title”,"input_type”,"required”,"sort_order”,"row_title”,"row_price”,"row_price_type”,"row_sku”,"row_sort_order"
“AAA”,"A”,"drop_down”,0,0,"A1”,10,"Fixed",12343,1
“AAA”,"A”,"drop_down”,0,0,"A2”,10,"Fixed",12343,1
“AAA”,"A”,"drop_down”,0,0,"A3”,10,"Fixed",12343,1
“BBB”,"C”,"drop_down”,0,50,"B1”,10,"Fixed",12343,1
“AAA”,"B”,"drop_down”,1,10,"A4”,1,"Fixed",98765,2
“CCC”,"D”,"drop_down”,0,25,"C5”,50,"percent",1232123,5

No comments:

Post a Comment