All work/Own operations systemLive
1688 Ordering and Reconciliation
From “what to order” to “was it paid correctly”, one pipeline runs end to end.
Walkthrough · 21.6s
The video is an illustration of the process. All data shown is for demonstration.
01 · The problem
Each cycle, our three stores order hundreds of items from dozens of 1688 suppliers. Adding to the cart, checking quantities, chasing shipments and matching payments by hand takes hours, and one wrong cell means the wrong goods.
02 · Our approach
- A restock sheet calculates a suggested quantity for every item. People only confirm the final quantity.
- A program reads the confirmed quantities, adds them to the 1688 cart and checks each line's spec and quantity.
- After ordering, in-transit stock is recorded automatically and cleared when goods arrive in the ERP.
- A reconciliation program runs continuously, comparing the ordered amount with the amount actually paid and marking each line with one of three statuses.
03 · Process
- 01Restock sheet suggests order quantities
- 02People confirm; program fills the 1688 cart
- 03Each line checked for spec and quantity
- 04In-transit recorded, cleared on arrival
- 05Reconcile ordered amount against amount paid
04 · Results
- Nail store stockout rate, weighted by sales volume: 22.1% → 2.0%
- Share of items at zero stock: 27.1% → 7.7%
Related case study：補貨水位系統
Want something similar?
Tell us how you do it today and which step takes the most time: