Short Answer: In Part 2 of the TechParts Malaysia case study, we explore how Odoo Inventory achieved 99.5% accuracy across 15,000 SKUs and 3 warehouses — using cycle counting, barcode scanning, and automated reorder rules to eliminate RM300,000 in annual stockout losses.
Table of Contents
- Inventory Management Deep Dive
- Cycle Counting Strategy
- Barcode Scanning Setup
- Automated Reorder Rules
- Frequently Asked Questions
- Results After 6 Months
- Summary
Inventory Management Deep Dive
TechParts Malaysia manages 15,000 SKUs across 3 warehouses in Penang, KL, and Johor. Before Odoo, they relied on spreadsheets and annual stock counts — accuracy was just 85%, costing RM300,000 in stockouts and RM500,000 in overstocking annually.
Cycle Counting Strategy
Instead of annual counts (which shut down operations for days), TechParts now uses Odoo's cycle counting:
- A items (high value) — counted weekly
- B items (medium value) — counted monthly
- C items (low value) — counted quarterly
This ensures high-value items are always accurate while minimizing counting effort.
Barcode Scanning Setup
Systum360 deployed barcode scanners at all 3 warehouses:
- Receiving — scan incoming shipments against POs
- Putaway — scan location barcodes for proper storage
- Picking — scan pick lists for order fulfillment
- Shipping — scan outgoing packages for verification
Automated Reorder Rules
Odoo automatically triggers purchase orders when stock hits minimum levels:
| Rule Type | Trigger | Action |
|---|---|---|
| Min/Max | Stock drops below minimum | PO to preferred supplier |
| Safety Stock | Buffer for demand spikes | Maintain 2-week supply |
| Reorder Point | Lead time consideration | Order before stockout |
Step-by-Step: Setting Up Inventory Accuracy
- Classify your SKUs — ABC analysis: A (high value), B (medium), C (low)
- Set up cycle counting — A items weekly, B monthly, C quarterly
- Deploy barcode scanners — Receiving, putaway, picking, shipping
- Configure reorder rules — Min/max levels based on lead time and demand
- Train warehouse staff — Scanning procedures for every movement
- Review accuracy weekly — Dashboard monitoring and exception reporting
Frequently Asked Questions
How do you manage 15,000 SKUs across 3 warehouses?
Odoo's multi-warehouse feature lets you view stock levels across all locations in real-time. Transfer orders move stock between warehouses based on demand.
What barcode scanners work with Odoo?
Odoo supports USB, Bluetooth, and Wi-Fi barcode scanners. Systum360 recommended Zebra TC21 handheld scanners for TechParts — cost: RM1,500 each.
How accurate is cycle counting vs annual counts?
Cycle counting maintains 99%+ accuracy continuously. Annual counts typically achieve 85–90% accuracy and require full operational shutdown for 2–3 days.
Can Odoo handle lot/serial number tracking?
Yes. Odoo supports lot numbers, serial numbers, and expiry dates — critical for electronics components that may have quality recalls.
Results After 6 Months
| Metric | Before | After |
|---|---|---|
| Inventory accuracy | 85% | 99.5% |
| Annual stockout losses | RM300,000 | RM15,000 |
| Overstocking costs | RM500,000 | RM100,000 |
| Annual count shutdown | 3 days | Zero (cycle counting) |
Pros
- ✅ Proven results — real metrics from a real Malaysian business
- ✅ Scalable approach — same methodology works for any size company
- ✅ Quick implementation — 12 weeks from start to go-live
Cons Encountered
- ⚠️ Change management — staff needed time to adapt to digital workflows
- ⚠️ Data migration — initial setup required significant effort
- ⚠️ Customization — some processes needed tailored configuration
Summary
TechParts Malaysia achieved 99.5% inventory accuracy across 15,000 SKUs using Odoo's cycle counting, barcode scanning, and automated reorder rules. Contact Systum360 for an inventory assessment.
📞 Contact us: +6011 5995 0954 | tech@systum360.com | www.systum360.com