capacityweb

Import Export Products with categories, multiple images and custom options

  • Popularity Score 13920 Popularity Score

    Popularity ScoreReferrals to Site/Downloads

    0 0 1+ 1+ 250+ 250+ 1000+ 1000+ 10000+ 10000+

This extension can use to import export products with categories, multiple images and custom options from CSV
Compatible with:
This extension is currently unavailable on Magento Connect. Please contact the developer.

You will be re-directed to the developer's website to complete your purchase.

You must be registered and logged in to get extension key.
In order to get this extension, you must be logged in to the Magento Community. Click here to login or register.
In order to get this extension, you must have active Magento Go Store. Click here to create Go store.

Magento Connect 2.0

Magento Connect 2.0

$50.00
Overview

Import Export Products with categories, multiple images and custom options

You can use this extension to import export products with categories, multiple images and custom options from CSV file. This extension also provide export products feature. 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.

Our newer version 2.1 provide below new features :-

  • Now you can import these types of products :- Simple, Configurable, Bundle, Grouped, Virtual and Downloadable Products.
  • Import Related, Cross Sell and Up sell Products.
  • Import Group Price for products.
  • Import Tier Price for products.
  • Support Multi Website, Multi Store and Multi Store View for Import Products.
  • Give options All Fields Export, Export Only Image Related Fields, Export Only Price Related Fields and Export Only Quantity Related Fields in export.

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.

Download Sample CSV ( Different CSV file formats for import products, update price, update quantity etc…)

Download Documentation ( Explain Installation Steps and how to use this extension with snapshots into this pdf manual )

Explanation regarding Import Custom Options for Products :-

Custom Option Format:

cws!{custom_option_name}:{custome_option_type}:{is_require}:{sort_order}

{custom_option_name}: Here enter custom option name.

{custome_option_type}: Here enter custom option type.

For example: dropdown, text field, file or date type. Here some code is written.

File = file

Text Field = field

Text Area = area

Date = date

Time = time

Date & time = date_time

Drop Down= drop_down

Radio Button= radio

Checkbox= checkbox

Multi Select= multiple

{is_require}: which is used for define that custom option is require or not.

There are just two values 1 and 0

1 = Yes

0 = No

{sort_order}: Here enter custom option sort order.

Examples:-

1. Dropdown

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:0 (Column Heading)

Size = custom option name

drop_down = control name

1 = mandatory filed. (0 for optional field)

0 = sort order.

Under this column enter value of custom option separated by pipe sign (|) as per example.

E.g. XS:fixed:5:pro-111:0|S:percent:2:pro-222:1|M::::2

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.

===================================================

2. Checkbox

cws!Size:checkbox:1:0 (Column Heading)

Size = custom option name

checkbox = control name

1 = mandatory filed. (0 for optional field)

0 = sort order.

Under this column enter value of custom option separated by pipe sign (|) as per example.

E.g. Small1:fixed:10:pro-111:0|Medium2:percent:5:pro-222:1|Large2:fixed:10::0

===================================================

3. Radio

cws!Size:radio:1:0 (Column Heading)

Size = custom option name

radio = control name

1 = mandatory filed. (0 for optional field)

0 = sort order.

Under this column enter value of custom option separated by pipe sign (|) as per example.

E.g. Small3:fixed:5:pro-111:1|Medium3:percent:2:pro-222:1|Large3:fixed:1::2

===================================================

4. Multiple

cws!Size:multiple:1:0 (Column Heading)

Size = custom option name

multiple = control name

1 = mandatory filed. (0 for optional field)

0 = sort order.

Under this column enter value of custom option separated by pipe sign (|) as per example.

E.g. Small4:fixed:12:pro-111:0|Medium4:fixed:5 :pro-222:1|Large4:fixed:1::2

===================================================

5. Area

cws!Size:area:1:0 (Column Heading)

Size = custom option name

area = control name

1 = mandatory filed. (0 for optional field)

0 = sort order.

Under this column enter value of custom option separated by pipe sign (|) as per example.

E.g. |:fixed:101::20
Here 20 is max input character for text area

===================================================

6. Date

cws!Delivery Date:date:1:0 (Column Heading)

Delivery Date = custom option name

date = control name

1 = mandatory filed. (0 for optional field)

0 = sort order.

Under this column enter value of custom option separated by pipe sign (|) as per example.

E.g. |:fixed:31:pro-111

===================================================

7. Date and Time

