We have an oscommerce website that lets people sell their products on the website.
When the person signs up for an account it lets them list unlimited products for a monthly fee. We charge their card every month on the day they signed up .
This is what needs to be done:
Every month a cron job should email them telling them their card will be charged for that month 5 days before we will charge it.
Also, the webmaster should get an email telling him that it is time to charge "john doe's" card on the day it should be charged.
The website owner should be able to suspend their account, activate, or cancel their account from the admin panel.
There should be a dropdown in the admin->customers edit page that has 3 options:
1. Active (this is the default when they sign up)
2. Suspended
3. Canceled
When the customer is "suspended" the products will not show on the website.
When the customer is "canceled" the products will not show on the website.
There should be a link to "delete all products by this customer"
The search page, category page, new products page, and the products detail page should only show products where the customer is set to active. The product query will have to check to see if the customer is set to active for every product.
Do not set the product status to inactive becuase the website customer can set it back to active. You will need to check the customer to see if they are set to active for every product in the query.