This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
urapidflow:columns [2013/09/25 22:02] jamby77 |
urapidflow:columns [2016/11/01 20:06] (current) jamby77 [Default columns] |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ======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 '' | ||
+ | ====product.websites==== | ||
+ | Websites code '' | ||
+ | =====Category===== | ||
+ | There are few options for category export/ | ||
+ | By default you separate multiple values with **;** | ||
+ | ====category.ids==== | ||
+ | You can export import product category IDs - 3;4;5 | ||
+ | ====category.name==== | ||
+ | Categoy names - '' | ||
+ | |||
+ | 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' | ||
+ | ====category.path==== | ||
+ | Category url pats - '' | ||
+ | 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 - '' | ||
+ | Where '' | ||
+ | <code php> | ||
+ | class Some_Class { | ||
+ | public function callback($product, | ||
+ | } | ||
+ | </ | ||
+ | |||
+ | =====Example file===== | ||
+ | <file csv products.csv> | ||
+ | sku, | ||
+ | PO170LT,,,," | ||
+ | PO170TC,,,," | ||
+ | PO170NV,,,," | ||
+ | </ |