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 95when install this extension when i import productso by profiles default, i have a parse error, I think there are that I have to change something more than just installing the extension ... something??? April 18, 2011Great extension, thanks. Its possible to import also grouped products with this extension? Thanks. April 10, 2011mag 1501 gt; Categories are not created during import, don't know what to do. April 8, 2011Great work..many many thanks for this extension . April 8, 2011Well i tried to import products via the usual method in Magento (v1.5.01) and got nothing but errors, I finally got the import to work but no products showed in the manage product section, if I go to manage categories they show up in the import category I made???? So after 3 days, I come across this module, edited the sample CSV to my requirements and it worked perfectly. Nice job, great work - IGGY April 4, 2011Worked like a charm with Magento ver. 1.5.0.1 exactly as downloaded no hacks required! THANK YOU! Note: Multiple options appear on the product page in alphabetical order. So name the column headers in alphabetical order. March 8, 2011Is there a way to export this kind of products once you imported them? it work for the import now i need the export! March 8, 2011Works great here with 1.5. It will make duplicate options for a product if you upload a csv file with the same options already defined. This can be fixed though. I replaced the code inside if (isset($custom_options)) { with the code below... now if it finds you are importing options for a product it deletes the existing options then imports them.... foreach ($product-gt;getOptions() as $option) { try { $option-gt;getValueInstance()-gt;deleteValue($option-gt;getId()); $option-gt;deletePrices($option-gt;getId()); $option-gt;deleteTitles($option-gt;getId()); $option-gt;delete(); } catch (Exception $e) { } } // add the options to the product foreach ($custom_options as $option) { try { $opt = Mage::getModel('catalog/product_option'); $opt-gt;setProduct($product); $opt-gt;addOption($option); $opt-gt;saveOptions(); } catch (Exception $e) { } } } March 4, 2011I have one problem. After importing the products do not show up in their category. In the admin panel products are in their category but they do not show on the frontend. i'm using ver. 1.4.2.0. February 12, 2011Ok I got it working with 1.5.1. Use: app/code/core/Mage/Catalog/Model/Convert/Adapter/Product.php from 1.4.2 and replace it in your 1.5.1 Also 1.4.2 was working great for me. February 11, 2011- 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
