How to display products randomly on promotion block.

[hurray]

Hi,

I am using prestashop 1.5.6.2. On my promotion block that appears on the right-hand side of the webiste, right now there are 3 products that get displayed. These products do not change at all, no matter how many times I refresh my browser. On top of that, 2 of the products on the block at the most expensive products that are on promotion. I do not want them to show there.

How can I randomize the products that show in this block?

[NemoPS]

What's the exact name of the "promotion block"?

[hurray]

It is called "Bloc promotions" developed by prestashop. It is a french website.

[NemoPS]

I wonder if it's blockspecials. Can you check if it reads 'blockspecials' somewhere in the url, when you access the configuration page? 

[hurray]

Hi Nemo1,

Sorry I was wrong. It is actually called "Multiple Specials block".

[NemoPS]

Hmmm there is no such block by default, so it's hard to guide you. Did you buy it? Or is it a free module?

[hurray]

It is a default module. It must be blockspecials.

[NemoPS]

Ah, I see. THat module displays one product only in the column, by default. Did you alter it? It should display a random special by default, as you said

[hurray]

Hi Nemo, please look at the right-hand side on my homepage http://www.savdana.com/. The block that is all the way at the bottom is called "Promotions" and it displays 3 products and sorts them "High-to-Low" according to the price. I would like them to sort eithr "Low-to-High" pricewise or randomly. Whichever can be done easily will be fine with me.

May be this makes it clearer to you now.

[NemoPS]

It does look like blockspecials, but it should really display only 1 product by default. Check blockspecials,php, see what it does for hookDisplayRightColumn

[hurray]

Hi Nemo,

Finally I figured out the name of this block. It is "Multiple Specials block". ON the back-end the number of product to display is set to 3.

Now here is what I have in blockmultiplespecials.php for hookRightColumn

 

public function hookRightColumn($params)
    {
        $nbr=Configuration::get('BLOCKSPECIALS_NBR');

            $products = Product::getPricesDrop($this->context->language->id, 0, $nbr, false);

            $this->smarty->assign(array(
                'products' => $products,
                'add_prod_display' => Configuration::get('PS_ATTRIBUTE_CATEGORY_DISPLAY'),
                'homeSize' => Image::getSize(ImageType::getFormatedName('home')),
            ));
        
        return $this->display(__FILE__, 'blockmultiplespecials.tpl');
    }

[NemoPS]

You can add a further parameter for the order by
 

public static function getPricesDrop($id_lang, $page_number = 0, $nb_products = 10, $count = false,

$order_by = null, $order_way = null, $beginning = false, $ending = false, Context $context = null)

I guess you want to set that to price? Then add 'asc' as next parameter as well

[hurray]

Hi Nemo,

Where do I put your code and where do I add the paramete "asc"?

I am not good at coding.

Thanks in advance.

[hurray]

Hi Nemo,

Do you mind helping? Please.

[NemoPS]

The one you linked earlier, just add parameters till you reach the "order way", should be the sixth

[hurray]

Oh yeah, that helps a lot  

 

It was easier asking for help for some questions during exams from some of my professors than it is from you

I already told you, I suck at coding.

[hakeryk2]

Well, I tried a lot of times to get it working with random way but I gave up.

 

My solution is to show the products in date update DESC to show last edited promotions.

 

My  working code is 

getPricesDrop((int)$params['cookie']->id_lang, 0, Configuration::get('BLOCKSPECIALS_SPECIALS_NBR'), 0, 'date_upd', 'DESC');

but I tried with

getPricesDrop((int)$params['cookie']->id_lang, 0, Configuration::get('BLOCKSPECIALS_SPECIALS_NBR'), 0, 'name', 'RAND');

or

getPricesDrop((int)$params['cookie']->id_lang, 0, Configuration::get('BLOCKSPECIALS_SPECIALS_NBR'), 0, 'name', 'RAND()');

but none of these worked - any help to get this random?

[NemoPS]

Rand must be order by, not way

getPricesDrop((int)$params['cookie']->id_lang, 0, Configuration::get('BLOCKSPECIALS_SPECIALS_NBR'), 0,'RAND()');

[hakeryk2]

Well, none of theese working either:

getPricesDrop((int)$params['cookie']->id_lang, 0, Configuration::get('BLOCKSPECIALS_SPECIALS_NBR'), 0, 'RAND()');

is giving lot of print_r arrays/objects on page

getPricesDrop((int)$params['cookie']->id_lang, 0, Configuration::get('BLOCKSPECIALS_SPECIALS_NBR'), 0, 'RAND');

is giving SQL error Unknown column 'RAND' in 'order clause' and the end of query looks like this

ORDER BY RAND DESC

LIMIT 0, 12

 

I just trully don't know the reason :/