Do I have to do something special to get Orders to show up in the Admin UI?

Hi there!

I’ve been doing an integration for a merchant, and so far have been using the Sandbox to make sure things are coming together. I’ve used the Catalog API to create my items. I’ve used the Customer API to create a customer for the user, I’ve used the Orders API to create the order, gotten the users’ credit card information and created a payment for the order using the Payments API. However, the order doesn’t show up in the Admin UI for my default test user. The order has a fulfillments field, set to SHIPPING, and the payment is showing as completed, here’s the order data:

order = object(Square\Models\Order)#134 (28) {
[“id”:“Square\Models\Order”:private]=>
string(28) “dgaUIDnL12z4RldyqmG3XtnpPi4F”
[“locationId”:“Square\Models\Order”:private]=>
string(13) “QG4FJYDDFVBBG”
[“referenceId”:“Square\Models\Order”:private]=>
NULL
[“source”:“Square\Models\Order”:private]=>
object(Square\Models\OrderSource)#206 (1) {
[“name”:“Square\Models\OrderSource”:private]=>
string(41) “Sandbox for sq0idp-IJVH1URfgw-tAgGF6Qv01A”
}
[“customerId”:“Square\Models\Order”:private]=>
string(26) “XRWCJGM6D8TXH0RES38T0J15Y8”
[“lineItems”:“Square\Models\Order”:private]=>
array(2) {
[0]=>
object(Square\Models\OrderLineItem)#92 (17) {
[“uid”:“Square\Models\OrderLineItem”:private]=>
string(22) “6IUsUGoG9rwoJSaysVks3B”
[“name”:“Square\Models\OrderLineItem”:private]=>
string(33) “CASTLE FORBES Pre Shave Unscented”
[“quantity”:“Square\Models\OrderLineItem”:private]=>
string(1) “1”
[“quantityUnit”:“Square\Models\OrderLineItem”:private]=>
NULL
[“note”:“Square\Models\OrderLineItem”:private]=>
NULL
[“catalogObjectId”:“Square\Models\OrderLineItem”:private]=>
string(24) “IQ6SJJIKOSMRM5FOSCDCC6EA”
[“variationName”:“Square\Models\OrderLineItem”:private]=>
string(7) “Regular”
[“metadata”:“Square\Models\OrderLineItem”:private]=>
NULL
[“modifiers”:“Square\Models\OrderLineItem”:private]=>
NULL
[“appliedTaxes”:“Square\Models\OrderLineItem”:private]=>
NULL
[“appliedDiscounts”:“Square\Models\OrderLineItem”:private]=>
NULL
[“basePriceMoney”:“Square\Models\OrderLineItem”:private]=>
object(Square\Models\Money)#93 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(7500)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“variationTotalPriceMoney”:“Square\Models\OrderLineItem”:private]=>
object(Square\Models\Money)#46 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(7500)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“grossSalesMoney”:“Square\Models\OrderLineItem”:private]=>
object(Square\Models\Money)#76 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(7500)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“totalTaxMoney”:“Square\Models\OrderLineItem”:private]=>
object(Square\Models\Money)#85 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(0)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“totalDiscountMoney”:“Square\Models\OrderLineItem”:private]=>
object(Square\Models\Money)#29 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(0)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“totalMoney”:“Square\Models\OrderLineItem”:private]=>
object(Square\Models\Money)#31 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(7500)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
}
[1]=>
object(Square\Models\OrderLineItem)#45 (17) {
[“uid”:“Square\Models\OrderLineItem”:private]=>
string(22) “ezTsXSJ1BV98D20jBvdsLB”
[“name”:“Square\Models\OrderLineItem”:private]=>
string(47) “Castle Forbes Essential Oils Shaving Cream Lime”
[“quantity”:“Square\Models\OrderLineItem”:private]=>
string(1) “1”
[“quantityUnit”:“Square\Models\OrderLineItem”:private]=>
NULL
[“note”:“Square\Models\OrderLineItem”:private]=>
NULL
[“catalogObjectId”:“Square\Models\OrderLineItem”:private]=>
string(24) “MBEC7CBCO47HJ5EL7ZBZMYAS”
[“variationName”:“Square\Models\OrderLineItem”:private]=>
string(7) “Regular”
[“metadata”:“Square\Models\OrderLineItem”:private]=>
NULL
[“modifiers”:“Square\Models\OrderLineItem”:private]=>
NULL
[“appliedTaxes”:“Square\Models\OrderLineItem”:private]=>
NULL
[“appliedDiscounts”:“Square\Models\OrderLineItem”:private]=>
NULL
[“basePriceMoney”:“Square\Models\OrderLineItem”:private]=>
object(Square\Models\Money)#39 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(6000)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“variationTotalPriceMoney”:“Square\Models\OrderLineItem”:private]=>
object(Square\Models\Money)#98 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(6000)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“grossSalesMoney”:“Square\Models\OrderLineItem”:private]=>
object(Square\Models\Money)#89 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(6000)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“totalTaxMoney”:“Square\Models\OrderLineItem”:private]=>
object(Square\Models\Money)#91 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(0)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“totalDiscountMoney”:“Square\Models\OrderLineItem”:private]=>
object(Square\Models\Money)#132 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(0)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“totalMoney”:“Square\Models\OrderLineItem”:private]=>
object(Square\Models\Money)#95 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(6000)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
}
}
[“taxes”:“Square\Models\Order”:private]=>
NULL
[“discounts”:“Square\Models\Order”:private]=>
NULL
[“serviceCharges”:“Square\Models\Order”:private]=>
NULL
[“fulfillments”:“Square\Models\Order”:private]=>
array(1) {
[0]=>
object(Square\Models\OrderFulfillment)#163 (6) {
[“uid”:“Square\Models\OrderFulfillment”:private]=>
string(22) “2IpK8SMXqPcvD2UUumS2zB”
[“type”:“Square\Models\OrderFulfillment”:private]=>
string(8) “SHIPMENT”
[“state”:“Square\Models\OrderFulfillment”:private]=>
string(8) “PROPOSED”
[“metadata”:“Square\Models\OrderFulfillment”:private]=>
NULL
[“pickupDetails”:“Square\Models\OrderFulfillment”:private]=>
NULL
[“shipmentDetails”:“Square\Models\OrderFulfillment”:private]=>
object(Square\Models\OrderFulfillmentShipmentDetails)#160 (15) {
[“recipient”:“Square\Models\OrderFulfillmentShipmentDetails”:private]=>
object(Square\Models\OrderFulfillmentRecipient)#118 (5) {
[“customerId”:“Square\Models\OrderFulfillmentRecipient”:private]=>
string(26) “XRWCJGM6D8TXH0RES38T0J15Y8”
[“displayName”:“Square\Models\OrderFulfillmentRecipient”:private]=>
string(12) “Steve Sauder”
[“emailAddress”:“Square\Models\OrderFulfillmentRecipient”:private]=>
string(16) “ourson66@mac.com
[“phoneNumber”:“Square\Models\OrderFulfillmentRecipient”:private]=>
string(11) “16472718061”
[“address”:“Square\Models\OrderFulfillmentRecipient”:private]=>
object(Square\Models\Address)#137 (15) {
[“addressLine1”:“Square\Models\Address”:private]=>
string(25) “306-25 Wellesley St. East”
[“addressLine2”:“Square\Models\Address”:private]=>
NULL
[“addressLine3”:“Square\Models\Address”:private]=>
NULL
[“locality”:“Square\Models\Address”:private]=>
string(7) “Toronto”
[“sublocality”:“Square\Models\Address”:private]=>
NULL
[“sublocality2”:“Square\Models\Address”:private]=>
NULL
[“sublocality3”:“Square\Models\Address”:private]=>
NULL
[“administrativeDistrictLevel1”:“Square\Models\Address”:private]=>
string(2) “ON”
[“administrativeDistrictLevel2”:“Square\Models\Address”:private]=>
NULL
[“administrativeDistrictLevel3”:“Square\Models\Address”:private]=>
NULL
[“postalCode”:“Square\Models\Address”:private]=>
string(7) “M4Y 2S9”
[“country”:“Square\Models\Address”:private]=>
string(2) “CA”
[“firstName”:“Square\Models\Address”:private]=>
NULL
[“lastName”:“Square\Models\Address”:private]=>
NULL
[“organization”:“Square\Models\Address”:private]=>
NULL
}
}
[“carrier”:“Square\Models\OrderFulfillmentShipmentDetails”:private]=>
NULL
[“shippingNote”:“Square\Models\OrderFulfillmentShipmentDetails”:private]=>
NULL
[“shippingType”:“Square\Models\OrderFulfillmentShipmentDetails”:private]=>
NULL
[“trackingNumber”:“Square\Models\OrderFulfillmentShipmentDetails”:private]=>
NULL
[“trackingUrl”:“Square\Models\OrderFulfillmentShipmentDetails”:private]=>
NULL
[“placedAt”:“Square\Models\OrderFulfillmentShipmentDetails”:private]=>
NULL
[“inProgressAt”:“Square\Models\OrderFulfillmentShipmentDetails”:private]=>
NULL
[“packagedAt”:“Square\Models\OrderFulfillmentShipmentDetails”:private]=>
NULL
[“expectedShippedAt”:“Square\Models\OrderFulfillmentShipmentDetails”:private]=>
NULL
[“shippedAt”:“Square\Models\OrderFulfillmentShipmentDetails”:private]=>
NULL
[“canceledAt”:“Square\Models\OrderFulfillmentShipmentDetails”:private]=>
NULL
[“cancelReason”:“Square\Models\OrderFulfillmentShipmentDetails”:private]=>
NULL
[“failedAt”:“Square\Models\OrderFulfillmentShipmentDetails”:private]=>
NULL
[“failureReason”:“Square\Models\OrderFulfillmentShipmentDetails”:private]=>
NULL
}
}
}
[“returns”:“Square\Models\Order”:private]=>
NULL
[“returnAmounts”:“Square\Models\Order”:private]=>
NULL
[“netAmounts”:“Square\Models\Order”:private]=>
object(Square\Models\OrderMoneyAmounts)#190 (5) {
[“totalMoney”:“Square\Models\OrderMoneyAmounts”:private]=>
object(Square\Models\Money)#99 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(13500)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“taxMoney”:“Square\Models\OrderMoneyAmounts”:private]=>
object(Square\Models\Money)#189 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(0)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“discountMoney”:“Square\Models\OrderMoneyAmounts”:private]=>
object(Square\Models\Money)#104 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(0)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“tipMoney”:“Square\Models\OrderMoneyAmounts”:private]=>
object(Square\Models\Money)#108 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(0)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“serviceChargeMoney”:“Square\Models\OrderMoneyAmounts”:private]=>
object(Square\Models\Money)#110 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(0)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
}
[“roundingAdjustment”:“Square\Models\Order”:private]=>
NULL
[“tenders”:“Square\Models\Order”:private]=>
NULL
[“refunds”:“Square\Models\Order”:private]=>
NULL
[“metadata”:“Square\Models\Order”:private]=>
NULL
[“createdAt”:“Square\Models\Order”:private]=>
string(24) “2020-08-06T07:12:39.945Z”
[“updatedAt”:“Square\Models\Order”:private]=>
string(24) “2020-08-06T07:12:39.945Z”
[“closedAt”:“Square\Models\Order”:private]=>
NULL
[“state”:“Square\Models\Order”:private]=>
string(4) “OPEN”
[“version”:“Square\Models\Order”:private]=>
int(1)
[“totalMoney”:“Square\Models\Order”:private]=>
object(Square\Models\Money)#185 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(13500)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“totalTaxMoney”:“Square\Models\Order”:private]=>
object(Square\Models\Money)#184 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(0)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“totalDiscountMoney”:“Square\Models\Order”:private]=>
object(Square\Models\Money)#187 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(0)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“totalServiceChargeMoney”:“Square\Models\Order”:private]=>
object(Square\Models\Money)#192 (2) {
[“amount”:“Square\Models\Money”:private]=>
int(0)
[“currency”:“Square\Models\Money”:private]=>
string(3) “CAD”
}
[“pricingOptions”:“Square\Models\Order”:private]=>
NULL
[“rewards”:“Square\Models\Order”:private]=>
NULL
}

