I had initially hoped to setup a very quick integration using Zapier, rather than direct API calls as this approach would suite my employer for a variety of reasons.
Unforunately, I’ve discovered that my orders are not providing customer_ids as per the myriad of forum posts and google searches frustratingly querying the issue.
I have setup a basic single product Square Online Site, where the only item available has a buy it now button, straight to checkout and order complete. I have made test purcahses, inputting customer details (Name, Email, etc.) yet these are not available in the Order API response and there appears to be zero reference to a customer object in any way.
I can see within the Square dashboard that these order do infact have customers associated with the transactions. Why, therefore, is this customer data not available from the Order API?
I wouldn’t even mind if I was just returned with a customer_id or some other reference, so I could query the Customers API, but there nada.
Is this a configuration issue with Square settings? It’d be helpful if the documentation could provide the item/transaction/checkout/location configuration required in order to ensure that customer data is provided with order.
From forum reading, it sounds like the API is just unreliable(?), and if so, this is a great weakness.
Additionally, why is the customer facing/ frontend Order Number not available in the Orders API? It feels like it should be really simple to get customer data, order number, date or purchase and just bang it into a Google Sheet, but it’s seemingly very challenging.
I’d really appreciate if anyone can help with any configuration I may need on my products, square site, or any other settings in order to get customer data (even just customer_id) reflected in the Orders API calls.
Some order_ids for y’all: