Hi, in simple terms I want to get a webhook notification when an invoice (ideally also an estimate) is created/updated, and then retrieve the line items for that invoice. I’ve done the first bit, but am struggling with the second.
After a lot of head scratching I’ve realised the problem is that the order_id field doesn’t exist until an invoice is paid (Invoices that are unpaid have no order_id).
So, how do I get the line items for an estimate/unpaid invoice via the API? Surely there is a way, otherwise there’s no way to get ‘sales pipeline’ data out of Square?
At this time the ability to get line items from estimates or unpaid invoices isn’t currently possible with our API. We’re constantly working to improve our features based on feedback like this, so I’ll be sure to share your request to the API product team.
Out of interest, have there been any developments on the above since last year? Or are there any third party integrations/solutions that would help us?
If we invoice a customer on 30 day terms, but deliver the goods sooner (which is quite normal business practice for regular customers), then it seems strange that according to Square that item is not ‘sold’ and doesn’t appear in reports (even with some sort of ‘pending payment’ flag).
Is that item also counted as stock in our inventory until the invoice is paid? If so, that’s even more mad as it would report as stock in our warehouse when it wasn’t actually there?
