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.
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.
~/.openclaw/erpclaw/data.sqliteActivate 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.
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
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"
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}
Freight charges and invoices:
--action logistics-add-freight-charge --shipment-id {id} --charge-type base --amount "45.00" --company-id {id}
--action logistics-add-carrier-invoice --carrier-id {id} --invoice-number "INV-001" --invoice-date "2026-01-15" --total-amount "1250.00" --company-id {id}
--action logistics-verify-carrier-invoice --id {carrier_invoice_id}
Link carrier to supplier (required for invoice verification):
--action logistics-add-carrier --company-id {id} --name "FastShip Express" --carrier-type parcel --supplier-id {supplier_id}
--action logistics-update-carrier --id {carrier_id} --supplier-id {supplier_id}
Reports and analytics:
--action logistics-shipment-summary-report --company-id {id}
--action logistics-carrier-performance-report --company-id {id}
--action logistics-freight-cost-analysis-report --company-id {id}
--action logistics-on-time-delivery-report --company-id {id}
--action logistics-delivery-exception-report --company-id {id}
| Action | Description |
|---|---|
logistics-add-shipment | Create a new shipment |
logistics-update-shipment | Update shipment details |
logistics-get-shipment | Get shipment with tracking events |
logistics-list-shipments | List shipments with filters |
logistics-update-shipment-status | Change shipment status |
logistics-add-tracking-event | Add a tracking event to a shipment |
logistics-list-tracking-events | List tracking events for a shipment |
logistics-add-proof-of-delivery | Record proof of delivery |
logistics-generate-bill-of-lading | Generate BOL data for a shipment |
logistics-shipment-summary-report | Summary statistics on shipments |
logistics-add-carrier | Register a new carrier |
logistics-update-carrier | Update carrier details |
logistics-get-carrier | Get carrier details with stats |
logistics-list-carriers | List carriers with filters |
logistics-add-carrier-rate | Add a rate entry for a carrier |
logistics-list-carrier-rates | List rates for a carrier |
logistics-carrier-performance-report | Carrier on-time and volume stats |
logistics-carrier-cost-comparison | Compare costs across carriers |
logistics-add-route | Create a logistics route |
logistics-update-route | Update route details |
logistics-list-routes | List routes with filters |
logistics-add-route-stop | Add a stop to a route |
logistics-list-route-stops | List stops for a route |
logistics-optimize-route-report | Route optimization suggestions |
logistics-add-freight-charge | Add a freight charge to a shipment |
logistics-list-freight-charges | List freight charges |
logistics-allocate-freight | Allocate freight to a shipment |
logistics-add-carrier-invoice | Create a carrier invoice |
logistics-list-carrier-invoices | List carrier invoices |
logistics-verify-carrier-invoice | Verify carrier invoice and create purchase invoice |
logistics-freight-cost-analysis-report | Freight cost breakdown report |
logistics-on-time-delivery-report | On-time delivery metrics |
logistics-delivery-exception-report | Delivery exceptions summary |
status | Skill health check |