WMS Systems Research
Дата: 2026-01-02
Версия: 1.0
Статус: Исследование
Содержание
- Odoo WMS
- inFlow Inventory
- Cin7 Core WMS
- Fishbowl Inventory
- Сравнительная матрица
- Заключение
ODOO WMS
1. Модели данных
Основные сущности
| Сущность |
Описание |
Поля |
Примечание |
| stock.location |
Локация складирования |
location_id, name, usage, barcode |
Иерархическая |
| stock.quant |
Текущие остатки |
product_id, location_id, qty |
Снимок состояния |
| stock.move |
История движений |
product_id, location_src, location_dest, qty |
FIFO/LIFO/FEFO |
| stock.move.line |
Строки движения |
move_id, product_id, qty_done |
Связь с quant |
| stock.warehouse |
Склад |
name, company_id |
Группирует локации |
| stock.production.lot |
Партии/серии |
name, product_id, expiration_date |
Tracking |
Inventory Tracking
- Double-entry: все движения как переводы между локациями
- Real-time: quant обновляется при завершении stock.move
- FIFO/LIFO/FEFO: для расчёта себестоимости
- Index:
(product_id, location_id, company_id, qty, in_date)
Barcode/SKU
| Поле |
Тип |
Использование |
product.barcode |
String |
EAN-13, UPC |
product.barcode_ids |
Many2many |
Дополнительные |
product.default_code |
String |
SKU |
2. UI паттерны
Структура складов/локаций
Warehouse/
├─ Receiving Area/
├─ Shelves/ (A-01, A-02, ...)
├─ Pallets/ (PALLET-001, ...)
└─ Shipping/
Движения и операции
Draft → Waiting → Assigned → Done
Barcode scanner интеграция
- Receipt scan
- Product barcode
- Location barcode
- Serial/Lot tracking
3. Документы
| Документ |
Назначение |
| Stock Picking |
Приём, комплектация, доставка |
| Stock Move |
Движение товара |
| Goods Receipt |
Приёмка поставщика |
| Inventory Adjustment |
Инвентаризация |
4. Общие компоненты
- Reorder points per location
- FIFO/LIFO/FEFO costing
- Multi-warehouse support
- Dashboard с alerts
INFLOW INVENTORY
1. Модели данных
| Сущность |
Описание |
| Product |
SKU, UPC, категория |
| Location |
Склад, отделение |
| Inventory |
Остатки по локациям |
| Supplier |
Поставщик |
| Bill of Materials |
Для сборки |
| Assembly |
Операция сборки |
Inventory Tracking
- Real-time multi-location
- Reorder points per location
- Cloud-based (Azure)
- Offline capability (Windows)
Barcode/SKU
- SKU (unique)
- UPC (EAN-13)
- Multiple barcodes (comma-separated)
- No duplicates support
2. UI паттерны
Структура
Company/
├─ Main Warehouse
│ ├─ Receiving Area
│ ├─ Storage Shelves (Aisle A, Aisle B)
│ ├─ Packing Area
│ └─ Shipping Area
├─ Retail Store #1
└─ Retail Store #2
Операции
- Stock Transfer workflow
- Picking/Packing interface
- Barcode scanning (Receiving, Picking, Transfer, Cycle Count)
3. Документы
| Document |
Purpose |
| Purchase Order |
Заказ поставщику |
| Stock Transfer |
Перемещение |
| Bill of Materials |
Состав |
| Receiving Report |
Приём |
4. Общие компоненты
- Manufacturing: BOM, Assembly, WIP
- Auto-PO: при низких остатках
- Reports: Valuation, Low Stock, Transfer History
- Search: by SKU, UPC, location
CIN7 CORE WMS
1. Модели данных
| Сущность |
Описание |
| Product |
SKU, batch/serial support |
| Warehouse |
Склад |
| Location |
Шельф/зона |
| Stock Level |
Остатки |
| Sales Order |
Заказ покупателя |
| Pick List |
Комплектация с маршрутом |
| Branch Transfer |
Межскладской перевод |
Inventory Tracking
- Real-time sync (mobile ↔ cloud)
- Batch & Serial tracking
- Location hierarchy
- Multi-warehouse seamless
2. UI паттерны
Mobile WMS app
- Main Menu: Pick, Restock, Put Away, Lookup Stock
- Pick Screen: order → product → location → confirm
- Restock: low inventory suggestions
- Lookup: qty by location, reorder points
Features
- Route optimization
- Up to 1000 items per pick
- Multi-order picking
3. Документы
| Document |
Purpose |
| Pick List |
Комплектация |
| Packing Slip |
Упаковка |
| Goods Receipt |
Приём |
| Transfer Order |
Перемещение |
4. Общие компоненты
- API: Order Download, Shipment Confirmation
- Batch tracking: serial numbers, expiration
- Search: SKU, barcode, location, order
FISHBOWL INVENTORY
1. Модели данных
Firebird SQL
| Table |
Purpose |
| Part |
Товар (PartNumber = SKU) |
| Inventory |
Остатки по локациям |
| Location |
Шельф/зона |
| Warehouse |
Склад |
| SalesOrder |
Заказ |
| TransferOrder |
Перемещение |
| PurchaseOrder |
Заказ поставщику |
| Barcode |
Штрих-коды |
Inventory Tracking
- Unlimited locations: no extra cost
- Granular bin tracking: per-shelf level
- Real-time updates
- Cost tracking: FIFO/weighted average
2. UI паттерны
Warehouse Structure
Main Warehouse
├─ Location Group: RECEIVING
├─ Location Group: STORAGE
│ ├─ Shelf-A01, A02, ...
│ └─ Shelf-B01, B02, ...
├─ Location Group: PALLETS
└─ Location Group: SHIPPING
Dashboard
- Inventory value
- Low stock items
- Stock-to-sales ratio
- Alerts: min, max, reorder point
Transfer Order Workflow
1. Create + select locations + items
2. Add items + qty
3. Confirm & execute
4. Receive at destination
3. Документы
| Document |
Type |
| Sales Order |
Outbound |
| Transfer Order |
Internal |
| Purchase Order |
Inbound |
| Receipt |
Inbound |
| Stock History |
Report |
| Valuation Report |
Report |
4. Общие компоненты
- Integration: QB, Xero, e-commerce, REST API
- Manufacturing: Work Orders, BOM, Assembly
- Analytics: Turnover, Aging, Forecasting
- Search: Part #, Barcode, Location
Сравнительная матрица
Архитектура & Технология
| Критерий |
Odoo |
inFlow |
Cin7 |
Fishbowl |
| Тип |
Open Source ERP |
Cloud SaaS |
Cloud SaaS |
Desktop/Server |
| Database |
PostgreSQL |
Azure |
Cloud |
Firebird SQL |
| Barcode |
✓ Full |
✓ Full |
✓ Full |
✓ Full |
| Mobile App |
✓ Web |
✓ App |
✓ iOS/Android |
Limited |
| Offline |
Web cache |
✓ Windows |
✓ Sync |
Desktop |
Модели данных
| Аспект |
Odoo |
inFlow |
Cin7 |
Fishbowl |
| Основная сущность |
stock.move |
Inventory |
Stock Level |
Inventory |
| Location tracking |
Иерархическая |
Multi-level |
Groups |
Unlimited |
| Batch/Serial |
✓ lots |
✓ BOM |
✓ Batch/Serial |
✓ |
| Multi-warehouse |
✓ |
✓ |
✓ |
✓ Unlimited |
| Real-time |
✓ Double-entry |
✓ |
✓ |
✓ |
UI & Workflow
| Feature |
Odoo |
inFlow |
Cin7 |
Fishbowl |
| Barcode Scanning |
✓ Web app |
✓ Mobile |
✓ Mobile WMS |
✓ Desktop |
| Mobile Picking |
Web |
✓ App |
✓ Dedicated |
Limited |
| Guided Walk Path |
No |
✓ |
✓ WMS |
Manual |
| Dashboard |
✓ Custom |
✓ |
✓ Mobile |
✓ |
Integration & Manufacturing
| Feature |
Odoo |
inFlow |
Cin7 |
Fishbowl |
| Accounting |
Built-in |
QB, Xero |
✓ |
QB, Xero |
| E-commerce |
Shopify, WooCommerce |
✓ |
Shopify, Amazon |
Multi-channel |
| Manufacturing |
MRP |
BOM, Assembly |
Limited |
✓ Full WO |
| API |
REST/JSON-RPC |
✓ |
Webhooks |
REST |
Cost Analysis
| Factor |
Odoo |
inFlow |
Cin7 |
Fishbowl |
| License |
Open Source |
SaaS |
Cloud |
Server/User |
| Setup |
High |
Low |
Medium |
Medium |
| Multi-warehouse |
No extra |
Included |
Included |
No extra |
Рекомендации
Для пироТехники
Потребности:
- Multi-warehouse (основной + branch locations)
- High-volume SKU (~2000-5000)
- Batch/Expiration tracking
- Mobile receiving & picking
Рекомендация: Fishbowl или Cin7
| Критерий |
Cin7 |
Fishbowl |
| Multi-warehouse |
✓ |
✓ ✓ (unlimited) |
| Mobile WMS |
✓ ✓ |
Limited |
| Manufacturing |
Limited |
✓ ✓ ✓ |
| Cost analysis |
✓ |
✓ ✓ |
| Cloud-native |
✓ ✓ |
Desktop |
Fishbowl лучше: manufacturing (kit assembly), unlimited locations, cost tracking
Cin7 лучше: mobile-first, real-time, guided walk-path
Источники
Статус: Завершено | Версия: 1.0 | Дата: 2026-01-02