capacityweb

Import Export Products with categories, multiple images and custom options

  • Popularity Score 13907 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
I am also getting same problem, its duplicating custom options can someone help please :) v 1.5.1.0 September 19, 2011
i'm having a problem, its duplicating custom options can someone help please :) v 1.5.1.0 September 18, 2011
Hello, very nice extension. It works very good for me. One question: is it possible to import the image label for each product on the gallery? This could be very good for SEO. Is it possible? August 22, 2011
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! August 8, 2011
Hi, I can't use the gallery option. I put it in like described "gallery" and /17002_1.jpg;/17002_2.jpg;/17002_3.jpg The pictures reside in /media/import But somehow only one image gets imported (and that's what I specified under image, thumbnail, etc.) Any ideas? July 29, 2011
This seems to work fine. One question ... what is the behavior if a category already exists. Do products get added to the existing category or is a duplicate category created. The latter seemed to be occurring when I tried it. In other words, I ended up with 2 categories with the same name with the second one having the correct products in it. July 26, 2011
Great extension - working a treat in 1.5. It seems that the disabled column in the spreadsheet corresponds to the 'Exclude' flag in the images tab of the Product. However, when I set disabled to 1, it does not 'Exclude' the image. I have also tried 'yes' and 'true' in this column but no effect on the 'Exclude' flag in the Product image. July 10, 2011
I can not use the "custom option" of this extension. My magento version is 1.4.1.0. Is this extension not working on 1.4.1.0.please help me June 13, 2011
:( it does not work... i get an error line without an error (online the red line). the image i saved in the right folder. the import tool makes the categories, but no article import. May 25, 2011
Hi There i cannot use the custom option of this extension in 1.4.1.1 - any help would be appreciated! May 6, 2011
<<prev 6 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, 8 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.