Change due date to multiple products in an order

[davoram]

Hi I need to change massively the due dates of products in orders. Can that be done?

 

 

 

I have orders with 140 google apps accounts in them but need the same due date as in google apps, the due date I need is not the date I created the order it is already define cause are old accounts, and is a tough job to change 140 due dates manually for just 1 order.

 

 

The only way to solve this I have found is to create packages lets say 5, 10, 20, 30 and match that number or create a 140 product package to match my Google Apps panel...

 

Any ideas to solve this?

[sentq]

You can change them using Database Query

[davoram]

Do you know in which table ?

 

Thanks!!!!

[sentq]

products/services located in "tblhosting" table, you need to know which services you are going to update, i think you don't need to change all services DueDate so you need to be specific in your query!

 

e.x: change DueDate to "something" if the current duedate equal "xyz".

or change DueDate if type equal "googleapp"