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 Buld 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
  • 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

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
custom_layout_update  
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"
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"

 

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

 

Feel free to contact us with any questions.

Back to extension page