Category Archives: Magento

Magento 2 Remove version signing static files

Monday, 09 November 2020 13:23

Tim Ramsey

0 Comments

INSERT INTO core_config_data (scope, scope_id, path, value) VALUES ('default', 0, 'dev/static/sign', '0');

1	INSERT INTO core_config_data (scope, scope_id, path, value) VALUES ('default', 0, 'dev/static/sign', '0');

M2E additional columns in grid

Wednesday, 29 May 2019 17:20

Tim Ramsey

0 Comments

app/code/community/Ess/M2ePro/Block/Adminhtml/Ebay/Listing/View/Ebay/Grid
app/code/community/Ess/M2ePro/Block/Adminhtml/Ebay/Listing/Product
protected function _prepareCollection(){
	$collection->addAttributeToSelect('asset_type');
}

protected function _prepareColumns(){
	$attribute = Mage::getModel('eav/config')->getAttribute('catalog_product', 'asset_type');
	$options = array();
	foreach( $attribute->getSource()->getAllOptions(false, true) as $option ) {
		$options[$option['value']] = $option['label'];
	}
	$this->addColumn('asset_type',array(
		'header'=> Mage::helper('M2ePro')->__('Dept.'),
		'width' => '150px',
		'index' => 'asset_type',
		'type'  => 'options',
		'options' => $options,
		'sortable' => false,
	));

	$sets = Mage::getResourceModel('eav/entity_attribute_set_collection')
				->setEntityTypeFilter(Mage::getModel('catalog/product')->getResource()->getTypeId())
				->load()
				->toOptionHash();
	$this->addColumn('set_name',
		array(
			'header'=> Mage::helper('M2ePro')->__('Attrib. Set Name'),
			'width' => '100px',
			'index' => 'attribute_set_id',
			'type'  => 'options',
			'options' => $sets,
			'sortable' => false,
	), 'name'); 
}

app/code/community/Ess/M2ePro/Block/Adminhtml/Ebay/Listing/View/Ebay/Grid

app/code/community/Ess/M2ePro/Block/Adminhtml/Ebay/Listing/Product

protected function _prepareCollection(){

$collection->addAttributeToSelect('asset_type');

}

protected function _prepareColumns(){

$attribute = Mage::getModel('eav/config')->getAttribute('catalog_product', 'asset_type');

$options = array();

foreach( $attribute->getSource()->getAllOptions(false, true) as $option ) {

$options[$option['value']] = $option['label'];

}

$this->addColumn('asset_type',array(

'header'=> Mage::helper('M2ePro')->__('Dept.'),

'width' => '150px',

'index' => 'asset_type',

'type' => 'options',

'options' => $options,

'sortable' => false,

));

$sets = Mage::getResourceModel('eav/entity_attribute_set_collection')

->setEntityTypeFilter(Mage::getModel('catalog/product')->getResource()->getTypeId())

->load()

->toOptionHash();

$this->addColumn('set_name',

array(

'header'=> Mage::helper('M2ePro')->__('Attrib. Set Name'),

'width' => '100px',

'index' => 'attribute_set_id',

'type' => 'options',

'options' => $sets,

'sortable' => false,

), 'name');

}

Get around M2E “The only common (presented in all Attribute sets) “Text Field” or “Dropdown” Attributes available for selection.”

Thursday, 30 March 2017 14:14

Tim Ramsey

0 Comments

Change function around line 170 in app\code\community\Ess\M2ePro\Helper\Magento\Attribute.php from:

private function _getGeneralFromAttributeSets(array $attributeSetIds)
    {
        if (count($attributeSetIds) > 50) {
            throw new Ess_M2ePro_Model_Exception("Attribute sets must be less then 50");
        }

        $attributeCollection = Mage::getResourceModel('catalog/product_attribute_collection')
            ->addVisibleFilter()
            ->setInAllAttributeSetsFilter($attributeSetIds)
            ->setOrder('frontend_label', Varien_Data_Collection_Db::SORT_ORDER_ASC);

        return $attributeCollection->getAllIds();
    }

