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/02/13 18:06]
wtsergo [CPI: Catalog Product Image]
urapidflow:fixed_row_format [2020/07/10 16:31] (current)
wtsergo
Line 715: Line 715:
 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:​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."​ 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>​ </​file>​
  
Line 755: Line 1197:
 | 4 | active |  |  | | | 4 | active |  |  | |
 | 5 | created_at |  |  | | | 5 | created_at |  |  | |
 +
 +
  
  
urapidflow/fixed_row_format.1581617182.txt.gz · Last modified: 2020/02/13 18:06 by wtsergo