4. Story 1. Compress and Downsize Declined SYB Images

Base: SYB Submitted Base – View “Declined”

Objective

Reduce Airtable storage usage by compressing and downsizing all attached images in the “Declined” view of the SYB Submitted base to approximately 100 KB per image.

Scope of Work

1. Identify all records in the “Declined” view that contain image attachments.

2. Download attachments and compress them to ~100 KB per image using an appropriate compression method.

3. Re-upload compressed versions to Airtable, replacing the original images while keeping filenames and attachment order consistent.

4. Confirm backup/archive status:

   • Check whether the full-size original images for these declined records are already archived in HubSpot.

   • If not archived, store them in Box, using the following naming convention:
     DealID_AirtableID_ProductName_ImageNr

5. Future consideration:

   • The same compression and archival process may be repeated in the future for sold SYB items to manage attachment storage limits efficiently.

Acceptance Criteria