Magento – How to Update Order Attribute

attributesmoduleorderssales-order

I was able to successfully add new order field through an install script:

$installer->addAttribute('order', 'is_local', array('type'=>Varien_Db_Ddl_Table::TYPE_SMALLINT, 'default'=>1));

However, I could not update the "default" property of it, let's say default=>0. One suggested to use updateAttribute() https://stackoverflow.com/questions/10420199/magento-module-setup-change-product-attribute-to-not-required but it doesn't work in order table.

Thank you.

Best Answer

Hi you can do this by updateAttribute() function

Create upgrade installer and on the upgrade file update field by updateAttribute() function.

Here

$installer = $this;
/* @var $installer Mage_Sales_Model_Mysql4_Setup */

$installer->startSetup();
$installer->updateAttribute('order', 'is_local',  array('default'=>0));
$installer->endSetup();

format:

$params=array()
$installer->updateAttribute(EntityTypeId,attribute_code',$params );

Till now ,i cannot find the where the issue But currently, i give u an alternative solution:

$installer = $this;
/* @var $installer Mage_Sales_Model_Mysql4_Setup */

$installer->startSetup();
$installer->run("ALTER TABLE  {$this->getTable('sales_flat_order')} CHANGE `is_local` `is_local` SMALLINT(6) NULL DEFAULT '0' COMMENT 'Is Local'");
$installer->endSetup();

Related Solutions

Magento – Create a sortable and filterable custom attribute to stand-alone entity

When adding the product attribute, set used_in_product_listing, used_for_sort_by and filterable to true.

You can do that with the following update script:

$installer = Mage::getResourceModel('catalog/setup', 'catalog_setup');
$installer->startSetup();
$installer->updateAttribute('catalog_product', 'product_type', 'used_in_product_listing', 1);
$installer->updateAttribute('catalog_product', 'product_type', 'used_for_sort_by', 1);
$installer->updateAttribute('catalog_product', 'product_type', 'is_filterable', 1);
$installer->endSetup();

Thats all, if if you are NOT using the flat catalog.

If you enable the flat catalog product feature, then you need to ensure that your custom source model implements the methods getFlatColums(), getFlatIndexes() and getFlatUpdateSelect().
If they are missing, your attribute won't be included in the generated flat tables, even if used_in_product_listing is enabled.
Have a look at the class Mage_Eav_Model_Entity_Attribute_Source_Boolean for an example. You can probably copy over the methods with minimal adjustments into your custom source model from there. Otherwise, please ask a new question.

Magento – I can’t get a product attribute value

To answer the question:

Thanks to some handy built-in methods you don't have to do any loading on your own:

Mage_Sales_Model_Order_Shipment_Item provides getOrderItem
Mage_Sales_Model_Order_Item provides getProduct

So, all you should have to do is this:

$product = $shipmentItem->getOrderItem()->getProduct();

If size is persisted to the order item, you can do:

$item = $shipmentItem->getOrderItem();
echo $item->getAttributeText('size');

Or, if you need to load the ID value from the product itself, you can get all of the product's selected ID values:

$size = $shipmentItem->getOrderItem()->getProduct()->getSize();

Best Answer

Related Solutions

Magento – Create a sortable and filterable custom attribute to stand-alone entity

Magento – I can’t get a product attribute value

Related Topic