Skip to main content
Question

Issue with country and state in Wave invoice

  • April 29, 2024
  • 4 replies
  • 47 views

Hi there!

I am creating invoices in Wave from Shopify and keep running into this error
 

Failed to find or create a customer in Wave

Could not find `Province` with slug: 'WA'
 
It happens with both country and state even though both are present and valid from Shopify. I have tried both codes ( US, WA) and written out (United States, Washington) and the issue persists. When creating a customer in Wave, these options are drop downs, so I am aware the inputs must match this, but don’t know how else to do it. I have tried to use the formatter to remove possible white spaces etc.

 

 

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

4 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • April 29, 2024

Hi @carmen802 

The screenshot did not upload.

 


  • Author
  • Beginner
  • April 29, 2024

Should be there now!


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • April 29, 2024

@carmen802 

Help article about mapping dynamic variables to dropdown fields: https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps

 


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • May 2, 2024

Hi there @carmen802! 👋

The value selected for the Country field is correct, but it appears that the Province field that needs altering.

For the province field the full name would need to be supplied instead of a two-letter country code. Additionally, it appears that the province needs to be supplied in lowercase, with any spaces replaced by dashes as pictured below:
56d2cabd487e88543d7d9b66b03826c4.png

Can you adjust the first Formatter action so that the Washington province is output as required and confirm whether that fixes it?