Skip to main content
Question

Troubleshooting missing Line Items ID in Quickbase from Shopify updates

  • February 13, 2025
  • 3 replies
  • 19 views

I have a zap setup to enter a Quickbase record when a shopify record is updated. It was working fine and then Zapier made some updates and now I randomly get an error message and a missed zap. It is pretty low frequency but high enough to be a problem. Below is a screenshot of the most recent event. When I checked this order in shopify it is from a Bold subscription purchase (Shopify plug in app) and I’m wondering if that is messing with the ID. It doesn’t happen every time. I cannot see where this ID is empty.

 

 

 

Did this topic help you find an answer to your question?

3 replies

escalateur.com

Hi! Just from the error message, it looks to me that the step just doesn’t know which record to update. 

 

Since you mentioned that it only fails occasionally, could it be that the failures only happen to items that are new to Quickbase? This would explain why this ID doesn’t exist yet.

 

If this matches your experience, a fix might be to split the flow after your trigger with the condition being “1. Line Items ID → Exists” vs “1. Line Items ID → Does not exist”. And respectively adding a “Update Record” and “Create Record” step afterwards. This way you’d be sure that the “Update” action only takes care of preexisting records.

 

If I understood wrong please feel free to share a screenshot of the “Data in” tab :)


  • Author
  • Beginner
  • 1 reply
  • February 13, 2025

Hey thanks for the response. I don’t think that’s the case because it’s not a new item. Here is a screenshot

 

 


escalateur.com

Ok thanks for these new details! 

 

Since this action is expecitng an array as an input, it’s possible that it’s only a problem of formatting.

 

Could you try to add a formatting step just before, so as to transform this ID (which I assume is in string format) into a line item value?

 

Formatter > Utilities > Text to Line-item. Then use the output in your Quickbase step. Note that if this is indeed the solution, you may have to repeat it with all of the other fields.

 

An alternative may also be to simply change the step to the more classic “Update Record” Quickbase step. This one should not be expecting Line-items.