Jump to content

Form Data - How to export to sheet

Go to solution Solved by Imanisb,

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

BeyondSpace - Squarespace Website Developer

🖼️ Lightbox Studio (Enable Pinch/Zoom on lightbox)
🗓️ Delivery Date Picker (Squarespace Date picker form field)
💫 Gallery block 7.1 workaround
🥳 Sparkplugin Customisations Browsers (Browse +100 Spark plugin customisations)
🥳 Elfsight Template Browsers (Browse +1000 Elfsight widget Templates)

If you find my answer useful, 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

BeyondSpace - Squarespace Website Developer

🖼️ Lightbox Studio (Enable Pinch/Zoom on lightbox)
🗓️ Delivery Date Picker (Squarespace Date picker form field)
💫 Gallery block 7.1 workaround
🥳 Sparkplugin Customisations Browsers (Browse +100 Spark plugin customisations)
🥳 Elfsight Template Browsers (Browse +1000 Elfsight widget Templates)

If you find my answer useful, 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...
  • Solution

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!

Noah Olson
Web Design, Brand, Marketing
❄️ Snowday Design

 

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.