Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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

EKM to QuickBooks Zap - how to reduce task usage

  • May 24, 2021
  • 5 replies
  • 80 views
A

I have a Zap that links EKM Sales to QuickBooks to create a Sales Receipt. To make the zap work I have 5 steps that 

  • convert the VAT rate to a code (the receipts tend to be split rated) for each line item  (number.spreadsheet.formula)
  • work out the price before VAT for each line item (spreadsheet formula),
  • work out the delivery before VAT (number.spreadsheet.formula) and
  • each line’s subtotal (Utilities)
  • Work out the code for the bank the sale has been sent to (paypal or current through Stripe)  (spreadsheet formula)

This means each zap is 6 tasks and eats it’s way through my allowance quickly

Is there any way for me to combine these tasks?

Best answer by GetUWired

You can multiple with the ‘*’ operator https://www.pythoncentral.io/multiplying-dividing-numbers-python/ 


You can loop through pushing to the new list using the below code

lineVAT = input_data['ItemVAT']
lineVAT_list = lineVAT.split(",")
List_Line_VAT = []

for i in range(len(lineVAT_list)):
    if lineVAT_list[i] == '0' :
        List_Line_VAT.append('11')
    else :
        List_Line_VAT.append('3')

 

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

5 replies

GetUWired
Forum|alt.badge.img+12
  • GetUWiredZapier Solution Partner
  • Zapier Solution Partner
  • May 24, 2021

Hi @AngelsLedgers 

The only way to consolidate many formatting steps into one would be by utilizing a code block 

https://zapier.com/help/doc/how-get-started-code-zapier 

A

Thank you for this I have managed to combine the Delivery and Bank into one task

WIth the other one they are lists with a value for each line item. I am struggling to figure out how to change the values in the array/list to data QuickBooks can use for example

From EKM
ItemVAT = 0, 0

Me trying to convert 0 to value of 11 otherwise value of 3

This is what I have so far but I think my if statement is incorrect as I don’t understand how to the value in the new list

lineVAT = input_data['ItemVAT']
lineVAT_list = lineVAT.split(",")
List_Line_VAT = []

for i in range(0,len(lineVAT_list)):
if lineVAT_list[i] == '0' :
    List_Line_VAT.append('11')
else :
    List_Line_VAT.append('3')

 

Also how do I do a multply in python?

 

Thanks

GetUWired
Forum|alt.badge.img+12
  • GetUWiredZapier Solution Partner
  • Zapier Solution Partner
  • Answer
  • May 25, 2021

You can multiple with the ‘*’ operator https://www.pythoncentral.io/multiplying-dividing-numbers-python/ 


You can loop through pushing to the new list using the below code

lineVAT = input_data['ItemVAT']
lineVAT_list = lineVAT.split(",")
List_Line_VAT = []

for i in range(len(lineVAT_list)):
    if lineVAT_list[i] == '0' :
        List_Line_VAT.append('11')
    else :
        List_Line_VAT.append('3')

 

A

Thank you so much for your help @GetUWired I have managed to get all the tasks coded in Python meaning I have gone from 6 tasks to 2. I am so pleased, particularly as it meant I could use my old coding skills from 15 years ago :smile:

    GetUWired
    Forum|alt.badge.img+12
    • GetUWiredZapier Solution Partner
    • Zapier Solution Partner
    • May 26, 2021

    @AngelsLedgers 

     

    That is great news!

    Terms & ConditionsAccessibility statement