**Template Based osCommerce Newsletter**
We require the current newsletter system to be modified to allow much more functionality. The entire should be template based using tags within the template to insert the data entered by the user.
1. Template must be html and a separate file in a new directory
2. Template list must be read from the directory and a dropdown menu in the admin to allow choice of template to use
3. Admin should be written using either AJAX or PHP to allow easy insertion of data.
**Data required:**
1. Main content of newsletter as already implemented in the default distribution of osCommerce.
2. Ability to select which template to use
3. Ability to upload images to the template
4. Ability to select products to insert. All data about the product MUST be inserted from the database.
5. Ability to change the category headings within the Newsletter.
6. Ability to select multiple news items from our database to be inserted
7. There are possibly more features required, however this should be the majority of them.
**What we will provide:**
1. A PSD or JPG of the first template
2. A screengrab of the admin page showing the details required
3. Access to our server including FTP and Database
4. Fast responses to your questions and comments