erpclaw-logistics

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":["python3"],"env":[],"optionalEnv":["ERPCLAW_DB_PATH"]},"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}

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}

Advanced (Tier 3)

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}

Actions Reference