urapidflow:columns
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
urapidflow:columns [2014/05/09 17:59] jamby77 [category.name] |
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,,,," | ||
| + | </ | ||
urapidflow/columns.txt · by jamby77
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
