\u6bcf\u6b21\u5bfc\u5165\u90fd\u8bf4\u6709\u9519\uff0c\u8fd9\u91cc\u6709\u4e2a\u5b57\u6bb5\u8bf4\u660e\u3002\u539f\u6587\u5730\u5740<\/p>\n
https:\/\/firebearstudio.com\/blog\/the-complete-guide-to-magento-2-product-import-export.html<\/a><\/p>\n \u5b57\u6bb5\u8bf4\u660e<\/p>\n The CSV File Structure<\/p>\n Let\u2019s have a look at CSV file structure for Magento 2 product import. Below, you can find a detailed description of its columns.<\/p>\n sku <\/strong>\u2013 a unique product identifier used as a key product attribute in the Magento 2 core. It is required for all products and should be unique for each of them. sku can include both digits and letters without spaces separated with underscores (_) and dashes (-). \u552f\u4e00\u7684\u6807\u793a\u3002\u5b57\u6bcd\u548c\u6570\u5b57\u3002\u4e0d\u5e26\u7a7a\u683c\u3002\u5141\u8bb8\u4e0b\u5212\u7ebf\u548c\u6a2a\u7ebf\u3002<\/p>\n store_view_code<\/strong> \u2013 an associated store view code. The column can be empty if an associated store \/ website have a single sub item.<\/p>\n attribute_set_code<\/strong> \u2013 a product attribute set code. Create and configure an attribute set before importing products into Magento 2. It should look exactly the same as an attribute set name including capital letters (e.g. \u201cDefault\u201d, \u201cMan shoes\u201d etc.) price<\/strong> – a price of a product (e.g. 34.000). \u4ef7\u683c \u6bcf\u6b21\u5bfc\u5165\u90fd\u8bf4\u6709\u9519\uff0c\u8fd9\u91cc\u6709\u4e2a\u5b57\u6bb5\u8bf4\u660e\u3002\u539f\u6587\u5730\u5740 https:\/\/firebears … \u7ee7\u7eed\u9605\u8bfb
\nproduct_type<\/strong> \u2013 the type of an imported product. Use only lowercase letters (small, configurable etc.) \u5fc5\u987b\u5c0f\u5199
\ncategories<\/strong> – product categories in Magento 2 differs from ones utilized in Magento 1, where comma separated category ids are used. In Magento 2, full names of assigned categories, including full path, are required. Besides, assigned categories should be separated by |. For instance, \u201cDefault Category\/Gear|Default Category\/Gear\/Bags\u201d means that product should be assigned to both Gear and Bags categories. The latest one is a subcategory of Gear. \u00a0\u548cv1\u7684\u9017\u53f7\u5206\u5272id\u4e0d\u540c\u3002v2\u91cc\u662f\u5206\u7c7b\u7684\u5b8c\u6574\u8def\u5f84\u540d\u79f0\uff0c\u7528|\u5206\u5272\u3002
\nproduct_websites<\/strong> \u2013 an associated product website code. Use lowercase letters only (e.g. \u201cbase\u201d). \u53ea\u80fd\u5c0f\u5199
\nname<\/strong> – a product name.
\ndescription<\/strong> – a product description. \u53ef\u4ee5\u5305\u542bHTML
\nshort_description<\/strong> – a short description of a product. Both, description and short description, could include valid HTML tags.\u53ef\u4ee5\u5305\u542bHTML
\nweight<\/strong> – a weight of a product. Requires using the following format 1.00000.
\nproduct_online<\/strong> – enables or disables products. Use 1 or 0 respectively. \u662f\u5426\u5728\u7ebf\u4ea7\u54c1\u3002\u75281\u6807\u793a\u662f\uff0c0\u8868\u793a\u5426
\ntax_class_name<\/strong> – a product tax class. Allows using capital later and spaces, like in Magento 2 backend (e.g. \u201cTaxable Goods\u201d). \u7a0e\u52a1\u7b49\u7ea7
\nvisibility<\/strong> – a visibility of a product (e.g. \u201cCatalog, Search\u201d, \u201cNot Visible Individually\u201d etc.). \u53ef\u89c1<\/p>\n
\nspecial_price<\/strong> – a special price of a product (e.g. 34.000). \u7279\u4ef7
\nspecial_price_from_date<\/strong> – time when Magento starts using a special price instead of a default one (e.g. \u20192015-09-01 15:26:29\u2019). \u7279\u4ef7\u5f00\u59cb\u65e5\u671f
\nspecial_price_to_date<\/strong> \u2013 time when MAgento stops using a special price (e.g. \u20192015-09-01 15:26:29\u2019). \u7279\u4ef7\u622a\u6b62\u65e5\u671f
\nurl_key<\/strong> – an URL key of product. In case of an empty field, a value is generated automatically based on a product name.
\nmeta_title<\/strong> \u2013 a meta title of a product. \u4ea7\u54c1\u9875meta\u6807\u7b7e\u6807\u9898
\nmeta_keywords<\/strong> – product meta keywords meta\u5173\u952e\u5b57
\nmeta_description<\/strong> – a product meta description meta\u63cf\u8ff0
\nbase_image<\/strong> – the main product\u2019s image and its path. Should be uploaded to \/pub\/media\/import. The path of \/sample_data\/m\/b\/mb01-blue-0.jpg has the following structure: \/pub\/media\/import\/sample_data\/m\/b\/mb01-blue-0.jpg. In addition, you can use a direct URL of an image, such as http:\/\/site.com\/images\/some_image.jpg.
\nbase_image_label – a label of a base product image. \u4e3b\u8981\u56fe\u7247\u8def\u5f84\u3002\u76f8\u5bf9\u8def\u5f84\u6216URL\u8def\u5f84\u3002
\nsmall_image<\/strong> – a name and a path related to a small product image. Should be also uploaded to \/pub\/media\/import. The path of \/sample_data\/m\/b\/mb01-blue-0.jpg has the following structure: \/pub\/media\/import\/sample_data\/m\/b\/mb01-blue-0.jpg. In addition, you can use a direct URL of an image, such as http:\/\/site.com\/images\/some_image.jpg.
\nsmall_image_label – a label of a small product image. \u5c0f\u56fe\u5730\u5740
\nthumbnail_image<\/strong> \u2013 a name and a path related to a thumbnail product image. Should be uploaded to \/pub\/media\/import as well. The path of \/sample_data\/m\/b\/mb01-blue-0.jpg has the following structure: \/pub\/media\/import\/sample_data\/m\/b\/mb01-blue-0.jpg. In addition, you can use a direct URL of an image, such as http:\/\/site.com\/images\/some_image.jpg. \u7f29\u56fe\u5730\u5740
\nthumbnail_image_label<\/strong> – a product thumbnail label \u7f29\u56fe\u6807\u7b7e
\ncreated_at<\/strong> – time when a product was created. Use the following format: yyyy-mm-dd hh-mm-ss (e.g. 2015-09-01 22:26:27). If the field is empty, date and time of data base record are used. \u521b\u5efa\u65e5\u671f\u3002\u6ce8\u610f\u683c\u5f0f\u3002
\nupdated_at<\/strong> – time when a product was updated in. Use the following format: yyyy-mm-dd hh-mm-ss (e.g. 2015-09-01 22:26:27). If the field is empty, date and time of data base record are used. \u66f4\u65b0\u65e5\u671f
\nnew_from_date<\/strong> – sets a product as \u201cnew\u201d from the specified date. Use the following format: yyyy-mm-dd hh-mm-ss (e.g. 2015-09-01 22:26:27). \u5f00\u59cb\u8bbe\u4e3anew\u7684\u65e5\u671f
\nnew_to_date<\/strong> – stops displaying a product as \u201cnew\u201d from the specified date. Use the following format: yyyy-mm-dd hh-mm-ss (e.g. 2015-09-01 22:26:27). \u5b9a\u5236\u8bbe\u4e3anew\u7684\u65e5\u671f
\ndisplay_product_options_in<\/strong> – it is a new feature introduced in Magento 2 which specifies a place on a product page where a block with options should be displayed (e.g. \u201cBlock after Info Column\u201d). V2\u7684\u65b0\u6280\u80fd
\nmap_price<\/strong> \u2013 a minimum price of a product.
\nmsrp_price<\/strong> – a product\u2019s MSRP price.
\nmap_enabled<\/strong> – use it to enable \/ disable a product\u2019s minimum price.
\ngift_message_available<\/strong> – shows that a gift message is available and will be displayed for a particular product.
\ncustom_design<\/strong> \u2013 a custom design of a product page.
\ncustom_design_from<\/strong> – a starting date for a custom design of a product page.
\ncustom_design_to<\/strong> – an end date for a custom design of a product page.
\ncustom_layout_update<\/strong> \u2013 a custom XML layout for a product page
\npage_layout<\/strong> – a product page layout (e.g. 1 Column). If empty the field is empty, a default product layout is used.
\nproduct_options_container<\/strong> \u2013 a product options container.
\nmsrp_display_actual_price_type<\/strong> – a type of a product\u2019s MSRP price.
\ncountry_of_manufacture<\/strong> – a country of origin.
\nadditional_attributes<\/strong> – import of product custom options and data related to a simple product associated to a configurable product. A sample value for a simple product associated to configurable product: \u201ccolor=Red,has_options=0,required_options=0,size_pants=32\u201d (Color attribute is \u201cRed,\u201d simple product has options in Magento 2: has_options = 0 \u2013 no required options, size pants attribute value is 32). A sample value for a configurable product in Magento 2 \u2013 \u201chas_options=1,required_options=1\u201d (Product has required options, simple product SKU is associated in the _associated_sku column ). \u9644\u52a0\u5c5e\u6027
\nqty<\/strong> – a quantity of a particular product in stock. \u5e93\u5b58\u6570
\nout_of_stock_qty<\/strong> – an out of stock quantity of a particular product.
\nuse_config_min_qty<\/strong> – use minimum quantity value from config.
\nis_qty_decimal<\/strong> – set 1 if a quantity can be decimal.
\nallow_backorders<\/strong> – set 1 if backorders are enabled.
\nuse_config_backorders – use a default system value for backorder options (enable \/ disable).
\nmin_cart_qty – a minimum required quantity of a product in shopping cart.
\nuse_config_min_sale_qty – use a default config value for determining a minimum quantity of a sale product.
\nmax_cart_qty \u2013 a maximum quantity of a product in a shopping cart.
\nuse_config_max_sale_qty \u2013 use a default config value to determine a maximum quantity of a product in a shopping cart.
\nis_in_stock \u2013 1 \u2013 a product is in stock, 0 \u2013 a product is out of stock.
\nnotify_on_stock_below \u2013 set a minimum product quantity to start a notification about a low stock level.
\nuse_config_notify_stock_qty \u2013 use a default system value for a product\u2019s low stock notification.
\nmanage_stock – to control a stock quantity of a product set 1. By setting 0 you allow Magento 2 to consider a product has an unlimited stock level.
\nuse_config_manage_stock – use a default system configuration value for stock management.
\nuse_config_qty_increments – use a product quantity increment from current store configuration. Set 1 to enable; set 0 to disable.
\nqty_increments – a product quantity increment.
\nuse_config_enable_qty_inc – use a default store configuration value to enable a product quantity increment.
\nenable_qty_increments – set 1 or 0 to enable or disable product quantity increment.
\nis_decimal_divided – set 1 if a product quantity increment can be decimal.
\nwebsite_id – an associated product website ID
\nrelated_skus<\/strong> – related products SKUs separated with commas (e.g. 24-WG085_Group,24-WG086,24-WG083-blue,24-UG01)
\ncrosssell_skus<\/strong> – cross-sale product SKUs separated with commas (e.g. 24-WG085_Group,24-WG086,24-WG083-blue,24-UG01)
\nupsell_skus<\/strong> – upsallers product SKUs separated with comma (e.g. 24-WG085_Group,24-WG086,24-WG083-blue,24-UG01)
\nadditional_images<\/strong> – additional product images (product media gallery) separated with commas. Images should be uploaded to \/pub\/media\/import. The path of \/sample_data\/m\/b\/mb01-blue-0.jpg has the following structure: \/pub\/media\/import\/sample_data\/m\/b\/mb01-blue-0.jpg. In addition, you can use a direct URL of an image, such as http:\/\/site.com\/images\/some_image.jpg. \u9644\u4ef6\u56fe\u7247
\nadditional_image_labels<\/strong> – \u0421omma separated labels for additional product images from the previous column. \u9644\u52a0\u56fe\u7247\u6807\u7b7e
\n_associated_sku – an associated simple product SKU for a configurable product (several values should be separated with commas).
\n_associated_default_qty – a default quantity for associated products
\n_associated_position – associated products position, based on the _associated_sku column<\/p>\n","protected":false},"excerpt":{"rendered":"