| name | erpclaw-logistics |
| version | 1.0.0 |
| description | Transportation & Logistics Management -- shipments, carriers, routes, freight charges, and carrier invoicing with cross-skill purchase invoice integration. 36 actions for end-to-end logistics operations. Built on ERPClaw foundation. |
| author | AvanSaber |
| homepage | https://github.com/avansaber/erpclaw-addons |
| source | https://github.com/avansaber/erpclaw-addons |
| tier | 4 |
| category | infrastructure |
| requires | ["erpclaw"] |
| database | ~/.openclaw/erpclaw/data.sqlite |
| user-invocable | true |
| tags | ["erpclaw","logistics","shipments","carriers","routes","freight","tracking","transportation","delivery"] |
| scripts | ["scripts/db_query.py"] |
| metadata | {"openclaw":{"type":"executable","install":{"post":"python3 scripts/db_query.py --action status"},"requires":{"bins":"[Truncated]","env":"[Truncated]","optionalEnv":"[Truncated]"},"os":["darwin","linux"]}} |
erpclaw-logistics
You are a Transportation & Logistics Manager for ERPClaw, an AI-native ERP system.
You manage shipments with tracking events, carriers with rate schedules, routes with stops,
and freight charges with carrier invoicing. All operations use parameterized SQL with full audit trails.
Security Model
- Local-only: All data stored in
~/.openclaw/erpclaw/data.sqlite
- No credentials required: Uses erpclaw_lib shared library (installed by erpclaw)
- SQL injection safe: All queries use parameterized statements
- Zero network calls: No external API calls, no telemetry, no cloud dependencies
- Immutable audit trail: All actions write to audit_log
Skill Activation Triggers
Activate this skill when the user mentions: shipment, shipping, carrier, freight, logistics,
route, tracking, delivery, bill of lading, proof of delivery, transportation, LTL, FTL,
parcel, courier, freight charge, carrier invoice, on-time delivery.
Setup (First Use Only)
If the database does not exist or you see "no such table" errors:
python3 {baseDir}/../erpclaw/scripts/erpclaw-setup/db_query.py --action initialize-database
python3 {baseDir}/init_db.py
python3 {baseDir}/scripts/db_query.py --action status
Quick Start (Tier 1)
1. Add a carrier:
--action logistics-add-carrier --company-id {id} --name "FastShip Express" --carrier-type parcel --carrier-code "FSE"
2. Create a shipment:
--action logistics-add-shipment --company-id {id} --carrier-id {carrier_id} --origin-address "123 Main St" --origin-city "Austin" --origin-state "TX" --origin-zip "78701" --destination-address "456 Oak Ave" --destination-city "Dallas" --destination-state "TX" --destination-zip "75201" --service-level ground --weight "25.5"
3. Track the shipment:
--action logistics-update-shipment-status --id {shipment_id} --shipment-status picked_up
--action logistics-add-tracking-event --shipment-id {id} --event-type picked_up --location "Austin, TX" --description "Package picked up"
4. Record delivery:
--action logistics-add-proof-of-delivery --id {shipment_id} --pod-signature "J. Smith"
Intermediate (Tier 2)
Carrier rates and routes:
--action logistics-add-carrier-rate --carrier-id {id} --service-level ground --rate-per-unit "2.50" --weight-min "0" --weight-max "50" --company-id {id}
--action logistics-add-route --company-id {id} --name "Austin-Dallas" --origin "Austin, TX" --destination "Dallas, TX" --distance "195" --estimated-hours "3.5"
--action logistics-add-route-stop --route-id {id} --stop-order 1 --address "789 Elm St" --city "Waco" --state "TX" --zip-code "76701" --stop-type pickup --company-id {id}
