Set created_at When Programmatically Creating a Magento Order

datemagento-1.8orders

I'm struggling to set the order date when creating a magento order programatically.

Here is what I'm trying to use:

$orderObj->setData('created_at', $date);
$orderObj->setUpdatedAt($date);

but it doesn't appear to work.

Thank you in advance!

Best Answer

created_at and updated_at for orders is set in Mage_Sales_Model_Resource_Abstract::_prepareDataForSave():

/**
 * Prepare data for save
 *
 * @param Mage_Core_Model_Abstract $object
 * @return array
 */
protected function _prepareDataForSave(Mage_Core_Model_Abstract $object)
{
    $currentTime = Varien_Date::now();
    if ((!$object->getId() || $object->isObjectNew()) && !$object->getCreatedAt()) {
        $object->setCreatedAt($currentTime);
    }
    $object->setUpdatedAt($currentTime);
    $data = parent::_prepareDataForSave($object);
    return $data;
}

You can see that updated_at is always set to the current time, whereas created_at is only set if the attribute is empty. The format that it should have comes from Varien_Date.

So you should be able to define your own creation timestamp:

$order->setCreatedAt(Varien_Date::formatDate($date, false));

where $date can be a Unix timestamp or an arbitrary date expression that can be parsed with PHPs strtotime

Convert Price from Current Currency to Base Currency and vice-versa

<?php
$baseCurrencyCode = Mage::app()->getStore()->getBaseCurrencyCode();
$currentCurrencyCode = Mage::app()->getStore()->getCurrentCurrencyCode();
$price = 100;

// convert price from current currency to base currency
$priceOne = Mage::helper('directory')->currencyConvert($price, $currentCurrencyCode, $baseCurrencyCode); 

// convert price from base currency to current currency
$priceTwo = Mage::helper('directory')->currencyConvert($price, $baseCurrencyCode, $currentCurrencyCode);
?>

Changing price from any one currency to another

<?php
$from = 'USD';
$to = 'NPR';
$price = 10;

$newPrice = Mage::helper('directory')->currencyConvert($price, $from, $to);
?>

Get Currency Rates

<?php
/**
 * Get the base currency
 */
$baseCurrencyCode = Mage::app()->getBaseCurrencyCode();

/**
 * Get all allowed currencies
 * returns array of allowed currency codes
 */
$allowedCurrencies = Mage::getModel('directory/currency')->getConfigAllowCurrencies();

/**
 * Get the currency rates
 * returns array with key as currency code and value as currency rate
 */
$currencyRates = Mage::getModel('directory/currency')->getCurrencyRates($baseCurrencyCode, array_values($allowedCurrencies));

$allowedCurrencies = Mage::getModel('directory/currency')->getConfigAllowCurrencies();

/**
 * Get currency rates for Nepalese Currency
 */
$currencyRates = Mage::getModel('directory/currency')->getCurrencyRates('NPR', array_values($allowedCurrencies));
?>

Magento – “Please specify a shipping method” when programmatically creating an order

You should add $quote->getShippingAddress()->collectTotals(); before your above code. It will work :

/* Important*/
 $quote->getShippingAddress()->collectTotals();// if not will show Please specify shipping methods.
 /* Important*/

$shipping_address->setCollectShippingRates(true)->collectShippingRates()
        ->setShippingMethod($delivery)
        ->setPaymentMethod($payment);

Best Answer

Related Solutions

Magento – Magento – set currency when creating order programmatically

Convert Price from Current Currency to Base Currency and vice-versa

Changing price from any one currency to another

Get Currency Rates

Magento – “Please specify a shipping method” when programmatically creating an order

Related Topic