Magento Fast Product Import User Guide

General installation steps

  1. Backup your web directory and database
  2. Download and unzip extension contents on your computer and navigate inside the extracted folder.
  3. Disable compilation under System->Tools->Compilation if you are using it.
  4. Using your FTP client upload app, skin and js directories to your store root.
  5. Refresh cache
  6. Enable compilation if you are using it.

Your first import

If installation went fine, you should see new menu item under System->Import/Export: Fast Bulk Product Import. First, we need to open Dataflow-Profiles page to create our first import profile.

Dataflow menu

Available options:

General Tab

  • Profile Name - name for future uses
  • Column Mapping - select whether you set valid column headers in first csv row or will define mapping manually through configurator
  • Scope for Attribute Values - select the store for which you would like to import the data
  • Create New Items - select whether you need to create new items or only update existing ones
  • Update Existing Products - select whether you need to update existing products or not
  • Sku Transform Pattern - expression to use if you need to transform the sku from csv, e.g. adding suffix/prefix. {sku} from the pattern will be replaced by the actual sku from csv file. For example, "prefix-{sku}-suffix" will add "prefix-" before and "-suffix" after sku value
  • Create Categories - the flag to create new categories or not
  • Create Options - the flag to create new attribute options for dropdown and multiple select attributes
  • Column Delimiter - delimiter used to separate csv column values
  • Option Delimiter - delimiter used to separate multiple options for multiselect attributes
  • Correction Factor for Options - a value in percents for correction factor. It means if you have a big csv file where some options are named simillary but not exactly the same because of typo or something else and you don't want to process it manually, you can set correction factor and such options will be imported as one option. For example you have "AlfaRomeo" attribute opion. In csv you have "AlfaTomeo" and "AlfqTomeo" options because of typos. You set correction factor to 20% and it means that if 2 options has 80% concurrence they are concidered the same and options will be imported with correct name "AlfaRomeo"

Dataflow general tab

Custom column mapping (active if column mapping setting is set to manual)

You should set mapping for your csv columns and valid Magento attributes. Just put column number (starts from 0) in the first column and correspondent existing Magento attribute in the second.

Import mapping

Fallback attribute values

In case you are missing some attribute values in your csv file (like status, websites etc.), you can set default values to be used during import

Import fallback attributes

Available conditions for fallback:

  • All Products - fallback value will be applied for all products in csv file
  • Only if value is empty - fallback value will be applied for products where attribute value is not found or empty
  • Only if value is not empty - fallback value will be applied for products where attribute value is not empty

Column Transformations

If you need to apply some additional logic to a column value before importing it, you can apply one or several transformations on column value.

Put your column number (starts from 0) into column number field, choose transformation type and put value, if necessary.

Import column transformations

Available transformation types:

  • Uppercase - column value will be transformed to upper case. Example: lorem ipsum -> LOREM IPSUM
  • Lowercase - column value will be transformed to lower case. Example: LORem IPSum -> lorem ipsum
  • Lowercase and Capitilize All - each word in column value will be transformed to lower case and first letter of word - capitilized. Example: lOrem ipSUM -> Lorem Ipsum
  • Capitilize - first letter of value will be capitilized. Example: lorem ipsum -> Lorem ipsum
  • Replace - replacement based on condition set in "Value" field will be applied to column value. "Value" field should have the next format: from_str1,from_str2|to_str1,to_str2. In this case, all occurencies of from_str1 will be replaced with to_str1, and from_str2 - with to_str2. Example: if we have m|t in Value column, lorem ipsum -> loret ipsut
  • Round - column value will be rounded. Example 2.6 -> 3.
  • Round fractions up - column value will be rounded up. Example 2.4 -> 3.
  • Round fractions down - column value will be rounded down. Example 2.6 -> 2.
  • Add - string or number you put in "Value" column will be added to the column value. Example: if we have 10 in Value colum, 20 -> 30
  • Multiply by - column value will be multiplied by a number you put in "Value" column. Example: if we have 1.2 in Value colum, 10 -> 12

Schedule Tab

Running profile

After you set the options you can save profile or "save and run". Running profile will lead you to the page where you can upload necessary csv file and run profile. When import is finished, you see a message with total records found,skipped and imported.

The last step is updating all indexes under System->Index Management to make your store front up to date

List of supported attributes with examples

Note! From version 2.0.3 empty attributes for existing products will be skipped, if you want to remove values, you must set cell value to "unset"

