• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Pabbly only entering the first product in an order through shopify

dfouni

Member
Hello,

All is setup however when i receive an order, only the first item is exported to my google sheet. How can i get all products ordered by one client?
 
P

PabblyMember4

Guest
Hey @dfouni

Could you please share any example of the above-mentioned scenario and share the task id where you have noticed this issue? Also, share some screenshots for understanding it better.
 

dfouni

Member
Hello,

Task ID:

IjU3NjYwNTZlMDYzZjA0MzI1MjY4NTUzMTUxMzU1MTY0NTQzMSI_3D_pc​


This order has 3 items however i only see one row in the google sheet as attached and the product name is not there whereas other orders have all filled info.

tx
 

Attachments

  • 9-5-2022 9-50-57 AM.png
    9-5-2022 9-50-57 AM.png
    3.4 KB · Views: 73
P

PabblyMember4

Guest
@dfouni

Thanks for sharing the details, kindly let us know how you want the data in an excel sheet. Are you looking for a single row for all the products (comma-separated values for your products) or do you want to see one by one row for all the products in your Google sheets?

Kindly confirm so that we will suggest you best solution for your need.
 
P

PabblyMember4

Guest
Hey @dfouni

We have made changes to your workflow so that you will get multiple rows for your products purchased. Kindly check the attached screenshots:-

1662378994811.png



1662379029869.png


1662379072297.png


Kindly make sure you have checked all the fields mapping and let us know if you have any questions or comments.

Thanks
Kunal
 

dfouni

Member
Thanks. For the shipping it should enter the shipping method:
1662381401771.png


Also for order # (not iD), it should enter the order of sshopify in format "#324234" example, not the four digits.
 
P

PabblyMember4

Guest
Hey @dfouni

You can map the appropriate field in the Shipping and Order# from the response from Shopify. Kindly map and let us know if you have any questions or comments.
 
P

PabblyMember4

Guest
Hey @dfouni

You can map either of the below fields in your shipping field. These response you are getting from Shopify only.

1662630695562.png



Also, these are the available Order fields you can map any of the fields in the Google Sheets. Kindly check and map the column.

1662630982461.png



Thanks
Kunal
 

dfouni

Member
I need to map the shipping method. It's now showing. On zapier i'm able to. Same thing for the order ID.

If i can't i guess i will continue using zapier. tx
 
P

PabblyMember4

Guest
Hey @dfouni

Could you please confirm that "Free Worldwide Trackable Shipping" will be your shipping method?

1662632014674.png
 
P

PabblyMember4

Guest
Kindly confirm if that will be one of your Shipping details. We have added JSON extractor in your workflow which is extracting the information.


1662633174711.png



1662633154026.png
 
P

PabblyMember4

Guest
Hey @dfouni

We have mapped the Shipping method to the Google Sheet's column Shipping. Kindly check and confirm the same.

Also could you please explain the Phone number error? Could you please share any screenshots?
 

dfouni

Member
Ok thanks.

See screenshot attached of 1 order with 2 SKUs
- Phone giving error
- Address is split in 2 rows?

tx
 

Attachments

  • 9-8-2022 2-47-36 PM.png
    9-8-2022 2-47-36 PM.png
    7.9 KB · Views: 74
P

Pabblymember11

Guest
Hey @dfouni

Since you are using the "Google Sheets: Add Multiple Rows" action step and it functions if you are passing comma separate values in the respective fields the value will add it to the next row.

If you only want to pass the single row data one by one then you should use the "Google Sheets: Add New Row" action step.

2022-09-09_11h24_23.png
 

dfouni

Member
THis doesn't make sense. What is it so complicated. I want to see all orders with all items ordered in google sheet. If this doesn't work let me know and i will stop using pabbly.
 
P

Pabblymember11

Guest
Hey @dfouni

The "Google Sheets: Add Multiple Rows" action step add the rows at once if you pass the values in comma separately.

You can watch the following video tutorial for the same.

 
Top