Table of Contents

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.

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

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

products.csv
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 --",,"<p>Our beautiful Rivoli collections are inspired by Eastern classics. Modern classic candleholders with solid brass accents, porcelain, and acrylic base.</p><ul><li>Color: Latte</li><li>Dimensions:14""H x 5""W</li></ul>","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 --",,"<p>Our beautiful Rivoli collections are inspired by Eastern classics. Modern classic candleholders with solid brass accents, porcelain, and acrylic base.</p><ul><li>Color: Terracotta</li><li>Dimensions:14""H x 5""W</li></ul>","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 --",,"<p>Our beautiful Rivoli collections are inspired by Eastern classics. Modern classic candleholders with solid brass accents, porcelain, and acrylic base.</p><ul><li>Color: Navy</li><li>Dimensions:14""H x 5""W</li></ul>","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,,