User Tools

Site Tools


urapidflow:fixed_row_format

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
urapidflow:fixed_row_format [2020/01/14 19:55]
wtsergo
urapidflow:fixed_row_format [2023/05/29 17:06] (current)
wtsergo [B2BSC: B2B Shared Catalog]
Line 56: Line 56:
 ^ EAOS       | X       | X       | X                   | [[#eaoseav_attribute_option_swatch|EAV Attribute Swatch]]                                                                                 | ^ EAOS       | X       | X       | X                   | [[#eaoseav_attribute_option_swatch|EAV Attribute Swatch]]                                                                                 |
 ^ EAOSL      | X       | X       | X                   | [[#eaosleav_attribute_swatch_store_specific|EAV Attribute Swatch Store Specific]]                                                   | ^ EAOSL      | X       | X       | X                   | [[#eaosleav_attribute_swatch_store_specific|EAV Attribute Swatch Store Specific]]                                                   |
-^ CC        |                 | X                   | [[#cccatalog_category|Catalog Category]]                                                                                           | 
-^ CCP       | X       | X       | X                   | [[#ccpcatalog_category-product_association|Catalog Category-Product Association]]                                                  | 
-^ CP        |                 | X       | X           | [[#cpcatalog_product|Catalog Product]]                                                                                             | 
-^ CPI       | X       | X       | X                   | [[#cpicatalog_product_image|Catalog Product Image]]                                                                                | 
-^ CPIL      | X       | X       | X                   | [[#cpilcatalog_product_image_store_specific|Catalog Product Image Store Specific]]                                                 | 
-^ CPCO      | X       | X       | X       | X           | [[#cpcocatalog_product_custom_option|Catalog Product Custom Option]]                                                               | 
-^ CPCOL     | X       | X       | X                   | [[#cpcolcatalog_product_custom_option_store_specific|Catalog Product Custom Option Store Specific]]                                | 
-^ CPCOS     | X       | X       | X       | X           | [[#cpcoscatalog_product_custom_option_selection|Catalog Product Custom Option Selection]]                                          | 
-^ CPCOSL    | X       | X       | X                   | [[#cpcoslcatalog_product_custom_option_selection_store_specific|Catalog Product Custom Option Selection Store Specific]]           | 
-^ CPBO      | X       | X       | X       | X           | [[#cpbocatalog_product_bundle_option|Catalog Product Bundle Option]]                                                               | 
-^ CPBOL     | X       | X       | X                   | [[#cpbolcatalog_product_bundle_option_store_specific|Catalog Product Bundle Option Store Specific]]                                | 
-^ CPBOS     | X       | X       | X                   | [[#cpboscatalog_product_bundle_option_selection|Catalog Product Bundle Option Selection]]                                          | 
-^ CPRI      | X       | X       | X                   | [[#cpricatalog_product_related_item|Catalog Product Related Item]]                                                                 | 
-^ CPUI      | X       | X       | X                   | [[#cpuicatalog_product_up_sell_item|Catalog Product Up Sell Item]]                                                                 | 
-^ CPXI      | X       | X       | X                   | [[#cpxicatalog_product_cross_sell_item|Catalog Product Cross Sell Item]]                                                           | 
-^ CPGI      | X       | X       | X                   | [[#cpgicatalog_product_grouped_item|Catalog Product Grouped Item]]                                                                 | 
-^ CPSA      | X       | X       | X       | X           | [[#cpsacatalog_product_super_configurable_attribute|Catalog Product Super Configurable Attribute]]                                 | 
-^ CPSAL     | X       | X       | X                   | [[#cpsalcatalog_product_super_configurable_attribute_store_specific|Catalog Product Super Configurable Attribute Store Specific]]  | 
-^ CPSAP     | X       | X       | X                   | [[#cpsapcatalog_product_super_configurable_attribute_pricing|Catalog Product Super Configurable Attribute Pricing]]                | 
-^ CPSI      | X       | X       | X                   | [[#cpsicatalog_product_super_configurable_item|Catalog Product Super Configurable Item]]                                           | 
-^ CPD       | X       | X       | X       | X           | [[#cpdcatalog_product_downloadable|Catalog Product Downloadable]]                                                                  | 
-^ CPDL      | X       | X       | X                   | [[#cpdlcatalog_product_downloadable_store_specific|Catalog Product Downloadable Label]]                                            | 
-^ CPDP      | X       | X       | X                   | [[#cpdpcatalog_product_downloadable_website_price|Catalog Product Downloadable Price]]                                             | 
-^ CPDS      | X       | X       | X       | X           | [[#cpdscatalog_product_downloadable_sample|Catalog Product Downloadable Sample]]                                                   | 
-^ CPDSL     | X       | X       | X                   | [[#cpdslcatalog_product_downloadable_sample_store_specific|Catalog Product Downloadable Sample Label]]                             | 
-^ CPPT      | X       | X       | X                   | [[#cpptcatalog_product_tier_prices|Catalog Product Tier Prices]]                                                                   | 
-^ CPPG      | X       | X       | X                   | [[#cppgcatalog_product_group_prices|Catalog Product Group Prices]]                                                                 | 
-^ GCA      | X       | X       | X                   | [[#gcagiftcard_account|Gift Card Account]]                                                                 | 
-^ GCAH      | X       | X       | X                   | [[#gcahgiftcard_account_history|Gift Card Account History]]                                                                 | 
- 
- 
  
 * 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  ^ Update  ^ Delete  ^ Rename (*)  ^ Description                                                                                                                        ^
 +^ CC        |                 | X                   | [[#cccatalog_category|Catalog Category]]                                                                                           |
 +^ CCP       | X       | X       | X                   | [[#ccpcatalog_category-product_association|Catalog Category-Product Association]]                                                  |
 +^ CP        |                 | X       | X           | [[#cpcatalog_product|Catalog Product]]                                                                                             |
 +^ CPI       | X       | X       | X                   | [[#cpicatalog_product_image|Catalog Product Image]]                                                                                |
 +^ CPIL      | X       | X       | X                   | [[#cpilcatalog_product_image_store_specific|Catalog Product Image Store Specific]]                                                 |
 +^ CPCO      | X       | X       | X       | X           | [[#cpcocatalog_product_custom_option|Catalog Product Custom Option]]                                                               |
 +^ CPCOL     | X       | X       | X                   | [[#cpcolcatalog_product_custom_option_store_specific|Catalog Product Custom Option Store Specific]]                                |
 +^ CPCOS     | X       | X       | X       | X           | [[#cpcoscatalog_product_custom_option_selection|Catalog Product Custom Option Selection]]                                          |
 +^ CPCOSL    | X       | X       | X                   | [[#cpcoslcatalog_product_custom_option_selection_store_specific|Catalog Product Custom Option Selection Store Specific]]           |
 +^ CPBO      | X       | X       | X       | X           | [[#cpbocatalog_product_bundle_option|Catalog Product Bundle Option]]                                                               |
 +^ CPBOL     | X       | X       | X                   | [[#cpbolcatalog_product_bundle_option_store_specific|Catalog Product Bundle Option Store Specific]]                                |
 +^ CPBOS     | X       | X       | X                   | [[#cpboscatalog_product_bundle_option_selection|Catalog Product Bundle Option Selection]]                                          |
 +^ CPRI      | X       | X       | X                   | [[#cpricatalog_product_related_item|Catalog Product Related Item]]                                                                 |
 +^ CPUI      | X       | X       | X                   | [[#cpuicatalog_product_up_sell_item|Catalog Product Up Sell Item]]                                                                 |
 +^ CPXI      | X       | X       | X                   | [[#cpxicatalog_product_cross_sell_item|Catalog Product Cross Sell Item]]                                                           |
 +^ CPGI      | X       | X       | X                   | [[#cpgicatalog_product_grouped_item|Catalog Product Grouped Item]]                                                                 |
 +^ CPSA      | X       | X       | X       | X           | [[#cpsacatalog_product_super_configurable_attribute|Catalog Product Super Configurable Attribute]]                                 |
 +^ CPSAL     | X       | X       | X                   | [[#cpsalcatalog_product_super_configurable_attribute_store_specific|Catalog Product Super Configurable Attribute Store Specific]]  |
 +^ CPSAP     | X       | X       | X                   | [[#cpsapcatalog_product_super_configurable_attribute_pricing|Catalog Product Super Configurable Attribute Pricing]]                |
 +^ CPSI      | X       | X       | X                   | [[#cpsicatalog_product_super_configurable_item|Catalog Product Super Configurable Item]]                                           |
 +^ CPD       | X       | X       | X       | X           | [[#cpdcatalog_product_downloadable|Catalog Product Downloadable]]                                                                  |
 +^ CPDL      | X       | X       | X                   | [[#cpdlcatalog_product_downloadable_store_specific|Catalog Product Downloadable Label]]                                            |
 +^ CPDP      | X       | X       | X                   | [[#cpdpcatalog_product_downloadable_website_price|Catalog Product Downloadable Price]]                                             |
 +^ CPDS      | X       | X       | X       | X           | [[#cpdscatalog_product_downloadable_sample|Catalog Product Downloadable Sample]]                                                   |
 +^ CPDSL     | X       | X       | X                   | [[#cpdslcatalog_product_downloadable_sample_store_specific|Catalog Product Downloadable Sample Label]]                             |
 +^ CPPT      | X       | X       | X                   | [[#cpptcatalog_product_tier_prices|Catalog Product Tier Prices]]                                                                   |
 +^ CPPG      | X       | X       | X                   | [[#cppgcatalog_product_group_prices|Catalog Product Group Prices]]                                                                 |
 +
 +
 ==== CC: Catalog Category ==== ==== CC: Catalog Category ====
 === Examples === === Examples ===
Line 333: Line 334:
 # CPI,sku,image name,image label,position,disabled # CPI,sku,image name,image label,position,disabled
 # to add images  # to add images 
-CPI,SKU-1,i/m/image1.jpg,"Image 1 label",1,0  +CPI,SKU-1,/i/m/image1.jpg,"Image 1 label",1,0  
-CPI,SKU-1,i/m/image2.jpg,"Image 2 label",2,+CPI,SKU-1,/i/m/image2.jpg,"Image 2 label",2,
  
 # to add images but exclude them from gallery  # to add images but exclude them from gallery 
-CPI,SKU-1,i/m/image3.jpg,"Image 3 label",3,1  +CPI,SKU-1,/i/m/image3.jpg,"Image 3 label",3,1  
-CPI,SKU-1,i/m/image4.jpg,"Image 4 label",4,+CPI,SKU-1,/i/m/image4.jpg,"Image 4 label",4,
  
 # delete image  # delete image 
--CPI,SKU-1,i/m/image5.jpg+-CPI,SKU-1,/i/m/image5.jpg
 </file> </file>
 ==== 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/Update Columns === === Create/Update Columns ===
 ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ ^ # ^ Column ^ Key? ^ Required? ^ Comments ^
Line 671: Line 673:
  
 ===== Enterprise Data Row Types ===== ===== Enterprise Data Row Types =====
 +
 +==== Allowed actions ====
 +^ Row Type  ^ Create  ^ Update  ^ Delete  ^ Rename (*)  ^ Description                                                                                                                        ^
 +^ GCA      | X       | X       | X                   | [[#gcagiftcard_account|Gift Card Account]]                                                                 |
 +^ GCAH     | X       | X       | X                   | [[#gcahgiftcard_account_history|Gift Card Account History]]                                                                 |
 +
 ==== GCA: Gift Card Account ==== ==== GCA: Gift Card Account ====
 === Columns === === Columns ===
Line 682: Line 690:
 ^ 7 | date_expires |  |  | | ^ 7 | date_expires |  |  | |
 ^ 8 | website |  |  | | ^ 8 | website |  |  | |
 +
 +=== Examples ===
 +<file>
 +GCA,001PZCPE0Y1N-2,110.00,1,0,1,2020-01-14,2020-06-26,base
 +</file>
 +
 +== Delete giftcard ==
 +<file>
 +-GCA,02UXLMTJC5AH-2,50.00,1,0,1,2020-01-14,,base
 +</file>
 +
 +
 ==== GCAH: Gift Card Account History ==== ==== GCAH: Gift Card Account History ====
 === Columns === === Columns ===
Line 691: Line 711:
 ^ 5 | balance_delta | X | X | | ^ 5 | balance_delta | X | X | |
 ^ 6 | additional_info |  |  | | ^ 6 | additional_info |  |  | |
 +
 +=== Examples ===
 +<file>
 +GCAH,02UXLMTJC5AH-2,"2020-01-14 18:34:21",Created,50.00,50.00,"By admin: admin."
 +GCAH,02UXLMTJC5AH-2,"2020-01-14 18:34:38",Updated,44.00,-6.00,"By admin: admin."
 +</file>
 +
 +===== Multi Source Inventory Row Types =====
 +
 +==== Allowed actions ====
 +^ Row Type  ^ Create  ^ Update  ^ Delete  ^ Rename (*)  ^ Description                                                                                                                        ^
 +^ MSIS      | X       | X       | X                   | [[#msismsi_source|MSI Source]]                                                                 |
 +^ MSIST     | X       | X       | X                   | [[#msistmsi_stock|MSI Stock]]                                                                 |
 +^ MSISL     | X       | X       | X                   | [[#msislmsi_stock_source_link|MSI Stock Source Link]]                                                                 |
 +^ MSISI     | X       | X       | X                   | [[#msisimsi_source_item|MSI Source Item]]                                                                 |
 +^ MSIC      | X       | X       | X                   | [[#msicmsi_stock_sales_channel|MSI Stock Sales Channel]]                                                                 |
 +
 +==== 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 ===
 +<file>
 +MSIS,default,"US PA Source",1,"US PA Source",0.000000,0.000000,US,51,,Eclectic,"Steel Crossway",17589,,,,,1
 +</file>
 +
 +== Delete source ==
 +<file>
 +-MSIS,eu_it,"Europe IT Source",1,"Europe IT Source",,,IT,,,Rome,"Rome Street",00199,,,,,1
 +</file>
 +
 +==== MSIST: MSI Stock ====
 +=== Columns ===
 +^ # ^ Column ^ Key? ^ Required? ^ Comments ^
 +^ 1 | name | X | X | |
 +
 +=== Examples ===
 +<file>
 +MSIST,"Default Stock"
 +</file>
 +
 +== Delete stock ==
 +<file>
 +-MSIST,"US Stock"
 +</file>
 +
 +==== 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 ===
 +<file>
 +MSISL,default,"Default Stock",1
 +</file>
 +
 +== Delete stock source link ==
 +<file>
 +-MSISL,us_ca,"US Stock",3
 +</file>
 +
 +==== 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 ===
 +<file>
 +MSISI,eu_it,"utest 1",3.0000,1
 +</file>
 +
 +== Delete source item ==
 +<file>
 +-MSISI,eu_uk,"utest 1",2.0000,1
 +</file>
 +
 +==== MSIS: MSI Stock Sales Channel ====
 +=== Columns ===
 +^ # ^ Column ^ Key? ^ Required? ^ Comments ^
 +^ 1 | website_code | X | X | |
 +^ 2 | stock_name | X | X | |
 +
 +=== Examples ===
 +<file>
 +MSIC,base,"Base Stock"
 +</file>
 +
 +== Delete stock sales channel ==
 +<file>
 +-MSIC,europe,"Europe Stock"
 +</file>
 +
 +
 +===== B2B Data Row Types =====
 +
 +==== Allowed actions ====
 +^ Row Type  ^ Create  ^ Update  ^ Delete  ^ Rename (*)  ^ Description                                                                                                                        ^
 +^ B2BC      | X       | X       | X                   | [[#b2bcb2b_company|B2B Company]]                                                                 |
 +^ B2BCACE   | X       | X       | X                   | [[#b2bcaceb2b_company_advanced_customer_entity|B2B Company Advanced Customer Entity]]                  |
 +^ B2BCC     | X       | X       | X                   | [[#b2bccb2b_company_credit|B2B Company Credit]]                                                                 |
 +^ B2BCCH    | X       | X       | X                   | [[#b2bcchb2b_company_credit_history|B2B Company Credit History]]                                                                 |
 +^ B2BCOE    | X       | X       | X                   | [[#b2bcoeb2b_company_order_entity|B2B Company Order Entity]]                                                                 |
 +^ B2BCPM    | X       | X       | X                   | [[#b2bcpmb2b_company_payment|B2B Company Payment]]                                                                 |
 +^ B2BCR     | X       | X       | X                   | [[#b2bcrb2b_company_roles|B2B Company Roles]]                                                                 |
 +^ B2BCPR    | X       | X       | X                   | [[#b2bcprb2b_company_permissions|B2B Company Permissions]]                                                                 |
 +^ B2BCT     | X       | X       | X                   | [[#b2bctb2b_company_team|B2B Company Team]]                                                                 |
 +^ B2BCS     | X       | X       | X                   | [[#b2bcsb2b_company_structure|B2B Company Structure]]                                                                 |
 +^ B2BCUR    | X       | X       | X                   | [[#b2bcurb2b_company_user_roles|B2B Company User Roles]]                                                                 |
 +^ B2BSC     | X       | X       | X                   | [[#B2BSCB2B_shared_catalog|B2B Shared Catalog]]                                                                 |
 +^ B2BSCPI   | X       | X       | X                   | [[#b2bscpib2b_shared_catalog_product_item|B2B Shared Catalog Product Item]]                           |
 +^ B2BRQL    | X       | X       | X                   | [[#b2brqlb2b_requisition_list_item|B2B Requisition List]]                                                                 |
 +^ B2BRQLI   | X       | X       | X                   | [[#b2brqlib2b_requisition_list_item|B2B Requisition List Item]]                                                                 |
 +
 +==== 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 ===
 +<file>
 +B2BC,company1,Approved,company1@example.com,"Foam Road","Foam Lak",US,,23,60360,3235553232,"Wholesale SC",company1admin@example.com,base,admin,,,,,,
 +B2BC,company2,Approved,company2@example.com,"Grove Crossing",Noseville,US,,61,23860,911,"Wholesale SC",company2admin@example.com,base,admin,,,,,,
 +</file>
 +
 +== Delete company ==
 +<file>
 +-B2BC,company1,Approved,company1@example.com,"Foam Road","Foam Lak",US,,23,60360,3235553232,"Wholesale SC",company1admin@example.com,base,admin,,,,,,
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BCACE,company1,company1admin@example.com,Active,,,base
 +B2BCACE,company2,company2admin@example.com,Active,CEO,,base
 +</file>
 +
 +== Delete ==
 +<file>
 +-B2BCACE,company2,company2admin@example.com,Active,CEO,,base
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BCC,company1,1500.0000,100.0000,USD,0
 +B2BCC,company2,1000.0000,0.0000,USD,1
 +</file>
 +
 +== Delete ==
 +<file>
 +-B2BCC,company2,1000.0000,0.0000,USD,1
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BCCH,company1,"2020-06-24 18:43:21",0.0000,0.0000,1000.0000,1000.0000,Allocated,adminuser,Admin,USD,USD,1.000000000000,0.000000000000,,,
 +B2BCCH,company2,"2020-06-30 07:57:59",0.0000,0.0000,1000.0000,1000.0000,Allocated,adminuser,Admin,USD,USD,1.000000000000,0.000000000000,,,
 +</file>
 +== Delete ==
 +<file>
 +-B2BCCH,company2,"2020-06-30 07:57:59",0.0000,0.0000,1000.0000,1000.0000,Allocated,adminuser,Admin,USD,USD,1.000000000000,0.000000000000,,,
 +</file>
 +
 +==== B2BCOE: B2B Company Order Entity ====
 +=== Columns ===
 +^ # ^ Column ^ Key? ^ Required? ^ Comments ^
 +^ 1 | company_name | X | X | |
 +^ 2 | order_id | X | X | |
 +
 +=== Examples ===
 +<file>
 +B2BCOE,company1,000000001
 +B2BCOE,company2,000000002
 +</file>
 +== Delete ==
 +<file>
 +-B2BCOE,company2,000000002
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BCPM,company1,0,B2B,"amazonlogin,amazon_payment,banktransfer,cashondelivery,checkmo,payflow_advanced,payflowpro,payflow_link,authorizenet_acceptjs,braintree,cybersource,eway,authorizenet_directpost,klarna_kp,free,braintree_paypal,paypal_billing_agreement,payflow_express_bml,paypal_express_bml,paypal_express,payflow_express,hosted_pro,worldpay,companycredit,purchaseorder,braintree_paypal_vault,braintree_cc_vault,payflowpro_cc_vault"
 +B2BCPM,company2,1,B2B,"amazonlogin,amazon_payment,banktransfer,cashondelivery,checkmo,payflow_advanced,payflowpro,payflow_link,authorizenet_acceptjs,braintree,cybersource,eway,authorizenet_directpost,klarna_kp,free,braintree_paypal,paypal_billing_agreement,payflow_express_bml,paypal_express_bml,paypal_express,payflow_express,hosted_pro,worldpay,companycredit,purchaseorder,braintree_paypal_vault,braintree_cc_vault,payflowpro_cc_vault"
 +</file>
 +== Delete ==
 +<file>
 +-B2BCPM,company2,1,B2B,"amazonlogin,amazon_payment,banktransfer,cashondelivery,checkmo,payflow_advanced,payflowpro,payflow_link,authorizenet_acceptjs,braintree,cybersource,eway,authorizenet_directpost,klarna_kp,free,braintree_paypal,paypal_billing_agreement,payflow_express_bml,paypal_express_bml,paypal_express,payflow_express,hosted_pro,worldpay,companycredit,purchaseorder,braintree_paypal_vault,braintree_cc_vault,payflowpro_cc_vault"
 +</file>
 +
 +==== B2BCR: B2B Company Roles ====
 +=== Columns ===
 +^ # ^ Column ^ Key? ^ Required? ^ Comments ^
 +^ 1 | company_name | X | X | |
 +^ 2 | role_name | X | X | |
 +^ 3 | sort_order | X |  | |
 +
 +=== Examples ===
 +<file>
 +B2BCR,company1,"Default User",0
 +B2BCR,company1,"Warehouse Role",0
 +B2BCR,company2,"Default User",0
 +</file>
 +== Delete ==
 +<file>
 +-B2BCR,company2,"Default User",0
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BCPR,company1,"Default User",Magento_Company::index,allow
 +B2BCPR,company1,"Default User",Magento_Sales::all,allow
 +B2BCPR,company1,"Default User",Magento_Sales::place_order,allow
 +B2BCPR,company1,"Warehouse Role",Magento_Company::roles_view,deny
 +B2BCPR,company1,"Warehouse Role",Magento_Company::roles_edit,deny
 +</file>
 +== Delete ==
 +<file>
 +-B2BCPR,company1,"Warehouse Role",Magento_Company::roles_edit,deny
 +</file>
 +
 +==== B2BCT: B2B Company Team ====
 +=== Columns ===
 +^ # ^ Column ^ Key? ^ Required? ^ Comments ^
 +^ 1 | company_name | X | X | |
 +^ 2 | team_name | X | X | |
 +^ 3 | description | X |  | |
 +
 +=== Examples ===
 +<file>
 +B2BCT,company1,Sales,
 +B2BCT,company1,Warehouse,
 +B2BCT,company2,Sales,
 +</file>
 +== Delete ==
 +<file>
 +-B2BCT,company2,Sales,
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BCS,company1,Customer,company1admin@example.com,,,0,base,
 +B2BCS,company1,Team,Sales,Customer,company1admin@example.com,0,,base
 +B2BCS,company1,Team,Warehouse,Team,Sales,0,,
 +</file>
 +== Delete ==
 +<file>
 +-B2BCS,company1,Team,Warehouse,Team,Sales,0,,
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BCUR,company1,"Default User",company1user@example.com,1
 +B2BCUR,company2,"Default User",company2user@example.com,1
 +</file>
 +== Delete ==
 +<file>
 +-B2BCS,company1,Team,Warehouse,Team,Sales,0,,
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BSC,"Wholesale SC","Wholesale Customer",adminuser,"2020-07-08 06:02:50",,
 +</file>
 +== Delete ==
 +<file>
 +-B2BSC,"Wholesale SC","Wholesale Customer",adminuser,"2020-07-08 06:02:50",,
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BSCPI,"NOT LOGGED IN",24-MB01
 +B2BSCPI,General,24-MB01
 +B2BSCPI,"Wholesale SC",24-MB01
 +B2BSCPI,"Retailer 1; Retailer 2",24-MB01
 +</file>
 +== Delete ==
 +<file>
 +-B2BSCPI,"Wholesale SC",24-MB01
 +-B2BSCPI,"Retailer 1; Retailer 2",24-MB01
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BRQL,"company1 Req List",company1admin@example.com,,"2020-07-08 06:49:44",1
 +</file>
 +== Delete ==
 +<file>
 +-B2BRQL,"company1 Req List",company1admin@example.com,,"2020-07-08 06:49:44",1
 +</file>
 +
 +==== 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 ===
 +<file>
 +B2BRQLI,"company1 Req List",company1admin@example.com,24-MB01,1.0000,,,"{""info_buyRequest"":{""product"":""1"",""uenc"":""aHR0cDovL21hZ2VudG8yMzJiMmIubG9jL2NoZWNrb3V0L2NhcnQvYWRkL3VlbmMvYUhSMGNEb3ZMMjFoWjJWdWRHOHlNekppTW1JdWJHOWpMMmRsWVhJdlltRm5jeTVvZEcxcy9wcm9kdWN0LzEv"",""form_key"":""rspW4yqaVs3ZrNdQ""}}",1
 +B2BRQLI,"company1 Req List",company1admin@example.com,24-MB04,1.0000,,,,
 +</file>
 +== Delete ==
 +<file>
 +-B2BRQLI,"company1 Req List",company1admin@example.com,24-MB04,1.0000,,,,
 +</file>
 +
  
 ===== Roadmap ===== ===== Roadmap =====
Line 729: Line 1200:
 | 4 | active |  |  | | | 4 | active |  |  | |
 | 5 | created_at |  |  | | | 5 | created_at |  |  | |
 +
 +
  
  
urapidflow/fixed_row_format.1579031748.txt.gz · by wtsergo