Connecting shopify to google sheet unable to find certain values

[San]

Hello,
As I'm using Pabbly connect to map the field values I can't find certain values, which are
Variant Type
Payment Status
Fulfilment Date
Delivery Type
Delivered Date

Can someone help me

 

[Pabblymember11]

Hey @San

You can try using the following 2 action steps in the Shopify action step to get the relative details which you can further pass into the Google Sheets.

 

[San]

Hey @San

You can try using the following 2 action steps in the Shopify action step to get the relative details which you can further pass into the Google Sheets.

I am trying to find the values which I want them to be populated in googlesheets

View attachment 25715

 

[Pabblymember11]

I am trying to find the values which I want them to be populated in googlesheets

Yes, please use those action steps once to get the related data as you desired which you can then pass to the Google Sheets.

 

[San]

Yes, please use those action steps once to get the related data as you desired which you can then pass to the Google Sheets.

It's very frustrating that you don't have a Knowledgebase, just few youtube videos

 

[San]

Yes, please use those action steps once to get the related data as you desired which you can then pass to the Google Sheets.

Nor do you have a customer support

 

[Pabblymember11]

Kindly elaborate on your concern briefly and the workflow in which you have tried the same.

And it seems like you haven't tried the action step we suggested to you in terms to get the Product Variants.

 

[San]

I want to fetch all the order details in google sheets. Below are the fields that I'm trying to get the data of

Order No. - Working
Order Date - working
Customer Name - Working
Customer Email- Working
Currency- Working
Price- Working
Quantity- Working
Item Name- Working
Item SKU- Working
Variant Type - I am unable to find variant size/colour
Fulfillment Status - working
Payment Status - I can't find the option in the values
Cancelled - - I can't find the option in the values (Yes/No option)
City - - Working
Fulfilment Date Delivery Type - I can't find the option in the values
Delivered Date - I can't find the option in the values
Fulfillment QTY - Working

I have attached the screenshot on how I want

Thank you

 

[Pabblymember11]

Kindly note that Shopify's trigger event is a descriptive-based trigger event where Pabbly Connect only captures the response once send by the application.

So, we recommend you to please use the "Shopify: Get Order by ID " action step will provide the additional data which is required of you.