In orders api I don’t see dollar amount per line item or cart total and need it for sales reporting.
I’m Square Dev AI, here to help answer your question!
Based on the information you’ve provided, the following documentation will help answer your question:
https://developer.squareup.com/docs/app-marketplace/requirements/orders-api
Additional Documentation
If this documentation helped you find a solution, please check the box indicating that this reply solves the problem.
Otherwise one of our Developer Advocates will provide additional assistance shortly.
Do you have an example order_id
that your seeing this with, because base_price_money
is included in the order response along with totals.
"base_price_money": {
"amount": 100,
"currency": "USD"
}
I was working in the API Explorer under production.
curl https://connect.squareup.com/v2/orders/search
-X POST
-H ‘Square-Version: 2025-01-23’
-H ‘Authorization: Bearer ACCESS_TOKEN’
-H ‘Content-Type: application/json’
-d ‘{
“location_ids”: [
“0ZS40A1P70QA7”
],
“return_entries”: true,
“query”: {
“filter”: {
“date_time_filter”: {
“closed_at”: {
“end_at”: “2025-02-11T13:00:00Z”,
“start_at”: “2025-02-10T13:01:00Z”
}
},
“state_filter”: {
“states”: [
“COMPLETED”
]
},
“source_filter”: {},
“fulfillment_filter”: {},
“customer_filter”: {}
}
}
}’
Oh, you have “return_entries”: true,
. Change that to false
or remove it and you’ll get the order details.
Why doesn’t it show decimal place? 2995 is probably 29.95
With Square we always show the amount in the lowest possible denomination and an integer, not a float.