Search the Community
Showing results for tags 'prices-drop'.
-
Hi everyone! Unless I have missed it, I don't think that my problem has been raised in previous post, so I hope someone will be able to help me or direct me to the right place. 😊 I am currently setting up a shop with Prestashop version 8 where I want to show in the Special block and Prices Drop page only products with the 'on_sale' flag. To do so, I've been following this topic that is quite simple: create an override of Product.php and in the functions getRandomSpecial() and getPricesDrop() add to SQL WHERE conditions 'p.`on_sale`= 1 AND '. I tried to put this at the beginning of the WHERE condition, with and without brackets surrounding the rest of the condition, I tried to put it at the end of the condition and I also did so directly in the main Product.php disabling the override one. Before every attempt I cleared the cache through the BO or by erasing directories in /var/cache/. Whichever way I tried, the Prices Drop page still has every products with a specific price, even those that are not labeled as 'on_sale'... It is as if other getRandomSpecial() and getPricesDrop() functions exist somewhere else and has the priority over my modified queries... Can someone help me understand what is happening? NB: In the case of Prices Drop page, I went down the rabbit hole of looking into controllers/front/listing/PricesDropController.php then Adapter\PricesDrop\PricesDropProductSearchProvider.php to see where getPricesDrop() is called and it is definitely called through Product class.
- 2 replies
-
- special prices
- getrandomspecial
- (and 5 more)
-
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
- 1 reply
-
- price drop
- prices-drop
-
(and 1 more)
Tagged with:
-
Ciao a tutti voi del forum! Ho un problemino che vorrei risolvere: come posso inserire un blocco di ricerca per categorie, aspetti o entrambi nella pagina 'offerte speciali' (prices-drop)? Nel modulo esiste solo la possibilità di impostare il numero di prodotti da visualizzare in home.. sono un autodidatta naturalmente helpppp please!!!
-
- blocco categorie
- prices-drop
-
(and 1 more)
Tagged with:
-
Bonjour, Je souhaiterais avoir des informations avec la page "prices-drop" de Prestashop. Cette page remonte automatiquement les produits en promotion. Celle-ci est native à Prestashop. Le souci c'est que cette page ne remonte pas les produits ayant une promotion appliquée via l'onglet "Catalogue > Promotions > Règles de prix catalogue". Pour moi cette page devrait remonter ces produits. Pensez-vous que cela est un bug? Sinon, avez-vous une solution pour avoir une page remontant réellement tous les produits en promotion ? Je vous remercie par avance. PS 1.7.4.3
- 1 reply
-
- prices-drop
- promotion
-
(and 1 more)
Tagged with:
-
Witajcie, przesiadłem się jakiś czas temu na PS 1.7 i w zleceniu które teraz realizuje potrzebuje utworzyć stronę, która będzie prezentowała tylko produkty, z oznaczeniem on_sale = 1, nadpisałem sobie w override Product.php i utworzyłem własną metodę, wszystko jest ok, problem pojawia się kiedy stworzyłem sobie nowy controller dajmy na to NowyController.php. Mam w nim ustawione initContent() na końcu public function initContent() { parent::initContent(); $products_for_template = Product::getProductOnSale((int)$this->context->language->id, 0, 0); $this->context->smarty->assign(array( 'products' => $products_for_template, 'homeSize' => Image::getSize('home_default') )); $this->setTemplate('catalog/listing/outlet'); } Utworzyłem również plik outlet.tpl i de facto wszystko działa, jednak jeżeli zrobię w nim podobnie jak w pliku prices-drop.tpl {extends file='catalog/listing/product-list.tpl'} To w treści strony pojawia mi się formularz wyszukiwania. Obstawiam, że problem jest to co przekazuje do TPL.. Pytanie, co i w jaki sposób powinienem przekazywać. W pierwszym listingu zmienna $products_for_template przy wylistowaniu przechowuje prawidłowe produkty. Jakaś pomoc/podpowiedź? Zapis $this->context->smarty->assign(array( 'products' => $products_for_template, 'homeSize' => Image::getSize('home_default') )); Umieściłem testując różne możliwości i może on być niepoprawny. Oczywiście strona w Preferencje -> Ruch -> Strony utworzona.
-
- prices-drop
- own tpl file
-
(and 1 more)
Tagged with:
-
Hola amigos, este es mi primer Post, pero creo que es muy interesante y de gran Ayuda para muchísima gente si algún genio soluciona este tema. Llevo muchas horas dando vueltas y no encuentro nada. El tema es que necesitaría poder categorizar o filtrar los artículos mostrados de las páginas tanto de artículos con descuento (prices-drop) como las Novedades (new-products). Y de cómo gestionar esto en el BackOffice. No sé si me explico.. vamos que de cara al cliente que accede a comprar nuestros productos, sería ideal que tuviera la opción de poder filtrar su búsqueda por categorías. Si tienes muchos productos nuevos o tienes muchas ofertas es engorroso y complicado ver tanto producto de golpe sin poder filtrarlos. Conozco la navegación por facetas, es una pasada, la aplico a categorías y funciona bien, pero no sé si se puede aplicar a estas páginas de resultados que indico. En concreto estoy trabajando sobre la versión 1.5.6.2. Muchísimas gracias por adelantado y brindo por este Forum, la Comunidad y a título particular a toda la gente que colabora en ayudar sin ánimo de lucro cada vez que tenemos un problema.
- 4 replies
-
- prices-drop
- new-products
-
(and 2 more)
Tagged with:
-
Hello, can please someone help me how to make in prices drop module shows only products where reduction is more then 10%? Thanks!
- 4 replies
-
- prices-drop
- reduction
-
(and 1 more)
Tagged with:
-
Hi, Has someone tried following: 1) Go to the BO -> Preferences -> SEO & URLs -> edit e.g. Prices-drop page 2) Select from the dropdown menu the one without "-" (prices-drop => pricesdrop) -> Save 3) Go to the FO and to the prices-drop page Has the friendly url gone haywire? Meaning it now states index.php?controller=prices-drop and not the nice "friendly url" as it should state e.g. /discountproducts? Is the link to the second page working anymore? No it's not. So what happened to me is that I've translated some of these pages and then noticed this issue, now my customers cannot go to the discount page 2 or further nor see the "new products" beyond page 1. There's a way to see the second page by manually putting in the url without one "&" e.g. www.domain.com/index.php?controller=prices-drop?p=2 works fine but if you would use the link proposed by Prestashop in the "next page" link (www.domain.com/index.php?controller=prices-drop?&p=2) it doesn't work. I've created issue (http://forge.prestas...owse/PSCFV-6411) for this, but would like to know if you guys who have some test shops running if this happens to you as well. Here's a link to (Finnish) live store to see the issue in practice if you're interested of: http://www.sisustusi...i/verkkokauppa/ You can go to the discount products (prices-drop) from the footer "erikoistarjoukset"
- 5 replies
-
- 1
-
-
- 1.5.3
- friendly URL
-
(and 2 more)
Tagged with: