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 92Hello ! First, Thank you for the pluggin ! it's very convenient for simple product. UnfortunAtly, i didn't manage to import configurable product with multiple image... Could you help me or send me an exemple of CSV that i could use with your module ? Thank you again for your help October 21, 2012Magento import multiple images SOLVED After spending hours trying to get the gallery images to work in the CSV product import though dataflow I have up and looked for an extension. I found this it installed in a few seconds and worked first shot! Also it solved the issue: Magento product import duplicate images. October 10, 2012Eveything works fine with the upload. However, when I go to re-download the spreadsheet the custom option columns do not exist and the images are reverted back to how magento sets them /a/b/image.jpg. So now if I was to re-upload this then it would get rid of the product options and images. Is there any way this does not happen? October 3, 2012The app worked like a charm. Also good support, my questions where answered within a day. I have some bulk import for my site, so this is the tool September 21, 2012we finally give up this extension, and develop our owns. if you are thinking about bulk import products, you may met with the following troubles: 1) the extension can not import images 2) custom options not workings 3) can not work with multi-store 4) the import process is extremely slow until you want to give it up! initially we use this extension, but it takes me at least 1.5 month to communicate with capacityweb to solve the problem. and FINALLY I GIVE UP because it's not working. if you are still face the trouble, just let me know, maybe i can help. Good Lucky! September 14, 2012just purchased and tested but size option is not appear on front end . and category is not defined ( format ; Men/Shirt ) August 21, 2012Purchased this today, received it within minutes and very simple install by FTP (no files are replaced). My main reason for purchase was to use it for importing multiple images (Gallery). We have about 150 products that share the same images, so by just using SKU, Image and Gallery on the CSV we were able to get everything imported within minutes. I'm looking forward to trying its other import features soon, and should save us a great deal of time. Thank for the excellent service guys :) Magento 1.7.0.2 August 20, 2012great easy tool, I was having all sorts of trouble with the default magento Import/Export Profile 1.7.02, spent many hours with no luck, this extension took 2 minutes to start the import and all my categories were imported with the 11k+ products, thankyou July 18, 2012Works like a charm! Had to convert proprietary mySQL data to Magento. Wrote a script, fine tuned it and imported it with this extension. Saved days! Tx June 17, 2012And i will not recommend any person to buy this extension before they fix the serious bugs! you will face trouble once you use this extension. June 13, 2012- 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
