Woocommerce Checkout Fields have different meta ID Numbers

[Guy]

I have a woocommerce connection to a google sheet, but in the custom checkout fields, the ID numbers of the fields change at random. On one submission, it was 10-12 ,on a different one, it was 11-13, and on a different one, its 22-24. It fills in different information depending on the submission, and its the same product and payment every time.

Does anyone have any idea on how to fix it and then use pabbly to correctly export the data?

Thanks in advance.

 

[Himesh]

You need to Map product ID from your response. Refer this video for more clarity

If you are still not able to solve this on your own feel free to DM me and we can do a free zoom call. FYI I'm not from Pabbly Connect team, just a freelancer who helps other Pabbly users.

 

[Guy]

You need to Map product ID from your response. Refer this video for more clarity

If you are still not able to solve this on your own feel free to DM me and we can do a free zoom call. FYI I'm not from Pabbly Connect team, just a freelancer who helps other Pabbly users.

Hi @Himesh ,

It isnt the mapping that isn't working, it is that the mapping field numbers of the custom field changes with every order, but it is completely arbitrary. All of the other fields stay the same, but these custom fields jump from number to number, so the mapping isn't working properly.

 

[ArshilAhmad]

Could you please make a short screen recording and elaborate a bit more on your exact concern?

 

[Guy]

Could you please make a short screen recording and elaborate a bit more on your exact concern?

Hi, Here is the video I made: https://vimeo.com/982077455/73c899c664?share=copy

 

[ArshilAhmad]

Thank you for sharing the video.

The trigger used in WooCommerce is based on descriptive webhooks and captures whatever data the application sends to us. We do not have any control over the data that WooCommerce sends to Pabbly Connect. Since the data associated with Meta Data Keys is coming in a jumbled manner from their end, we cannot do anything about it from our end.

We suggest you try using the 'Retrieve an Order' action event as step 2 of your workflow and see if that provides the data without the Meta Data Keys being jumbled.

Watch this video to understand how you can set up a new connection in the WooCommerce action step.

 

[Himesh]

Hello @Guy , Turn off the simple response from first step and after that you'll get array of key and valu pair and in next step write JS code which will fetch your desired key and value pair.

If you are still not able to solve this on your own feel free to DM me and we can do a free zoom call.