Problem Description

This is the first step for a little business Web App. We are aiming to work. Some basic code already exists.

The first step will be used to generae a monthly mailing to customers that are eligible to receive a gift for their purchases. Therefore some customer data needs to be imported, mails sent out to those customers wich on their end confirm their shipping address. After that csv needs to be exported for the gift shipping-

Functionality for this first step:

• Read data from Airtable and send emails using SES based on this data
• E-Mails contain links for customers to confirm shipping data
• Shipping data gets confirmed and processed based on a few rules
• Address confirmation service API is used to make sure the address is valid
• shipping data needs to be exported from Airtable and downloaded as CSV through admin
• Basic interface is done via Tailwind
• Admin interface is also used to upload CSV every month to process and import more data into airtable. The basic processing code is already there - only needs to be integrated into the flask webb app

Later steps which we would like to do with the same person will be done in future bounties and include adding more functionality to the web app.

Acceptance Criteria

• Experience with Python/Flask