Skip to main content
Question

Issues with zapier not using the correct output value

  • December 22, 2023
  • 3 replies
  • 41 views

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

I am bringing in opportunity product line items form salesforce and using this information to creat line items on an invoice in STAX. 

Step 1 - I create the invoice items (works) and gives me output #1, output #2, output $3

Step 2 I create the associated prices (using a formatter) Works and gives me 3 prices (output #1, output #2, output #3)

Output Item 1

item_1

200

Output Item 2

item_2

299

Output Item 3

item_3

10.5

 

Step 3 - I create the quantities - works and gives me output #1, output #2, output #3

Output Item 1

item_1

1

Output Item 2

item_2

1

Output Item 3

item_3

30

Step 4 - creating the STAX invoice 

Output #1 Item, Output #1 price , Output #1 quantity - works 

Meta Line Items

lineItems

1

1

Meta Line Items Item

item

NWHYTX : AV Charge

Meta Line Items Details

details

2004-12-01T00:00:00Z : Event Date

Meta Line Items Quantity

quantity

1

Meta Line Items Price

price

200

 

Output #2 Item, Output #2 price , Output #2 quantity - works 

2

Meta Line Items Item

item

NWHYTX : Auditorium Rental

Meta Line Items Details

details

2004-12-01T00:00:00Z : Event Date

Meta Line Items Quantity

quantity

1

Meta Line Items Price

price

299

3

Output 3 - Item woks, Output #2 quantity works - FOR SOME REASON Zapier is using a “Meta Price” which is already the price * the quantity. Where the heck is the meta price coming from and hwo the heck do I get rid of it? 

3

Meta Line Items Item

item

CV : Group Rental Tickets

Meta Line Items Details

details

2004-12-01T00:00:00Z : Event Date

Meta Line Items Quantity

quantity

30

Meta Line Items Price

price

315 - This should be $10.50 - not the $315 

 

Why do two of the three steps work correctly? 

xxx xxxx

xxxxxxx@gmail.com

 

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

3 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • December 23, 2023

Hi @timweis 

To help us have true context, please post detailed screenshots with how your Zap steps are configured.


  • Author
  • Beginner
  • December 26, 2023

Here are how the zaps are configured 

 

and here are the values zapier is actually using : Note the price is $150 instead of $50 and $630 instead of 10.50.

 

It is only happening when the quantity is greater than 1. 

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • December 27, 2023

Hi @timweis 

You may need to try reaching out to STAX Support for help with their Zap app integration.