如何在Magento中更改订单增量ID和前缀? [英] How to Change the Order Increment ID and Prefix in Magento?

问题描述

如何在Magento中更改订单增量ID和前缀?我已经成功运行了SQL查询，但没有将结果输入到前端magento中.

How to change the order increment ID and prefix in Magento? I was successfully run the SQL queries but I did not get the results into my frontend magento.

我正在尝试在magnto(eav_entity_store)中查询本地主机/phpmyadmin..so如何更改我的订单前缀号?

I am trying the query here local host/phpmyadmin in magnto (eav_entity_store)..so how can I change my order prefix number?

推荐答案

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

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';

这篇关于如何在Magento中更改订单增量ID和前缀?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！