Commerce 1 and 2 include different fields in their respective payment tables. Document the tables and work if there are any fields that need further work.
| D7 field | D8+ field | Status |
|---|---|---|
| transaction_id | payment_id | Included. |
| revision_id | n/a | Not used. |
| uid | n/a | Not used. |
| order_id | order_id | Included. |
| payment_method | payment_gateway | Included. |
| instance_id | --- | Not used. |
| remote_id | --- | #3339236: Commerce 1 payment record does not include remote_id value |
| message | --- | Not migrated. |
| message_variables | --- | Not migrated. |
| amount | amount/number | Bug fix: #3233594: Payments from Commerce 1 have wrong decimal place |
| currency_code | amount/currency_code | Included. |
| status | state | Included. |
| remote_status | --- | Should this be migrated to remote_state? |
| payload | --- | Not migrated. |
| created | --- | Not migrated. |
| changed | --- | Not migrated. |
| data | --- | Not migrated. |
| received | completed | Included. |
| n/a | type | Fixed string "payment_manual". |
| n/a | refunded_amount/number | TBD |
| n/a | refunded_amount/currency_code | TBD |
| n/a | payment_gateway_mode | TBD |
| n/a | payment_gateway_method | TBD |
| n/a | authorized | TBD |
| n/a | expires | TBD |
| n/a | avs_response_code | TBD |
| n/a | avs_response_code_label | TBD |
| n/a | test | Deprecated field, will be removed later. |
| n/a | captured | Deprecated field, will be removed later. |
| n/a | payment_gateway_method | TBD |
Comments
Comment #2
damienmckennaThe D7 schema:
Comment #3
damienmckennaThe v2 schema:
https://git.drupalcode.org/project/commerce/-/blob/8.x-2.x/modules/payme...
See: baseFieldDefinitions()
Comment #4
damienmckennaComment #5
damienmckennaComment #6
damienmckennaComment #7
damienmckennaComment #8
damienmckennaComment #9
damienmckennaAt least some of this data is supposed to go into the commerce_payment_method table, see #3339270: Create commerce_payment_method records for details.