Skip to main content

I’ve been running a zap for months thats worked, but it just stared throwing an error with the product/service section.

Correct: took the product type from SF and placed it into the product service field in the invoice.

Now the product service is going in as “sales”.
Here is an example of it working prior to the bug: 

 

 

 

Now invoices show: 

 

 

in the Zap step create invoice action step i have it mapped (as before when it was working)

when i test it i see this data in:

 

and this data out:

 

 

Can anybody help me get this working please?

Thank you

Hi @PinMaker 

The QBO field for Product/Service expects a number value as indicated by the 123 icon.

The field expects the ID of the QBO Product/Service.

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

 


Thank you troy.
I had a “find product” step prior to create invoice, but based con your reply i deleted and recreated this step

 

Then went back to step 6 - create invoice and now i see a number in the id 

 

 

but when i run the test i still get “sales” in the product field

 


Any other suggestions? TIA


@PinMaker 

If you tested live, check your Zap Runs history details to see the DATA IN/OUT for each step to help you troubleshoot: https://zapier.com/app/history/

Post screenshots of the data flow between steps if you need more help.


Thanks for the ongoing help….

 

 Here is one from live this morning…

Step 5 - find products Data in & data out 

 

Step 6 - create invoice

Data in & data out

 

 


@PinMaker

You may need to retest Step 5 and remap the desired variable from Step 5 since it is showing the (!) and highlighted in yellow border indicating a possible issue.

 

In Zap Runs, for a step, for the DATA IN, if you see {{VAR}} then that means the mapped variable was blank/empty/invalid/missing/null.

 


Thanks I remapped - but still not working :-(

 

Step 5

 

 

 

 

Step 6

 


@PinMaker 

Same feedback as before...

 

The QBO field for Product/Service expects a number value as indicated by the 123 icon.

The field expects the ID of the QBO Product/Service.

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


Thanks for your patience - this is working now - with your help.

For others searching for answers here is the solution…

Step 6 create invoice

Action step

product/service field

choose find product (from step 5)

And select the one with an ID not the text name - eg ID 8 not “medals” in my case
 

 


That’s awesome @PinMaker! A huge thanks to Troy for lending a hand and pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗


Reply