This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
urapidflow:fixed_row_format [2020/01/14 19:52] wtsergo |
urapidflow:fixed_row_format [2023/05/29 17:06] (current) wtsergo [B2BSC: B2B Shared Catalog] |
||
---|---|---|---|
Line 41: | Line 41: | ||
This allows to combine different types of fixed format rows into the same file, as there' | This allows to combine different types of fixed format rows into the same file, as there' | ||
- | ===== Row Types ===== | + | ===== Eav Structure |
==== Allowed actions ==== | ==== Allowed actions ==== | ||
Line 56: | Line 56: | ||
^ EAOS | X | X | X | ^ EAOS | X | X | X | ||
^ EAOSL | X | X | X | ^ EAOSL | X | X | X | ||
- | ^ 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 | ||
- | ^ GCA | X | X | X | ||
- | ^ GCAH | X | X | X | ||
- | |||
- | |||
* Rename is in ROADMAP, currently only CP and CPBO are implemented. | * Rename is in ROADMAP, currently only CP and CPBO are implemented. | ||
Line 287: | Line 256: | ||
===== Product Extra Data Row Types ===== | ===== 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 ==== | ==== CC: Catalog Category ==== | ||
=== Examples === | === Examples === | ||
Line 333: | Line 334: | ||
# CPI, | # CPI, | ||
# to add images | # to add images | ||
- | CPI, | + | CPI,SKU-1,/i/ |
- | CPI, | + | CPI,SKU-1,/i/ |
# to add images but exclude them from gallery | # to add images but exclude them from gallery | ||
- | CPI, | + | CPI,SKU-1,/i/ |
- | CPI, | + | CPI,SKU-1,/i/ |
# delete image | # delete image | ||
- | -CPI, | + | -CPI,SKU-1,/i/ |
</ | </ | ||
==== CPIL: Catalog Product Image Store Specific ==== | ==== CPIL: Catalog Product Image Store Specific ==== | ||
Line 581: | Line 582: | ||
^ 4 | label | | | | | ^ 4 | label | | | | | ||
==== CPSAP: Catalog Product Super Configurable Attribute Pricing ==== | ==== CPSAP: Catalog Product Super Configurable Attribute Pricing ==== | ||
+ | **Magento 1 only** | ||
=== Create/ | === Create/ | ||
^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
Line 669: | Line 671: | ||
^ 3 | store | X | X | | | ^ 3 | store | X | X | | | ||
^ 4 | title | | 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 ==== | ==== GCA: Gift Card Account ==== | ||
=== Columns === | === Columns === | ||
Line 680: | Line 690: | ||
^ 7 | date_expires | | | | | ^ 7 | date_expires | | | | | ||
^ 8 | website | | | | | ^ 8 | website | | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | GCA, | ||
+ | </ | ||
+ | |||
+ | == Delete giftcard == | ||
+ | < | ||
+ | -GCA, | ||
+ | </ | ||
+ | |||
+ | |||
==== GCAH: Gift Card Account History ==== | ==== GCAH: Gift Card Account History ==== | ||
=== Columns === | === Columns === | ||
Line 689: | Line 711: | ||
^ 5 | balance_delta | X | X | | | ^ 5 | balance_delta | X | X | | | ||
^ 6 | additional_info | | | | | ^ 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, | ||
+ | </ | ||
+ | |||
+ | |||
+ | ===== B2B Data Row Types ===== | ||
+ | |||
+ | ==== Allowed actions ==== | ||
+ | ^ Row Type ^ Create | ||
+ | ^ B2BC | X | X | X | ||
+ | ^ B2BCACE | ||
+ | ^ B2BCC | X | X | X | ||
+ | ^ B2BCCH | ||
+ | ^ B2BCOE | ||
+ | ^ B2BCPM | ||
+ | ^ B2BCR | X | X | X | ||
+ | ^ B2BCPR | ||
+ | ^ B2BCT | X | X | X | ||
+ | ^ B2BCS | X | X | X | ||
+ | ^ B2BCUR | ||
+ | ^ B2BSC | X | X | X | ||
+ | ^ B2BSCPI | ||
+ | ^ B2BRQL | ||
+ | ^ B2BRQLI | ||
+ | |||
+ | ==== B2BC: B2B Company ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | company_status | X | X | | | ||
+ | ^ 3 | email | X | X | | | ||
+ | ^ 4 | street | X | X | | | ||
+ | ^ 5 | city | X | X | | | ||
+ | ^ 6 | country_id | X | X | | | ||
+ | ^ 7 | region | X | X | | | ||
+ | ^ 8 | region_id | X | X | | | ||
+ | ^ 9 | postcode | X | X | | | ||
+ | ^ 10 | telephone | X | X | | | ||
+ | ^ 11 | customer_group | X | X | | | ||
+ | ^ 12 | admin_customer | X | X | | | ||
+ | ^ 13 | admin_customer_website | X | | | | ||
+ | ^ 14 | sales_representative | X | | | | ||
+ | ^ 15 | legal_name | X | | | | ||
+ | ^ 16 | vat_id | X | | | | ||
+ | ^ 17 | reseller_id | X | | | | ||
+ | ^ 17 | comment | X | | | | ||
+ | ^ 17 | reject_reason | X | | | | ||
+ | ^ 17 | rejected_at | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BC, | ||
+ | B2BC, | ||
+ | </ | ||
+ | |||
+ | == Delete company == | ||
+ | < | ||
+ | -B2BC, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCACE: B2B Company Advanced Customer Entity ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | customer | X | X | | | ||
+ | ^ 3 | ace_status | X | X | | | ||
+ | ^ 4 | job_title | X | | | | ||
+ | ^ 5 | telephone | X | | | | ||
+ | ^ 6 | customer_website | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCACE, | ||
+ | B2BCACE, | ||
+ | </ | ||
+ | |||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCACE, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCC: B2B Company Credit ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | credit_limit | X | | | | ||
+ | ^ 3 | balance | X | | | | ||
+ | ^ 4 | currency_code | X | | | | ||
+ | ^ 5 | exceed_limit | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCC, | ||
+ | B2BCC, | ||
+ | </ | ||
+ | |||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCC, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCCH: B2B Company Credit History ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | datetime | X | X | | | ||
+ | ^ 3 | amount | X | X | | | ||
+ | ^ 4 | balance | X | X | | | ||
+ | ^ 5 | credit_limit | X | X | | | ||
+ | ^ 6 | available_credit | X | X | | | ||
+ | ^ 7 | credit_history_type | X | X | | | ||
+ | ^ 8 | user | X | X | | | ||
+ | ^ 9 | user_type | X | X | | | ||
+ | ^ 10 | currency_credit | X | | | | ||
+ | ^ 11 | currency_operation | X | | | | ||
+ | ^ 12 | rate | X | | | | ||
+ | ^ 13 | rate_credit | X | | | | ||
+ | ^ 14 | purchase_order | X | | | | ||
+ | ^ 15 | comment | X | | | | ||
+ | ^ 16 | user_website | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCCH, | ||
+ | B2BCCH, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCCH, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCOE: B2B Company Order Entity ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | order_id | X | X | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCOE, | ||
+ | B2BCOE, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCOE, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCPM: B2B Company Payment ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | use_config_settings | X | X | | | ||
+ | ^ 3 | applicable_payment_method | X | | | | ||
+ | ^ 4 | available_payment_methods | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCPM, | ||
+ | B2BCPM, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCPM, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCR: B2B Company Roles ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | role_name | X | X | | | ||
+ | ^ 3 | sort_order | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCR, | ||
+ | B2BCR, | ||
+ | B2BCR, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCR, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCPR: B2B Company Permissions ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | role_name | X | X | | | ||
+ | ^ 3 | resource_id | X | X | | | ||
+ | ^ 4 | permission | X | X | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCPR, | ||
+ | B2BCPR, | ||
+ | B2BCPR, | ||
+ | B2BCPR, | ||
+ | B2BCPR, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCPR, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCT: B2B Company Team ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | team_name | X | X | | | ||
+ | ^ 3 | description | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCT, | ||
+ | B2BCT, | ||
+ | B2BCT, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCT, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCS: B2B Company Structure ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | entity_type | X | X | | | ||
+ | ^ 3 | entity | X | X | | | ||
+ | ^ 4 | parent_type | X | X | | | ||
+ | ^ 5 | parent_entity | X | X | | | ||
+ | ^ 6 | position | X | | | | ||
+ | ^ 7 | entity_website | X | | | | ||
+ | ^ 8 | parent_website | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCS, | ||
+ | B2BCS, | ||
+ | B2BCS, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCS, | ||
+ | </ | ||
+ | |||
+ | ==== B2BCUR: B2B Company User Roles ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | company_name | X | X | | | ||
+ | ^ 2 | role_name | X | X | | | ||
+ | ^ 3 | customer | X | X | | | ||
+ | ^ 4 | customer_website | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BCUR, | ||
+ | B2BCUR, | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BCS, | ||
+ | </ | ||
+ | |||
+ | ==== B2BSC: B2B Shared Catalog ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | name | X | X | | | ||
+ | ^ 2 | tax_class | X | X | | | ||
+ | ^ 3 | created_by | X | | | | ||
+ | ^ 4 | created_at | X | | | | ||
+ | ^ 5 | description | X | | | | ||
+ | ^ 6 | store | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BSC," | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BSC," | ||
+ | </ | ||
+ | |||
+ | ==== B2BSCPI: B2B Shared Catalog Product Item ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | customer_group | X | X | Supports multiple values separated with multivalue separator (default '; ' | ||
+ | ^ 2 | sku | X | X | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BSCPI," | ||
+ | B2BSCPI, | ||
+ | B2BSCPI," | ||
+ | B2BSCPI," | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BSCPI," | ||
+ | -B2BSCPI," | ||
+ | </ | ||
+ | |||
+ | ==== B2BRQL: B2B Requisition List ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | name | X | X | | | ||
+ | ^ 2 | customer | X | X | | | ||
+ | ^ 3 | description | X | | | | ||
+ | ^ 4 | updated_at | X | | | | ||
+ | ^ 5 | customer_website | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BRQL," | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BRQL," | ||
+ | </ | ||
+ | |||
+ | ==== B2BRQLI: B2B Requisition List Item ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | name | X | X | | | ||
+ | ^ 2 | customer | X | X | | | ||
+ | ^ 3 | sku | X | X | | | ||
+ | ^ 4 | qty | X | | | | ||
+ | ^ 5 | added_at | X | | | | ||
+ | ^ 6 | store | X | | | | ||
+ | ^ 7 | options | X | | | | ||
+ | ^ 8 | customer_website | X | | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | B2BRQLI," | ||
+ | B2BRQLI," | ||
+ | </ | ||
+ | == Delete == | ||
+ | < | ||
+ | -B2BRQLI," | ||
+ | </ | ||
+ | |||
===== Roadmap ===== | ===== Roadmap ===== | ||
Line 727: | Line 1200: | ||
| 4 | active | | | | | | 4 | active | | | | | ||
| 5 | created_at | | | | | | 5 | created_at | | | | | ||
+ | |||
+ | |||
+ | |||