Xianyu built a custom SPU system and data pipeline that cleans Alibaba’s raw SPU data, defines key, binding, sales and product attributes, stores enriched records in MySQL, syncs to OpenSearch, and supports diverse business scenarios such as inspection, search publishing, and worry‑free purchase.
The article describes a supply‑demand modeling framework for the idle second‑hand market that extracts and structures product attributes, builds a decision‑tree‑based index from price, inventory, search‑hotspot and demand‑activation sub‑models, and uses the index to optimize category allocation, boost scarce supply, and drive overall growth.
This article explains the core concepts and architecture of an e‑commerce product center, covering SPU, SKU, sales and non‑sales attributes, pricing models, inventory control, scheduled on/off‑shelf operations, and optimization techniques for querying product data.
The article examines Meituan’s O2O supply chain system, detailing its complex data structuring, dynamic product modeling, configurable workflows, and extensive automation that together cut order‑processing costs by over 90% and boost efficiency eightfold, illustrating the challenges and solutions of modern operations management.
This article explains Taobao's product and SKU concepts, the relationship between attribute name and value tables, how to fetch and process attribute data via the API, and techniques for dynamically building forms and handling SKU combinations in e‑commerce systems.
The article explains Meituan's supply chain (SCP) process, detailing its role in converting merchant agreements into electronic contracts, the complex data structures, flexible sales models, dynamic auditing, and how automation, workflow, and product‑center modeling address these challenges to dramatically reduce costs and improve efficiency.
This article examines Meituan's O2O supply chain challenges and how the company transformed a fragmented, manually intensive process into an automated, highly efficient system that reduced order‑entry costs by 90% and boosted efficiency eightfold.
