Skip to main content
Question

Zapier accepts static text but not variable data

  • September 25, 2024
  • 4 replies
  • 46 views

I’m trying to sync order information from Shopify to MyGadgetRepairs (MGR) which is our POS and inventory application. The zap looks like this:

Step 1 = New Order (Shopify) 

Step 2 = Find Customer (in MGR) and create a new one if the customer doesn’t exist

Step 3 = Create POS Order (in MGR)

Within Step 3 of the Zap, when mapping the “Line Item SKU” from Shopify’s “New Order” trigger step to the “Product Code” field in “Create New POS Order” action step in MGR, it won’t accept the variable field data. I keep getting an error message that says “Required field "Product Code" (productCode) is missing.”

However, if I copy and paste the “Line Item SKU” value as static text in the “Product Code” field, the zap works. To note, the value of the static text is in exactly the same format as the variable value. 

I have even tried including a “Formatter” step before the “Create POS Order” step to ensure the code doesn’t include commas or spaces, and mapped the output data from this step to the “Product Code” field, but this hasn’t worked either. 

It’s almost as if Zapier is not accepting any type of variable data for this field (which is crucial for the data sync to be successful).

Can someone tell me how to solve this please?

Thank you!

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

4 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30959 replies
  • September 25, 2024

Hi @EWadmin 

For us to have more info, post these screenshots:

  • How your Zap steps are outlined and configured in EDIT mode
  • The encountered error

  • Author
  • New
  • 1 reply
  • September 26, 2024

Hi Troy

Thanks for helping on this. 

I have attached screenshots that show how the action step is configured, as well as the error messages. As mentioned in my original post, I’ve tried two scenarios for mapping the “SKU code” as a dynamic field (neither of which work):

One: directly from the ‘New Order’ trigger step

 

Two: as a reformatted dynamic field, taken from a Formatter step:

 

I have also included a screenshot of the Zap configured using static text with exactly the same SKU code, which works:

 

Please let me know if you need any further information.

Many thanks again!


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30959 replies
  • September 26, 2024

Hi @EWadmin 

From the screenshot, you can see there are 2 line items. (e.g. Check the QTY to see 1,1)

But the issue is that the first line item has no value for SKU.

Fix that in Shopify to set a SKU for the product (variant).

 


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7487 replies
  • October 3, 2024

Hi @EWadmin! 👋

Did you manage to get things solved by updating the product variant to have a SKU? 

If that didn’t work or you’re running into further issues here just let us know and we’ll be happy to assist further! 🙂