AH-546467
SPAIN ·
rejected
FULL DETAILS
Customer
All known fields
Name
DAVID GABARRON TUSET
Email
david.gaba.dgs@gmail.com
Phone
649224339
Address
CARRER DE PERE MARTELL 0019
City
Tarragona
Province
Tarragona
Zip
43001
Order
Items + tracking
Payment
PREPAID
Total
40.00
Created
08-04-2026 13:08
Confirmed
08-04-2026 13:08
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 05:10
Details fetched
17-04-2026 18:36
History fetched
17-04-2026 15:09
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
546467
name
DAVID GABARRON TUSET
phone
649224339
method_payment
PREPAID
lead_value
40
email
david.gaba.dgs@gmail.com
status_confirmation
confirmed
status_livrison
rejected
city
Tarragona
zipcod
43001
address
CARRER DE PERE MARTELL 19
quantity
1
note
province
Tarragona
tracking_number
32300028962594401430014
tracking_return
33000000753733001181104
shipping_company
cexpr
orderId
leadproduct
item 0
quantity
1
lead_value
40
name
ACMC ES
upsel
history
item 0
status
confirmed
comment
created_at
2026-04-08T11:08:57.000000Z
item 1
status
picking process
comment
picking process
created_at
2026-04-08T13:01:01.000000Z
item 2
status
item packed
comment
item packed
created_at
2026-04-08T13:43:33.000000Z
item 3
status
proseccing
comment
proseccing
created_at
2026-04-08T14:19:19.000000Z
item 4
status
shipped
comment
shipped
created_at
2026-04-08T17:15:11.000000Z
item 5
status
proseccing
comment
proseccing
created_at
2026-04-08T17:19:37.000000Z
item 6
status
in transit
comment
in transit
created_at
2026-04-08T17:37:14.000000Z
item 7
status
in delivery
comment
in delivery
created_at
2026-04-09T08:15:29.000000Z
item 8
status
incident
comment
incident
created_at
2026-04-09T11:44:14.000000Z
item 9
status
rejected
comment
rejected
created_at
2026-04-17T15:09:10.000000Z
Derived & mapped fields
Columns we store for fast dashboards
Lead
AH-546467
Country
SPAIN
Current status
rejected · 17-04-2026 17:09
Created (remote)
08-04-2026 13:08
Confirmed
08-04-2026 13:08
Delivered
Returned
Rejected
17-04-2026 17:09 ever
Canceled
Final
YES
Full data
YES
Full details
YES
Customer
DAVID GABARRON TUSET · david.gaba.dgs@gmail.com · 649224339
Address
CARRER DE PERE MARTELL 0019, Tarragona 43001 Tarragona
Payment
PREPAID · 40.00
Tracking
32300028962594401430014 ·
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": 546467,
"name": "DAVID GABARRON TUSET",
"phone": "649224339",
"method_payment": "PREPAID",
"lead_value": "40",
"email": "david.gaba.dgs@gmail.com",
"status_confirmation": "confirmed",
"status_livrison": "rejected",
"city": "Tarragona",
"zipcod": "43001",
"address": "CARRER DE PERE MARTELL 19",
"quantity": 1,
"note": null,
"province": "Tarragona",
"tracking_number": "32300028962594401430014",
"tracking_return": "33000000753733001181104",
"shipping_company": "cexpr",
"orderId": null
},
"leadproduct": [
{
"quantity": 1,
"lead_value": "40",
"name": "ACMC ES"
}
],
"upsel": [],
"history": [
{
"status": "confirmed",
"comment": null,
"created_at": "2026-04-08T11:08:57.000000Z"
},
{
"status": "picking process",
"comment": "picking process",
"created_at": "2026-04-08T13:01:01.000000Z"
},
{
"status": "item packed",
"comment": "item packed",
"created_at": "2026-04-08T13:43:33.000000Z"
},
{
"status": "proseccing",
"comment": "proseccing",
"created_at": "2026-04-08T14:19:19.000000Z"
},
{
"status": "shipped",
"comment": "shipped",
"created_at": "2026-04-08T17:15:11.000000Z"
},
{
"status": "proseccing",
"comment": "proseccing",
"created_at": "2026-04-08T17:19:37.000000Z"
},
{
"status": "in transit",
"comment": "in transit",
"created_at": "2026-04-08T17:37:14.000000Z"
},
{
"status": "in delivery",
"comment": "in delivery",
"created_at": "2026-04-09T08:15:29.000000Z"
},
{
"status": "incident",
"comment": "incident",
"created_at": "2026-04-09T11:44:14.000000Z"
},
{
"status": "rejected",
"comment": "rejected",
"created_at": "2026-04-17T15:09:10.000000Z"
}
]
}
History
10 entries
| Status | Raw | When |
|---|---|---|
| rejected | rejected | 17-04-2026 17:09 |
| incident | incident | 09-04-2026 13:44 |
| in_delivery | in delivery | 09-04-2026 10:15 |
| in_transit | in transit | 08-04-2026 19:37 |
| proseccing | proseccing | 08-04-2026 19:19 |
| shipped | shipped | 08-04-2026 19:15 |
| proseccing | proseccing | 08-04-2026 16:19 |
| item packed | item packed | 08-04-2026 15:43 |
| picking process | picking process | 08-04-2026 15:01 |
| confirmed | confirmed | 08-04-2026 13:08 |