Table of Contents
- Overview
- A. Note Before Use Extension
- B. Create profile
-
C. Field Mapping
- I. Field mapping for Configurable Product
- II. Field mapping for Bundle Product
- III. Field mapping for Downloadable Product
- IV. Field mapping for Group Product
- V. Field mapping for Tier Pricing
- VI. Field mapping for Group Pricing
- VII. Field mapping for Product Tags
- VIII. Field mapping for Related Products
- IX. Field mapping for Up-sells
- X. Field mapping for Cross-sells
- XI. Field mapping for Gallery Images
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
- Format type for export and import
-
Chmod 777 for some folder:
- var/import
- var/export
- media
- Upload all image in path: media/import.
- Upload all file for product downloadable in path: media/import/downloadable.
B. Create profile
I. Create export profile
- Go to menu: Mlx ~> Dataflow(Extended)
- Click button "Add New Profile"
-
Please do as image follow
II. Create import profile
- Go to menu: Mlx ~> Dataflow(Extended)
- Click button "Add New Profile"
-
Please do as image follow
C. Field Mapping
I. Field mapping for Configurable Product
a. Product Children
- Column name: configurable_product
- Format type: Type 1
- Data Item: Item are product sku
- Example: ana_3,ana_4,ana_5,ana_6,ana_7,ana_8,ana_9
b. Options
- Column name: configurable_option
- Format type: Type 2
- Data Item: Item are attributes use for configurable product
-
Fields:
Code Required Value Type attribute_code Yes Attribute code label Yes Attribute label position No Number: position display - Example: [attribute_code::shoe_size][label::Shoe Size][position::0]
c. Option value
- Column name: configurable_option_value
- Format type: Type 2
- Data Item: Item are value for each configurable_option
-
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 - Example: [attribute_code::shoe_size][label::3][is_percent::0][pricing_value::]
II. Field mapping for Bundle Product
a. Options
- Column name: bundle_options
- Format type: Type 2
- Data Item: Item are values for each option.
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 - Example: [required::1][position::1][type::select][title::Case][delete::0]
b. Bundle Selections
- Column name: bundle_selections
- Format type: Type 3
- Data Item: Item are field for each selection
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 - 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
- Column name: downloadable
- Format type: Type 2
- Data Item: Item are field for each downloadable link.
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 - 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
- Column name: grouped
- Format type: Type 2
- Data Item: Item are values for each associated product.
Fields:
Field Name Required Value Type sku Yes Sku of associated products position No Number. Default is 0 - Example: [sku::1113][position::0]
V. Field mapping for Tier Pricing
- Column name: tier_price
- Format type: Type 2
- Data Item: Item are field for each tier price.
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. - Example: [website_id::0][cust_group::0][price::2.99][price_qty::1]
VI. Field mapping for Group Pricing
- Column name: group_price
- Format type: Type 2
- Data Item: Item are field for each group price.
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 - Example: [website_id::0][cust_group::0][price::1.9900]
VII. Field mapping for Product Tags
- Column name: tags
- Format type: Type 2
- Data Item: Item are field for each tag.
Fields:
Field Name Required Value Type name Yes Tag name store Yes ID of store - Example: [name::bed][store::1]
VIII. Field mapping for Related Products
- Column name: related_product
- Format type: Type 1
- Data Item: Item are product sku
- Example: 384822,bar1234
IX. Field mapping for Up-sells
- Column name: up_sells
- Format type: Type 1
- Data Item: Item are product sku
- Example: 384822,4fasd5f5
X. Field mapping for Cross-sells
- Column name: cross_sells
- Format type: Type 1
- Data Item: Item are product sku
- Example: bar1234,4fasd5f5
XI. Field mapping for Gallery Images
- Column name: gallery
- Format type: Type 2
- Data Item: Item are field for each images.
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 - Example: [file::/t/h/the-get-up-kids-band-camp-pullover-hoodie.jpg][label::][position::0][disabled::0]