User Tools

Site Tools


urapidflow:columns

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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 ''​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:
 +<code php>
 +class Some_Class {
 +    public function callback($product,​ $columnInfo,​ $storeId)
 +}
 +</​code>​
 +
 +=====Example file=====
 +<file csv 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,,​
 +</​file>​
urapidflow/columns.txt · Last modified: 2016/11/01 20:06 by jamby77