Magento 1.5中订单号的自定义开始号码 [英] Custom Start Number for Order Numbers in Magento 1.5

问题描述

如何自定义Magento 1.5中的订单，发票等的起始号码？

How do I customise the starting number for orders, invoices etc in Magento 1.5?

推荐答案

从magento论坛：

From magento's forum:

• 由LindyKyaw（Magento团队成员），更改开始号（通过sql查询）：

• by LindyKyaw (Magento Team Member), changing start number (through sql query):

There is a table in the database which stored increment id of order.
It is called "eav_entity_store" table.
You can check which entity type id belongs to which entity by looking at 
eav_entity_type table.
You can run following query to update last increment id for the order.

    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=3001 
    where eav_entity_type.entity_type_code='order';

• $ b $。 b
  • by FOOMAN (active contributor), changing start number (through db management tool) and removing "0"s at the beginning:

  With a tool like phpmyadmin look at your database. In the table 
  eav_entity_type you will find all entity types listed. The one of interest to 
  change where the order number starts is order sales/order. Remember the 
  entity_type_id (in my install it is 11). To remove the leading zeros 
  (padding) set increment_pad_length to 1.

  接下来转到表eav_entity_store。查找entity_type_id。现在你
  可以改变increment_prefix和increment_last_id的值。如果你想
  将你的下一个orderId设置为15000，将increment_last_id设置为14999，将
  increment_prefix设置为0.

  Next go to the table eav_entity_store. Look up the entity_type_id. Now you can change the value of increment_prefix and increment_last_id. If you wanted to have your next orderId to be 15000 set increment_last_id to 14999 and increment_prefix to 0.

  的文件
  /app/code/core/Mage/Eav/Model/Entity/Increment/Abstract.php
  to
  / app / code / local / Mage / Eav / Model / Entity /Increment/Abstract.php
  public function getPadLength（）
{
$ padLength = $ this-> getData（'pad_length'）;
if（empty（$ padLength））{
$ padLength = 0;
}
return $ padLength;
}
...
公共函数格式（$ id）
{
$ result = str_pad（（string）$ id，$ this-> getPadLength ，$ this-> getPadChar（），STR_PAD_LEFT）;
return $ result;
}

  希望有助于

  这篇关于Magento 1.5中订单号的自定义开始号码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！