Magento Import Export Products with categories, multiple images and custom options

Compatibility (Magento CE): 1.6, 1.6.1, 1.6.2.0, 1.7, 1.8, 1.8.1, 1.9

$89.00

Rating:

You can use this magento 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.

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

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

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

Go to Menu Import/Export -> Import Products
Click on Upload File from left menu
Upload csv file and Click on Save and Continue button
Click on run profile
Select your uploaded file
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

Portfolio