AH-540192
ITALY ·
delivered
FULL DETAILS
Customer
All known fields
Name
MARIO FRANCO TORCOLI
Email
mariofrancotorcoli@gmail.com
Phone
393461297505
Address
Via Lombardia 2/C
City
Porto Torres
Province
SS
Zip
07046
Order
Items + tracking
Payment
PREPAID
Total
40.00
Created
24-03-2026 10:17
Confirmed
24-03-2026 10:17
Tracking
06635700681206
Cards QTY
1
Items
| SKU | QTY | Total |
|---|---|---|
| 1 |
Sync / Cron info
When we last fetched this lead
Last sync job
sync_leads
Last sync at
27-04-2026 06:50
Details fetched
02-04-2026 09:49
History fetched
02-04-2026 15:51
Final status
YES
Details completeness
All required fields are present
Required
OK
OKEverything required is available.
Optional
1 missing
- Courier
All lead data (API)
Everything we fetched from EFC for this lead (details + derived fields). Expand blocks as needed.
Details payload (tree)
From
/api/leads/details?leadNumber=...keys: 4
lead
code
540192
name
MARIO FRANCO TORCOLI
phone
393461297505
method_payment
PREPAID
lead_value
40
email
mariofrancotorcoli@gmail.com
status_confirmation
confirmed
status_livrison
in delivery
city
Porto Torres
zipcod
07046
address
Via Lombardia 2/C
quantity
1
note
province
SS
tracking_number
0663570068120620260324
tracking_return
shipping_company
dpd
orderId
leadproduct
item 0
quantity
1
lead_value
40
name
ACMC IT
upsel
history
item 0
status
confirmed
comment
confirmed
created_at
2026-03-24T09:17:46.000000Z
item 1
status
picking process
comment
picking process
created_at
2026-03-24T09:19:38.000000Z
item 2
status
item packed
comment
item packed
created_at
2026-03-24T09:23:55.000000Z
item 3
status
shipped
comment
shipped
created_at
2026-03-24T14:33:50.000000Z
item 4
status
proseccing
comment
Data exchange - Control
created_at
2026-03-24T15:00:13.000000Z
item 5
status
in transit
comment
Status parcel - Information
created_at
2026-03-24T16:10:37.000000Z
item 6
status
in delivery
comment
Linehaul - Arrival
created_at
2026-03-25T06:33:48.000000Z
item 7
status
in transit
comment
Linehaul - Start unloading
created_at
2026-03-25T10:44:08.000000Z
item 8
status
in delivery
comment
Linehaul - Arrival
created_at
2026-03-26T14:06:15.000000Z
item 9
status
in transit
comment
Hub or other premises - Sorted
created_at
2026-03-27T15:32:02.000000Z
item 10
status
in delivery
comment
Message Notification - Destination Location: Notification of delivery
created_at
2026-03-28T18:15:27.000000Z
item 11
status
in transit
comment
Status parcel - Scan
created_at
2026-03-31T08:31:09.000000Z
item 12
status
in delivery
comment
Message Notification - Destination Location: Notification of delivery
created_at
2026-03-31T09:15:59.000000Z
item 13
status
incident
comment
Delivery - Delivery Exception
created_at
2026-03-31T13:32:47.000000Z
item 14
status
in delivery
comment
Destination depot - Inbound
created_at
2026-04-01T05:44:14.000000Z
item 15
status
incident
comment
Delivery - Delivery Exception
created_at
2026-04-01T08:32:15.000000Z
item 16
status
in delivery
comment
Destination depot - Inbound
created_at
2026-04-02T07:03:11.000000Z
Derived & mapped fields
Columns we store for fast dashboards
Lead
AH-540192
Country
ITALY
Current status
delivered · 02-04-2026 16:33
Created (remote)
24-03-2026 10:17
Confirmed
24-03-2026 10:17
Delivered
02-04-2026 16:33
Returned
Rejected
Canceled
Final
YES
Full data
YES
Full details
YES
Customer
MARIO FRANCO TORCOLI · mariofrancotorcoli@gmail.com · 393461297505
Address
Via Lombardia 2/C, Porto Torres 07046 SS
Payment
PREPAID · 40.00
Tracking
06635700681206 ·
Cards QTY
1
Products / Items blocks found in payload
items_json
| SKU | QTY | TOTAL | NAME/DESC |
|---|---|---|---|
| 1 | ACMC IT |
leadproduct
| SKU | QTY | TOTAL | NAME/DESC |
|---|---|---|---|
| 1 | ACMC IT |
upsel
No rows
Raw JSON (pretty)
{
"lead": {
"code": 540192,
"name": "MARIO FRANCO TORCOLI",
"phone": "393461297505",
"method_payment": "PREPAID",
"lead_value": "40",
"email": "mariofrancotorcoli@gmail.com",
"status_confirmation": "confirmed",
"status_livrison": "in delivery",
"city": "Porto Torres",
"zipcod": "07046",
"address": "Via Lombardia 2/C",
"quantity": 1,
"note": null,
"province": "SS",
"tracking_number": "0663570068120620260324",
"tracking_return": null,
"shipping_company": "dpd",
"orderId": null
},
"leadproduct": [
{
"quantity": 1,
"lead_value": "40",
"name": "ACMC IT"
}
],
"upsel": [],
"history": [
{
"status": "confirmed",
"comment": "confirmed",
"created_at": "2026-03-24T09:17:46.000000Z"
},
{
"status": "picking process",
"comment": "picking process",
"created_at": "2026-03-24T09:19:38.000000Z"
},
{
"status": "item packed",
"comment": "item packed",
"created_at": "2026-03-24T09:23:55.000000Z"
},
{
"status": "shipped",
"comment": "shipped",
"created_at": "2026-03-24T14:33:50.000000Z"
},
{
"status": "proseccing",
"comment": "Data exchange - Control",
"created_at": "2026-03-24T15:00:13.000000Z"
},
{
"status": "in transit",
"comment": "Status parcel - Information",
"created_at": "2026-03-24T16:10:37.000000Z"
},
{
"status": "in delivery",
"comment": "Linehaul - Arrival",
"created_at": "2026-03-25T06:33:48.000000Z"
},
{
"status": "in transit",
"comment": "Linehaul - Start unloading",
"created_at": "2026-03-25T10:44:08.000000Z"
},
{
"status": "in delivery",
"comment": "Linehaul - Arrival",
"created_at": "2026-03-26T14:06:15.000000Z"
},
{
"status": "in transit",
"comment": "Hub or other premises - Sorted",
"created_at": "2026-03-27T15:32:02.000000Z"
},
{
"status": "in delivery",
"comment": "Message Notification - Destination Location: Notification of delivery",
"created_at": "2026-03-28T18:15:27.000000Z"
},
{
"status": "in transit",
"comment": "Status parcel - Scan",
"created_at": "2026-03-31T08:31:09.000000Z"
},
{
"status": "in delivery",
"comment": "Message Notification - Destination Location: Notification of delivery",
"created_at": "2026-03-31T09:15:59.000000Z"
},
{
"status": "incident",
"comment": "Delivery - Delivery Exception",
"created_at": "2026-03-31T13:32:47.000000Z"
},
{
"status": "in delivery",
"comment": "Destination depot - Inbound",
"created_at": "2026-04-01T05:44:14.000000Z"
},
{
"status": "incident",
"comment": "Delivery - Delivery Exception",
"created_at": "2026-04-01T08:32:15.000000Z"
},
{
"status": "in delivery",
"comment": "Destination depot - Inbound",
"created_at": "2026-04-02T07:03:11.000000Z"
}
]
}
History
18 entries
| Status | Raw | When |
|---|---|---|
| delivered | delivered | 02-04-2026 16:33 |
| in_delivery | in delivery | 02-04-2026 09:03 |
| incident | incident | 01-04-2026 10:32 |
| in_delivery | in delivery | 01-04-2026 07:44 |
| incident | incident | 31-03-2026 15:32 |
| in_delivery | in delivery | 31-03-2026 11:15 |
| in_transit | in transit | 31-03-2026 10:31 |
| in_delivery | in delivery | 28-03-2026 19:15 |
| in_transit | in transit | 27-03-2026 16:32 |
| in_delivery | in delivery | 26-03-2026 15:06 |
| in_transit | in transit | 25-03-2026 11:44 |
| in_delivery | in delivery | 25-03-2026 07:33 |
| in_transit | in transit | 24-03-2026 17:10 |
| proseccing | proseccing | 24-03-2026 16:00 |
| shipped | shipped | 24-03-2026 15:33 |
| item packed | item packed | 24-03-2026 10:23 |
| picking process | picking process | 24-03-2026 10:19 |
| confirmed | confirmed | 24-03-2026 10:17 |