big-picture-studio

Clearinghouse project for IC students to implement automation between Google Docs and SquareSpace

https://docs.google.com/spreadsheets/d/1orvOkrQ5jGUuyOTUmfd9puNDH_witgreauFWGCMdlYU/edit#gid=1622139872 https://developers.squarespace.com/commerce-apis/overview

Goals:

• Automation of order exporting system
  • Directly sent from website orders to master spreadsheet
• Up-to-date in real-time
• Shared with multiple people
• Edit the sheet
  • Support Cancellation or switch sections

Solutions:

• Keep website on Squarespace
• Shortcut for iPad to courses
• Allow for sign-ups when inventory is empty

Pain points with SquareSpace:

• Inventory management, especially related to year long versus single section sign-ups
• Seeing current class openings ahead of time
  • Parents that inquire about this to decide about sign-ups
  • Last minute sign-ups
  • Marketing / Advertising decisions (currently gets Squarespace notifications in emails, but overwhelmed with this)
• Manual sign-ups (Potential cash payment, with form data)