I can’t figure out why it’s not showing up in the Orders list, any help would be appreciated!

1 Like

Just realized i included the wrong version of the order … this was BEFORE the payment was applied … here’s the result from the API when use the BatchRetrieveOrder endpoint to get the order after the payment is applied:

{
“orders”: [
{
“id”: “dgaUIDnL12z4RldyqmG3XtnpPi4F”,
“location_id”: “QG4FJYDDFVBBG”,
“line_items”: [
{
“uid”: “6IUsUGoG9rwoJSaysVks3B”,
“catalog_object_id”: “IQ6SJJIKOSMRM5FOSCDCC6EA”,
“quantity”: “1”,
“name”: “CASTLE FORBES Pre Shave Unscented”,
“variation_name”: “Regular”,
“base_price_money”: {
“amount”: 7500,
“currency”: “CAD”
},
“gross_sales_money”: {
“amount”: 7500,
“currency”: “CAD”
},
“total_tax_money”: {
“amount”: 0,
“currency”: “CAD”
},
“total_discount_money”: {
“amount”: 0,
“currency”: “CAD”
},
“total_money”: {
“amount”: 7500,
“currency”: “CAD”
},
“variation_total_price_money”: {
“amount”: 7500,
“currency”: “CAD”
}
},
{
“uid”: “ezTsXSJ1BV98D20jBvdsLB”,
“catalog_object_id”: “MBEC7CBCO47HJ5EL7ZBZMYAS”,
“quantity”: “1”,
“name”: “Castle Forbes Essential Oils Shaving Cream Lime”,
“variation_name”: “Regular”,
“base_price_money”: {
“amount”: 6000,
“currency”: “CAD”
},
“gross_sales_money”: {
“amount”: 6000,
“currency”: “CAD”
},
“total_tax_money”: {
“amount”: 0,
“currency”: “CAD”
},
“total_discount_money”: {
“amount”: 0,
“currency”: “CAD”
},
“total_money”: {
“amount”: 6000,
“currency”: “CAD”
},
“variation_total_price_money”: {
“amount”: 6000,
“currency”: “CAD”
}
}
],
“fulfillments”: [
{
“uid”: “2IpK8SMXqPcvD2UUumS2zB”,
“type”: “SHIPMENT”,
“state”: “PROPOSED”,
“shipment_details”: {
“recipient”: {
“customer_id”: “XRWCJGM6D8TXH0RES38T0J15Y8”,
“display_name”: “Steve Sauder”,
“email_address”: “ourson66@mac.com”,
“phone_number”: “16472718061”,
“address”: {
“address_line_1”: “306-25 Wellesley St. East”,
“locality”: “Toronto”,
“administrative_district_level_1”: “ON”,
“postal_code”: “M4Y 2S9”,
“country”: “CA”
}
}
}
}
],
“created_at”: “2020-08-06T07:12:39.945Z”,
“updated_at”: “2020-08-06T07:12:40.706Z”,
“state”: “OPEN”,
“version”: 2,
“total_tax_money”: {
“amount”: 0,
“currency”: “CAD”
},
“total_discount_money”: {
“amount”: 0,
“currency”: “CAD”
},
“total_tip_money”: {
“amount”: 0,
“currency”: “CAD”
},
“total_money”: {
“amount”: 13500,
“currency”: “CAD”
},
“tenders”: [
{
“id”: “pmRwUJPqaaCoCrpqODpgdgA9AaNZY”,
“location_id”: “QG4FJYDDFVBBG”,
“transaction_id”: “dgaUIDnL12z4RldyqmG3XtnpPi4F”,
“created_at”: “2020-08-06T07:12:40.536Z”,
“amount_money”: {
“amount”: 13500,
“currency”: “CAD”
},
“type”: “CARD”,
“card_details”: {
“status”: “AUTHORIZED”,
“card”: {
“card_brand”: “VISA”,
“last_4”: “1111”,
“exp_month”: 12,
“exp_year”: 2021,
“fingerprint”: “sq-1—2AwJLy_VmxN1chWyBwzuWZMqyCNvL3EIlE7oJRuMwUZEeDLHD_55XIPwBWtE7OcA”,
“card_type”: “CREDIT”,
“bin”: “411111”
},
“entry_method”: “KEYED”
},
“payment_id”: “pmRwUJPqaaCoCrpqODpgdgA9AaNZY”
}
],
“total_service_charge_money”: {
“amount”: 0,
“currency”: “CAD”
},
“net_amounts”: {
“total_money”: {
“amount”: 13500,
“currency”: “CAD”
},
“tax_money”: {
“amount”: 0,
“currency”: “CAD”
},
“discount_money”: {
“amount”: 0,
“currency”: “CAD”
},
“tip_money”: {
“amount”: 0,
“currency”: “CAD”
},
“service_charge_money”: {
“amount”: 0,
“currency”: “CAD”
}
},
“source”: {
“name”: “Sandbox for sq0idp-IJVH1URfgw-tAgGF6Qv01A”
},
“customer_id”: “XRWCJGM6D8TXH0RES38T0J15Y8”
}
]
}

