Magento 1.7 – Programmatically Differentiate Between Admin & Customer-Placed Orders

magento-1.7orders

I'm trying to establish whether it is possible to differentiate between orders placed in the frontend (by the customer) and the backend (by an administrator).

I read this post on SO:

Differentiating Backend vs. Frontend Purchases in Magento

Which mainly highlights the fact that you used to be able to check the store_id field, but this does not hold true for the latest versions of Magento.

The other thing which it mentions is that when looking at an order via the backend, if it was indeed placed by a customer, you will see a field titled Placed from IP, which is missing if it was placed by an administrator.

I can't seem to find anything related to IP addresses via the sales_flat_order table.

Any ideas?

Best Answer

There is a field remote_ip on the table sales_flat_order, that appears to be null from the admin and the ip of the customer from the front end.

It was added in Magento 1.6 so if you are using version 1.7 you should be safe here.

It is set in app/code/core/Mage/Checkout/Model/Session.php on the quote and copied across.

<sales_convert_quote>
    <remote_ip>
        <to_order>*</to_order>
    </remote_ip>
</sales_convert_quote>

Related Solutions

Magento – Programmatically reorder multiple orders

I had same problem. But i resolved this by resetting new quote to adminhtml quote session. So it will not take items from previous orders.

Here is your solution.

foreach($orders as $_order){
    $orderId = $_order->getId();

    Mage::unregister('rule_data');
    Mage::getSingleton('adminhtml/session_quote')->clear();

    $order = Mage::getModel('sales/order')->load($orderId);
    $incId = $order->getIncrementId();

    $newQuote = new Mage_Sales_Model_Quote();
    $newQuote->setStoreId($order->getStoreId());
    Mage::getSingleton('adminhtml/sales_order_create')->setQuote($newQuote);

    $order_model = Mage::getSingleton('adminhtml/sales_order_create');
    $order_model->getSession()->clear();

    try {
        $order->setReordered(true);
        Mage::getSingleton('adminhtml/session_quote')->setUseOldShippingMethod(true);

        $reorder = new Varien_Object();
        $reorder = $order_model->initFromOrder($order);
        $newOrder = $reorder->createOrder();

        $reOrderId = $newOrder->getId();
        $reOrderIncId = $newOrder->getIncrementId();
        Mage::log("Order #{$incId} is Reorders To New Order #{$reOrderIncId} Successfully",null,"reorder.log");
    } catch (Exception $e) {
        Mage::log("Order #{$incId} Reorder Error : {$e->getMessage()}",null,"reorder.log";
    }
    $reorder->getSession()->clear();
    Mage::unregister('rule_data');
    Mage::getSingleton('adminhtml/session_quote')->clear();
}

How to Programmatically Get Pending and Canceled Orders in Magento

You can use the below code :

$orders = Mage::getModel('sales/order')->getCollection()
        ->addFieldToFilter('status', array('in' => array('complete','processing','pending_payment','canceled')));

Best Answer

Related Solutions

Magento – Programmatically reorder multiple orders

How to Programmatically Get Pending and Canceled Orders in Magento

Related Topic