This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
urapidflow:fixed_row_format [2019/03/05 17:17] wtsergo |
urapidflow:fixed_row_format [2020/06/23 06:17] wtsergo [Multi Source Inventory Types] |
||
---|---|---|---|
Line 41: | Line 41: | ||
This allows to combine different types of fixed format rows into the same file, as there' | This allows to combine different types of fixed format rows into the same file, as there' | ||
- | ===== EAV Structure Row Types ===== | + | ===== Eav Structure Row Types ===== |
==== Allowed actions ==== | ==== Allowed actions ==== | ||
Line 56: | Line 56: | ||
^ EAOS | X | X | X | ^ EAOS | X | X | X | ||
^ EAOSL | X | X | X | ^ EAOSL | X | X | X | ||
- | ^ CC | | ||
- | ^ CCP | X | X | X | ||
- | ^ CP | | ||
- | ^ CPI | X | X | X | ||
- | ^ CPIL | X | X | X | ||
- | ^ CPCO | X | X | X | X | [[# | ||
- | ^ CPCOL | X | X | X | ||
- | ^ CPCOS | X | X | X | X | [[# | ||
- | ^ CPCOSL | ||
- | ^ CPBO | X | X | X | X | [[# | ||
- | ^ CPBOL | X | X | X | ||
- | ^ CPBOS | X | X | X | ||
- | ^ CPRI | X | X | X | ||
- | ^ CPUI | X | X | X | ||
- | ^ CPXI | X | X | X | ||
- | ^ CPGI | X | X | X | ||
- | ^ CPSA | X | X | X | X | [[# | ||
- | ^ CPSAL | X | X | X | ||
- | ^ CPSAP | X | X | X | ||
- | ^ CPSI | X | X | X | ||
- | ^ CPD | X | X | X | X | [[# | ||
- | ^ CPDL | X | X | X | ||
- | ^ CPDP | X | X | X | ||
- | ^ CPDS | X | X | X | X | [[# | ||
- | ^ CPDSL | X | X | X | ||
- | ^ CPPT | X | X | X | ||
- | ^ CPPG | X | X | X | ||
- | |||
- | |||
* 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 | ||
+ | ^ CC | | ||
+ | ^ CCP | X | X | X | ||
+ | ^ CP | | ||
+ | ^ CPI | X | X | X | ||
+ | ^ CPIL | X | X | X | ||
+ | ^ CPCO | X | X | X | X | [[# | ||
+ | ^ CPCOL | X | X | X | ||
+ | ^ CPCOS | X | X | X | X | [[# | ||
+ | ^ CPCOSL | ||
+ | ^ CPBO | X | X | X | X | [[# | ||
+ | ^ CPBOL | X | X | X | ||
+ | ^ CPBOS | X | X | X | ||
+ | ^ CPRI | X | X | X | ||
+ | ^ CPUI | X | X | X | ||
+ | ^ CPXI | X | X | X | ||
+ | ^ CPGI | X | X | X | ||
+ | ^ CPSA | X | X | X | X | [[# | ||
+ | ^ CPSAL | X | X | X | ||
+ | ^ CPSAP | X | X | X | ||
+ | ^ CPSI | X | X | X | ||
+ | ^ CPD | X | X | X | X | [[# | ||
+ | ^ CPDL | X | X | X | ||
+ | ^ CPDP | X | X | X | ||
+ | ^ CPDS | X | X | X | X | [[# | ||
+ | ^ CPDSL | X | X | X | ||
+ | ^ CPPT | X | X | X | ||
+ | ^ CPPG | X | X | X | ||
+ | |||
+ | |||
==== CC: Catalog Category ==== | ==== CC: Catalog Category ==== | ||
=== Examples === | === Examples === | ||
Line 331: | Line 334: | ||
# CPI, | # CPI, | ||
# to add images | # to add images | ||
- | CPI, | + | CPI,SKU-1,/i/ |
- | CPI, | + | CPI,SKU-1,/i/ |
# to add images but exclude them from gallery | # to add images but exclude them from gallery | ||
- | CPI, | + | CPI,SKU-1,/i/ |
- | CPI, | + | CPI,SKU-1,/i/ |
# delete image | # delete image | ||
- | -CPI, | + | -CPI,SKU-1,/i/ |
</ | </ | ||
==== 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 | ||
+ | ^ GCA | X | X | X | ||
+ | ^ GCAH | X | X | X | ||
+ | |||
+ | ==== 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 === | ||
+ | < | ||
+ | GCA, | ||
+ | </ | ||
+ | |||
+ | == Delete giftcard == | ||
+ | < | ||
+ | -GCA, | ||
+ | </ | ||
+ | |||
+ | |||
+ | ==== 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 === | ||
+ | < | ||
+ | GCAH, | ||
+ | GCAH, | ||
+ | </ | ||
+ | |||
+ | ===== Multi Source Inventory Row Types ===== | ||
+ | |||
+ | ==== Allowed actions ==== | ||
+ | ^ Row Type ^ Create | ||
+ | ^ MSIS | X | X | X | ||
+ | ^ MSIST | X | X | X | ||
+ | ^ MSISL | X | X | X | ||
+ | ^ MSISI | X | X | X | ||
+ | ^ MSIC | X | X | X | ||
+ | |||
+ | ==== 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 === | ||
+ | < | ||
+ | MSIS, | ||
+ | </ | ||
+ | |||
+ | == Delete source == | ||
+ | < | ||
+ | -MSIS, | ||
+ | </ | ||
+ | |||
+ | ==== MSIST: MSI Stock ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | name | X | X | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | MSIST," | ||
+ | </ | ||
+ | |||
+ | == Delete stock == | ||
+ | < | ||
+ | -MSIST," | ||
+ | </ | ||
+ | |||
+ | ==== 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 === | ||
+ | < | ||
+ | MSISL, | ||
+ | </ | ||
+ | |||
+ | == Delete stock source link == | ||
+ | < | ||
+ | -MSISL, | ||
+ | </ | ||
+ | |||
+ | ==== 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 === | ||
+ | < | ||
+ | MSISI, | ||
+ | </ | ||
+ | |||
+ | == Delete source item == | ||
+ | < | ||
+ | -MSISI, | ||
+ | </ | ||
+ | |||
+ | ==== MSIS: MSI Stock Sales Channel ==== | ||
+ | === Columns === | ||
+ | ^ # ^ Column ^ Key? ^ Required? ^ Comments ^ | ||
+ | ^ 1 | website_code | X | X | | | ||
+ | ^ 2 | stock_name | X | X | | | ||
+ | |||
+ | === Examples === | ||
+ | < | ||
+ | MSIC, | ||
+ | </ | ||
+ | |||
+ | == Delete stock sales channel == | ||
+ | < | ||
+ | -MSIC, | ||
+ | </ | ||
Line 706: | Line 862: | ||
| 4 | active | | | | | | 4 | active | | | | | ||
| 5 | created_at | | | | | | 5 | created_at | | | | | ||
+ | |||
+ | |||