I need a web-based database application for managing monthly magazine subscribers by issue number. The app should integrate with 1shoppingcart and be able to perform the functions:
-Automatic Subscription Import(API) from 1shoppingcart Sales
-Add Subscribers Manually(admin area)
-Update Subscribers Records Manually(admin area)
-Update Subscribers Records Automatically Upon Renewal Sale
-Track Subscribers Status by Issue #(admin area)
-Export Current Subscribers Mailing List Manually(admin area)
Subscriber Record Information:
Address Line 1
Address Line 2
Number of Issues(Subscription Purchase)*
*The DB must calculate the issue start number, number of issues and last issue by the product type(12 or 24 issue subscription) by referencing a current issue field that is manually updated..
I will need to export a mailing list by issue number so that all subscribers that have paid to receive that issue will be exported to csv.
I will also need to export a mailing list including telephone and email for all expired subscribers.
Application must be accessible privately through a web interface. System must be able to handle a large number of records 100k plus.