Search the Community

Hello Prestas, we extended the specific price rules functionality with an option "show_discount_front". Now on the sales-page I want to show items only with "show_discount_front = 1". Inside the SpecificPrice.php I'm trying to update the function getProductIdByDate, which get's called by "Product::getPricesDrop": $results = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(' SELECT sp.`id_product`, sp.`id_product_attribute`, spr.`id_specific_price_rule` FROM `' . _DB_PREFIX_ . 'specific_price` AS sp INNER JOIN `' . _DB_PREFIX_ . 'specific_price_rule` AS spr ON (sp.id_specific_price_rule=spr.id_specific_price_rule) WHERE sp.id_shop ' . self::formatIntInQuery(0, $id_shop) . ' AND sp.id_currency ' . self::formatIntInQuery(0, $id_currency) . ' AND sp.id_country ' . self::formatIntInQuery(0, $id_country) . ' AND sp.id_group ' . self::formatIntInQuery(0, $id_group) . ' AND sp.from_quantity = 1 AND spr.show_discount_front = 1 AND sp.reduction > 0 ' . $query_extra); If I var_dump the $results, I just get an "false". Anyone an idea what I'm doing wrong? Thanks in advance for every suggestion! Cheers, Sebastian

How do you change the Price Drop module? I want to change the words "Price Drop" where they appear in the breadcrumb trail and in the <h1> on the page to "Special Offers" I assume I must edit a .tpl somewhere but which one?

hi, i offer free shipping for order more than a tot amount, i need that products on sale do not affect total amount. Is there any way to do it or any module that can manege it?

In my site https://inmob.it ver. 1.7.3.1 I have a problem with the block link in the footer, if I click "Price drop" does not show any product. I have some products on offer, for example: https://inmob.it/gtx-1080/1354-asus-geforce-gtx1080-turbo-8g-gddr5x-usata-90yv09s0-m0na00-4712900426663.html How does this link work? Can i configure it? Thanks.

I want to change the name and description of the price drop page to for better SEO. Where can I find these settings or how can I change it? Thank you a lot!

Hi, As we know, special module will display all the price dropped products. Now, My clients wants to display only one category products in the special module. I have copy pasted the special module and tried to change the below code. file : blockspecials.php from: BlockSpecial::$cache_special = Product::getPricesDrop((int)$params['cookie']->id_lang, 0, Configuration::get('BLOCKSPECIAL_SPECIAL_NBR')); To: BlockSpecial::$cache_special = $category->getProducts((int)$params['cookie']->id_lang, 1, Configuration::get('BLOCKSPECIAL_SPECIAL_NBR')); But it is not working. Page is blank. Can anyone please help me on this ? It is little bit urgent. Client wants to go live in next month starting. Thanks in Advance. Mani

hi! Please help me to solve this bug. i have 2 languages and 2 currencies on shop. And have a bug if i go to other currency different of USD. It will display a price 0 but only on product pages with price drop

After reading this post... I need help ! http://www.prestashop.com/forums/topic/169148-solved-what-is-the-name-of-the-module-for-price-drop/ Well... it just dont work ! (At least for me actually !) http://www.spikedwri...ather-mask.html Should have been displayed also at price drop page: http://www.spikedwri.../os/prices-drop Anyone have found a solution ?... and could explain it !!!!! lol NOTE: Using 1.5.3.1

I am importing XML data and adding products directly into database with php code. It works fine, i can edit the product successfully. Checkout also working fine. I am also manually adding records to specific_price table. I can view it in Specific Prices section when i edit the product. But ALL OF THE ITEMS does not appear in the Price Drop page (the page is empty) When i add new SPECIFIC PRICE from back office to any product, everything starts working fine. All products are started displaying in Price Drop. I believe i am missing some function call or a table which activates price drop or something similar. Any help is appreciated. PS version 1.6.09

Hi. I would like to know if there is any way to display in front end how long a special offer/ price drop product will be available. For the moment I can set up easealy how long a reduced price will be available, but It would be usefull if the customer could also see when the offer finishes/ how long the offer is available. Thanks! Luis

Bonjour, je veux créer un webservice qui retourne la liste des promotion d'une boutique. comment faire ? Merci d'avance

Hi everyone! I set many discounts in several product's category. To do this, I went in the BO, then I click to Costumers>Groups and then in the Group's setting. I apply several discount's values in the "current category discount" section! Well done, the prices displayed are correct, but I don't see any product in the PRICE DROP section! How can I do to fix it?!! Can someone help me?!?! Thank you all !! Matteo Ps: is there a module that display product in PRICE DROP, filtering by discount's value?!!

Hi, I have an item for sale but it does not show under Price Drop (I renamed it to Monthly Specials). I appreciate any help. http://www. mama berlin.ie/prices-drop.php You should see the following on sale: http://www. mama berlin.ie/product.php?id_product=69 Thank you. Anna

Hi, i want to change products position in price drop? How can i do that? Please help me. thanks

Hi, i want to change products position in price drop? How can i do that? Please help me. thanks