Magento 1.9 – Get Product ID from Customer Order

googlestrustedstoremagento-1.9orderssales-order

I am setting up Google trusted stores and I am stuck on one problem which is not compulsory but I would rather it was working.

I need to get the product ID of the item the customer has ordered

So far I have this:

$orderId = $this->getOrderId();
$order = Mage::getModel('sales/order')->loadByIncrementId($orderId);

and I guess I need to get the product ID with something like…$order->get**productID**()

Also what would happen if there is multiple products?

Best Answer

You can do the following after your code:

$items = $order->getAllVisibleItems();
$productIds = array();
foreach($items as $i) {
      $productIds[] = $i->getProductId();
}

The $productIds array will contain all the product ids from the order.

Related Solutions

Magento – Programmatically Invoice a Single Product from an Order

$order = Mage::getModel('sales/order')->loadByIncrementId($increment_id);
$items = $order->getAllItems();

$qtys = array(); //this will be used for processing the invoice

foreach($items as $item){
    if ($item->getSku() == 'SKU1') {
        $qty_to_invoice = $item->getQtyOrdered(); // now gets order quantity of item
    } else {
        $qty_to_invoice = 0;
    }

    $qtys[$item->getId()] = $qty_to_invoice;
    <!-- Note that the ->getId() method gets the item_id on the order, not the product_id -->
}

$invoice = Mage::getModel('sales/service_order', $order)->prepareInvoice($qtys);

Enhanced the answer so it's more clear when you want only a specific SKU

Magento – Create invoice and shipment in magento via cron based on store view and order age

user1618341,According magento an order can place from one store,Magento is save order store id at sales_flat_order,sales_flat_grid order.

At your collection you need get store_id.Also need rectify collection query,Please use * instead of some field

<?php
    try {
        $orders = Mage::getModel('sales/order')->getCollection()
            ->addFieldToFilter(
                'status',
                array(
                    'nin' => array('complete', 'canceled', 'processing', 'holded', 'fraud'),
                    'in' => 'pending',
                ))
            ->addAttributeToSelect('store_id')
            ->addAttributeToSelect('status');
    }
catch (Mage_Core_Exception $e) {
}

I have put the condition to skip create shipment for one store view[if($eachorder->getData('store_id')!=='YOUSKIPSTOREID'):]

see code:

try {

    foreach ($orders as $eachorder) {


        $order = Mage::getModel("sales/order")->load($eachorder->getId());
        if (!$order->canInvoice()) {
            Mage::throwException(Mage::helper('core')->__('Cannot create an invoice.'));
        }
        $invoice = Mage::getModel('sales/service_order', $order)->prepareInvoice();
        if (!$invoice->getTotalQty()) {
            Mage::throwException(Mage::helper('core')->__('Cannot create an invoice without products.'));
        }
        $invoice->setRequestedCaptureCase(Mage_Sales_Model_Order_Invoice::CAPTURE_ONLINE);
        $invoice->register();
        $transactionSave = Mage::getModel('core/resource_transaction')
            ->addObject($invoice)
            ->addObject($invoice->getOrder());
        $transactionSave->save();
        /* put code for skip for one store */
        if($eachorder->getData('store_id')!=='YOUSKIPSTOREID'):

            $shipment = $order->prepareShipment();

            if ($shipment) {
                $shipment->register();
                $order->setIsInProcess(true);

                $transaction_save = Mage::getModel('core/resource_transaction')
                    ->addObject($shipment)
                    ->addObject($shipment->getOrder())
                    ->save();
            } else {
                throw new Exception("Cant get shipment");
            }
        endif;

        $order->setState(Mage_Sales_Model_Order::STATE_COMPLETE);
        $order->save();
    }

}catch (Mage_Core_Exception $e) {

}

If you getting the issues for create invoice and shipment,Please see my Blog:

Create invoice:

Create Shipment:

Best Answer

Related Solutions

Magento – Programmatically Invoice a Single Product from an Order

Magento – Create invoice and shipment in magento via cron based on store view and order age

Related Topic