If you have no oscommerce experience, please do not bid.
This is what I need to get done:
Alongside the 'normal' products and categories I want to have a category called 'Newsletters' and I want to have Products inside it like '10 newsletters', '20 newsletters' etc.... and/or to have option 'types' like 'daily newsletter', 'weekly newsletter', 'monthly newsletter'
The idea is to have a customer pay in advance to receive newsletters. The customer buys newsletters in bundles of 5, 10, or 20... or in blocks of days, weeks, months etc and then goes to the checkout and pays for them.
Here's where I need to get done:
i) Use the Mulitple Mailing List contribution as a backdrop for sending out the Newsletters. You must build your work for me around this contribution.
ii) The correct number/type of newsletters remaining to show up in the admin/[login to view URL]
iii) The correct number/type of newsletters remaining to show in catalog/[login to view URL] for the customer to see
iv) When remaining newsletters for that particular customer falls below say 5, I want the newsletter to have a 'pre-worded script' to be added to the bottom of the newsletter email (stating there is 'x' newsletters left and asking customer to buy some more)
The bulk of the work is already done with the mailing list contribution but the fact that the SQL database needs to keep a record of the remaining newsletters and for that record to be linked to the 'send newsletter' dropbox, is proving to be a bit tricky for me.
I know it can be done but I don't have the knowledge to do it myself. Please keep the price in check because there will be other work coming the winners way too, I see this as a mutually beneficial partnership!
Good Luck!