I took a look at your sandbox dashboard (since this is in sandbox), and I do see this order. Are you looking in your sandbox dashboard? This can be found here: https://developer.squareup.com/apps and click “Open” next to “Default Test Account”.

The little bits I can add to this after having gone through it recently are:
Orders do not show up in the Seller Console until they are paid for - not great for restaurants that you pay at the end of the meal.
Finding the SANDBOX SELLER CONSOLE is maddeningly difficult to do. It is as mentioned by @sjosey above. However, the link just says “OPEN”, nothing about what you are opening, no mention of the seller dashboard, etc. I only spent about a week on those 2 items. HTH.

OMG i figured it out! Somewhere in the documentation, i read that in order to create a payment that will be applied to an order, you had to set the “autocomplete” flag to “false” when creating the Payment … so that’s what I did. And since the Payments were there, everything was hunky-dory, except the payment hadn’t been “captured” or completed yet, and I had to find it in my Transactions list, and manually complete them. Then they showed up in my Orders list. Phew! I’ve since removed the line of code that set “autoComplete” to false, and everything seems to work fine, so I’m not sure why that note was in the documentation, perhaps you could explain what it means … ?

autocomplete = false allows you to authorize a card transaction, but not charge them immediately. This allows you to charge the card at some time in the future (up to 7 days, I believe). In terms of Orders, they will not show up until the order has actually been paid for (captured), as you found out.