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 [2019/03/05 17:17]
wtsergo
urapidflow:fixed_row_format [2020/07/10 16:31] (current)
wtsergo
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 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]] ​                                                                | 
- 
- 
  
 * Rename is in ROADMAP, currently only CP and CPBO are implemented. * Rename is in ROADMAP, currently only CP and CPBO are implemented.
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,​0 ​+CPI,SKU-1,/i/​m/​image2.jpg,"​Image 2 label",​2,​0 ​
  
 # 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,​1 ​+CPI,SKU-1,/i/​m/​image4.jpg,"​Image 4 label",​4,​1 ​
  
 # 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 667: Line 670:
 ^ 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",​adminuser,"​2020-07-08 06:​02:​50",,​
 +</​file>​
 +== Delete ==
 +<​file>​
 +-B2BSC,"​Wholesale SC",​adminuser,"​2020-07-08 06:​02:​50",,​
 +</​file>​
 +
 +==== B2BSCPI: B2B Shared Catalog Product Item ====
 +=== Columns ===
 +^ # ^ Column ^ Key? ^ Required? ^ Comments ^
 +^ 1 | customer_group | X | X | |
 +^ 2 | sku | X | X | |
 +
 +=== Examples ===
 +<​file>​
 +B2BSCPI,"​NOT LOGGED IN",​24-MB01
 +B2BSCPI,​General,​24-MB01
 +B2BSCPI,"​Wholesale SC",​24-MB01
 +</​file>​
 +== Delete ==
 +<​file>​
 +-B2BSCPI,"​Wholesale SC",​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 706: Line 1197:
 | 4 | active |  |  | | | 4 | active |  |  | |
 | 5 | created_at |  |  | | | 5 | created_at |  |  | |
 +
 +
 +
  
urapidflow/fixed_row_format.1551806225.txt.gz · Last modified: 2019/03/05 17:17 by wtsergo