Magento – Magento API catalogProductList filter

apimagento-enterprise

I've been trying, without any success, to acquire a list of products via the API that meet a certain criteria. Our catalog is made up of products which we stock in-house and some that we drop ship. For those that we stock in house, 'manage stock' is set to 'yes' (1), and those are the ones I would like to get in my result set. I've tried setting my complex filter a few different ways with no luck (one example below):

$filter = array (
    'complex_filter' => array (
        array (
            'key' => 'manage_stock',
            'value' => array ('key' => 'in', 'value' => 'Yes')
        )
    )
);

$result = $proxy->catalogProductList($sessionId, $filter);

All variations of the above that I have tried result in a fatal error:

Fatal error:  Uncaught SoapFault exception: [SOAP-ENV:Server] Call to a member function getBackend() on a non-object

And the stack trace doesn't give me any info as to what I might be doing wrong. Does someone have some insight into this, or if it is even possible? Thanks in advance.

Best Answer

Add the filter to your call

$result = $proxy->catalogProductList($sessionId, $filter);

Also I assume that you already have a $sessionId and you have your soap client setup $proxy Yeh?

Also the user that you login with the soap client with, ensure that has correct permissions.

Related Solutions

How to Add Filterable ‘Manage Stock’ Column to Catalog Admin Grid

Try replacing the line

 $collection->addAttributeToSelect('manage_stock');

with

        $collection->joinField('manage_stock',
            'cataloginventory/stock_item',
            'manage_stock',
            'product_id=entity_id',
            '{{table}}.stock_id=1',
            'left');

Your _prepareColumns function should look like this

protected function _prepareColumns(){
    $this->addColumn('manage_stock', array(
           'header'=> Mage::helper('catalog')->__('Manage Stock'),
           'index' => 'manage_stock',
           'type'  => 'options',
           'options' => array (
                           '0' =>  Mage::helper('core')->__('No'), 
                           '1' =>  Mage::helper('core')->__('Yes'),
                        )
    ));
    return parent::_prepareColumns();
}

Magento Enterprise API – How to Update Category

The error indicates that the value for the default_sort_by field is invalid, because you use a empty value. Depending on the field that you want to use for sorting you need to enter it here, for example you could use position:

$result = $client->call($session, 'catalog_category.update', array(181, array(
                'is_anchor' => 1,
                'include_in_menu' => 0,
                'available_sort_by' => "position",
                'default_sort_by' => "position",
            )));

The code above should work, other options that are there by default are 'name' and 'price'. If you want another attribute to use as sortable field, you can set the option 'Used for Sorting in Product Listing' to 'Yes' for the attribute thru that admin option Catalog => Attributes => Manage Attributes

Best Answer

Related Solutions

How to Add Filterable ‘Manage Stock’ Column to Catalog Admin Grid

Magento Enterprise API – How to Update Category

Related Topic