Import Products categories, multiple images and custom options
-
12905 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 92 92i have found the way: /app/code/community/CapacityWebSolutions/ImportProduct/Model/Convert/Adapter/Product.php second decisions works fine, thanks to author very much!! February 1, 2012What file to change to do as below? Please tip me for way in magento 1.5.01. Dear developers, please include it to base function: "TangLiang Yes,it works fine on 1.5+,but here is a problem,when you import the csv twice or more,the custom option will import twice or more. here is the solution: below $product-gt;save().add this /* Remove existing custom options attached to the product */ foreach ($product-gt;getOptions() as $o) { $o-gt;getValueInstance()-gt;deleteValue($o-gt;getId()); $o-gt;deletePrices($o-gt;getId()); $o-gt;deleteTitles($o-gt;getId()); $o-gt;delete(); } i hop this will help somebody!" February 1, 2012Its work on magento 1.6.1 but i have problem with Cloud Zoom Pro. I must disable module to see images :( January 17, 2012This works BEAUTIFULLY for me! I was even able to add some custom attributes to the CSV and they imported into Magento perfectly. For those who cannot see products: if you are managing stock, may sure you have 'in-stock' selected in the product's drop down menu. I think 'out-of-stock' is the Magento default, therefore, no products will show in the front end. For those with media problems: Sorry, only advice I can give is to check your syntax for both the image names (no spaces, etc) and in the CSV (proper file extension [jpg/gif/png], syntax in the spreadsheet cell [/;] This extension has been a real life saver. Thank you and I have donated! January 13, 2012Thankyou so much, this is just such a great addon. December 31, 2011Imported a bunch of products, and the categories appear on the website just fine. However, no products populate in the website even after clearing cache, and reindexing. Help! December 24, 2011I have done a fresh install of my magento site. For older product images in older CSV's I put images into media/import the CSV and it pics up images fine. For newer images I am putting in to media/import and loading in the CSV it does not recognize the images and says 'image does not exist' any ideas please? thanks December 1, 2011Thanks share, but it don't work on version 1.6.1 November 29, 2011Hy Great module but i have a few questons: I have a few Attribute like Gen and has 3 options: Boy, girl and Unisex. How can i add to a product for example that can be used by a boy Best Regards, Stefan November 24, 2011In case someone else is wondering; yes the module allows you to import a product with multiple categories. I thought this wasn't the case, but when I opened the PHP file I found out that it does an explode. However please note that the delimiter is not a semicolon but a comma!! None of this is mentioned in the docs. Here's an example of a categories field: Products/DVDs,Products/DVDs/Animation Again, note the comma! October 25, 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 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
