且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在Magento中更改订单增量ID和前缀?

更新时间:2023-02-20 22:36:12

现在我将此查询用于订单增加

now i used this query for order increment

UPDATE eav_entity_store
INNER JOIN eav_entity_type ON eav_entity_type.entity_type_id = eav_entity_store.entity_type_id
SET eav_entity_store.increment_last_id='0000000000'
WHERE eav_entity_type.entity_type_code='order' AND eav_entity_store.store_id = '1';
UPDATE eav_entity_store
INNER JOIN eav_entity_type ON eav_entity_type.entity_type_id = eav_entity_store.entity_type_id
SET eav_entity_store.increment_prefix='ORD'
WHERE eav_entity_type.entity_type_code='order' AND eav_entity_store.store_id = '1';