Attribute CodeValue
sku ATRE5035
attribute_set Defatul
type simple|configurable|grouped|bundle|downloadable|virtual
name Nine West Women's Lucero Pump
description This flirty pump has a leather upper, a pretty almond-shaped toe with a slight V-cut vamp
short_description This flirty pump has a leather upper, a pretty almond-shaped toe with a slight V-cut vamp
weight 1.25
status (value must be translated to current locale language) Enabled|Disabled
visibility (value must be translated to current locale language) "Catalog, Search"|Catalog|Search|"Not Visible Individually"
tax_class_id None|Taxable Goods
url_key nine-west-women-s-lucero-pump
news_from_date 2012-12-24
news_to_date 2012-12-24
price 10.99
cost 9.99
special_price 8.88
special_from_date 2012-12-24
special_to_date 2012-12-24
enable_googlecheckout No|Yes
msrp 5.99
meta_title Nine West Women's Lucero Pump
meta_description This flirty pump has a leather upper, a pretty almond-shaped toe with a slight V-cut vamp
meta_keyword "pump, shoes"
custom_design default/blank
custom_design_from 2012-12-24
custom_design_to 2012-12-24
page_layout 1 column
gift_message_available Yes|No
manage_stock 1|0
use_config_manage_stock 1|0
qty 100
min_qty 10
use_config_min_qty 1|0
min_sale_qty 5
use_config_min_sale_qty 1|0
max_sale_qty 5
use_config_max_sale_qty 1|0
is_qty_decimal 0|1
backorders 0|1
use_config_backorders 0|1
notify_stock_qty 0|1
use_config_notify_stock_qty 0|1
enable_qty_increments 0|1
use_config_enable_qty_inc 0|1
use_config_qty_increments 5
qty_increments 5
is_in_stock 0|1
websites (necessary websites codes separated by coma) "base,custom_website"
categories "Category1/Subcategory1,Category2/Subcategory2"
category_ids "1,4,6"
relation (related products) "related_product_sku1,related_product_sku2"
up_sell (up-sell products) "upsell_product_sku1,upsell_product_sku2"
cross_sell (cross-sell products) "cross_sell_product_sku1,cross_sell_product_sku2"
Media attributes. All images must be uploaded to media/import folder, then relative pathes must be used in a csv file
image /red_highheels.jpg
small_image /red_highheels.jpg
thumbnail /red_highheels.jpg
images(additional gallery images can be added here separated by coma) "/green_highheels.jpg,/blue_highheels.jpg"
image_labels(gallery images labels separated by coma. First 3 values are image label, small_image label and thumbnail label, then you should put other images labels in the same order as in "images" column) "image_label,small_image_label,thumbnail_label,other_label"
image_positions(gallery images sort order separated by coma. You should put images sort order for images found in "images" column) "3,1,2"
exclude_images(images for exclude from media gallery on product page) "/green_highheels.jpg,/blue_highheels.jpg"
clear_old_gallery (Removes all images for product) 1|0
Custom attributes examples
manufacturer (dropdown) Acer
color (multiple select) "Black,Red"


Custom Options (use | as separator to create several custom options). Please note, that all existing custom options will be removed.

options_container container1|container2
custom_options {'type':'drop_down','is_require':1,'sku':'custom option','sort_order':'100','title':'Default Title','values':{'1':{'sku':'value sku','sort_order':1,'title':'Default Title','price':100},'2':{'sku':'value sku2','sort_order':2,'title':'Default Title 2','price':200}}}
It will create required dropdown option with 2 values. Required fields here are type, title and values. Sku, is_require and sort_order can be skipped
Supported Options Types
Type code Type Label
drop_down Drop-down
radio Radio Buttons
checkbox Checkbox
multiple Multiple Select
field Text Input
area Textarea
file File input
date Date
date_time Date & Time
time Time


Tier and Group Pricing (use | as separator to create several group/tier pricings)

group_pricing "Customer Group Name,Website Code,Price", e.g. "QAAAA,base,100|Retailer,website2,1000|Wholesale,all,100"
It will create 3 group prices for QAAAA on base webiste, Retailer on website2 and Wholesale on all websites
tier_pricing "Customer Group Name,Website Code,Qty,Price", e.g. "QAAAA,base,10,100|Retailer,website2,20,10"
It will create 2 tier prices for QAAAA on base webiste for qty 10 and price 100, Retailer on website2 for qty 20 and price 10


Configurable products import

options_container container1|container2
configurable_attributes "color,manufacturer"
associated_products "sku1,sku2,sku3"
configurable_pricing (ues | to separate several attributes) "attribute_code:[opion name;price;f - for fixed price or p for percentage]", e.g. "manufacturer:[test manufacturer;5;f]|color:[Black;5;p],[White;10;f]


Grouped products import

associated_simple_products "sku1,sku2,sku3"


Bundle Products

options_container container1|container2
price_type 0|1, 0 - Dynamic, 1 - Fixed
sku_type 0|1, 0 - Dynamic, 1 - Fixed
weight_type 0|1, 0 - Dynamic, 1 - Fixed
bundle_data {'type':'select','required':1,'position':'1','title':'Default Title','selections':{'1':'test1,0,0,0,10.0,2,1','2':'test2,0,0,1,10,2,1'}}
It will create required dropdown option with 2 selections. Required fields here are type, title and selections. required and position can be skipped.
Selections data syntax: sku,position,is_default,price_type,price,qty,can_change_qty
sku Selection product sku
position Selection position
is_default 0|1
price_type 0|1, 0 - fixed, 1- percent
price selection price or percent value
qty selection qty
can_change_qty 0|1 - User Defined Qty value, 0 - No, 1- Yes
Supported Options Types
Type code Type Label
select Drop-down
radio Radio Buttons
checkbox Checkbox
multi Multiple Select


Some example csv files

Simple example csv file with common attributes: Coma-separated or Semicolon-separated

Csv file for stock only updates: Stock Only

Csv file for custom options Custom Options only

Csv file for tier/grouped pricing Tier/Grouped Prices only

Csv file for Configurable/Grouped products Configurable/Grouped products

Csv file for Bundle products Bundle products


Feel free to contact us with any questions.

Back to extension page