cws!Delivery Date and Time:date_time:1:0 (Column Heading)

Size DateTime = custom option name

date_time = control name

1 = mandatory filed. (0 for optional field)

0 = sort order.

Under this column enter value of custom option separated by pipe sign (|) as per example.

E.g. |:fixed:31:pro-111

===================================================

8. Field

cws!Size:field:1:0 (Column Heading)

Size = custom option name

field = control name

1 = mandatory filed. (0 for optional field)

0 = sort order.

Under this column enter value of custom option separated by pipe sign (|) as per example.

E.g. fixed:10:pro-111:20

===================================================

Explanation regarding Import Categories and Assign Categories for Products:-

To 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

Movie=parent category

Cartoon=child category of Movie category.

If you want to add multiple categories 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.

Note : Our extension automatically assign products to the categories while import the products

After install extension Go to

1) Go to Menu Import/Export -> Import Products

2) 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.

Support

Need help? Please contact us at magento@capacitywebsolutions.com

Release Notes

Our extension support multiple type of products like simple, configurable, bundle, grouped, virtual and downloadable products

2014-09-04 06:19:01
  • Version number: 2.1
  • Stability: Stable
  • Compatibility: 1.6, 1.6.1, 1.6.2.0, 1.7, 1.8, 1.8.1, 1.9
  • Now you can import these types of products :- Simple, Configurable, Bundle, Grouped, Virtual and Downloadable Products.
  • Import Related, Cross Sell and Up sell Products.
  • Import Group Price for products.
  • Import Tier Price for products.
  • Support Multi Website, Multi Store and Multi Store View for Import Products.
  • Give options All Fields Export, Export Only Image Related Fields, Export Only Price Related Fields and Export Only Quantity Related Fields in export.

Import Export Products

2014-06-05 14:56:06
  • Version number: 2.0
  • Stability: Stable
  • Compatibility: 1.5, 1.6, 1.6.1, 1.6.2.0, 1.7, 1.8, 1.8.1, 1.9
Separate Menu
Export Products feature
All type of Sample CSV files
Detail documentation for installation and using extensions with snapshots.
Fixed bugs

This extension can import product with custom option, category and multiple images

2012-02-06 09:05:45
  • Version number: 1.1.2
  • Stability: Stable
  • Compatibility: 1.3, 1.4, 1.4.1.1, 1.4.2, 1.5
This extension can import product with custom option, category and multiple images

This extension can import product with custom option, category and multiple images

2010-08-30 15:40:22
  • Version number: 1.1.1
  • Stability: Stable
  • Compatibility: 1.3, 1.4, 1.4.1.1, 1.4.2, 1.5
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 Export Products with categories, multiple images and custom options 4 5 110 110
Worked 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, 2011
Is 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, 2011
Works 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, 2011
I 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, 2011
Ok 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
Works 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, 2011
This 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, 2011
I 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, 2010
This 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, 2010
This 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, 2010
<<prev 7 8 9 10 11 next>>
Q&A
(3 Questions : 0 Answers)

Product Q&A

Ask your questions. Share your answers.

 
 
« Back
 
 
Sort by
Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_26134198
Customer avatar
It is great that we can upload multiple images in a row, but how to update image sort order?
by
soundreality
-
1 year, 9 months ago
0points
0out of 0found this question helpful.
Was this helpful?Yes0No0
Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_26343743
Customer avatar
i have magento version 1.4.1.1 and want to upgrade to the new version of magento which is 1.7 or 1.8.
Will this product work to export from the old version to the new?
I need to export/import multiple photos, custom options, etc.
by
kinesis
-
1 year, 1 month ago
0points
0out of 0found this question helpful.
Was this helpful?Yes0No0
Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_27486480
Customer avatar
I have two websites (Live and Test/Dev)

Will the licence for this extension be valid for use on both my sites?
by
mrhussain
-
6 months ago
0points
0out of 0found this question helpful.
Was this helpful?Yes0No0
1 of 1
1 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.

In order to upload extension, you must be logged in to the Magento Community. Click here to login or register.

Close

Register

* Required Fields

Close window

Forgot Your Password?

Please enter your email below and we'll send you a new password.

* Required Fields

Close window

Login

To upload extension you must be logged in.

* Required Fields

Close window

You are using an outdated browser

We built Magento Connect using the latest techniques and technologies.
This makes Magento Connect faster and easier to use.
Unfortunately, your browser doesn't support those technologies.
Use the links below to download a new browser or upgrade your existing browser.