Magento – Backdate Orders? Change date on manual orders

orders

When creating an order, is there anyway to select the date when the order was made.

As some orders taken offline, we want to add back into the sytem, with the correct date, so they show on the reports.

Best Answer

No, there is no way with vanilla Magento. There may be a way via some module that exists.

Programmatically if you would like to change the date of an order you can do so via:

$orderId = '100000001'; //change this to your increment id
$order = Mage::getModel('sales/order')->loadByIncrementId($orderId);

$order->setCreatedAt('2013-01-01 04:00:00'); //or whatever date you wish
$order->save();

Related Solutions

Magento – Implementing ability to capture payments offline from orders

You could use the on account/invoice payment (free) extension from http://mamoc.com/rembours-and-invoice-payment-method. You can configure this extension to create an invoice when the order is completed but with the invoice payment state as pending. This way you only need to capture the payment for the invoice to set the order to the next stage.

Magento – How to Filter Orders by Date on Custom Page

try this query

$queryCondition .= "WHERE post_at >= '" . $from_date . "' AND post_at <= '" . $to_date . "'";





$reg_user = new USER();
$stmt = $reg_user->runQuery("SELECT * FROM order_details ".$queryCondition);
$row = $stmt->fetch(PDO::FETCH_ASSOC);
$stmt->execute();

updated code

$post_at = '0000-00-00 00:00:00'; 
$post_at_todate = '0000-00-00 00:00:00';

$queryCondition = "";

    if( !empty( $_POST[ 'post_at' ] ) ) 
{           
    $post_at        = date( 'Y-m-d  h:i:s', strtotime( $_POST[ 'post_at' ] ) );
    $post_at_todate = date( 'Y-m-d' );
    if( !empty( $_POST[ 'post_at_to_date' ] ) )
    {
        $post_at_to_date = date( 'Y-m-d h:i:s', strtotime( $_POST[ 'post_at_to_date' ] ) );
        $post_at_todate = $post_at_to_date;
    }
    $queryCondition .= "WHERE  created_at  >= '" . $post_at . "' AND  created_at  <= '" . $post_at_todate . "'";
}

$sqlquery = "SELECT * FROM order_details $queryCondition";
//$sqlquery = "SELECT * FROM order_details where created_at >= '2016-11-17' AND created_at < = '2016-11-19'";
var_dump( $sqlquery );

Best Answer

Related Solutions

Magento – Implementing ability to capture payments offline from orders

Magento – How to Filter Orders by Date on Custom Page

Related Topic