Skip to main content

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!

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

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!


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

 


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! 🙂 


Reply