AH-542567
SPAIN ·
delivered
FULL DETAILS
Customer
All known fields
Name
CARLOS SERRANO MINGUIJON
Email
Minguijoncarlos@gmail.com
Phone
671914374
Address
Calle de Antón García Abril 35
City
Zaragoza
Province
Zaragoza
Zip
50018
Order
Items + tracking
Payment
PREPAID
Total
40.00
Created
30-03-2026 12:13
Confirmed
30-03-2026 12:13
Tracking
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:55
Details fetched
13-04-2026 11:16
History fetched
13-04-2026 12:37
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
542567
name
CARLOS SERRANO MINGUIJON
phone
671914374
method_payment
PREPAID
lead_value
40
email
Minguijoncarlos@gmail.com
status_confirmation
confirmed
status_livrison
in delivery
city
Zaragoza
zipcod
50018
address
Calle de Antón García Abril 35
quantity
1
note
province
Zaragoza
tracking_number
32300028724885001500187
tracking_return
shipping_company
cexpr
orderId
leadproduct
item 0
quantity
1
lead_value
40
name
ACMC ES
upsel
history
item 0
status
confirmed
comment
confirmed
created_at
2026-03-30T10:13:46.000000Z
item 1
status
picking process
comment
picking process
created_at
2026-03-30T10:50:11.000000Z
item 2
status
item packed
comment
item packed
created_at
2026-03-30T10:59:26.000000Z
item 3
status
proseccing
comment
proseccing
created_at
2026-03-30T11:16:12.000000Z
item 4
status
shipped
comment
shipped
created_at
2026-03-30T17:41:46.000000Z
item 5
status
proseccing
comment
proseccing
created_at
2026-03-30T17:48:33.000000Z
item 6
status
in transit
comment
in transit
created_at
2026-03-30T18:10:09.000000Z
item 7
status
incident
comment
incident
created_at
2026-03-31T07:42:28.000000Z
item 8
status
in transit
comment
in transit
created_at
2026-03-31T14:48:50.000000Z
item 9
status
in delivery
comment
in delivery
created_at
2026-04-01T08:06:10.000000Z
item 10
status
in transit
comment
in transit
created_at
2026-04-01T08:36:20.000000Z
item 11
status
in delivery
comment
in delivery
created_at
2026-04-06T08:05:34.000000Z
item 12
status
incident
comment
incident
created_at
2026-04-06T08:12:08.000000Z
item 13
status
in transit
comment
in transit
created_at
2026-04-10T18:42:59.000000Z
item 14
status
in delivery
comment
in delivery
created_at
2026-04-13T06:14:31.000000Z
Derived & mapped fields
Columns we store for fast dashboards
Lead
AH-542567
Country
SPAIN
Current status
delivered · 13-04-2026 13:23
Created (remote)
30-03-2026 12:13
Confirmed
30-03-2026 12:13
Delivered
13-04-2026 13:23
Returned
Rejected
Canceled
Final
YES
Full data
YES
Full details
YES
Customer
CARLOS SERRANO MINGUIJON · Minguijoncarlos@gmail.com · 671914374
Address
Calle de Antón García Abril 35, Zaragoza 50018 Zaragoza
Payment
PREPAID · 40.00
Tracking
32300028724885001500187 ·
Cards QTY
1
Products / Items blocks found in payload
items_json
| SKU | QTY | TOTAL | NAME/DESC |
|---|---|---|---|
| 1 | ACMC ES |
leadproduct
| SKU | QTY | TOTAL | NAME/DESC |
|---|---|---|---|
| 1 | ACMC ES |
upsel
No rows
Raw JSON (pretty)
{
"lead": {
"code": 542567,
"name": "CARLOS SERRANO MINGUIJON",
"phone": "671914374",
"method_payment": "PREPAID",
"lead_value": "40",
"email": "Minguijoncarlos@gmail.com",
"status_confirmation": "confirmed",
"status_livrison": "in delivery",
"city": "Zaragoza",
"zipcod": "50018",
"address": "Calle de Antón García Abril 35",
"quantity": 1,
"note": null,
"province": "Zaragoza",
"tracking_number": "32300028724885001500187",
"tracking_return": null,
"shipping_company": "cexpr",
"orderId": null
},
"leadproduct": [
{
"quantity": 1,
"lead_value": "40",
"name": "ACMC ES"
}
],
"upsel": [],
"history": [
{
"status": "confirmed",
"comment": "confirmed",
"created_at": "2026-03-30T10:13:46.000000Z"
},
{
"status": "picking process",
"comment": "picking process",
"created_at": "2026-03-30T10:50:11.000000Z"
},
{
"status": "item packed",
"comment": "item packed",
"created_at": "2026-03-30T10:59:26.000000Z"
},
{
"status": "proseccing",
"comment": "proseccing",
"created_at": "2026-03-30T11:16:12.000000Z"
},
{
"status": "shipped",
"comment": "shipped",
"created_at": "2026-03-30T17:41:46.000000Z"
},
{
"status": "proseccing",
"comment": "proseccing",
"created_at": "2026-03-30T17:48:33.000000Z"
},
{
"status": "in transit",
"comment": "in transit",
"created_at": "2026-03-30T18:10:09.000000Z"
},
{
"status": "incident",
"comment": "incident",
"created_at": "2026-03-31T07:42:28.000000Z"
},
{
"status": "in transit",
"comment": "in transit",
"created_at": "2026-03-31T14:48:50.000000Z"
},
{
"status": "in delivery",
"comment": "in delivery",
"created_at": "2026-04-01T08:06:10.000000Z"
},
{
"status": "in transit",
"comment": "in transit",
"created_at": "2026-04-01T08:36:20.000000Z"
},
{
"status": "in delivery",
"comment": "in delivery",
"created_at": "2026-04-06T08:05:34.000000Z"
},
{
"status": "incident",
"comment": "incident",
"created_at": "2026-04-06T08:12:08.000000Z"
},
{
"status": "in transit",
"comment": "in transit",
"created_at": "2026-04-10T18:42:59.000000Z"
},
{
"status": "in delivery",
"comment": "in delivery",
"created_at": "2026-04-13T06:14:31.000000Z"
}
]
}
History
16 entries
| Status | Raw | When |
|---|---|---|
| delivered | delivered | 13-04-2026 13:23 |
| in_delivery | in delivery | 13-04-2026 08:14 |
| in_transit | in transit | 10-04-2026 20:42 |
| incident | incident | 06-04-2026 10:12 |
| in_delivery | in delivery | 06-04-2026 10:05 |
| in_transit | in transit | 01-04-2026 10:36 |
| in_delivery | in delivery | 01-04-2026 10:06 |
| in_transit | in transit | 31-03-2026 16:48 |
| incident | incident | 31-03-2026 09:42 |
| in_transit | in transit | 30-03-2026 20:10 |
| proseccing | proseccing | 30-03-2026 19:48 |
| shipped | shipped | 30-03-2026 19:41 |
| proseccing | proseccing | 30-03-2026 13:16 |
| item packed | item packed | 30-03-2026 12:59 |
| picking process | picking process | 30-03-2026 12:50 |
| confirmed | confirmed | 30-03-2026 12:13 |