This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
urapidflow:fixed_row_format [2016/09/22 20:19] jamby77 [CPCO: Catalog Product Custom Option] |
urapidflow:fixed_row_format [2020/06/23 06:17] wtsergo [Multi Source Inventory Types] |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== uRapidFlowPro Fixed Row format ====== | ||
+ | |||
+ | While Product and Category records require a dynamic row format, which would allow flexible columns configuration, | ||
+ | |||
+ | Example of file with fixed format rows: | ||
+ | < | ||
+ | ## | ||
+ | CPCO, | ||
+ | |||
+ | ## | ||
+ | CPCOL, | ||
+ | |||
+ | ## | ||
+ | CPCOS, | ||
+ | |||
+ | ## | ||
+ | CPCOSL, | ||
+ | |||
+ | ## | ||
+ | CPRI, | ||
+ | |||
+ | ## | ||
+ | CPGI, | ||
+ | </ | ||
+ | |||
+ | The file above will create a dropdown custom option named " | ||
+ | Also, it will add RELATED_SKU as related to SKU1 and GROUPED_SKU as a child grouped product with default quantity of 2. | ||
+ | |||
+ | Each row begins with action char and row type identifier. If action char is ommited, insert/ | ||
+ | ^ Action Char ^ Meaning ^ | ||
+ | | + | Insert/ | ||
+ | | - | Delete | | ||
+ | | % | Rename (* see below for explanation) | | ||
+ | | # | Comment line (## is used for row structure explanation) | | ||
+ | | ! | Define column order for row type within the file (ROADMAP) | | ||
+ | |||
+ | * For example, in CPCO, " | ||
+ | |||
+ | First few fields are always required, others are optional, but the row structure should always remain the same. | ||
+ | |||
+ | This allows to combine different types of fixed format rows into the same file, as there' | ||
+ | |||
+ | ===== Eav Structure Row Types ===== | ||
+ | |||
+ | ==== Allowed actions ==== | ||
+ | ^ Row Type ^ Create | ||
+ | ^ EA | X | X | X | X | [[# | ||
+ | ^ EAL | X | X | X | ||
+ | ^ EAX | ||
+ | ^ EAXP | | X | ||
+ | ^ EAS | X | X | X | ||
+ | ^ EAG | X | X | X | ||
+ | ^ EASI | X | X | X | ||
+ | ^ EAO | X | X | X | ||
+ | ^ EAOL | X | X | X | ||
+ | ^ EAOS | X | X | X | ||
+ | ^ EAOSL | X | X | X | ||
+ | |||
+ | * Rename is in ROADMAP, currently only CP and CPBO are implemented. | ||
+ | ==== EA: EAV Attribute ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | attribute_code | X | X | | | ||
+ | ^ 2 | backend_type | | X | | | ||
+ | ^ 3 | frontend_input | | X | | | ||
+ | ^ 4 | frontend_label | | X | | | ||
+ | ^ 5 | is_required | | X | | | ||
+ | ^ 6 | is_unique | | X | | | ||
+ | ^ 7 | entity_type | X | | If not specified, ' | ||
+ | === Examples === | ||
+ | == Create attributes == | ||
+ | < | ||
+ | ## | ||
+ | EA, | ||
+ | </ | ||
+ | ==== EAL: EAV Attribute Store Specific ==== | ||
+ | Support only for Magento CE 1.4.0.0+ or EE 1.7.0.0+ | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | attribute_code | X | X | | | ||
+ | ^ 2 | store | X | X | | | ||
+ | ^ 3 | label| | ||
+ | ^ 4 | entity_type | X | | If not specified, ' | ||
+ | |||
+ | ==== EAX: EAV Attribute Extension ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | attribute_code | X | X | | | ||
+ | ^ 2 | attribute_model | | | | | ||
+ | ^ 3 | backend_model | | | | | ||
+ | ^ 4 | backend_table | | | | | ||
+ | ^ 5 | frontend_model | | | | | ||
+ | ^ 6 | frontend_class | | | | | ||
+ | ^ 7 | source_model | | | | | ||
+ | ^ 8 | default_value | | | | | ||
+ | ^ 9 | note | | | | | ||
+ | ^ 10 | entity_type | X | | If not specified, ' | ||
+ | ==== EAXP: EAV Attribute Product Extension ==== | ||
+ | === Create/ | ||
+ | ==Magento 1== | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | attribute_code | X | X | | | ||
+ | ^ 2 | is_global | | | | | ||
+ | ^ 3 | is_visible | | | | | ||
+ | ^ 4 | is_searchable | | | | | ||
+ | ^ 5 | is_filterable | | | | | ||
+ | ^ 6 | is_comparable | | | | | ||
+ | ^ 7 | is_visible_on_front | | | | | ||
+ | ^ 8 | is_html_allowed_on_front | | | | | ||
+ | ^ 9 | is_used_for_price_rules | | | | | ||
+ | ^ 10 | is_filterable_in_search | | | | | ||
+ | ^ 11 | used_in_product_listing | | | | | ||
+ | ^ 12 | used_for_sort_by | | | | | ||
+ | ^ 13 | is_configurable | | | | | ||
+ | ^ 14 | apply_to | | | | | ||
+ | ^ 15 | is_visible_in_advanced_search | | | | | ||
+ | ^ 16 | position | | | | | ||
+ | ^ 17 | frontend_input_renderer | | | | | ||
+ | ^ 18 | is_wysiwyg_enabled | | | | | ||
+ | |||
+ | ==Magento 2== | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | attribute_code | X | X | string | | ||
+ | ^ 2 | is_global | | | int | | ||
+ | ^ 3 | is_visible | | | int | | ||
+ | ^ 4 | is_searchable | | | int | | ||
+ | ^ 5 | is_filterable | | | int | | ||
+ | ^ 6 | is_comparable | | | int | | ||
+ | ^ 7 | is_visible_on_front | | | int | | ||
+ | ^ 8 | is_html_allowed_on_front | | | int | | ||
+ | ^ 9 | is_used_for_price_rules | | | int | | ||
+ | ^ 10 | is_filterable_in_search | | | int | | ||
+ | ^ 11 | used_in_product_listing | | | int | | ||
+ | ^ 12 | used_for_sort_by | | | int | | ||
+ | ^ 13 | apply_to | | | string | | ||
+ | ^ 14 | is_visible_in_advanced_search | | | int | | ||
+ | ^ 15 | position | | | int | | ||
+ | ^ 16 | frontend_input_renderer | | | string | | ||
+ | ^ 17 | is_wysiwyg_enabled | | | int | | ||
+ | ^ 18 | is_used_for_promo_rules | | | int | | ||
+ | ^ 19 | is_required_in_admin_store | | | int | | ||
+ | ^ 20 | is_used_in_grid | | | int | | ||
+ | ^ 21 | is_visible_in_grid | | | int | | ||
+ | ^ 22 | is_filterable_in_grid | | | int | | ||
+ | ^ 23 | search_weight | | | float | | ||
+ | ^ 24 | additional_data | | | text | | ||
+ | ==== EAS: EAV Attribute Set ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | set_name | X | X | | | ||
+ | ^ 2 | sort_order | | | | | ||
+ | ^ 3 | entity_type | X | | If not specified, ' | ||
+ | |||
+ | === Examples === | ||
+ | == Create attribute set == | ||
+ | < | ||
+ | ## | ||
+ | EAS,New Attribute Set | ||
+ | </ | ||
+ | |||
+ | ==== EAG: EAV Attribute Group ==== | ||
+ | === Create/ | ||
+ | == Magento 1 == | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | set_name | X | X | | | ||
+ | ^ 2 | group_name | X | X | | | ||
+ | ^ 3 | sort_order | | | | | ||
+ | ^ 4 | entity_type | X | | If not specified, ' | ||
+ | |||
+ | == Magento 2 == | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | set_name | X | X | string | | ||
+ | ^ 2 | group_name | X | X | string | | ||
+ | ^ 3 | sort_order | | | int | | ||
+ | ^ 4 | default_id | X | | int | | ||
+ | ^ 5 | attribute_group_code | X | | varchar | | ||
+ | ^ 6 | tab_group_code | X | | varchar | | ||
+ | ^ 7 | entity_type | X | | If not specified, ' | ||
+ | ==== EASI: EAV Attribute Within Attribute Set ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | set_name | X | X | | | ||
+ | ^ 2 | group_name | X | X | | | ||
+ | ^ 3 | attribute_code | X | X | | | ||
+ | ^ 4 | sort_order | | | | | ||
+ | ^ 5 | entity_type | X | | If not specified, ' | ||
+ | === Examples === | ||
+ | == Add attribute to attribute set == | ||
+ | < | ||
+ | ## | ||
+ | EASI,New Attribute Set, | ||
+ | </ | ||
+ | == Remove attribute from attribute set == | ||
+ | < | ||
+ | ## | ||
+ | -EASI,New Attribute Set, | ||
+ | </ | ||
+ | |||
+ | ==== EAO: EAV Attribute Option ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | attribute_code | X | X | | | ||
+ | ^ 2 | option_name | X | X | | | ||
+ | ^ 3 | sort_order | | | | | ||
+ | ^ 4 | entity_type | X | | If not specified, ' | ||
+ | === Examples === | ||
+ | == Add attribute options == | ||
+ | < | ||
+ | EAO, | ||
+ | EAO, | ||
+ | </ | ||
+ | ==== EAOL: EAV Attribute Option Store Specific ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | attribute_code | X | X | | | ||
+ | ^ 2 | option_name | X | X | | | ||
+ | ^ 3 | store | X | X | | | ||
+ | ^ 4 | option_label | | Х | | | ||
+ | ^ 5 | entity_type | X | | If not specified, ' | ||
+ | |||
+ | |||
+ | ==== EAOS: EAV Attribute Option Swatch ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | attribute_code | X | X | varchar | | ||
+ | ^ 2 | swatch_name | X | X | varchar | | ||
+ | ^ 3 | option_name | X | X | varchar | | ||
+ | ^ 4 | sort_order | | | int | | ||
+ | ^ 5 | type | | | int - 0 - text, 1 - visual color, 2 - visual image | | ||
+ | ^ 6 | entity_type | X | | If not specified, ' | ||
+ | |||
+ | === Examples === | ||
+ | == Add attribute swatches == | ||
+ | < | ||
+ | # | ||
+ | EAOS, | ||
+ | EAOS, | ||
+ | </ | ||
+ | |||
+ | ==== EAOSL: EAV Attribute Swatch Store Specific ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | attribute_code | X | X | varchar | | ||
+ | ^ 2 | default_swatch_name | X | X | varchar | | ||
+ | ^ 3 | store | X | X | varchar | | ||
+ | ^ 4 | locale_swatch_name | | Х | varchar | | ||
+ | ^ 5 | entity_type | X | | If not specified, ' | ||
+ | |||
+ | === Examples === | ||
+ | == Add attribute swatch locale version == | ||
+ | < | ||
+ | # | ||
+ | EAOSL, | ||
+ | EAOSL, | ||
+ | </ | ||
+ | |||
+ | ===== Product Extra Data Row Types ===== | ||
+ | |||
+ | ==== Allowed actions ==== | ||
+ | ^ Row Type ^ Create | ||
+ | ^ CC | | ||
+ | ^ CCP | X | X | X | ||
+ | ^ CP | | ||
+ | ^ CPI | X | X | X | ||
+ | ^ CPIL | X | X | X | ||
+ | ^ CPCO | X | X | X | X | [[# | ||
+ | ^ CPCOL | X | X | X | ||
+ | ^ CPCOS | X | X | X | X | [[# | ||
+ | ^ CPCOSL | ||
+ | ^ CPBO | X | X | X | X | [[# | ||
+ | ^ CPBOL | X | X | X | ||
+ | ^ CPBOS | X | X | X | ||
+ | ^ CPRI | X | X | X | ||
+ | ^ CPUI | X | X | X | ||
+ | ^ CPXI | X | X | X | ||
+ | ^ CPGI | X | X | X | ||
+ | ^ CPSA | X | X | X | X | [[# | ||
+ | ^ CPSAL | X | X | X | ||
+ | ^ CPSAP | X | X | X | ||
+ | ^ CPSI | X | X | X | ||
+ | ^ CPD | X | X | X | X | [[# | ||
+ | ^ CPDL | X | X | X | ||
+ | ^ CPDP | X | X | X | ||
+ | ^ CPDS | X | X | X | X | [[# | ||
+ | ^ CPDSL | X | X | X | ||
+ | ^ CPPT | X | X | X | ||
+ | ^ CPPG | X | X | X | ||
+ | |||
+ | |||
+ | ==== CC: Catalog Category ==== | ||
+ | === Examples === | ||
+ | == Delete categories == | ||
+ | < | ||
+ | -CC, | ||
+ | -CC, | ||
+ | </ | ||
+ | ==== CCP: Catalog Category-Product Association ==== | ||
+ | Can be used to specify product position within category. | ||
+ | Alternatively, | ||
+ | === Examples === | ||
+ | == Create category-product associations == | ||
+ | < | ||
+ | CCP, | ||
+ | CCP, | ||
+ | </ | ||
+ | == Delete category-product associations == | ||
+ | < | ||
+ | -CCP, | ||
+ | -CCP, | ||
+ | </ | ||
+ | ==== CP: Catalog Product ==== | ||
+ | === Examples === | ||
+ | == Delete products == | ||
+ | < | ||
+ | -CP,SKU1 | ||
+ | -CP,SKU2 | ||
+ | </ | ||
+ | == Rename product SKU == | ||
+ | < | ||
+ | %CP, | ||
+ | </ | ||
+ | ==== CPI: Catalog Product Image ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | image_url | X | X | | | ||
+ | ^ 3 | label | | | | | ||
+ | ^ 4 | position | | | | | ||
+ | ^ 5 | disabled | | | | | ||
+ | === Examples === | ||
+ | == Add Gallery Images == | ||
+ | |||
+ | <file csv CPI.csv> | ||
+ | # CPI, | ||
+ | # to add images | ||
+ | CPI, | ||
+ | CPI, | ||
+ | |||
+ | # to add images but exclude them from gallery | ||
+ | CPI, | ||
+ | CPI, | ||
+ | |||
+ | # delete image | ||
+ | -CPI, | ||
+ | </ | ||
+ | ==== CPIL: Catalog Product Image Store Specific ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | image_url | X | X | | | ||
+ | ^ 3 | store | X | X | Can't be " | ||
+ | ^ 4 | label | | | | | ||
+ | ^ 5 | position | | | | | ||
+ | ^ 6 | disabled | | | | | ||
+ | |||
+ | ==== CPV: Catalog Product Video ==== | ||
+ | **Magento 2 only** | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | url | X | X | | | ||
+ | ^ 3 | screenshot | X | X | | | ||
+ | ^ 4 | store | X | X | | | ||
+ | ^ 5 | title | | | | | ||
+ | ^ 6 | provider | | | | | ||
+ | ^ 7 | description | | | | | ||
+ | ^ 8 | metadata | | | | | ||
+ | ^ 9 | position | | | | | ||
+ | ^ 10 | disabled | | | | | ||
+ | |||
+ | ==== CPVL: Catalog Product Video Store Specific ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | screenshot | X | X | | | ||
+ | ^ 3 | store | X | X | Can't be " | ||
+ | ^ 4 | label | | X | | | ||
+ | ^ 5 | position | | | | | ||
+ | ^ 6 | disabled | | | | | ||
+ | |||
+ | === Examples === | ||
+ | == Add Gallery Videos == | ||
+ | |||
+ | <file csv CPI.csv> | ||
+ | #CPV, sku ,url ,screenshot ,store ,title ,provider , | ||
+ | # to add video | ||
+ | CPV, SKU-1, https:// | ||
+ | |||
+ | # to add video but exclude it from gallery | ||
+ | CPV, SKU-1, https:// | ||
+ | |||
+ | # -CPV, sku ,url ,screenshot ,store | ||
+ | # delete video | ||
+ | -CPV,SKU-1, https:// | ||
+ | |||
+ | # -CPVL, sku ,url ,screenshot ,store | ||
+ | # delete video store specific | ||
+ | -CPVL, | ||
+ | </ | ||
+ | |||
+ | ==== CPCO: Catalog Product Custom Option ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | default_title | X | X | | | ||
+ | ^ 3 | type | | X | | | ||
+ | ^ 4 | is_require | | | | | ||
+ | ^ 5 | option_sku | | | | | ||
+ | ^ 6 | sort_order | | | | | ||
+ | ^ 7 | max_characters | | | | | ||
+ | ^ 8 | price | | | | | ||
+ | ^ 9 | price_type | | | | | ||
+ | ^ 10 | file_extension | | | | | ||
+ | ^ 11 | image_size_x | | | | | ||
+ | ^ 12 | image_size_y | | | | | ||
+ | === Examples === | ||
+ | == Add custom options to a product == | ||
+ | <file csv custom_options.csv> | ||
+ | # // Add a non-required text custom option | ||
+ | ## | ||
+ | CPCO, | ||
+ | |||
+ | # // Add a required dropdown custom option | ||
+ | ## | ||
+ | CPCO, | ||
+ | ## | ||
+ | CPCOS, | ||
+ | CPCOS, | ||
+ | </ | ||
+ | ==== CPCOL: Catalog Product Custom Option Store Specific ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | default_title | X | X | | | ||
+ | ^ 3 | store | X | X | | | ||
+ | ^ 4 | title | | X | | | ||
+ | ^ 5 | price | | | | | ||
+ | ^ 6 | price_type | | | | | ||
+ | ==== CPCOS: Catalog Product Custom Option Selection ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | default_title | X | X | | | ||
+ | ^ 3 | selection_default_title | X | X | | | ||
+ | ^ 4 | selection_sku | | | | | ||
+ | ^ 5 | sort_order | | | | | ||
+ | ^ 6 | price | | | | | ||
+ | ^ 7 | price_type | | | | | ||
+ | ==== CPCOSL: Catalog Product Custom Option Selection Store Specific ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | default_title | X | X | | | ||
+ | ^ 3 | selection_default_title | X | X | | | ||
+ | ^ 4 | store | | X | | | ||
+ | ^ 5 | title | | X | | | ||
+ | ^ 6 | price | | | | | ||
+ | ^ 7 | price_type | | | | | ||
+ | ==== CPBO: Catalog Product Bundle Option ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | default_title | X | X | | | ||
+ | ^ 3 | position | | | | | ||
+ | ^ 4 | type | | | | | ||
+ | ^ 5 | required | | | | | ||
+ | |||
+ | === Examples === | ||
+ | == Add a Bundle Product == | ||
+ | < | ||
+ | ## | ||
+ | CPBO, | ||
+ | CPBO, | ||
+ | ## | ||
+ | CPBOS, | ||
+ | CPBOS, | ||
+ | CPBOS, | ||
+ | CPBOS, | ||
+ | </ | ||
+ | ==== CPBOL: Catalog Product Bundle Option Store Specific ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | default_title | X | X | | | ||
+ | ^ 3 | store | X | X | | | ||
+ | ^ 4 | title | | X | | | ||
+ | ==== CPBOS: Catalog Product Bundle Option Selection ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | default_title | X | X | | | ||
+ | ^ 3 | selection_sku | X | X | | | ||
+ | ^ 4 | position | | | | | ||
+ | ^ 5 | is_default | | | | | ||
+ | ^ 6 | selection_price_type | | | | | ||
+ | ^ 7 | selection_price_value | | | | | ||
+ | ^ 8 | selection_qty | | | | | ||
+ | ^ 9 | selection_can_change_qty | | | | | ||
+ | |||
+ | ==== CPBOSL: Catalog Product Bundle Option Selection Price ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | default_title | X | X | | | ||
+ | ^ 3 | selection_sku | X | X | | | ||
+ | ^ 4 | selection_price_type | | X | | | ||
+ | ^ 5 | selection_price_value | | X | | | ||
+ | ^ 6 | website | X | X | | | ||
+ | |||
+ | === Delete Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | default_title | X | X | | | ||
+ | ^ 3 | selection_sku | X | X | | | ||
+ | ^ 4 | website | X | X | | | ||
+ | |||
+ | === Examples === | ||
+ | == Add a Bundle Product == | ||
+ | <file csv cpbosl.csv> | ||
+ | "## | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | "## | ||
+ | " | ||
+ | </ | ||
+ | ==== CPRI: Catalog Product Related Item ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | linked_sku | X | X | | | ||
+ | ^ 3 | position | | | | | ||
+ | ^ 4 | qty | | | | | ||
+ | ==== CPUI: Catalog Product Up Sell Item ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | linked_sku | X | X | | | ||
+ | ^ 3 | position | | | | | ||
+ | ^ 4 | qty | | | | | ||
+ | ==== CPXI: Catalog Product Cross Sell Item ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | linked_sku | X | X | | | ||
+ | ^ 3 | position | | | | | ||
+ | ^ 4 | qty | | | | | ||
+ | ==== CPGI: Catalog Product Grouped Item ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | linked_sku | X | X | | | ||
+ | ^ 3 | position | | | | | ||
+ | ^ 4 | qty | | | | | ||
+ | ==== CPSA: Catalog Product Super Configurable Attribute ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | attribute_code | X | X | | | ||
+ | ^ 3 | position | | X | | | ||
+ | ^ 4 | label | | X | | | ||
+ | === Examples === | ||
+ | == Basic link between configurable product and 5 simple products using 2 attributes == | ||
+ | < | ||
+ | ## | ||
+ | CPSA, | ||
+ | CPSA, | ||
+ | ## | ||
+ | CPSI, | ||
+ | CPSI, | ||
+ | CPSI, | ||
+ | CPSI, | ||
+ | CPSI, | ||
+ | </ | ||
+ | |||
+ | ==== CPSAL: Catalog Product Super Configurable Attribute Store Specific ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | attribute_code | X | X | | | ||
+ | ^ 3 | store | | X | | | ||
+ | ^ 4 | label | | | | | ||
+ | ==== CPSAP: Catalog Product Super Configurable Attribute Pricing ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | attribute_code | X | X | | | ||
+ | ^ 3 | value_label | X | X | | | ||
+ | ^ 4 | website | X | X | | | ||
+ | ^ 5 | pricing_value | | X | | | ||
+ | ^ 6 | is_percent | | X | | | ||
+ | ==== CPSI: Catalog Product Super Configurable Item ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | linked_sku | X | X | | | ||
+ | ==== CPPT: Catalog Product Tier Prices ==== | ||
+ | === Create/ | ||
+ | |||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | customer_group| X | X | Use ' | ||
+ | ^ 3 | qty | X | X | | | ||
+ | ^ 4 | price | | X | | | ||
+ | ^ 5 | website | | | | | ||
+ | ^ 6 | percentage_value | | | magento2 >= 2.2.0 | | ||
+ | |||
+ | === Delete Columns === | ||
+ | ^ # ^ Column | ||
+ | ^ 1 | sku | X | X | ||
+ | ^ 2 | customer_group | X | X | Use ' | ||
+ | ^ 3 | qty | X | X | ||
+ | ^ 4 | website | ||
+ | ==== CPPG: Catalog Product Group Prices ==== | ||
+ | < | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | customer_group| X | X | | | ||
+ | ^ 3 | price | | X | | | ||
+ | ^ 4 | website | | | | | ||
+ | === Delete Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | customer_group| X | X | | | ||
+ | ^ 4 | website | | | | | ||
+ | ==== CPD: Catalog Product Downloadable ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | title | X | X | | | ||
+ | ^ 3 | price | | | | | ||
+ | ^ 4 | max_downloads | | | | | ||
+ | ^ 5 | is_shareable | | | | | ||
+ | ^ 6 | sort_order | | | | | ||
+ | ^ 7 | link_url | | | | | ||
+ | ^ 8 | link_file | | | | | ||
+ | ^ 9 | link_type | | | | | ||
+ | ^ 10 | sample_url | | | | | ||
+ | ^ 11 | sample_file | | | | | ||
+ | ^ 12 | sample_type | | | | | ||
+ | |||
+ | ==== CPDL: Catalog Product Downloadable Store Specific ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | default_title | X | X | | | ||
+ | ^ 3 | store | X | X | | | ||
+ | ^ 4 | title | | X | | | ||
+ | ==== CPDP: Catalog Product Downloadable Website Price ==== | ||
+ | === Create/ | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | default_title | X | X | | | ||
+ | ^ 3 | website | X | X | | | ||
+ | ^ 4 | price | | X | | | ||
+ | ==== CPDS: Catalog Product Downloadable Sample ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | title | X | X | | | ||
+ | ^ 3 | sort_order | | | | | ||
+ | ^ 4 | sample_url | | | | | ||
+ | ^ 5 | sample_file | | | | | ||
+ | ^ 6 | sample_type | | | | | ||
+ | ==== CPDSL: Catalog Product Downloadable Sample Store Specific ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | sku | X | X | | | ||
+ | ^ 2 | default_title | X | X | | | ||
+ | ^ 3 | store | X | X | | | ||
+ | ^ 4 | title | | X | | | ||
+ | |||
+ | ===== Enterprise Data Row Types ===== | ||
+ | |||
+ | ==== Allowed actions ==== | ||
+ | ^ Row Type ^ Create | ||
+ | ^ GCA | X | X | X | ||
+ | ^ GCAH | X | X | X | ||
+ | |||
+ | ==== GCA: Gift Card Account ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | code | X | X | | | ||
+ | ^ 2 | balance | X | X | | | ||
+ | ^ 3 | status | X | X | | | ||
+ | ^ 4 | state | X | X | | | ||
+ | ^ 5 | is_redeemable | X | X | | | ||
+ | ^ 6 | date_created | | | | | ||
+ | ^ 7 | date_expires | | | | | ||
+ | ^ 8 | website | | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | GCA, | ||
+ | </ | ||
+ | |||
+ | == Delete giftcard == | ||
+ | < | ||
+ | -GCA, | ||
+ | </ | ||
+ | |||
+ | |||
+ | ==== GCAH: Gift Card Account History ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | code | X | X | | | ||
+ | ^ 2 | updated_at | X | X | | | ||
+ | ^ 3 | action | X | X | | | ||
+ | ^ 4 | balance_amount | X | X | | | ||
+ | ^ 5 | balance_delta | X | X | | | ||
+ | ^ 6 | additional_info | | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | GCAH, | ||
+ | GCAH, | ||
+ | </ | ||
+ | |||
+ | ===== Multi Source Inventory Row Types ===== | ||
+ | |||
+ | ==== Allowed actions ==== | ||
+ | ^ Row Type ^ Create | ||
+ | ^ MSIS | X | X | X | ||
+ | ^ MSIST | X | X | X | ||
+ | ^ MSISL | X | X | X | ||
+ | ^ MSISI | X | X | X | ||
+ | ^ MSIC | X | X | X | ||
+ | |||
+ | ==== MSIS: MSI Source ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | source_code | X | X | | | ||
+ | ^ 2 | name | X | X | | | ||
+ | ^ 3 | enabled | X | X | | | ||
+ | ^ 4 | description | X | X | | | ||
+ | ^ 5 | latitude | X | X | | | ||
+ | ^ 6 | longitude | X | X | | | ||
+ | ^ 7 | country_id | X | X | | | ||
+ | ^ 8 | region_id | X | X | | | ||
+ | ^ 9 | region | X | X | | | ||
+ | ^ 10 | city | X | X | | | ||
+ | ^ 11 | street | X | X | | | ||
+ | ^ 12 | postcode | X | X | | | ||
+ | ^ 13 | contact_name | X | X | | | ||
+ | ^ 14 | email | X | X | | | ||
+ | ^ 15 | phone | X | X | | | ||
+ | ^ 16 | fax | X | X | | | ||
+ | ^ 17 | use_default_carrier_config | X | X | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | MSIS, | ||
+ | </ | ||
+ | |||
+ | == Delete source == | ||
+ | < | ||
+ | -MSIS, | ||
+ | </ | ||
+ | |||
+ | ==== MSIST: MSI Stock ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | name | X | X | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | MSIST," | ||
+ | </ | ||
+ | |||
+ | == Delete stock == | ||
+ | < | ||
+ | -MSIST," | ||
+ | </ | ||
+ | |||
+ | ==== MSIS: MSI Stock Source Link ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | source_code | X | X | | | ||
+ | ^ 2 | stock_name | X | X | | | ||
+ | ^ 3 | priority | X | X | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | MSISL, | ||
+ | </ | ||
+ | |||
+ | == Delete stock source link == | ||
+ | < | ||
+ | -MSISL, | ||
+ | </ | ||
+ | |||
+ | ==== MSIS: MSI Source Item ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | source_code | X | X | | | ||
+ | ^ 2 | sku | X | X | | | ||
+ | ^ 3 | quantity | X | X | | | ||
+ | ^ 4 | status | X | X | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | MSISI, | ||
+ | </ | ||
+ | |||
+ | == Delete source item == | ||
+ | < | ||
+ | -MSISI, | ||
+ | </ | ||
+ | |||
+ | ==== MSIS: MSI Stock Sales Channel ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | website_code | X | X | | | ||
+ | ^ 2 | stock_name | X | X | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | MSIC, | ||
+ | </ | ||
+ | |||
+ | == Delete stock sales channel == | ||
+ | < | ||
+ | -MSIC, | ||
+ | </ | ||
+ | |||
+ | |||
+ | ===== Roadmap ===== | ||
+ | |||
+ | ^ Row Type ^ Description ^ Comments ^ | ||
+ | ^ CT | Catalog Tag | | | ||
+ | ^ CTL | Catalog Tag Store Specific | | | ||
+ | ^ CTP | Catalog Tag Product Relation | | | ||
+ | ^ CS | Catalog Search | | | ||
+ | ^ AC | Customer | | | ||
+ | ^ AA | Customer Address | | | ||
+ | ^ SO | Sales Order | | | ||
+ | ^ SI | Sales Invoice | | | ||
+ | ^ SS | Sales Shipment | | | ||
+ | ^ SC | Credit Memo | | | ||
+ | |||
+ | ==== CT: Catalog Tag ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | | 1 | tag_name | X | X | | | ||
+ | | 2 | status | | | | | ||
+ | ==== CTL: Catalog Tag Store Specific ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | | 1 | tag_name | X | X | | | ||
+ | | 2 | store | | | | | ||
+ | | 3 | customers | | | | | ||
+ | | 4 | products | | | | | ||
+ | | 5 | uses | | | | | ||
+ | | 6 | historical_uses | | | | | ||
+ | | 7 | popularity | | | | | ||
+ | ==== CTP: Catalog Tag Product Relation ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | | 1 | sku | X | X | | | ||
+ | | 2 | tag_name | X | X | | | ||
+ | | 3 | store | | | | | ||
+ | | 4 | active | | | | | ||
+ | | 5 | created_at | | | | | ||
+ | |||
+ | |||