UnirgyWiki

User Tools

Site Tools

You are here: start » urapidflow » fixed_row_format
Trace:
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 [2023/05/29 17:06] (current)
wtsergo [B2BSC: B2B Shared Catalog]
Line 582: 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 715: Line 716:
 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","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> </file>
  
Line 755: Line 1200:
 | 4 | active |  |  | | | 4 | active |  |  | |
 | 5 | created_at |  |  | | | 5 | created_at |  |  | |
 +
 +
  
  
urapidflow/fixed_row_format.1581617182.txt.gz · by wtsergo

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
CC Attribution-Noncommercial-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki