protected function _addAttributeToAttributeSet($attributeSetId, $attributeCode) { $setup = new \Mage_Eav_Model_Entity_Setup('core_setup'); $attributeId = $setup->getAttributeId('catalog_product', $attributeCode); $attributeGroupId = $setup->getDefaultAttributeGroupId('catalog_product', $attributeSetId); $setup->addAttributeToSet('catalog_product', $attributeSetId, $attributeGroupId, $attributeId); }
*/ /** @var $installer Mage_Core_Model_Resource_Setup */ $installer = $this; $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); /* Add credit value attribute */ $data = array('type' => 'decimal', 'input' => 'text', 'label' => 'Credit Balance', 'backend' => '', 'frontend' => '', 'source' => '', 'is_visible' => 0, 'is_visible_on_front' => 0, 'required' => 0, 'user_defined' => 0, 'is_searchable' => 1, 'is_filterable' => 0, 'is_comparable' => 0, 'position' => 2, 'unique' => 0, 'default' => 0.0, 'is_global' => ''); $setup->addAttribute('customer', 'credit_value', $data); $attribute = Mage::getSingleton('eav/config')->getAttribute('customer', 'credit_value'); $attribute->setDefaultValue('0.00'); $attribute->save(); $setup->removeAttribute('catalog_product', 'credit_amount'); $attr = array('group' => 'Prices', 'type' => 'text', 'input' => 'text', 'label' => 'Credit Amount', 'backend' => '', 'frontend' => '', 'source' => '', 'visible' => 1, 'user_defined' => 1, 'used_for_price_rules' => 1, 'position' => 2, 'unique' => 0, 'default' => '', 'sort_order' => 101, 'note' => 'For example: <br/>Fixed price: 100 <br/>Option Price: 10,20,30 <br/>Price range: 1-100 '); $setup->addAttribute('catalog_product', 'credit_amount', $attr); $creditAmount = Mage::getModel('catalog/resource_eav_attribute')->load($setup->getAttributeId('catalog_product', 'credit_amount')); $creditAmount->addData(array('is_global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE, 'is_required' => 0, 'apply_to' => array('customercredit'), 'is_configurable' => 1, 'is_searchable' => 1, 'is_visible_in_advanced_search' => 1, 'is_comparable' => 0, 'is_filterable' => 0, 'is_filterable_in_search' => 1, 'is_used_for_promo_rules' => 1, 'is_html_allowed_on_front' => 0, 'is_visible_on_front' => 0, 'used_in_product_listing' => 1, 'used_for_sort_by' => 0, 'backend_type' => 'text'))->save(); $tax = Mage::getModel('catalog/resource_eav_attribute')->load($setup->getAttributeId('catalog_product', 'tax_class_id')); $applyTo = explode(',', $tax->getData('apply_to')); $applyTo[] = 'customercredit'; $tax->addData(array('apply_to' => $applyTo))->save(); /** * create customercredit table */ $installer->run("\nDROP TABLE IF EXISTS {$this->getTable('credit_transaction')};\nDROP TABLE IF EXISTS {$this->getTable('credit_code')};\nDROP TABLE IF EXISTS {$this->getTable('type_transaction')};\n\t\nCREATE TABLE {$this->getTable('credit_transaction')} (\n `transaction_id` int(10) unsigned NOT NULL auto_increment,\n `customer_id` int(10) unsigned NOT NULL ,\n `type_transaction_id` int(11) NULL,\n `detail_transaction` varchar(255) NULL default '',\n `order_increment_id` varchar(30) NULL default '',\n `amount_credit` decimal(12,4) default '0',\n `begin_balance` decimal(12,4) default '0',\n `end_balance` decimal(12,4) default '0',\n `transaction_time` datetime NULL,\n `customer_group_ids` int(10) default '0',\n `status` varchar(20) default '',\n `spent_credit` decimal(12,4) NOT NULL,\n `received_credit` decimal(12,4) NOT NULL,\n PRIMARY KEY (`transaction_id`),\n INDEX (`customer_id`),\n FOREIGN KEY (`customer_id`)\n REFERENCES {$this->getTable('customer_entity')} (`entity_id`)\n ON DELETE CASCADE\n ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nCREATE TABLE {$this->getTable('credit_code')} (\n `credit_code_id` int(11) unsigned NOT NULL auto_increment,\n `credit_code` varchar(255) NOT NULL default '',\n `currency` varchar(45) default '',\n `description` text default '',\n `transaction_time` datetime NULL,\n `status` varchar(20) default '',\n `amount_credit` decimal(12,4) default '0',\n `recipient_email` varchar(200) default '',\n `customer_id` int(10) unsigned NOT NULL ,\n PRIMARY KEY (`credit_code_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nCREATE TABLE {$this->getTable('type_transaction')} (\n `type_transaction_id` int(11) unsigned NOT NULL auto_increment,\n `transaction_name` varchar(255) default '',\n PRIMARY KEY (`type_transaction_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\n\nINSERT INTO {$this->getTable('type_transaction')}(`type_transaction_id`,`transaction_name`) \nVALUES (1,'Changed by admin'),\n (2,'Send credit to friends'),\n (3,'Receive Credit from Friends'),\n (4,'Redeem Credit'),\n (5,'Receive order refund by credit'),\n (6,'Check Out by Credit'),\n (7,'Cancel sending credit'),\n (8,'Customer Buy Credit'),\n (9,'Cancel Order'),\n (10,'Refund Credit Product')\n;\n\n"); $installer->getConnection()->addColumn($installer->getTable('sales/order'), 'customercredit_discount', 'decimal(12,4) NULL'); $installer->getConnection()->addColumn($installer->getTable('sales/order'), 'base_customercredit_discount', 'decimal(12,4) NULL'); $installer->endSetup();
<?php /** * @author Amasty Team * @copyright Copyright (c) 2015 Amasty (https://www.amasty.com) * @package Amasty_Xnotif */ $installer = new Mage_Eav_Model_Entity_Setup($this->_resourceName); $installer->startSetup(); $installer->addAttribute('catalog_product', 'amxnotif_hide_alert', array('type' => 'int', 'backend' => '', 'frontend' => '', 'label' => 'Hide Stock Alert Block', 'input' => 'select', 'class' => '', 'source' => 'eav/entity_attribute_source_boolean', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, 'visible' => true, 'required' => false, 'user_defined' => false, 'default' => '', 'searchable' => false, 'filterable' => false, 'comparable' => false, 'visible_on_front' => false, 'unique' => false, 'is_configurable' => false)); $attributeId = $installer->getAttributeId('catalog_product', 'amxnotif_hide_alert'); foreach ($installer->getAllAttributeSetIds('catalog_product') as $attributeSetId) { try { $attributeGroupId = $installer->getAttributeGroupId('catalog_product', $attributeSetId, 'General'); } catch (Exception $e) { $attributeGroupId = $installer->getDefaultAttributeGroupId('catalog_product', $attributeSetId); } $installer->addAttributeToSet('catalog_product', $attributeSetId, $attributeGroupId, $attributeId); } $installer->endSetup();
<?php require_once "mygassi-config.php"; require_once mageroot; Mage::app(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $setup->startSetup(); $setup->deleteTableRow('eav/entity_attribute', 'attribute_id', $setup->getAttributeId('catalog_product', 'linientext'), 'attribute_set_id', $setup->getAttributeSetId('catalog_product', 'Default')); $setup->deleteTableRow('eav/entity_attribute', 'attribute_id', $setup->getAttributeId('catalog_product', 'gruppentext'), 'attribute_set_id', $setup->getAttributeSetId('catalog_product', 'Default')); $setup->deleteTableRow('eav/entity_attribute', 'attribute_id', $setup->getAttributeId('catalog_product', 'einzeltext'), 'attribute_set_id', $setup->getAttributeSetId('catalog_product', 'Default')); $setup->deleteTableRow('eav/entity_attribute', 'attribute_id', $setup->getAttributeId('catalog_product', 'add_desc_1'), 'attribute_set_id', $setup->getAttributeSetId('catalog_product', 'Default')); $setup->deleteTableRow('eav/entity_attribute', 'attribute_id', $setup->getAttributeId('catalog_product', 'add_desc_2'), 'attribute_set_id', $setup->getAttributeSetId('catalog_product', 'Default')); $setup->deleteTableRow('eav/entity_attribute', 'attribute_id', $setup->getAttributeId('catalog_product', 'add_desc_3'), 'attribute_set_id', $setup->getAttributeSetId('catalog_product', 'Default')); $setup->endSetup(); exit;
<?php $installer = $this; $installer->startSetup(); $installer->run("\n\nDROP TABLE IF EXISTS {$this->getTable('aramex_shipping_suppliers')};\nCREATE TABLE {$this->getTable('aramex_shipping_suppliers')} (\n `asv_id` int(11) unsigned NOT NULL auto_increment,\n `identifier` varchar(255) NOT NULL,\n `username` varchar(255) NOT NULL,\n `password` varchar(255) NOT NULL,\n `account_country_code` varchar(2) NULL,\n `account_entity` varchar(3) NULL,\n `account_number` int(11) unsigned NULL,\n `account_pin` int(11) unsigned NULL,\n `address_line1` varchar(255) NOT NULL,\n `address_line2` varchar(255) NULL,\n `address_line3` varchar(255) NULL,\n `city` varchar(255) NOT NULL,\n `state_or_province_code` varchar(255) NULL,\n `post_code` varchar(255) NOT NULL,\n `country_code` varchar(2) NOT NULL,\n `department` varchar(255) NULL,\n `person_name` varchar(255) NOT NULL,\n `person_title` varchar(255) NULL,\n `company_name` varchar(255) NOT NULL,\n `phone_number1` varchar(255) NOT NULL,\n `phone_number1_ext` varchar(255) NOT NULL,\n `phone_number2` varchar(255) NULL,\n `phone_number2_ext` varchar(255) NULL,\n `fax_number` varchar(255) NULL,\n `cellphone` varchar(255) NOT NULL,\n `email` varchar(255) NOT NULL,\n `type` varchar(255) NULL,\n PRIMARY KEY (`asv_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\n "); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); if (!$setup->getAttributeId(Mage_Catalog_Model_Product::ENTITY, 'aramex_supplier')) { $setup->addAttribute('catalog_product', 'aramex_supplier', array('attribute_set' => 'Default', 'group' => 'General', 'input' => 'select', 'type' => 'text', 'label' => 'Aramex Supplier', 'backend' => '', 'visible' => 1, 'required' => 0, 'user_defined' => 1, 'searchable' => 1, 'filterable' => 0, 'comparable' => 1, 'visible_on_front' => 1, 'visible_in_advanced_search' => 0, 'is_html_allowed_on_front' => 0, 'source' => 'aramexshipping/product_attribute_source_suppliers', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL)); } if (version_compare(Mage::getVersion(), '1.4.1.0', '>=')) { $setup = $this->_conn; $setup->addColumn($this->getTable('sales_flat_shipment'), 'aramex_shipment_data', 'text'); } else { $setup = new Mage_Eav_Model_Entity_Setup('sales_setup'); $setup->addAttribute('shipment', 'aramex_shipment_data', array('type' => 'text')); } $installer->endSetup();
<?php $installer = $this; $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $catalogProduct = 'catalog_product'; $attributeCode = 'ism_newstoremembers_price'; $setup->addAttribute($catalogProduct, $attribute_code, array('input' => 'text', 'label' => 'Newstore Member Price', 'backend' => '', 'frontend_class' => 'validate-number', 'visible' => 1, 'required' => 0, 'user_defined' => 1, 'searchable' => 0, 'filterable' => 0, 'sort_order' => 30, 'comparable' => 0, 'visible_on_front' => 0, 'visible_in_advanced_search' => 0, 'is_html_allowed_on_front' => 0, 'is_configurable' => 1, 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL)); //add new attribute in prices attribute set $groupName = 'prices'; $attributeSetName = 'default'; $attributeSetId = $setup->getAttributeSetId($catalogProduct, $attributeSetName); $attributeGroupId = $setup->getAttributeGroupId($catalogProduct, $attributeSetId, $groupName); $attributeId = $setup->getAttributeId($catalogProduct, $attributeCode); $setup->addAttributeToSet($catalogProduct, $attributeSetId, $attributeGroupId, $attributeId); $installer->endSetup(); $group = Mage::getModel('customer/group')->setData(array('customer_group_code' => 'Newstore Members Group', 'tax_class' => 3))->save(); Mage::getModel('core/config')->saveConfig('ism_newstore_members/newstore_members_group', "0", 'defaut', $group->getId());
public function testAction() { $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entity_type = Mage::getSingleton("eav/entity_type")->loadByCode("catalog_product"); $entity_type_id = $entity_type->getId(); $collection = Mage::getModel("eav/entity_attribute")->getCollection()->addFieldToFilter("entity_type_id", $entity_type_id)->addFieldToFilter("attribute_code", "giftwrap"); if (count($collection)) { $collection->getFirstItem()->delete(); } if (!count($collection)) { $data = array('group' => 'General', 'type' => 'int', 'input' => 'select', 'label' => 'Wrappable', 'backend' => '', 'frontend' => '', 'source' => 'giftwrap/attribute_wrappable', 'visible' => 1, 'required' => 1, 'user_defined' => 1, 'is_searchable' => 1, 'is_filterable' => 0, 'is_comparable' => 1, 'is_visible_on_front' => 0, 'is_visible_in_advanced_search' => 1, 'used_for_sort_by' => 0, 'used_in_product_listing' => 1, 'used_for_price_rules' => 1, 'is_used_for_promo_rules' => 1, 'position' => 2, 'unique' => 0, 'is_configurable' => 1, 'default' => 0, 'is_global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE); $setup->addAttribute('catalog_product', 'giftwrap', $data); $entity_type_id = $setup->getEntityTypeId('catalog_product'); $data['entity_type_id'] = $entity_type_id; $attribute = Mage::getModel("eav/entity_attribute")->setData($data)->setId($setup->getAttributeId('catalog_product', 'giftwrap')); $attribute->save(); } }
<?php $installer = $this; $installer = new Mage_Eav_Model_Entity_Setup('core_setup'); $attribute_set_name = 'default'; $group_name = 'General'; $attribute_code = 'salepages'; $attribute_set_id = $installer->getAttributeSetId('catalog_product', $attribute_set_name); $attribute_group_id = $installer->getAttributeGroupId('catalog_product', $attribute_set_id, $group_name); $attribute_id = $installer->getAttributeId('catalog_product', $attribute_code); $installer->addAttributeToSet($entityTypeId = 'catalog_product', $attribute_set_id, $attribute_group_id, $attribute_id); $installer->endSetup();
<?php /** * @author Amasty Team * @copyright Copyright (c) 2015 Amasty (https://www.amasty.com) * @package Amasty_Conf */ $installer = new Mage_Eav_Model_Entity_Setup($this->_resourceName); $installer->startSetup(); $installer->addAttribute('catalog_product', 'amconf_simple_price', array('type' => 'int', 'backend' => '', 'frontend' => '', 'label' => 'Use price of simple products', 'note' => 'If set to "Yes", full price of associated products of configurables is used for calculations and front end display instead of price difference.', 'input' => 'select', 'class' => '', 'source' => 'eav/entity_attribute_source_boolean', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, 'visible' => true, 'required' => false, 'user_defined' => false, 'default' => '', 'searchable' => false, 'filterable' => false, 'comparable' => false, 'visible_on_front' => false, 'unique' => false, 'apply_to' => 'configurable', 'is_configurable' => false)); $attributeId = $installer->getAttributeId('catalog_product', 'amconf_simple_price'); foreach ($installer->getAllAttributeSetIds('catalog_product') as $attributeSetId) { try { $attributeGroupId = $installer->getAttributeGroupId('catalog_product', $attributeSetId, 'General'); } catch (Exception $e) { $attributeGroupId = $installer->getDefaultAttributeGroupId('catalog_product', $attributeSetId); } $installer->addAttributeToSet('catalog_product', $attributeSetId, $attributeGroupId, $attributeId); } $installer->endSetup();
<?php $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer = $this; $installer->startSetup(); //Giftwrap attribute $entity_type = Mage::getSingleton("eav/entity_type")->loadByCode("catalog_product"); $entity_type_id = $entity_type->getId(); $collection = Mage::getModel("eav/entity_attribute")->getCollection()->addFieldToFilter("entity_type_id", $entity_type_id)->addFieldToFilter("attribute_code", "giftwrap"); if (!count($collection)) { $data = array('group' => 'General', 'type' => 'int', 'input' => 'select', 'label' => 'Wrappable', 'apply_to' => 'simple,bundle,configurable', 'backend' => '', 'frontend' => '', 'source' => 'giftwrap/attribute_wrappable', 'visible' => 1, 'required' => 1, 'user_defined' => 1, 'is_searchable' => 1, 'is_filterable' => 0, 'is_comparable' => 1, 'is_visible_on_front' => 0, 'is_visible_in_advanced_search' => 1, 'used_for_sort_by' => 0, 'used_in_product_listing' => 1, 'used_for_price_rules' => 1, 'is_used_for_promo_rules' => 1, 'position' => 2, 'unique' => 0, 'is_configurable' => 1, 'default' => 0, 'is_global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE); $setup->addAttribute('catalog_product', 'giftwrap', $data); $entity_type_id = $setup->getEntityTypeId('catalog_product'); $data['entity_type_id'] = $entity_type_id; $attribute = Mage::getModel("eav/entity_attribute")->setData($data)->setId($setup->getAttributeId('catalog_product', 'giftwrap')); $attribute->save(); } $installer->run("\r\n\r\n\tALTER TABLE {$this->getTable('sales_flat_order')} ADD `giftwrap_amount` DECIMAL( 12, 4 ) ;\r\n\r\n\tALTER TABLE {$this->getTable('sales_flat_order')} ADD `giftwrap_tax` DECIMAL( 12, 4 ) NOT NULL default '0';\r\n\t\r\n\tDROP TABLE IF EXISTS {$this->getTable('giftwrap')};\r\n\tCREATE TABLE {$this->getTable('giftwrap')} (\r\n\t `giftwrap_id` int(11) unsigned NOT NULL auto_increment,\r\n\t `title` varchar(255) NOT NULL default '',\r\n\t `price` DECIMAL(12,4) NOT NULL default '0',\r\n\t `image` varchar(255) NULL default '',\r\n\t `sort_order` int(10) NOT NULL default '0', \r\n\t `personal_message` smallint(6) NOT NULL default '0',\r\n\t `status` smallint(6) NOT NULL default '0',\r\n\t `character` int(10) NOT NULL default '0',\r\n\t `store_id` smallint(5) unsigned NOT NULL,\r\n\t `option_id` int(11) NOT NULL default '0',\r\n\t `default_title` tinyint(1) NOT NULL default '1',\r\n\t `default_price` tinyint(1) NOT NULL default '1',\r\n\t `default_image` tinyint(1) NOT NULL default '1',\r\n\t `default_sort_order` tinyint(1) NOT NULL default '1',\r\n\t `default_personal_message` tinyint(1) NOT NULL default '1',\r\n\t `default_status` tinyint(1) NOT NULL default '1',\r\n\t `default_character` tinyint(1) NOT NULL default '1',\r\n\t INDEX(`store_id`),\r\n\t FOREIGN KEY (`store_id`) REFERENCES {$this->getTable('core/store')} (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE, \r\n\t PRIMARY KEY (`giftwrap_id`)\r\n\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\n \r\n\tDROP TABLE IF EXISTS {$this->getTable('giftwrap_selection')};\r\n\tCREATE TABLE {$this->getTable('giftwrap_selection')} (\r\n\t `id` int(11) unsigned NOT NULL auto_increment,\r\n\t `quote_id` int(10) unsigned NOT NULL,\r\n\t `item_id` int(11) NOT NULL,\r\n\t `style_id` int(11) unsigned NOT NULL,\r\n\t `message` text NULL,\r\n\t INDEX(`style_id`),\r\n\t FOREIGN KEY (`style_id`) REFERENCES `{$this->getTable('giftwrap')}` (`giftwrap_id`) ON DELETE CASCADE ON UPDATE CASCADE,\r\n\t PRIMARY KEY (`id`)\r\n\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n"); $installer->endSetup();
<?php error_reporting(E_ALL); require_once 'app/Mage.php'; umask(0); echo "<pre>"; /* not Mage::run(); */ Mage::app(); $installer = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); $row = 1; $fields = array(); if (($handle = fopen("diameter.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $fields[] = trim($data[1]); } fclose($handle); } print_r(array_unique($fields)); $color = array_values(array_unique($fields)); //print_r($color);exit; $iProductEntityTypeId = Mage::getModel('catalog/product')->getResource()->getTypeId(); $aOption = array(); $aOption['attribute_id'] = $installer->getAttributeId($iProductEntityTypeId, 'diameter'); for ($iCount = 0; $iCount < sizeof($color); $iCount++) { $aOption['value']['option' . $iCount][0] = $color[$iCount]; } $installer->addAttributeOption($aOption); $installer->endSetup();
$config = array('position' => 1, 'required' => 0, 'label' => 'Comprimento (cm)', 'type' => 'int', 'input' => 'text', 'apply_to' => 'simple,bundle,grouped,configurable', 'note' => 'Comprimento da embalagem do produto (Para cálculo dos Correios)'); $setup->addAttribute('catalog_product', $codigo, $config); // Add volume to prduct attribute set $codigo = 'volume_altura'; $config = array('position' => 1, 'required' => 0, 'label' => 'Altura (cm)', 'type' => 'int', 'input' => 'text', 'apply_to' => 'simple,bundle,grouped,configurable', 'note' => 'Altura da embalagem do produto (Para cálculo dos Correios)'); $setup->addAttribute('catalog_product', $codigo, $config); // Add volume to prduct attribute set $codigo = 'volume_largura'; $config = array('position' => 1, 'required' => 0, 'label' => 'Largura (cm)', 'type' => 'int', 'input' => 'text', 'apply_to' => 'simple,bundle,grouped,configurable', 'note' => 'Largura da embalagem do produto (Para cálculo dos Correios)'); $setup->addAttribute('catalog_product', $codigo, $config); $codigo = 'postmethods'; $config = array('position' => 1, 'required' => 0, 'label' => 'Serviços de Entrega', 'type' => 'text', 'input' => 'multiselect', 'source' => 'pedroteixeira_correios/source_postMethods', 'backend' => 'eav/entity_attribute_backend_array', 'apply_to' => 'simple,bundle,grouped,configurable', 'note' => 'Selecione os serviços apropriados para o produto.'); $setup->addAttribute('catalog_product', $codigo, $config); $codigo = 'fit_size'; $config = array('position' => 1, 'required' => 0, 'label' => 'Diferença do Encaixe (cm)', 'type' => 'varchar', 'input' => 'text', 'apply_to' => 'simple,bundle,grouped,configurable', 'note' => 'Exemplo: Se 1 item mede 10cm de altura, e 2 itens encaixados medem 11cm. A diferença é de 1cm.'); $setup->addAttribute('catalog_product', $codigo, $config); $codigo = 'posting_days'; $config = array('position' => 1, 'required' => 0, 'label' => 'Prazo de Postagem', 'type' => 'int', 'input' => 'text', 'apply_to' => 'simple,bundle,grouped,configurable', 'note' => 'O prazo total é o Prazo dos Correios acrescido do maior Prazo de Postagem dos produtos no carrinho.'); $setup->addAttribute('catalog_product', $codigo, $config); // Add Correios Tab $setIds = $setup->getAllAttributeSetIds('catalog_product'); $attributes = array('volume_comprimento', 'volume_altura', 'volume_largura', 'postmethods', 'fit_size', 'posting_days'); foreach ($setIds as $setId) { $setup->addAttributeGroup('catalog_product', $setId, 'Correios', 2); $groupId = $setup->getAttributeGroupId('catalog_product', $setId, 'Correios'); foreach ($attributes as $attribute) { $attributeId = $setup->getAttributeId('catalog_product', $attribute); $setup->addAttributeToGroup('catalog_product', $setId, $groupId, $attributeId); } } $installer->endSetup();
<?php $installer = $this; $setup = new Mage_Eav_Model_Entity_Setup('catalog_setup'); $installer->startSetup(); $weight = Mage::getModel('catalog/resource_eav_attribute')->load($setup->getAttributeId('catalog_product', 'weight')); $applyTo = explode(',', $weight->getData('apply_to')); $applyTo[] = 'giftvoucher'; $weight->addData(array('apply_to' => $applyTo))->save(); $installer->endSetup();
<?php error_reporting(E_ALL); require_once 'app/Mage.php'; umask(0); echo "<pre>"; /* not Mage::run(); */ Mage::app(); $installer = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); $row = 1; $fields = array(); if (($handle = fopen("perforationtype.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $fields[] = trim($data[1]); } fclose($handle); } print_r(array_unique($fields)); $color = array_values(array_unique($fields)); //print_r($color);exit; $iProductEntityTypeId = Mage::getModel('catalog/product')->getResource()->getTypeId(); $aOption = array(); $aOption['attribute_id'] = $installer->getAttributeId($iProductEntityTypeId, 'perforationtype'); for ($iCount = 0; $iCount < sizeof($color); $iCount++) { $aOption['value']['option' . $iCount][0] = $color[$iCount]; } $installer->addAttributeOption($aOption); $installer->endSetup();
<?php error_reporting(E_ALL); require_once 'app/Mage.php'; umask(0); echo "<pre>"; /* not Mage::run(); */ Mage::app(); $installer = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); $row = 1; $fields = array(); if (($handle = fopen("sizeofoneunit.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $fields[] = trim($data[1]); } fclose($handle); } print_r(array_unique($fields)); $color = array_values(array_unique($fields)); //print_r($color);exit; $iProductEntityTypeId = Mage::getModel('catalog/product')->getResource()->getTypeId(); $aOption = array(); $aOption['attribute_id'] = $installer->getAttributeId($iProductEntityTypeId, 'sizeofoneunit'); for ($iCount = 0; $iCount < sizeof($color); $iCount++) { $aOption['value']['option' . $iCount][0] = $color[$iCount]; } $installer->addAttributeOption($aOption); $installer->endSetup();
* * Do not edit or add to this file if you wish to upgrade this extension to newer * version in the future. * * @category Magestore * @package Magestore_Customercredit * @copyright Copyright (c) 2012 Magestore (http://www.magestore.com/) * @license http://www.magestore.com/license-agreement.html */ /** @var $installer Mage_Core_Model_Resource_Setup */ $installer = $this; $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); //add new attribute - Trung Ha $setup->addAttribute('catalog_product', 'credit_rate', $arrayName = array('group' => 'Prices', 'type' => 'decimal', 'input' => 'text', 'label' => 'Credit Rate', 'frontend_class' => 'validate-number', 'backend' => '', 'frontend' => '', 'source' => '', 'visible' => 1, 'user_defined' => 1, 'used_for_price_rules' => 1, 'position' => 2, 'unique' => 0, 'default' => '1.0', 'sort_order' => 102, 'note' => 'For e.g: 1.5')); $creditRate = Mage::getModel('catalog/resource_eav_attribute')->load($setup->getAttributeId('catalog_product', 'credit_rate')); $creditRate->addData(array('is_global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE, 'is_required' => 0, 'apply_to' => array('customercredit'), 'is_configurable' => 1, 'is_searchable' => 1, 'is_visible_in_advanced_search' => 1, 'is_comparable' => 0, 'is_filterable' => 0, 'is_filterable_in_search' => 1, 'is_used_for_promo_rules' => 1, 'is_html_allowed_on_front' => 0, 'is_visible_on_front' => 0, 'used_in_product_listing' => 1, 'used_for_sort_by' => 0, 'backend_type' => 'text'))->save(); $setup->addAttribute('catalog_product', 'credit_value', array('group' => 'Prices', 'type' => 'text', 'input' => 'text', 'frontend_class' => 'disabled', 'label' => 'Credit Value', 'apply_to' => array('customercredit'), 'backend' => '', 'frontend' => '', 'source' => '', 'visible' => 0, 'is_visible_on_front' => 0, 'required' => 0, 'user_defined' => 0, 'is_searchable' => 1, 'is_filterable' => 0, 'is_comparable' => 0, 'position' => 2, 'unique' => 0, 'is_global' => '')); $attribute = Mage::getSingleton('eav/config')->getAttribute('catalog_product', 'credit_value'); $attribute->save(); //end add new attribute - Trung Ha //Change label of credit amount - Marko $attributeId = Mage::getResourceModel('eav/entity_attribute')->getIdByCode('catalog_product', 'credit_amount'); if ($attributeId) { $attribute = Mage::getModel('catalog/resource_eav_attribute')->load($attributeId); $attribute->setFrontendLabel('Price')->save(); } //end change label - Marko //Alter table and add discount field for tables //sales_flat_order_item //sales_flat_invoice
<?php error_reporting(E_ALL); require_once 'app/Mage.php'; umask(0); echo "<pre>"; /* not Mage::run(); */ Mage::app(); $installer = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); $row = 1; $fields = array(); if (($handle = fopen("grade.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $fields[] = trim($data[1]); } fclose($handle); } print_r(array_unique($fields)); $color = array_values(array_unique($fields)); //print_r($color);exit; $iProductEntityTypeId = Mage::getModel('catalog/product')->getResource()->getTypeId(); $aOption = array(); $aOption['attribute_id'] = $installer->getAttributeId($iProductEntityTypeId, 'grade'); for ($iCount = 0; $iCount < sizeof($color); $iCount++) { $aOption['value']['option' . $iCount][0] = $color[$iCount]; } $installer->addAttributeOption($aOption); $installer->endSetup();
Mage::app()->setCurrentStore(Mage::getModel('core/store')->load(Mage_Core_Model_App::ADMIN_STORE_ID)); $installer = $this; $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); /** * Adding a lookup table for Divido */ $conn = $installer->getConnection(); $lookup_table = $conn->newTable($installer->getTable('callback/lookup')); $lookup_table->addColumn('lookup_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true), 'Id')->addColumn('salt', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255, array('nullable' => false), 'Salt')->addColumn('quote_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('nullable' => false, 'unsigned' => true), 'Quote ID'); $lookup_table->addIndex($installer->getIdxName('callback/lookup', array('quote_id'), Varien_Db_Adapter_Interface::INDEX_TYPE_UNIQUE), array('quote_id'), array('type' => Varien_Db_Adapter_Interface::INDEX_TYPE_UNIQUE)); $conn->createTable($lookup_table); /** * Adding Divido attributes to products */ $groupName = 'Divido'; $entityTypeId = $setup->getEntityTypeId('catalog_product'); $defaultAttrSetId = $setup->getDefaultAttributeSetId($entityTypeId); // adding attribute group $setup->addAttributeGroup($entityTypeId, $defaultAttrSetId, $groupName, 1000); $groupId = $setup->getAttributeGroupId($entityTypeId, $defaultAttrSetId, $groupName); // Add attributes $planOptionAttrCode = 'divido_plan_option'; $setup->addAttribute($entityTypeId, $planOptionAttrCode, array('label' => 'Available on finance', 'type' => 'varchar', 'input' => 'select', 'backend' => 'eav/entity_attribute_backend_array', 'frontend' => '', 'source' => 'pay/source_option', 'default' => 'default_plans', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, 'visible' => true, 'required' => true, 'user_defined' => true, 'searchable' => true, 'filterable' => false, 'comparable' => false, 'visible_on_front' => true, 'unique' => false)); $planOptionAttrId = $setup->getAttributeId($entityTypeId, $planOptionAttrCode); $setup->addAttributeToGroup($entityTypeId, $defaultAttrSetId, $groupId, $planOptionAttrId, null); $planSelectionAttrCode = 'divido_plan_selection'; $setup->addAttribute($entityTypeId, $planSelectionAttrCode, array('label' => 'Selected plans', 'type' => 'varchar', 'input' => 'multiselect', 'backend' => 'eav/entity_attribute_backend_array', 'frontend' => '', 'source' => 'pay/source_defaultprodplans', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, 'visible' => true, 'required' => false, 'user_defined' => true, 'searchable' => true, 'filterable' => false, 'comparable' => false, 'visible_on_front' => true, 'unique' => false)); $planSelectionAttrId = $setup->getAttributeId($entityTypeId, $planSelectionAttrCode); $setup->addAttributeToGroup($entityTypeId, $defaultAttrSetId, $groupId, $planSelectionAttrId, null); $installer->endSetup();
$installer->getConnection()->addColumn($installer->getTable('sales/order_item'), 'customercredit_hidden_tax', 'decimal(12,4) NULL'); //remove attribute //$setup->removeAttribute('catalog_product', 'credit_amount'); //$setup->removeAttribute('catalog_product', 'credit_value'); $setup->removeAttribute('catalog_product', 'storecredit_value'); $setup->removeAttribute('catalog_product', 'storecredit_from'); $setup->removeAttribute('catalog_product', 'storecredit_to'); $setup->removeAttribute('catalog_product', 'storecredit_dropdown'); $setup->removeAttribute('catalog_product', 'storecredit_type'); /* add Store Credit product attributes */ /** * add storecredit_value attribute */ $att_storecredit_value = array('group' => 'Prices', 'type' => 'decimal', 'input' => 'price', 'class' => 'validate-number', 'label' => 'Store Credit value', 'backend' => '', 'frontend' => '', 'source' => '', 'visible' => 1, 'user_defined' => 1, 'used_for_price_rules' => 1, 'position' => 4, 'unique' => 0, 'default' => '', 'sort_order' => 101); $setup->addAttribute('catalog_product', 'storecredit_value', $att_storecredit_value); $storecreditValue = Mage::getModel('catalog/resource_eav_attribute')->load($setup->getAttributeId('catalog_product', 'storecredit_value')); $storecreditValue->addData(array('is_global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE, 'is_required' => 1, 'apply_to' => array('customercredit'), 'is_configurable' => 1, 'is_searchable' => 0, 'is_visible_in_advanced_search' => 0, 'is_comparable' => 0, 'is_filterable' => 0, 'is_filterable_in_search' => 1, 'is_used_for_promo_rules' => 1, 'is_html_allowed_on_front' => 0, 'is_visible_on_front' => 0, 'used_in_product_listing' => 1, 'used_for_sort_by' => 0))->save(); //show description of Store Credit $attr = array('group' => 'Prices', 'type' => 'int', 'input' => 'boolean', 'label' => 'Show description of Store Credit value', 'backend' => '', 'frontend' => '', 'source' => '', 'visible' => 1, 'user_defined' => 1, 'used_for_price_rules' => 1, 'position' => 10, 'unique' => 0, 'default' => '', 'sort_order' => 101, 'is_global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE, 'is_required' => 0, 'apply_to' => array('customercredit'), 'is_configurable' => 1, 'is_searchable' => 0, 'is_visible_in_advanced_search' => 0, 'is_comparable' => 0, 'is_filterable' => 0, 'is_filterable_in_search' => 1, 'is_used_for_promo_rules' => 1, 'is_html_allowed_on_front' => 0, 'is_visible_on_front' => 0, 'used_in_product_listing' => 1, 'used_for_sort_by' => 0); /** * add store credit from, to attribute for Store Credit type range */ $attr['type'] = 'decimal'; $attr['input'] = 'price'; $attr['is_required'] = 1; $attr['label'] = 'Minimum Store Credit value'; $attr['position'] = 4; $attr['sort_order'] = 101; $attr['class'] = 'validate-number'; $setup->addAttribute('catalog_product', 'storecredit_from', $attr); $attribute = Mage::getModel('catalog/resource_eav_attribute')->load($setup->getAttributeId('catalog_product', 'storecredit_from'));
public function importAttributeInsideGroup($attribute_group_id, $attributeSetId, $attribute_code, $attribute_sort_order) { $mapobj = Mage::getModel('customimport/customimport'); $attributeGroupId = $mapobj->getAttributeGroupByExternalId($attribute_group_id, $attributeSetId); // $attribute_group_id is external group id if ($attributeGroupId) { $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $attribute_id = $setup->getAttributeId('catalog_product', $attribute_code); if (!$attribute_id) { $this->customHelper->reportError($this->customHelper->__("Attribute code %s is missing during attribute group %s import", $attribute_code, $attribute_group_id)); } else { $attribute_exists = $mapobj->isAttributeExistsInGroup($attribute_id, $attributeGroupId); if ($attribute_exists) { $mapobj->updateSequenceOfAttribute($attributeGroupId, $attribute_id, $attribute_sort_order, $attribute_code, $attribute_group_id); } else { $setup->addAttributeToGroup('catalog_product', $attributeSetId, $attributeGroupId, $attribute_id, $attribute_sort_order); } } } }
<?php require_once 'app/Mage.php'; Mage::app(); $installer = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('catalog_category'); $attributeSetId = $setup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $setup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $attribute = array('input' => 'select', 'type' => 'int', 'source' => 'eav/entity_attribute_source_boolean', 'label' => 'Integrar com AnyMarket', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, 'visible' => true, 'position' => 0, 'required' => true, 'user_defined' => true, 'default' => "", 'group' => "General Information"); $setup->addAttribute('catalog_category', 'categ_integra_anymarket', $attribute); $attributeId = $setup->getAttributeId($entityTypeId, 'categ_integra_anymarket'); $setup->run("\nINSERT IGNORE INTO `{$installer->getTable('catalog_category_entity_int')}`\n(`entity_type_id`, `attribute_id`, `entity_id`, `value`)\n SELECT '{$entityTypeId}', '{$attributeId}', `entity_id`, '1'\n FROM `{$installer->getTable('catalog_category_entity')}`;\n"); $installer->endSetup();