Looking for complete shopping cart including line item amount and cart total for sales reporting

In orders api I don’t see dollar amount per line item or cart total and need it for sales reporting.

:wave: 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

Orders API
Pay for Orders
Create Orders

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"
                    }

:slight_smile:

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. :slight_smile:

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. :slight_smile: