Menu

How to use export/import bulk Product for Magento

Table of Contents

Overview

This is document for export/import bulk product. It will help you create profile and create csv with our format for Configurable Product, Bundle Product, Downloadable Product, Group Product, Gallery, Tags, etc...

A. Note Before Use Extension

  1. Format type for export and import
  2. Chmod 777 for some folder:

    • var/import
    • var/export
    • media
  3. Upload all image in path: media/import.
  4. Upload all file for product downloadable in path: media/import/downloadable.

B. Create profile

I. Create export profile

  1. Go to menu: Mlx ~> Dataflow(Extended)
  2. Click button "Add New Profile"
  3. Please do as image follow

II. Create import profile

  1. Go to menu: Mlx ~> Dataflow(Extended)
  2. Click button "Add New Profile"
  3. Please do as image follow

C. Field Mapping

I. Field mapping for Configurable Product

a. Product Children

  1. Column name: configurable_product
  2. Format type: Type 1
  3. Data Item: Item are product sku
  4. Example: ana_3,ana_4,ana_5,ana_6,ana_7,ana_8,ana_9

b. Options

  1. Column name: configurable_option
  2. Format type: Type 2
  3. Data Item: Item are attributes use for configurable product
  4. Fields:

    Code Required Value Type
    attribute_code Yes Attribute code
    label Yes Attribute label
    position No Number: position display

  5. Example: [attribute_code::shoe_size][label::Shoe Size][position::0]

c. Option value

  1. Column name: configurable_option_value
  2. Format type: Type 2
  3. Data Item: Item are value for each configurable_option
  4. Fields:

    Code Required Value Type
    attribute_code Yes Attribute code
    label Yes Label of value
    is_percent No 1 is Yes or 0 is No. Default 0
    pricing_value No Float. Default 0

  5. Example: [attribute_code::shoe_size][label::3][is_percent::0][pricing_value::]

II. Field mapping for Bundle Product

a. Options

  1. Column name: bundle_options
  2. Format type: Type 2
  3. Data Item: Item are values for each option.
  4. Fields:

    Code Required Value Type
    title Yes Option title
    type Yes Value: select, radio, checkbox, multi
    required No Yes is 1, No is 0.
    position No Number: position display
    delete No Delete is 1. Default 0

  5. Example: [required::1][position::1][type::select][title::Case][delete::0]

b. Bundle Selections

  1. Column name: bundle_selections
  2. Format type: Type 3
  3. Data Item: Item are field for each selection
  4. Fields:

    Code Required Value Type
    sku Yes Sku of product
    can_change_qty No Can change qty is 1. Default 0
    qty Yes Number qty to add
    position No Number: position display
    is_default No Is default is 1. Default 0
    delete No Delete is 1. Default 0

  5. Example: [sku::apevia-black][can_change_qty::0][qty::1.0000][position::0][is_default::0][delete::0];[sku::nzxtlexa][can_change_qty::0][qty::1.0000][position::0][is_default::0][delete::0]

III. Field mapping for Downloadable Product

  1. Column name: downloadable
  2. Format type: Type 2
  3. Data Item: Item are field for each downloadable link.
  4. Fields:

    Field Name Required Value Type
    title Yes Link title
    price No Float. Default 0
    type Yes file or url
    file Yes Required if type is file
    link_url Yes Required if type is url
    number_of_downloads No Number. If value is 0, the max download will unlimited. Default is 0.
    is_shareable No 0 is No, 1 is Yes, 2 is Use config
    sort_order No Number
    is_delete No Delete is 1. Default 0

  5. Example: [title::Link 1][price::10.0000][type::url][file::][link_url::http://test.com/][number_of_downloads::0][is_shareable::2][sort_order::0][is_delete::]

IV. Field mapping for Group Product

  1. Column name: grouped
  2. Format type: Type 2
  3. Data Item: Item are values for each associated product.
  4. Fields:

    Field Name Required Value Type
    sku Yes Sku of associated products
    position No Number. Default is 0

  5. Example: [sku::1113][position::0]

V. Field mapping for Tier Pricing

  1. Column name: tier_price
  2. Format type: Type 2
  3. Data Item: Item are field for each tier price.
  4. Fields:

    Field Name Required Value Type
    website_id Yes Integer. ID website, default 0.
    cust_group Yes Integer. ID customer group, default 0.
    price Yes Float. Default is 0
    price_qty Yes Number. Quality allow price.

  5. Example: [website_id::0][cust_group::0][price::2.99][price_qty::1]

VI. Field mapping for Group Pricing

  1. Column name: group_price
  2. Format type: Type 2
  3. Data Item: Item are field for each group price.
  4. Fields:

    Field Name Required Value Type
    website_id Yes Integer. ID website, default 0.
    cust_group Yes Integer. ID customer group, default 0.
    price Yes Float. Default is 0

  5. Example: [website_id::0][cust_group::0][price::1.9900]

VII. Field mapping for Product Tags

  1. Column name: tags
  2. Format type: Type 2
  3. Data Item: Item are field for each tag.
  4. Fields:

    Field Name Required Value Type
    name Yes Tag name
    store Yes ID of store

  5. Example: [name::bed][store::1]

VIII. Field mapping for Related Products

  1. Column name: related_product
  2. Format type: Type 1
  3. Data Item: Item are product sku
  4. Example: 384822,bar1234

IX. Field mapping for Up-sells

  1. Column name: up_sells
  2. Format type: Type 1
  3. Data Item: Item are product sku
  4. Example: 384822,4fasd5f5

X. Field mapping for Cross-sells

  1. Column name: cross_sells
  2. Format type: Type 1
  3. Data Item: Item are product sku
  4. Example: bar1234,4fasd5f5

XI. Field mapping for Gallery Images

  1. Column name: gallery
  2. Format type: Type 2
  3. Data Item: Item are field for each images.
  4. Fields:

    Field Name Required Value Type
    file Yes path file in "your_source/media/import"
    label No Label of image.
    position No Number. Default is 0
    disabled No Disabled is 1. Default is 0

  5. Example: [file::/t/h/the-get-up-kids-band-camp-pullover-hoodie.jpg][label::][position::0][disabled::0]

- How to use export/import with ssh or cron for magento?