Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

how to realize a new invoice after 1 year?...


cybermarti

Recommended Posts

Hi all,

I'm a beginner with osc and want to sell several services for a period of 1 year. After that period the customers must pay again for the service if they don't cancel the contract. Any idea how I can change the status of all orders after 1 year from "payment received" to "in progress" or something like that?...

Thanks for your help!

Link to comment
Share on other sites

Run a piece of SQL based on the date the product/service was purchased. If it's a year later, update the status...

You can run this on a cron, or you can just set it to run every time you open your admin area.

 

I'm sure something like that has already been discussed in the forum, might have been a long time ago though.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...