Magento 1.8 – How to Get Disabled or Inactive Products from Flat Catalog

catalogmagento-1.8PHP

I am trying to get all disabled products from magento using the following code but it returns only enabled products. I have enabled Flat Catalog Product options. Is there any way to get disabled configurable products using mysql or magento code?

$collection = Mage::getModel('catalog/product')->getCollection()
->addAttributeToFilter('type_id', array('eq' => 'configurable'))
->addAttributeToSelect('*')
->addAttributeToFilter('status', array('eq' => Mage_Catalog_Model_Product_Status::STATUS_DISABLED));

Best Answer

The disabled products are not indexed in the flat table.
Take a look at Mage_Catalog_Model_Product_Flat_Indexer::updateProductStatus(). This is called sometime during the indexing process.

public function updateProductStatus($productId, $status, $store = null)
{
    if (is_null($store)) {
        foreach (Mage::app()->getStores() as $store) {
            $this->updateProductStatus($productId, $status, $store->getId());
        }
        return $this;
    }

    if ($status == Mage_Catalog_Model_Product_Status::STATUS_ENABLED) {
        $this->_getResource()->updateProduct($productId, $store);
        $this->_getResource()->updateChildrenDataFromParent($store, $productId);
    }
    else { //IF the product is disabled it is removed from the flat tables
        $this->_getResource()->removeProduct($productId, $store);
    }

    return $this;
}

So you can get the disabled products only by using the EAV tables.
Try this:

$collection = Mage::getResourceModel('catalog/product_collection')
->addAttributeToFilter('type_id', array('eq' => 'configurable'))
->addAttributeToSelect('*')
->addAttributeToFilter('status', array('eq' => Mage_Catalog_Model_Product_Status::STATUS_DISABLED));

Related Solutions

Magento – Join Stock Information Problems with Flat Products

When filtering by stock status on a product collection you can use the standard way in magento as follows.

Mage::getSingleton('cataloginventory/stock')->addInStockFilterToCollection($collection);

This will eventually call setInStockFilterToCollection on Mage_CatalogInventory_Model_Resource_Stock

public function setInStockFilterToCollection($collection)
{
    $manageStock = Mage::getStoreConfig(Mage_CatalogInventory_Model_Stock_Item::XML_PATH_MANAGE_STOCK);
    $cond = array(
        '{{table}}.use_config_manage_stock = 0 AND {{table}}.manage_stock=1 AND {{table}}.is_in_stock=1',
        '{{table}}.use_config_manage_stock = 0 AND {{table}}.manage_stock=0',
    );

    if ($manageStock) {
        $cond[] = '{{table}}.use_config_manage_stock = 1 AND {{table}}.is_in_stock=1';
    } else {
        $cond[] = '{{table}}.use_config_manage_stock = 1';
    }

    $collection->joinField(
        'inventory_in_stock',
        'cataloginventory/stock_item',
        'is_in_stock',
        'product_id=entity_id',
        '(' . join(') OR (', $cond) . ')'
    );
    return $this;
}

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 – Join Stock Information Problems with Flat Products

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

Related Topic