======Default columns====== =====Product Attributes===== Bellow are default attributes that can be found in Magento. If you use different Magento version the list will vary according your instalation attributes. Many modules and customizations add additional attributes which will be also visible in Import Columns tab of your import profile. Any attributes with * are required by default to create a product. ====*sku==== SKU is the only required attribute for any product import regaqrdless if you create or update a product. Any of the other attributes can be updated on its own if needed as long as you have SKU column to identify the product. ====custom_design_from==== ====custom_design_to==== ====gift_message_available==== ====msrp_enabled==== ====image==== ====color==== ====cost==== ====country_of_manufacture==== ====custom_design==== ====custom_layout_update==== ====*description==== ====msrp_display_actual_price_type==== ====options_container==== ====is_recurring==== ====group_price==== ====enable_googlecheckout==== ====manufacturer==== ====msrp==== ====meta_description==== ====meta_keyword==== ====meta_title==== ====*name==== ====page_layout==== ====*price==== ====*price_view==== Only required for bundle products, the other product types can skip it. ====recurring_profile==== ====news_from_date==== ====news_to_date==== ====*short_description==== ====small_image==== ====special_price==== ====special_from_date==== ====special_to_date==== ====*status==== ====*tax_class_id==== ====thumbnail==== ====tier_price==== ====url_key==== ====*visibility==== ====*weight==== =====Hidden Attributes===== The following are product attributes that you cannot edit directly in Magento admin. ====image_label==== This image lable is not used anywhere to our knowledge. The one showed in image gallery in admin and frontend is not this attribute. ====links_purchased_separately==== ====links_title==== ====samples_title==== ====small_image_label==== This image lable is not used anywhere to our knowledge. The one showed in image gallery in admin and frontend is not this attribute. ====thumbnail_label==== This image lable is not used anywhere to our knowledge. The one showed in image gallery in admin and frontend is not this attribute. ====created_at==== ====links_exist==== ====old_id==== ====price_type==== ====shipment_type==== ====sku_type==== ====updated_at==== ====url_path==== ====weight_type==== =====Price===== Prices taken from price index table. ====price.final==== ====price.maximum==== ====price.minimal==== =====System Attributes===== These are not product attributes but product properties ====*product.attribute_set==== Attribute set to which a product belongs, valid attributes will depend on this value. If you import attributes which are not in the attribute set selected, they will not be imported by default. ====product.configurable_parent_sku==== This is **not** used to relate simple and configurable products, we allow it because it is in Magento but Rapidflow is not using it. ====product.entity_id==== This is internal product id. It is an option to have in export, but a product cannot be targeted by it in import profile. You can not change it as well. ====product.has_options==== Whether product has custom options ====product.required_options==== Or required custom options ====*product.type==== Product type, one of ''simple, configurable, virtual, downloadable, bundle'' ====product.websites==== Websites code ''base,german'', not store view code but websites codes. =====Category===== There are few options for category export/import By default you separate multiple values with **;** ====category.ids==== You can export import product category IDs - 3;4;5 ====category.name==== Categoy names - ''Cat One;Cat Two;Cat One>Cat Three'' Category hierarchies are built via **>** character, in the example above, **Cat Three** is child of **Cat One** and it will be created under it if it doesn't exist and the setting for auto creating categories is enabled. ====category.path==== Category url pats - ''cat-one;cat-two;cat-one/cat-three'' Use category url path to represent hierarchy =====Inventory Stock===== Stock data, it is not part of product attributes but a separate table in database. ====stock.backorders==== ====stock.enable_qty_increments==== ====stock.addqty==== ====stock.is_in_stock==== ====stock.is_qty_decimal==== ====stock.manage_stock==== ====stock.max_sale_qty==== ====stock.min_qty==== ====stock.min_sale_qty==== ====stock.notify_stock_qty==== ====stock.qty_increments==== ====*stock.qty==== ====stock.stock_status_changed_automatically==== ====stock.use_config_backorders==== ====stock.use_config_enable_qty_increments==== ====stock.use_config_manage_stock==== ====stock.use_config_max_sale_qty==== ====stock.use_config_min_sale_qty==== ====stock.use_config_min_qty==== ====stock.use_config_qty_increments==== ====stock.use_config_notify_stock_qty==== =====Constant===== Constant fields matter only for exports ====const.value==== Constant value, arbitrary constant value you may want to add to export (your brand for example) ====const.function==== Constant (not exactly) function. A string that resolves to a call back - ''Some_Class::callback'' Where ''callback'' is a method that accepts current row, column and store id as parameters: class Some_Class { public function callback($product, $columnInfo, $storeId) } =====Example file===== sku,custom_design_from,custom_design_to,gift_message_available,msrp_enabled,image,color,cost,country_of_manufacture,custom_design,custom_layout_update,description,msrp_display_actual_price_type,options_container,is_recurring,group_price,enable_googlecheckout,manufacturer,msrp,meta_description,meta_keyword,meta_title,name,page_layout,price,price_view,recurring_profile,news_from_date,news_to_date,short_description,small_image,special_price,special_from_date,special_to_date,status,tax_class_id,thumbnail,tier_price,url_key,visibility,weight,image_label,links_purchased_separately,links_title,samples_title,small_image_label,thumbnail_label,created_at,links_exist,old_id,price_type,shipment_type,sku_type,updated_at,url_path,weight_type,price.final,price.maximum,price.minimal,product.attribute_set,product.configurable_parent_sku,product.entity_id,product.has_options,product.required_options,product.type,product.websites,category.ids,category.name,category.path,stock.backorders,stock.enable_qty_increments,stock.addqty,stock.is_in_stock,stock.is_qty_decimal,stock.manage_stock,stock.max_sale_qty,stock.min_qty,stock.min_sale_qty,stock.notify_stock_qty,stock.qty_increments,stock.qty,stock.stock_status_changed_automatically,stock.use_config_backorders,stock.use_config_enable_qty_increments,stock.use_config_manage_stock,stock.use_config_max_sale_qty,stock.use_config_min_sale_qty,stock.use_config_min_qty,stock.use_config_qty_increments,stock.use_config_notify_stock_qty,const.value,const.function PO170LT,,,,"Use config",/A/C/ACES-074-04b.jpg,Latte,," ","-- Please Select --",,"

