Import Products categories, multiple images and custom options
-
12947 Popularity Score
Popularity ScoreReferrals to Site/Downloads
0
1+
250+
1000+
10000+
Learn more
Magento Connect 1.0 change
Loading platform data and releases... - Developer Info /
- Profile
- Support
- Extensions
- Overview
Import Products categories, multiple images and custom options
You can use this extension to import products with categories, multiple images and custom options from CSV file. We have well tested this extension and it is working perfectly. Please let us know if you need any guidance or help to use this extension. We are ready to help you.
To insert custom options, please create column with name of custom option in product import CSV file with specific format. Please Download Sample Products Import CSV and create your Products CSV file accordingly. Please read Overview Section throughly.
Few Products Columns Sample Import CSV :- Download Sample CSV
All Products Columns Sample Import CSV :- Download Sample CSV
E.g. if you want to create custom option for size then custom option column name should create like this,
cws!Size:drop_down:1 (Column Heading)
Size=custom option name
drop_down=control name
1=mandatory filed. (0 for optional field)
Under this column enter value of custom option separated by pipe sign (|) as per example.
E.g. XS|S|M|L|XL
For add different price for different size add like
Small|Medium:fixed:5|Large:fixed:10
It means if product price is $100 then for Medium size product price 105 and Large size product price is 110.
You can create different types of custom options. Here is example
cws!Size Time:time:1
Size Time = custom option name
time = control name
1 = mandatory filed. (0 for optional field)E.g
|:fixed:100
===================================================cws!Size CheckBox:checkbox:1
Size CheckBox = custom option name
checkbox = control name
1 = mandatory filed. (0 for optional field)
E.g.
Small1:fixed:10|Medium2:fixed:10|Large2:fixed:10===================================================
cws!Size RadioButton:radio:1
Size RadioButton = custom option name
radio = control name
1 = mandatory filed. (0 for optional field)
E.g.
Small3:fixed:101|Medium3:fixed:101|Large3:fixed:101
===================================================
cws!Size Multiselect:multiple:1Size Multiselect = custom option name
multiple = control name
1 = mandatory filed. (0 for optional field)
E.g.
Small4:fixed:11|Medium4:fixed:11|Large4:fixed:11===================================================
cws!Size Area:area:1Size Area = custom option name
area = control name
1 = mandatory filed. (0 for optional field)
E.g.
|:fixed:101::20
Here 20 is max input character for text area
===================================================
cws!Size Date:date:1Size Date = custom option name
date = control name
1 = mandatory filed. (0 for optional field)
E.g.
|:fixed:101===================================================
cws!Size DateTime:date_time:1
Size DateTime = custom option name
date_time = control name
1 = mandatory filed. (0 for optional field)
E.g.
|:fixed:31To insert category name, please create “categories“ column in your products import CSV file. Please remove “category_ids” column from products import CSV file if you have.
Now enter categories name under “categories” column
E.g. Movie/Cartoon
Movie1=parent category
cartoon1=child category of Movie1 category.
If you want to add multiple category then you can add "," comma separated.
E.g. Movie02/cartoon02,Movie02/cartoon03
To insert multiple images, please create “gallery “column in your products import CSV file.Under this column enter images name separated by semicolon ( ; ) . Please enter relative path of images like below example. Please do not use path like (<a>http://www.xyz.com/ab.jpg</a> ) for images.
E.g. /image1_1jpg;/image1_2.jpg
You have to put all the images in media/import directory folder.
Now in this version you can update multiple images also.
After install extension Go to
1) System -> Import/Export -> Data flow - Profiles
2) Click on Import All Products Edit link
3) Click on Upload File from left menu
4) Upload csv file and Click on Save and Continue button
5) Click on run profile
6) Select your uploaded file
7) Click on Run Profile in Popup button
Note:- Do not close this popup until all product import successfully.
When you are add/update any of products image then all the 4 images columns and data should available in CSV file.Note:- This extension support for product type only which magento default import functionality support.
Support
Need help? Please contact us at magento@capacitywebsolutions.com
- Release Notes
This extension can import product with custom option, category and multiple images
2012-02-06 04:05:45 This extension can import product with custom option, category and multiple imagesThis extension can import product with custom option, category and multiple images
2010-08-30 11:40:22 This extension can import product with custom option, category and multiple images- Reviews
About the Developer
This extension was developed by and is supported by capacityweb
Import Products categories, multiple images and custom options 95 95Works great with 1.5.1 except for the main image. Also if anyone needs the file options, you can implement it easily with the code in the comments from here: http://magentodev.blogspot.com/2009/05/how-to-import-products-with-custom.html February 11, 2011This extension does not work with Magento 1.4.2. I'm talking about import of Custom Options of Products. For istance, after the end of the foreach foreach ($importData as $field =gt; $value) { (that try to build $custom_options array ) $custom_options is EMPTY! And I debugged, in the foreach it add to the array some records but after the end of the foreach the $custom_options is totally EMPTY! Can you please debuf the situation with Magento 1.4.2? February 9, 2011I couldn't use this extension with version 1.4.x, but I moved to 1.5.0 and it all came together. No php warnings on the install and as soon as I got the CSV columns sorted out, it worked perfectly. I would say that anyone who tried and failed with this extension in 1.4.x should retry. Complaints: 1. Had to anchor all parent categories 2. Could only upload 4500 to 5000 products at a time, so I had to split my CSV files...no biggie. 3. Would LOVE an import extension that worked with image URL's. I hate the extra time it takes to download and then upload all my image files from my supplier. Pros: 1. Easy with the correct CSV mapping 2. Quick install, no recoding manually 3. No extra menus to deal with. Works right from Dataflow Profile Thanks for the great extension. December 31, 2010This extension is working great for me so far, however, how do I add prices to the individual custom options? For instance, an XL shirt may require a +$2 up charge. Thanks! December 31, 2010This has got to be some sort of joke... I can't get this to work at all. I have checked to make sure that everytthing is perfect with naming the CSV file and all of the fields, I even tried to upload the sample CSV file custom options do not show up. I tried using the code that was provided by the blog which you used to develop this extension and it was even worse. Does this really work? I am using Magento 1.4.1 I find it mystifying that so many people are saying it work when I cannot. December 22, 2010I used this to import custom options to my store. I'm using 1.4.1.1 and it worked perfectly. You do have to set the column "has_options" to 1 or the custom options won't show up. Also, if you want to upload the same product ever again, you have to delete the custom options column or it will duplicated the custom options. Excellent extension! Just read the instructions and some of the reviews here to make sure you're doing it right. November 18, 2010This is what i did and it worked on 1.4.1.1 1) log in to your admin| system| import/export| export all product 2) my default location for this file was in the mystore.com/magento/var/export/export_all_products.csv 3) open and modify export_all_products.csv (moved file from my server to my local drive to do the edit in excel) 4) add a column to the header (row 1 ) size:drop_down:1:2 I deleted all my products but the 1 test product (product1) i wanted to add options to. size:drop_down:1:2 will match the same fields as if added manually admin | catalog | manage products | product1 | custom options | add new options. Title= size , Input Type=drop_down, Is Required=1 or yes, Sort Order=2 5) row 2 (has all my options for my product1) i added under my new column created in step 4 sm:fixed:0.00:250sm:1|med:fixed:0.00:250med:2 in my admin when input type is drop_down a add new row option becomes available. these fields match above Title=sm, Price Type= fixed, Price=0.00, SKU=250sm, sort order=1 using the pipe | will add a new row for multiple selection options. 6) My default export_all_products.csv file has a column G in row 1 called --- has_options. i needed to enable options in row 2 by setting column g has_options to a 1 for product 1. 7) import the file admin| system| import/export| import all product (i had to upload from my local server and make sure my file name matched the default in import all products.) 8) check admin | catalog | manage products | product1 | custom options www.hookahs4u.com November 18, 2010when i used to import the sample csv,custom option do not show ,iam uisng version 1.4.1.1 and did not mapping the field size:drop_down:1?pls give me soln?pls help anyone? November 18, 2010I have been playing with this a few days and this may help. I created 2 columns in my header 1 for color and 1 for size and each of those has 2 selectiions. The fields match the same fields found in the ADMIN|catalog|manage products|custom options. : seperates the fields of an option and the | seperates the optiions. Example of my 'export_all_products.csv' file has_options color:drop_down:1:1 size:drop_down:1:2 1 GREEN:fixed:0.00:250APP:1|BLUE:fixed:0.00:250BLU:2 sm:fixed:0.00:250sm:1|med:fixed:0.00:250med:2 also there is a question below from StuartPica. StuartPica View details I have successfully uploaded products using this tool. My only problem is the Custom Options do not show up until I go into each individual product in Admin and Save the product....this can't be right can it? Help anyone? I had this same issue and found when i exported my file column G (has_options) was set to 0. changing this to a 1 may help. November 15, 2010I have successfully uploaded products using this tool. My only problem is the Custom Options do not show up until I go into each individual product in Admin and Save the product....this can't be right can it? Help anyone? October 23, 2010- Q&A
- (1 Question : 0 Answers)
Product Q&A
Ask your questions. Share your answers.
Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_26134198It is great that we can upload multiple images in a row, but how to update image sort order?bysoundreality-2 months, 3 weeks ago1 of 11 of 1 - Get Help
Support for This Extension
The best place to start if you need help with a specific extension is to contact the developer. All Magento developers have both a contact email and a support email listed.
Magento Platform Support
If you need support for a Magento platform, there are different options for support depending on which Magento platform you are using. Below are links for specific platforms.
All
All