private function _getGeneralFromAttributeSets(array $attributeSetIds)

{

if (count($attributeSetIds) > 50) {

throw new Ess_M2ePro_Model_Exception("Attribute sets must be less then 50");

}

$attributeCollection = Mage::getResourceModel('catalog/product_attribute_collection')

->addVisibleFilter()

->setInAllAttributeSetsFilter($attributeSetIds)

->setOrder('frontend_label', Varien_Data_Collection_Db::SORT_ORDER_ASC);

return $attributeCollection->getAllIds();

}

to:

private function _getGeneralFromAttributeSets(array $attributeSetIds)
    {
        if (count($attributeSetIds) > 500) {
            throw new Ess_M2ePro_Model_Exception("Attribute sets must be less then 500");
        }

        $attributeCollection = Mage::getResourceModel('catalog/product_attribute_collection')
            ->addVisibleFilter()
            ->setOrder('frontend_label', Varien_Data_Collection_Db::SORT_ORDER_ASC);

        return $attributeCollection->getAllIds();
    }

private function _getGeneralFromAttributeSets(array $attributeSetIds)

{

if (count($attributeSetIds) > 500) {

throw new Ess_M2ePro_Model_Exception("Attribute sets must be less then 500");

}

$attributeCollection = Mage::getResourceModel('catalog/product_attribute_collection')

->addVisibleFilter()

->setOrder('frontend_label', Varien_Data_Collection_Db::SORT_ORDER_ASC);

return $attributeCollection->getAllIds();

}

How to duplicate | copy a Magento Database with SSH

Tuesday, 30 December 2014 22:41

Tim Ramsey

0 Comments

I was a bit hopeful with phpMyAdmin “Synchronize”, but Magento’s databases are apparently too big for it because I ended up with white screens and partial uploads. I resorted to using SSH and doing it over command line. Two lines of code and you can export from your live database and import into a production database. Here you go. Export

mysqldump -u username -p database_name > dump.sql

1	mysqldump -u username -p database_name > dump.sql

Import

mysql -u username -p target_database_name < dump.sql

1	mysql -u username -p target_database_name < dump.sql

Hopefully saved you some time and frustration 🙂

Magento + Get Backend Variables = getStoreConfig

Saturday, 26 October 2013 22:41

Tim Ramsey

0 Comments

Well I had finished a custom PayPal payout module for a client in my test environment, and had to incorporate it into the Magento interface. After research, I found the code to grab the information I needed was

Mage::getStoreConfig('sectionName/groupName/fieldName');

I thought the next logical step for me was to go into the XML file in the CORE PayPal model to find the ‘sectionName/groupName/fieldName’ hierarchy in the config file. After being frustrated with how nested the config file was, I turned to the database core_config_data, which quickly gave me the information I was looking for.

Now I can use getStoreConfig to extract the data

$sandbox = Mage::getStoreConfig('paypal/wpp/sandbox_flag');
$usernameUn = Mage::getStoreConfig('paypal/wpp/api_username');
$passwordUn = Mage::getStoreConfig('paypal/wpp/api_password');
$sigUn = Mage::getStoreConfig('paypal/wpp/api_signature');
$environment = ($sandbox == 0 ? 'live' : 'sandbox');

$sandbox = Mage::getStoreConfig('paypal/wpp/sandbox_flag');

$usernameUn = Mage::getStoreConfig('paypal/wpp/api_username');

$passwordUn = Mage::getStoreConfig('paypal/wpp/api_password');

$sigUn = Mage::getStoreConfig('paypal/wpp/api_signature');

$environment = ($sandbox == 0 ? 'live' : 'sandbox');

Category Archives: Magento

Magento 2 Remove version signing static files

M2E additional columns in grid

Get around M2E “The only common (presented in all Attribute sets) “Text Field” or “Dropdown” Attributes available for selection.”

How to duplicate | copy a Magento Database with SSH

Magento + Get Backend Variables = getStoreConfig

Categories

Recent Posts