Why Taobao Order IDs End with the Same Six Digits: Inside the Gene Method

0x1. User Gene: Technical Essence of the Last Six Digits

The final six digits of a Taobao order number are a "user gene" – typically the last six bits of a hashed user ID or a desensitized user identifier. This fragment creates a strong binding between a user and the storage location of the order, ensuring that all orders of the same user are routed to the same database shard and thus dramatically improving query efficiency for the common "query all orders of a user" scenario.

0x2. Challenges of Order Generation in Sharded Environments

In a distributed database, traditional order‑ID schemes encounter two key problems:

Low routing efficiency – without a business‑related identifier, querying a user's orders requires scanning every shard.

Uneven data distribution – random sharding can create hotspot nodes with excessive load.

Three representative schemes were compared:

Auto‑increment ID : routing efficiency low, data distribution unbalanced, user‑related query requires full‑db scan.

Snowflake ID : routing efficiency medium, data distribution relatively balanced, user‑related query still requires full‑db scan.

Gene method : routing efficiency high, data distribution controllably balanced, user‑related query can precisely locate the shard.

The gene method embeds a user‑identifier fragment, directly addressing both routing inefficiency and data‑distribution imbalance.

0x3. Decomposing the Taobao Order‑ID Gene Structure

A typical 20‑digit gene‑method order ID is divided into four segments, each serving a specific technical purpose:

Time gene (6 digits) : format yyMMdd (e.g., 240815). Supports time‑range queries and assists sharding decisions.

Business gene (2 digits) : values such as 01 for regular orders, 02 for pre‑sale orders. Enables partitioning by business type.

Random sequence (6 digits) : a random number from 000000 to 999999. Guarantees uniqueness of the overall ID.

Routing gene (6 digits) : hash of the user ID (last six bits). Serves as the core sharding key.

Example order ID 24081501123456100860 parses as:

Time gene 240815 → 2024‑08‑15.

Business gene 01 → regular order.

Random sequence 123456 → ensures uniqueness.

Routing gene 100860 → hash result of user ID 10086.

Sharding algorithm using the routing gene:

Database index: 100860 % 8 = 4 → fourth database.

Table index: 100860 % 16 = 8 → eighth table.

This design enables O(1) time‑complexity location of any user's order data.

0x4. Technical Advantages of the Gene Method

1. Query Performance Optimization

Transforms user‑order queries from full‑database scans to direct shard location.

Significantly improves aggregation query performance in high‑concurrency scenarios.

2. Data Distribution Management

Hash‑based routing gene yields even data spread across shards.

Supports dynamic scaling (adding or removing shards) without hot‑spot formation.

3. Business Safety Features

Natural duplicate‑submission protection via the combined time‑+‑user‑+‑business key.

Idempotency control derived from the same combination.

4. System Extensibility

Business gene allows independent table partitioning by order type.

Time gene facilitates time‑based data archiving.

0x5. Evolution and Technical Considerations

Gene selection principle : choose dimensions that appear frequently in queries as sharding genes.

Hash algorithm choice : ensure the hash function produces a uniform distribution of results.

Gene length balance : trade off between uniqueness guarantees and storage efficiency.

Historical data migration : address the impact of adopting the gene method on existing data and provide migration solutions.

0x6. Summary of Design Insights

The fixed six‑digit suffix in Taobao order numbers exemplifies how large‑scale e‑commerce systems integrate business requirements with technical mechanisms. By embedding a hashed user identifier into the order ID, the gene method resolves sharding challenges, delivers O(1) query routing, maintains even data distribution, and supports extensible partitioning and safety features, offering a concrete reference for building high‑performance distributed e‑commerce platforms.