#StackBounty: #magento-1.9 If pre-order(Customized) products need to purchase, not allowed non-pre-order products include into the chec…

Bounty: 100

How can i set the condition, if pre-order(Customized) products purchase, not other products include into the checkout, how can i add the condition

How can I give condition like, if some of the non-pre-order products
in the cart not able to allow my pre-order products and another one if
my cart consists Pre-order products not allowed non-pre-orders
products? How can I do that?


Get this bounty!!!

#StackBounty: #magento-1.9 Update dropdown attribute value Programtically for single product

Bounty: 100

Onclick Add to cart button we are trying to update the Attribute value from “NO” to “YES”.

[ attribute code : cart_status (Yes/No dropdown) Attribute ]

I tried below code, its changing attribute values for all products, but i need to change value only for that particular product that i added to cart.

<?php

foreach ($collections as $key => $product) 
{
    echo $product->getName().' <br><br>';           
    $_product = Mage::getModel('catalog/product')->load($product->getId());             
?>

<form action="<?php 

echo  Mage::helper('checkout/cart')->getAddUrl($product);

// update cart_status

    echo "n".'updating '.$_product->getSku()."...n";
    $_product->setData('cart_status', 1)->getResource()->saveAttribute($_product, 'cart_status');
    $_product->save(); 

// update cart_status end

?>" method="post">  
</form>


Get this bounty!!!

#StackBounty: #magento-1.9 #catalog #pagination Pagination Not Showing on Category Pages – Magento 1

Bounty: 50

For some reason, Pagination is not showing on all of our category pages.

I’ve looked at other question on here and from what I’ve learned you need the page/html_pager block within catalog.xml for the category.

In this file we have a few instances of and they all have this page/html_pager block.

Any ideas why the pagination is not showing?


Get this bounty!!!

#StackBounty: #magento-1.9 #cms-pages Prevent CMS page availability on base URL

Bounty: 50

I have an issue in a Magento 1.9.2.2 store that I can’t quite figure out the solution for, so i was hoping for your assistance.
There are 2 different store views each serving a different language. Those views are accessible by ULRs as the following:

base URL: www.example.nl

dutch version: www.exampe.nl/nl/cmspage

english version: www.example.nl/en/cmspage

The goal is to make the cms pages accessible only by using the correct country tag in the URL, this is working for the English part of the site but not for the Dutch.

To clarify:

www.exampe.nl/nl/cmspage is also accessible through www.exampe.nl/cmspage, the idea is to simply return a not found when trying to acces the cms page through www.example.nl/cmspage.

Any advice or tips you could give me on the subject would be greatly appreciated.


Get this bounty!!!

#StackBounty: #magento-1.9 #php #csv #inventory #import-script Multiple Inventory slots for Different warehouses

Bounty: 50

I have found a great script that allows for quick inventory updating via a php script, and it does work well. I am able to just go by SKU, quantity, and set each as is_in_stock.

My question then becomes, we have two main warehouses, call them Main and West, would it be possibly to add a secondary inventory slot to each product, and via the same script with few adjustments, be able to upload two different values for each warehouse?

Implementation of the display would be simple enough as currently it is just:

<?php 
$qty = (int) Mage::getModel('cataloginventory/stock_item')->loadByProduct($_product)->getQty();
if ($qty<=0) { ?>

//Backordered

<?php } else { ?>    

//Echo Quantity
<?php echo $qty; } ?>

<?php endif; ?>

And adding another slot could turn into (what I assume) just $qty_secondary with similar loading format.


As a side note, I see the work it goes through with each product, is it as optimized as it could be? It was created back in 2010, and I imagine a lot of things have changed since then and it could be changed for the better I’m sure.


System: Magento 1.9.0.1 & PHP 5.6


Get this bounty!!!

#StackBounty: #magento-1.9 #extensions #email #third-party-module #adminnotification Magento 1.9.1 After change the order address from …

Bounty: 50

On Magento system, I have placed a 1 order for wholesale customer from the admin. The customer receives a mail of new order place. After placing the order I notice the shipping address which I have selected is wrong.

I edit the shipping address and check on all the 3 checkboxes (Recalculate, Notification[customize],confirm update) below the update button. I have written a note on Notification [customize] section also. After clicking on update the message display “Order update, not yet applied. Customer has been sent an email with a confirmation link. Updates will be applied after confirmation.

But the customer didn’t get any mail related to address change. We have used mandrill for sending a mail. I have checked is mandrill outbound but seems that the mail is not triggered from the Magento. Other than this mail all the mail is going to customer. Can anyone please tell me what is the problem? Why the address change/notification mail is not triggered from Magento ?


Get this bounty!!!

#StackBounty: #magento-1.9 #system.xml #system-configuration #default-values System Config Multiselect default all selected

Bounty: 50

I have a system config field of type multiselect which will be populated using the catalog/product_attribute_collection. This is a part of the system.xml that defines it.

  <attributes>
       <label>Choose Attributes to JSONize</label>
       <frontend_type>multiselect</frontend_type>
       <sort_order>3</sort_order>
       <show_in_default>1</show_in_default>
       <show_in_website>1</show_in_website>
       <show_in_store>1</show_in_store>

<source_model>package_module/system_config_attributes</source_model>
  </attributes>

Now I want all of the values in the multiselect to be selected by default. Since the default values for system config are defined in the config.xml, I’m not sure how to choose all as default.

This is the section of config.xml which is relevant to the question

<default>
    <mytab>
        <mysection>
            <attributes><!-- ***WHAT SHOULD I WRITE HERE*** --></attributes>
        </mysection>
    </mytab>
</default>


Get this bounty!!!

#StackBounty: #magento-1.9 Wrong sorting with "name" attribute

Bounty: 50

I have a problem regarding the sorting with the “name” attribute. When i sort by Name the table is changing but it’s not sorted by name.

In app/core/Mage/Catalog/Block/Product/List/Toolbar.php i made an output in the set collection method.

/**
 * Set collection to pager
 *
 * @param Varien_Data_Collection $collection
 * @return Mage_Catalog_Block_Product_List_Toolbar
 */
public function setCollection($collection)
{
    $this->_collection = $collection;

    $this->_collection->setCurPage($this->getCurrentPage());

    // we need to set pagination only if passed value integer and more that 0
    $limit = (int)$this->getLimit();
    if ($limit) {
        $this->_collection->setPageSize($limit);
    }
    if ($this->getCurrentOrder()) {
        $this->_collection->setOrder($this->getCurrentOrder(), $this->getCurrentDirection());
    }
    return $this;
}

The setOrder method is called with “name” as first parameter i’ve checked that. But when i output the query after that.

echo $this->_collection->getSelect();

i get the following output:

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '17' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0

i can’t see a sort by the name field.

/xxxx/xxx.html?dir=asc&order=name

That URL is called. But the output is not sorted by name it’s in a random order. The products are all “simple” products and the attribute is a “global” attribute because we have some shops that share the name.

I’ve read a lot but can’t find a solution. Perhaps someone an help me to find the correct file and line or know that problem.

Edit:

Some more informations:

$this->_productCollection->addAttributeToSort("name");
echo $this->_productCollection->getSelect();

If i do that some really wired is extended to my query:

AND stock_qty.website_id=1 ORDER BY `salable` DESC, `qty` DESC

So why is “salable” added if i try to sort by name?


Get this bounty!!!