About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Error: Failed to create an invoice in Square. This order ID isn't valid for creating an invoice.

  • 27 October 2022
  • 8 replies
  • 549 views
C

We are trying to create a zap so that every time an appointment in Acuity is made, it will automatically generate and send a Square invoice to the customer. When we test the "Create an invoice in Square" action, we continue to get a "Failed to create an invoice in Square. This order ID is not valid for creating an invoice." error message. We looked at community support and found a relevant article. It tells us to contact the Support Team so you can look at the back-end logs of the zap to track down the correct error message for us.

 

We contacted Zapier Support and they responded with the following:

Happy to help if I can, but our internal logs aren't giving any extra detail in this case:
"MISSING_REQUIRED_PARAMETER","detail":"order_id is required"

 
It's saying an Order ID is required but that is supposed to be assigned by Square once they receive and process our "create invoice" request. 
 
It looks like other users have started running into this just a couple weeks ago, so it's possible the system that Square's API uses to process "create invoice" requests has changed and needs to be adjusted in the integration.
 
To that end, I have added your name and email to a list of affected users to be notified when this is fixed. I don't know what the timeline would be, but you will automatically be notified as soon as we've closed the issue. Really sorry for the interruption here, and I hope we get some good news soon. 
 
In the meantime, it might be worth getting in touch with Square API support to ask for their side of the logs. They may have more detail regarding any info in your Zap's requests that isn't being accepted.
 
I wish I had more concrete help for you today but hope that gets you pointed in the right direction. Please let me know if you have other questions, and I'll be happy to answer them!

 

We then contact Square API Support, and they responded with the following:

Square doesn’t currently have a direct partnership with Zapier, so I recommend reaching out to this company directly for help.


If you’re curious about any of Square’s supported partners, check out our Square App Marketplace.


If you have any other questions, please do not hesitate to contact me, I will do my best to help you.
 

 

We have already tried:

  • New Appointment in Acuity Scheduling > Create Invoice in Square
  • New Appointment in Acuity Scheduling > Create Customer in Square > Create Invoice in Square
  • New Appointment in Acuity Scheduling > Create Customer in Square > Find Customer in Square > Create Invoice in Square

All steps of these iterations have tested successfully. The constant hang-up is with the Create Invoice in Square step, where the error message says, “Failed to create an invoice in Square. This order ID is not valid for creating an invoice.”. The weird thing is that there are existing Customer IDs when we select the option.

 

Has anyone been able to successfully create a Zap that allows Square to Create an Invoice? 

icon

Best answer by christina.d 21 December 2022, 09:14

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

MohSwellam
Userlevel 7
Badge +8

Hi @cbcastil408 

 

It seems as per Square API documents that you need to create an Order first before creating the invoice (hence the error Invalid Order ID). 

 

You might need to add a step before the invoice which is Create Order then use the returned Order ID in the Create Invoice.

 

The only action I see for the Order is Create Paid Order, if this is not it, then you might wanna use a Webhook to create order as shown here

 

https://developer.squareup.com/docs/orders-api/create-orders  

Founder of GeekyAir.com
Danvers
Userlevel 7
Badge +12

Hi @cbcastil408!

The Square action Create Invoice doesn’t have an option to add an order number in the Zap editor, so I don’t think that @MohSwellam’s suggestion will work.

I took a look at the Square API documentation and the issue report that we have about this and made sure that our team know that Order ID needs to be added to the Create Invoice action as Square now requires that field in order to create an invoice. As you’re already listed as an affected user on the issue, you’ll get an email when we have an update on that. 

I’m sorry that I don’t have better news for you in the meantime. 

 

D

Hi @cbcastil408!

The Square action Create Invoice doesn’t have an option to add an order number in the Zap editor, so I don’t think that @MohSwellam’s suggestion will work.

I took a look at the Square API documentation and the issue report that we have about this and made sure that our team know that Order ID needs to be added to the Create Invoice action as Square now requires that field in order to create an invoice. As you’re already listed as an affected user on the issue, you’ll get an email when we have an update on that. 

I’m sorry that I don’t have better news for you in the meantime. 

 

Please add me to list of affected users! I just signed up for Square and built out a Zap and have hit the same issue. No Order Id = No Invoice generated

nicksimard
Userlevel 7
Badge +11

Hi @Dave_FERCS!

I’ve added you as an affected user as well, which means you’ll be notified via email when the issue has been resolved.

O

Please add me as well.

JammerS
Userlevel 6
Badge +3

Hi @OliverPPL 

 

I’ve added you to the list of affected users and we’ll update you via email once available. Thanks!

jammer․solijon
christina.d
Userlevel 7
Badge +9

The Square action Create Invoice doesn’t have an option to add an order number in the Zap editor, so I don’t think that @MohSwellam’s suggestion will work.

I took a look at the Square API documentation and the issue report that we have about this and made sure that our team know that Order ID needs to be added to the Create Invoice action as Square now requires that field in order to create an invoice. As you’re already listed as an affected user on the issue, you’ll get an email when we have an update on that. 

Hi there, ya’ll! One of our engineers shared a potential workaround that we think may work. I wanted to mention here it in case it’s useful:

Ensure there is an OPEN order at the location you’re selecting- even if it’s not the one you’ll eventually use.

The thought is - having an open order should provide the dropdown field for Order ID where you can then set your custom value.

I hope this helps but please keep us posted either way! We’ll also let ya’ll know once a true fix is in place. 

As always thanks so much for your patience!

christina.d
Userlevel 7
Badge +9

I took a look at the Square API documentation and the issue report that we have about this and made sure that our team know that Order ID needs to be added to the Create Invoice action as Square now requires that field in order to create an invoice. As you’re already listed as an affected user on the issue, you’ll get an email when we have an update on that. 

Hey friends, I wanted to swing by and let ya’ll know a fix was implemented for this and the Create Invoice action should be working as intended now!

If you’re still running into this with the required OrderID, please feel free to open a ticket with support and they can absolutely dig into this a bit further.

Thanks as always for your patience on this ya’ll! 🙂

Terms & Conditions