Build a content management system
The content for most e-commerce sites is managed by non-technical staff.
To enable that, we need to build a content management system.
One way to do it: • Set up a spreadsheet like this that can be edited by non-technical staff. This would be the source of data for all editable content. • Create an admin page with a (one-click) facility to update the database from the spreadsheet. • Optionally, build a process to periodically get data from the spreadsheet and update the database. (Probably not a good idea.) • Document the process: 1. Add/remove/update images, 2. Update the spreadsheet, 3. Update the database.
We should include some simple sanity checks for updates: missing data, broken images, replicated data, etc.