Our beautiful Rivoli collections are inspired by Eastern classics. Modern classic candleholders with solid brass accents, porcelain, and acrylic base.

","Use config","Block after Info Column",No,,Yes,Port68,,,,,"Rvoli Candleholder-Latte","No layout updates",174.0000,,,,,"dolor sit amet",/A/C/ACES-074-04b.jpg,,,,Enabled,"Taxable Goods",/A/C/ACES-074-04b.jpg,,rivoli-candleholder-latte,"Not Visible Individually",0.0000,,,,,,,"2013-08-06 11:46:50",0,,,,,"2013-08-06 11:46:50",rivoli-candleholder-latte.html,,174.0000,174.0000,174.0000,Default,,590,No,No,simple,base,3,Sample,sample.html,"No Backorders",No,,"In Stock",No,Yes,0.0000,0.0000,1.0000,,0.0000,500.0000,,Yes,,No,Yes,Yes,Yes,Yes,Yes,, PO170TC,,,,"Use config",/A/C/ACES-074-05b.jpg,Terracotta,," ","-- Please Select --",,"

Our beautiful Rivoli collections are inspired by Eastern classics. Modern classic candleholders with solid brass accents, porcelain, and acrylic base.

","Use config","Block after Info Column",No,,Yes,Port68,,,,,"Rivoli Candleholder-Terracotta","No layout updates",174.0000,,,,,"dolor sit amet",/A/C/ACES-074-05b.jpg,,,,Enabled,"Taxable Goods",/A/C/ACES-074-05b.jpg,,rivoli-candleholder-terracotta,"Not Visible Individually",0.0000,,,,,,,"2013-08-06 11:46:53",0,,,,,"2013-08-06 11:46:53",rivoli-candleholder-terracotta.html,,174.0000,174.0000,174.0000,Default,,591,No,No,simple,base,3,Sample,sample.html,"No Backorders",No,,"In Stock",No,Yes,0.0000,0.0000,1.0000,,0.0000,500.0000,,Yes,,No,Yes,Yes,Yes,Yes,Yes,, PO170NV,,,,"Use config",/A/C/ACES-074-06b.jpg,Navy,," ","-- Please Select --",,"

Our beautiful Rivoli collections are inspired by Eastern classics. Modern classic candleholders with solid brass accents, porcelain, and acrylic base.

","Use config","Block after Info Column",No,,Yes,Port68,,,,,"Rivoli Candleholder-Navy","No layout updates",174.0000,,,,,"dolor sit amet",/A/C/ACES-074-06b.jpg,,,,Enabled,"Taxable Goods",/A/C/ACES-074-06b.jpg,,rivoli-candleholder-navy,"Not Visible Individually",0.0000,,,,,,,"2013-08-06 11:46:56",0,,,,,"2013-08-06 11:46:56",rivoli-candleholder-navy.html,,174.0000,174.0000,174.0000,Default,,592,No,No,simple,base,3,Sample,sample.html,"No Backorders",No,,"In Stock",No,Yes,0.0000,0.0000,1.0000,,0.0000,500.0000,,Yes,,No,Yes,Yes,Yes,Yes,Yes,,