mysql - Magento DB 客户订单映射

Question

Magento 订单如何映射到客户？订单包含客户 ID 还是客户包含其所有订单 ID？试图弄清楚更改订单号是否会扰乱客户映射。

Answer 1

我先回答你的问题

Magento 订单如何映射到客户？

Magento Orders are mapped to the customers using "customer_id" Foreign Key field in the order tables "sales_flat_order","sales_flat_order_grid","sales_flat_order_address". And Customer entity has no reference to the orders in turn.

订单包含客户 ID 还是客户包含其所有订单 ID？

Order only contains the customer ID not the other way around. Basically Customer entity follows the EAV structure like products and categories.

现在开始执行更改订单号的任务(技术字段名称increment_id)。

Yes you can change the increment numbers of the order. You need to do that in two tables

1. sales_flat_order
2. sales_flat_order_grid

Please make sure to reset the order increment last id of entity type id "5" which represents Order after completing your task of changing the order numbers. You should do this in the table "eav_entity_store"

如果您需要更多相关信息，请告诉我。