capacityweb

Import Export Products with categories, multiple images and custom options

  • Popularity Score 13910 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 used this to import custom options to my store. I'm using 1.4.1.1 and it worked perfectly. You do have to set the column "has_options" to 1 or the custom options won't show up. Also, if you want to upload the same product ever again, you have to delete the custom options column or it will duplicated the custom options. Excellent extension! Just read the instructions and some of the reviews here to make sure you're doing it right. November 18, 2010
This is what i did and it worked on 1.4.1.1 1) log in to your admin| system| import/export| export all product 2) my default location for this file was in the mystore.com/magento/var/export/export_all_products.csv 3) open and modify export_all_products.csv (moved file from my server to my local drive to do the edit in excel) 4) add a column to the header (row 1 ) size:drop_down:1:2 I deleted all my products but the 1 test product (product1) i wanted to add options to. size:drop_down:1:2 will match the same fields as if added manually admin | catalog | manage products | product1 | custom options | add new options. Title= size , Input Type=drop_down, Is Required=1 or yes, Sort Order=2 5) row 2 (has all my options for my product1) i added under my new column created in step 4 sm:fixed:0.00:250sm:1|med:fixed:0.00:250med:2 in my admin when input type is drop_down a add new row option becomes available. these fields match above Title=sm, Price Type= fixed, Price=0.00, SKU=250sm, sort order=1 using the pipe | will add a new row for multiple selection options. 6) My default export_all_products.csv file has a column G in row 1 called --- has_options. i needed to enable options in row 2 by setting column g has_options to a 1 for product 1. 7) import the file admin| system| import/export| import all product (i had to upload from my local server and make sure my file name matched the default in import all products.) 8) check admin | catalog | manage products | product1 | custom options www.hookahs4u.com November 18, 2010
when i used to import the sample csv,custom option do not show ,iam uisng version 1.4.1.1 and did not mapping the field size:drop_down:1?pls give me soln?pls help anyone? November 18, 2010
I have been playing with this a few days and this may help. I created 2 columns in my header 1 for color and 1 for size and each of those has 2 selectiions. The fields match the same fields found in the ADMIN|catalog|manage products|custom options. : seperates the fields of an option and the | seperates the optiions. Example of my 'export_all_products.csv' file has_options color:drop_down:1:1 size:drop_down:1:2 1 GREEN:fixed:0.00:250APP:1|BLUE:fixed:0.00:250BLU:2 sm:fixed:0.00:250sm:1|med:fixed:0.00:250med:2 also there is a question below from StuartPica. StuartPica View details I have successfully uploaded products using this tool. My only problem is the Custom Options do not show up until I go into each individual product in Admin and Save the product....this can't be right can it? Help anyone? I had this same issue and found when i exported my file column G (has_options) was set to 0. changing this to a 1 may help. November 15, 2010
I have successfully uploaded products using this tool. My only problem is the Custom Options do not show up until I go into each individual product in Admin and Save the product....this can't be right can it? Help anyone? October 23, 2010
I have downloaded and installed this app for importing over 6000 products with images successfully. HOWEVER, I can now not export any of the products whatsoever. I dont know if this has something to do with this install or if it is a bug in magento 1.4.1.1. However, the export module is not working.. It goes to the screen to loads and just stays there.. No file is created.. Has any1 else had this issue with this extension? Anyone know of a FIX.. I NEED to be able to export my products using mapped fields.. October 22, 2010
On a fresh defaut Magento installatio the status is not being set (it is empty) and the visibility is set to “Not Visible Individually” September 21, 2010
Beware. If you import csv a second time to update products, custom options will be duplicated. Just remove columns. September 17, 2010
1.4.1.1 Image(s) Upload Simply Did Not work with configurable Product. Some one needs to make a stand alone App that will create all the CSV and Images in a easy to upload file.... Million dollar idea... your welcome September 4, 2010
Awsome i will give this extension a try sometime. Keep up the good work sir! August 31, 2010
<<prev 7 8 9 10 11
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.