AH-530298
ITALY ·
delivered
FULL DETAILS
Customer
All known fields
Name
ANDREA LANCIA
Email
a.lancia@mixstudios.it
Phone
393517186930
Address
Via Francesco Borromini 14
City
Mentana
Province
RM
Zip
00013
Order
Items + tracking
Payment
PREPAID
Total
40.00
Created
06-03-2026 13:20
Confirmed
06-03-2026 13:20
Tracking
06635700662747
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 03:15
Details fetched
19-03-2026 06:30
History fetched
19-03-2026 11:47
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
530298
name
ANDREA LANCIA
phone
393517186930
method_payment
PREPAID
lead_value
40
email
a.lancia@mixstudios.it
status_confirmation
confirmed
status_livrison
in delivery
city
Mentana
zipcod
00013
address
Via Francesco Borromini 14
quantity
1
note
province
RM
tracking_number
0663570066274720260306
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-06T12:20:40.000000Z
item 1
status
picking process
comment
picking process
created_at
2026-03-06T12:26:04.000000Z
item 2
status
item packed
comment
item packed
created_at
2026-03-06T12:31:31.000000Z
item 3
status
shipped
comment
shipped
created_at
2026-03-09T15:47:10.000000Z
item 4
status
in transit
comment
Status parcel - Loaded
created_at
2026-03-09T16:51:52.000000Z
item 5
status
in delivery
comment
Message Notification - Destination Location: Notification of delivery
created_at
2026-03-10T15:45:47.000000Z
item 6
status
in transit
comment
Status parcel - Loaded
created_at
2026-03-10T21:53:47.000000Z
item 7
status
in delivery
comment
Message Notification - Destination Location: Notification of delivery
created_at
2026-03-11T11:10:46.000000Z
item 8
status
in transit
comment
Status parcel - Information
created_at
2026-03-12T02:36:47.000000Z
item 9
status
in delivery
comment
Destination depot - Out for delivery
created_at
2026-03-12T10:19:42.000000Z
item 10
status
in transit
comment
Status parcel - Scan
created_at
2026-03-12T12:22:19.000000Z
item 11
status
in delivery
comment
Destination depot - Inbound
created_at
2026-03-13T07:12:38.000000Z
item 12
status
in transit
comment
Status parcel - Scan
created_at
2026-03-13T13:14:40.000000Z
item 13
status
in delivery
comment
Destination depot - Inbound
created_at
2026-03-16T07:14:23.000000Z
item 14
status
incident
comment
Delivery - Delivery Exception
created_at
2026-03-17T17:14:06.000000Z
item 15
status
in transit
comment
Destination depot - Held
created_at
2026-03-17T19:07:25.000000Z
item 16
status
incident
comment
Query - Opened
created_at
2026-03-18T04:44:50.000000Z
item 17
status
in delivery
comment
Destination depot - Inbound
created_at
2026-03-18T07:06:17.000000Z
item 18
status
incident
comment
Query - Opened
created_at
2026-03-18T12:48:46.000000Z
item 19
status
in delivery
comment
Instruction - Delivery instructions received and validated
created_at
2026-03-18T14:19:20.000000Z
Derived & mapped fields
Columns we store for fast dashboards
Lead
AH-530298
Country
ITALY
Current status
delivered · 19-03-2026 12:33
Created (remote)
06-03-2026 13:20
Confirmed
06-03-2026 13:20
Delivered
19-03-2026 12:33
Returned
Rejected
Canceled
Final
YES
Full data
YES
Full details
YES
Customer
ANDREA LANCIA · a.lancia@mixstudios.it · 393517186930
Address
Via Francesco Borromini 14, Mentana 00013 RM
Payment
PREPAID · 40.00
Tracking
06635700662747 ·
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": 530298,
"name": "ANDREA LANCIA",
"phone": "393517186930",
"method_payment": "PREPAID",
"lead_value": "40",
"email": "a.lancia@mixstudios.it",
"status_confirmation": "confirmed",
"status_livrison": "in delivery",
"city": "Mentana",
"zipcod": "00013",
"address": "Via Francesco Borromini 14",
"quantity": 1,
"note": null,
"province": "RM",
"tracking_number": "0663570066274720260306",
"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-06T12:20:40.000000Z"
},
{
"status": "picking process",
"comment": "picking process",
"created_at": "2026-03-06T12:26:04.000000Z"
},
{
"status": "item packed",
"comment": "item packed",
"created_at": "2026-03-06T12:31:31.000000Z"
},
{
"status": "shipped",
"comment": "shipped",
"created_at": "2026-03-09T15:47:10.000000Z"
},
{
"status": "in transit",
"comment": "Status parcel - Loaded",
"created_at": "2026-03-09T16:51:52.000000Z"
},
{
"status": "in delivery",
"comment": "Message Notification - Destination Location: Notification of delivery",
"created_at": "2026-03-10T15:45:47.000000Z"
},
{
"status": "in transit",
"comment": "Status parcel - Loaded",
"created_at": "2026-03-10T21:53:47.000000Z"
},
{
"status": "in delivery",
"comment": "Message Notification - Destination Location: Notification of delivery",
"created_at": "2026-03-11T11:10:46.000000Z"
},
{
"status": "in transit",
"comment": "Status parcel - Information",
"created_at": "2026-03-12T02:36:47.000000Z"
},
{
"status": "in delivery",
"comment": "Destination depot - Out for delivery",
"created_at": "2026-03-12T10:19:42.000000Z"
},
{
"status": "in transit",
"comment": "Status parcel - Scan",
"created_at": "2026-03-12T12:22:19.000000Z"
},
{
"status": "in delivery",
"comment": "Destination depot - Inbound",
"created_at": "2026-03-13T07:12:38.000000Z"
},
{
"status": "in transit",
"comment": "Status parcel - Scan",
"created_at": "2026-03-13T13:14:40.000000Z"
},
{
"status": "in delivery",
"comment": "Destination depot - Inbound",
"created_at": "2026-03-16T07:14:23.000000Z"
},
{
"status": "incident",
"comment": "Delivery - Delivery Exception",
"created_at": "2026-03-17T17:14:06.000000Z"
},
{
"status": "in transit",
"comment": "Destination depot - Held",
"created_at": "2026-03-17T19:07:25.000000Z"
},
{
"status": "incident",
"comment": "Query - Opened",
"created_at": "2026-03-18T04:44:50.000000Z"
},
{
"status": "in delivery",
"comment": "Destination depot - Inbound",
"created_at": "2026-03-18T07:06:17.000000Z"
},
{
"status": "incident",
"comment": "Query - Opened",
"created_at": "2026-03-18T12:48:46.000000Z"
},
{
"status": "in delivery",
"comment": "Instruction - Delivery instructions received and validated",
"created_at": "2026-03-18T14:19:20.000000Z"
}
]
}
History
21 entries
| Status | Raw | When |
|---|---|---|
| delivered | delivered | 19-03-2026 12:33 |
| in_delivery | in delivery | 18-03-2026 15:19 |
| incident | incident | 18-03-2026 13:48 |
| in_delivery | in delivery | 18-03-2026 08:06 |
| incident | incident | 18-03-2026 05:44 |
| in_transit | in transit | 17-03-2026 20:07 |
| incident | incident | 17-03-2026 18:14 |
| in_delivery | in delivery | 16-03-2026 08:14 |
| in_transit | in transit | 13-03-2026 14:14 |
| in_delivery | in delivery | 13-03-2026 08:12 |
| in_transit | in transit | 12-03-2026 13:22 |
| in_delivery | in delivery | 12-03-2026 11:19 |
| in_transit | in transit | 12-03-2026 03:36 |
| in_delivery | in delivery | 11-03-2026 12:10 |
| in_transit | in transit | 10-03-2026 22:53 |
| in_delivery | in delivery | 10-03-2026 16:45 |
| in_transit | in transit | 09-03-2026 17:51 |
| shipped | shipped | 09-03-2026 16:47 |
| item packed | item packed | 06-03-2026 13:31 |
| picking process | picking process | 06-03-2026 13:26 |
| confirmed | confirmed | 06-03-2026 13:20 |