Best answer

EKM to QuickBooks Zap - how to reduce task usage


Userlevel 1

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?

icon

Best answer by GetUWired 25 May 2021, 15:30

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.

5 replies

Userlevel 7
Badge +12

@AngelsLedgers 

 

That is great news!

Userlevel 1

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:

Userlevel 7
Badge +12

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')

 

Userlevel 1

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

Userlevel 7
Badge +12

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