CityNet Posted January 13, 2020 Share Posted January 13, 2020 We have a custom form on our website for donors to give, and the additional information field includes info to which specific fund they want to give. However, when that donation is processed through Stripe, the additional information field is not reported. Thus, for our accountants to have knowledge of which fund the money should go to, they cannot see it in our Stripe reports. Any ideas as to how to get this additional information which is very important reported over to Stripe in all transactions? Willdoes, Widle, cbroad and 2 others 5 Link to comment
Willdoes Posted January 23, 2020 Share Posted January 23, 2020 We have exactly the same problem! I wanted to also export all the information to a csv but the additional information doesn't download making my life very difficult. Hopefully they will change it. maryb0wen, cbroad and Widle 3 Link to comment
maryb0wen Posted April 14, 2020 Share Posted April 14, 2020 Without the additional fields, accounting is nearly impossible for our organization. When we receive a donation online, we enable the donor to choose where the funds are applied. This is the donation type field. Right now, the donation type field is only coming through in disparate email receipts (1 email per donor). We need it in a reportable format... I'm shocked that these fields are not in the donations csv file that Squarespace offers. Has anybody found creative ways to solve for this? cbroad and Widle 2 Link to comment
Guest Posted December 8, 2020 Share Posted December 8, 2020 I have this same problem. We ran a GivingTuesday fundraising campaign and I had two additional questions asked of donors but cannot figure out how to access the donors' answers, other than in the email confirmation I received that a donation was made. Why aren't the answers to these fields included in the .csv file export of donations? Link to comment
LBennett Posted January 7, 2021 Share Posted January 7, 2021 Add my name to the people who find this a giant pain! Please Squarespace-- you collect this info, please allow us to access it in the csv download!!! Widle and Willdoes 2 Link to comment
sruss76 Posted January 7, 2021 Share Posted January 7, 2021 3 hours ago, LBennett said: Add my name to the people who find this a giant pain! Please Squarespace-- you collect this info, please allow us to access it in the csv download!!! You're going to have to create a ticket to customer care about this. They don't read and/or count requests posted here on the forums. Widle 1 Link to comment
BESCAVPTech Posted January 20, 2021 Share Posted January 20, 2021 This is a huge problem for us too. I've asked squarespace and they say they submitted the request, but I don't expect a change. I wonder if there's a way to use curl and script the process of clicking each item in the donation list to view and grab the additional information? Widle and Beyondspace 2 Link to comment
Beyondspace Posted January 29, 2021 Share Posted January 29, 2021 The additional field value is sent over in the confirmation email, I think we have to extract it from there (manually or via coding automation) while waiting for squarespace sort it out in their system Widle 1 BeyondSpace - Squarespace Website Developer 🖼️ Lightbox Studio (Enable Pinch/Zoom on lightbox, video lightbox and much more) 🗓️ Delivery Date Picker (Squarespace Date picker form field) 💫 Gallery block 7.1 workaround 🥳 No-code customisations for Squarespace (+100 Spark plugin customisations) 🚀 Learn how to rank new pages on Google in 48 hours! 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
PhantomRide Posted April 21, 2021 Share Posted April 21, 2021 Plus one. Same problem. Beyondspace and Widle 2 Link to comment
cbroad Posted May 6, 2021 Share Posted May 6, 2021 Same problem, and this is a huge issue. Can't believe they haven't fixed it yet. Squarespace, are you listening?! Widle 1 Link to comment
Willdoes Posted May 17, 2021 Share Posted May 17, 2021 On 1/7/2021 at 9:33 PM, sruss76 said: You're going to have to create a ticket to customer care about this. They don't read and/or count requests posted here on the forums. I have raised a few tickets and still nothing! Widle 1 Link to comment
sruss76 Posted May 17, 2021 Share Posted May 17, 2021 (edited) 6 hours ago, Willdoes said: I have raised a few tickets and still nothing! yeah, you will often see people here (including me sometimes) say to create a ticket with customer care about the features you want added -- because that's what SQSP says is the "official" way to make requests. however, they will tell you they don't guarantee your requests will be implemented. to be honest, i think it's all lip service because i've yet to see them really listen to their customers, especially to their existing/paying ones. you'll find many requests dating back YEARS and they've been ignored. i've never come across a more unresponsive company than Squarespace. Edited May 17, 2021 by sruss76 Widle 1 Link to comment
PhantomRide Posted December 28, 2021 Share Posted December 28, 2021 Plus one. Same problem. Frustrating! Widle 1 Link to comment
LMstudio Posted February 19, 2022 Share Posted February 19, 2022 Is there a plan in place to fix this issue? Unbelievable that it doesn't export ALL form information! Widle and creedon 2 Link to comment
allisonstratton820 Posted August 1, 2022 Share Posted August 1, 2022 I also created 2 tickets. This is a huge problem. Has anyone been successful scraping the email for the information? Widle 1 Link to comment
falk0069 Posted November 9, 2022 Share Posted November 9, 2022 If it helps, I did find the data can be pull with a resp call. And actually if you open the DevTool [f12] in the browsers when you click on 'Donations' you will see a URL like this is used: https://SITENAME.squarespace.com/api/rest/commerce/contributions?offset=0&limit=100 If you browse to it, it will return a JSON payload with all the data. Change to 'limit=100' to get more records. The tricky part is now how to parse the JSON data the easiest. Uslan and LMstudio 1 1 Link to comment
falk0069 Posted November 9, 2022 Share Posted November 9, 2022 To add my previous post, here is a quick PowerShell script I wrote to parse the JSON payload and convert it to a CSV (Excel) output. Very little error checking done. Just paste in Excel and delimit by the comma. Hope it works for others. $payload = 'PASTE ENTIRE JSON PAYLOAD HERE' $results = ConvertFrom-Json $payload Write-Output "Date,Donor,Email,Phone,Amount,Currency,DonationType,Label0,Field0,Label1,Field1" $(ForEach($r in $results.contributions){ $Date = (Get-Date -Date "01-01-1970") + ([System.TimeSpan]::FromMilliSeconds(($r.submittedOn))) $Donor = $r.donor.name $Email = $r.donor.email $Phone = $r.donor.phone $Amount = $r.amount.decimalValue $currency = $r.amount.currencyCode $DonationType = $r.donationTitle $Label0 = $Value0 = $Label1 = $Value1 = "" if($r.formData){ $Label0 = $r.formData.fields[0].label $Value0 = $r.formData.fields[0].value $Label1 = $r.formData.fields[1].label $Value1 = $r.formData.fields[1].value } Write-Output "`"$($Date)`",$($Donor),$($Email),$($Phone),$($Amount),$($Currency),$($DonationType),$($Label0),`"$($Value0)`",$($Label1),`"$($Value1)`"" }) LMstudio 1 Link to comment
elementarymomfundraiser Posted June 7, 2023 Share Posted June 7, 2023 (edited) I cannot believe this is still an issue after 3 years. I do fundraising for a school PTA and we are considering switching platforms due to the refusal to update these systems. It's irresponsible to use this system for donations at this point. Edited June 7, 2023 by elementarymomfundraiser Link to comment
Danielle901 Posted July 4, 2023 Share Posted July 4, 2023 Wow, reading the history of this, I can't believe it isn't fixed. Link to comment
squaredan Posted December 27, 2023 Share Posted December 27, 2023 Costing us dozens of man-hours to work around this egriously absent feature. Please include "additional information" in donations exports! Link to comment
Uslan Posted August 6 Share Posted August 6 Just encountered this issue on a site I'm working on, feels this needs to be addresses urgently. Link to comment
Bricker Posted September 9 Share Posted September 9 Same problem here: wake up Squarespace! This can't be the most difficult issue to fix. Simply include the "additional information" field in the CSV of donations exports and we'll all be happy. Otherwise, myself and doubtless others are seriously considering changing platforms. Thank you. Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment