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 [2018/01/22 23: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's no need for header titles, which means each row's structure is well known and will be expected by the parser. This allows to combine different types of fixed format rows into the same file, as there's no need for header titles, which means each row's structure is well known and will be expected by the parser.
  
-===== EAV Structure Row Types =====+===== Eav Structure Row Types =====
  
 ==== Allowed actions ==== ==== Allowed actions ====
Line 54: Line 54:
 ^ EAO       | X       | X       | X                   | [[#eaoeav_attribute_option|EAV Attribute Option]]                                                                                  | ^ EAO       | X       | X       | X                   | [[#eaoeav_attribute_option|EAV Attribute Option]]                                                                                  |
 ^ EAOL      | X       | X       | X                   | [[#eaoleav_attribute_option_store_specific|EAV Attribute Option Store Specific]]                                                   | ^ EAOL      | X       | X       | X                   | [[#eaoleav_attribute_option_store_specific|EAV Attribute Option Store Specific]]                                                   |
-^ EAOS       | X       | X       | X                   | [[#eaoseav_attribute_option_swatch_magento2_only|EAV Attribute Swatch]] (magento2 only)                                                                                 | +^ EAOS       | X       | X       | X                   | [[#eaoseav_attribute_option_swatch|EAV Attribute Swatch]]                                                                                 | 
-^ EAOSL      | X       | X       | X                   | [[#eaosleav_attribute_swatch_store_specific_magento2_only|EAV Attribute Swatch Store Specific]] (magento2 only)                                                   | +^ 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]]                                                                 | +
- +
  
 * Rename is in ROADMAP, currently only CP and CPBO are implemented. * Rename is in ROADMAP, currently only CP and CPBO are implemented.
Line 249: Line 220:
  
  
-==== EAOS: EAV Attribute Option Swatch (magento2 only) ====+==== EAOS: EAV Attribute Option Swatch ====
 === Create/Update Columns === === Create/Update Columns ===
 ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ ^ # ^ Column ^ Key? ^ Required? ^ Comments ^
Line 267: Line 238:
 </file> </file>
  
-==== EAOSL: EAV Attribute Swatch Store Specific (magento2 only) ====+==== EAOSL: EAV Attribute Swatch Store Specific ====
 === Create/Update Columns === === Create/Update Columns ===
 ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ ^ # ^ Column ^ Key? ^ Required? ^ Comments ^
Line 285: 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 331: 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 579: 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 594: Line 598:
 ==== CPPT: Catalog Product Tier Prices ==== ==== CPPT: Catalog Product Tier Prices ====
 === Create/Update Columns === === Create/Update Columns ===
-^ # ^ Column ^ Key? ^ Required? ^ Comments ^+
 ^ 1 | sku | X | X | | ^ 1 | sku | X | X | |
 ^ 2 | customer_group| X | X | Use '*' for all groups | ^ 2 | customer_group| X | X | Use '*' for all groups |
Line 600: Line 604:
 ^ 4 | price |  | X | | ^ 4 | price |  | X | |
 ^ 5 | website | | | | ^ 5 | website | | | |
 +^ 6 | percentage_value | | | magento2 >= 2.2.0 |
 +
 === Delete Columns === === Delete Columns ===
 ^ # ^ Column         ^ Key? ^ Required? ^ Comments               ^ ^ # ^ Column         ^ Key? ^ Required? ^ Comments               ^
Line 665: 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  ^ 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 ====
 +=== 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 ===
 +<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 ====
 +=== 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 ===
 +<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>
  
  
Line 704: Line 1200:
 | 4 | active |  |  | | | 4 | active |  |  | |
 | 5 | created_at |  |  | | | 5 | created_at |  |  | |
 +
 +
 +
 +
urapidflow/fixed_row_format.1516665152.txt.gz · by wtsergo