Jump to content

Form Data - How to export to sheet

Recommended Posts

Site URL: https://www.sherbornyachtclub.org/

When selling memberships, we collect member information in a custom form.

When I export the orders, none of the information from the custom form is included in the export to CSV.

I see the information in the confirmation email and also in the actual order.

Is it possible to export the custom form information that is collected from an order to a google sheet?

Link to comment
37 minutes ago, SYC said:

Site URL: https://www.sherbornyachtclub.org/

When selling memberships, we collect member information in a custom form.

When I export the orders, none of the information from the custom form is included in the export to CSV.

I see the information in the confirmation email and also in the actual order.

Is it possible to export the custom form information that is collected from an order to a google sheet?

I think we got to use Commerse API or email parser to extract the form data along with orders

Greeting, it's BeyondSpace, I am Squarespace dev focus on provide solutions to enhance feature that squarespace.com can't provide.
Feel free to check my current Squarespace Plugins Developement: Enable Pinch/Zoom on lightbox, Delivery Date Picker, Keyword Highlighter
If you find my answer fit your need, let's leave a like or upvote so others with the same issue can find their solution. Thank you

Link to comment
  • 1 month later...
  • 4 weeks later...
  • 2 weeks later...
3 hours ago, colin.simmons said:

Also trying to find a solution to this!

Use Integromat to automate order data exportation

Greeting, it's BeyondSpace, I am Squarespace dev focus on provide solutions to enhance feature that squarespace.com can't provide.
Feel free to check my current Squarespace Plugins Developement: Enable Pinch/Zoom on lightbox, Delivery Date Picker, Keyword Highlighter
If you find my answer fit your need, let's leave a like or upvote so others with the same issue can find their solution. Thank you

Link to comment

I'm drowning...our employee set up badge sales for an event and put the additional names as a variant and now I'm ready to print out badges and we cannot get those additional names. Any ideas...we need help asap! I can't even find where those are stored!

Link to comment
  • 4 months later...

I found the solution on this page: https://support.squarespace.com/hc/en-us/articles/206540677-Exporting-orders

On step 3 of the order export, select a specific product, then check the option to "Include product form data." The exported file will show form responses for each order. The only downfall is you have to do one product at a time during the export.

image.png.a9b88c596f45510733202d7aebd0d8a5.png

Hope this helps!

Link to comment
  • 1 year later...
On 10/26/2021 at 12:24 PM, Imanisb said:

I found the solution on this page: https://support.squarespace.com/hc/en-us/articles/206540677-Exporting-orders

On step 3 of the order export, select a specific product, then check the option to "Include product form data." The exported file will show form responses for each order. The only downfall is you have to do one product at a time during the export.

image.png.a9b88c596f45510733202d7aebd0d8a5.png

Hope this helps!

THIS is the answer! Thank you so much!

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.