Change Invoice Dates

Hi!

How can I change my order created dates, as we create the invoice only once we receive an electronic funds transfer and the date has to match this.

Hi,

One solution would be to edit the "invoice" file of the "order" view of your back-end template and change the line :

<?php echo JText::_('DATE').': '.hikashop_getDate($this->element->order_created,'%d %B %Y ');?><br/>

<?php echo JText::_('DATE').': '.hikashop_getDate($this->element->order_modified,'%d %B %Y ');?><br/>

That is helpful thank you. One problem is that we sometimes edit, correct or alter and this shows up on the modify date. How can we edit the modify date?

Thank you for that tip on editing the "invoice" file of the "order" view. It will be very helpful and will automatically fix 90% of our problems. We need to generate tax reports however, so we need to be able to fix some of the orders that were modified a second time.

Is there anyway we could fix these order dates in the MySQL backend? Which records would we look for?

Appreciate it.

Hi,

You can edit the order modification date via the mass actions, System > Mass actions.
It allow you to edit what you want on product, categories, orders, ...

So configure it on the data "Order" and change the value of the field "order_modified" in the action "update values".

That is very helpful! How should I set the INT value for a order_modified? Say I was changing 2013-10-31 16:28 to 2013-10-30 16:28?

Appreciate the help... but I found the easiest way was to drill down into the MySQL backend via phpMyAdmin, convert the datetime to int (from human readable into unix epoch) and edit the "order_modified" field with this value.

The "Display" value in mass actions would have been ideal, as it allowed me to edit the "order_created" date. Unfortunately, it didn't allow me to save changed to the "order_modified" record.

Thank again,
Bruce Atkinson