Leaderboard

Hello, I wanted to share a free module that I developed for PrestaShop and that can be useful for many merchants. 👉 JPresta Doctor The module lets you run a complete diagnosis of your PrestaShop store in just a few clicks. It runs more than 500 automatic checks to detect the most common issues: orphan data in the database inconsistencies after installing or uninstalling modules issues that may impact performance or stability unused images etc. The goal is simple. quickly know whether your store is healthy, without having to dig everywhere. 📥 Download the latest version and get more information: https://jpresta.com/en/prestashop-doctor-diagnostic-repair-clean-optimize If you have any questions or feedback, I will be happy to discuss. Have a nice day, Jérôme jprestadoctor-1.1.1-jprestadoctor.zip

Lot of SQL queries in PS are not optimized for huge data (history or lot of orders per day). Specially join queries with pagination are very poor. Let me give you a sample: This query takes several minutes if you have more than 100.000 orders, even on a dedicated database server 😞 SELECT o.`id_order`, o.`reference`, o.`total_paid_tax_incl` AS total_paid, ... FROM `ps_orders` o LEFT JOIN `ps_customer` c ON o.`id_customer` = c.`id_customer` LEFT JOIN `ps_address` a ON o.`id_address_invoice` = a.`id_address` LEFT JOIN `ps_order_state_lang` b ON b.`id_order_state` = o.`current_state` AND b.`id_lang` = 1 LEFT JOIN `ps_country` co ON co.`id_country` = a.`id_country` LEFT JOIN `ps_state` s ON s.`id_state` = a.`id_state` LEFT JOIN `ps_order_cart_rule` ocr ON ocr.`id_order` = o.`id_order` LEFT JOIN `ps_cart_rule_lang` cr_lang ON ocr.`id_cart_rule` = cr_lang.`id_cart_rule` AND cr_lang.`id_lang` = 1 LEFT JOIN `ps_order_detail` od ON od.`id_order` = o.`id_order` LEFT JOIN `ps_order_slip_detail` osd ON (od.`id_order_detail` = osd.`id_order_detail`) LEFT JOIN `ps_product` p ON p.`id_product` = od.`product_id` LEFT JOIN `ps_product_lang` p_lang ON p.`id_product` = p_lang.`id_product` AND p_lang.`id_lang` = 1 AND p_lang.`id_shop` = 1 WHERE o.`id_shop` = 1 AND o.`current_state` != 0 GROUP BY o.`id_order` LIMIT 0, 250 optimized query < 8 seconds should be something like: SELECT o.`id_order`, o.`reference`, o.`total_paid_tax_incl` AS total_paid, ... FROM ( SELECT `id_order` FROM `ps_orders` WHERE `id_shop` = 1 AND `current_state` != 0 ORDER BY `id_order` DESC LIMIT 250 OFFSET 0 ) AS filtered_orders JOIN `ps_orders` o ON filtered_orders.`id_order` = o.`id_order` LEFT JOIN `ps_customer` c ON o.`id_customer` = c.`id_customer` LEFT JOIN `ps_address` a ON o.`id_address_invoice` = a.`id_address` LEFT JOIN `ps_order_state_lang` osl ON osl.`id_order_state` = o.`current_state` AND osl.`id_lang` = 1 LEFT JOIN `ps_country` co ON co.`id_country` = a.`id_country` LEFT JOIN `ps_state` s ON s.`id_state` = a.`id_state` LEFT JOIN ( SELECT ocr.`id_order`, GROUP_CONCAT(DISTINCT cr_lang.`name` SEPARATOR ', ') AS distinct_coupons FROM `ps_order_cart_rule` ocr LEFT JOIN `ps_cart_rule_lang` cr_lang ON ocr.`id_cart_rule` = cr_lang.`id_cart_rule` AND cr_lang.`id_lang` = 1 GROUP BY ocr.`id_order` ) coupon_data ON coupon_data.`id_order` = o.`id_order` LEFT JOIN ( SELECT od.`id_order`, SUM(osd.`amount_tax_incl`) as refunded FROM `ps_order_detail` od LEFT JOIN `ps_order_slip_detail` osd ON od.`id_order_detail` = osd.`id_order_detail` GROUP BY od.`id_order` ) refund_sums ON refund_sums.`id_order` = o.`id_order` LEFT JOIN ( SELECT od.`id_order`, GROUP_CONCAT( CONCAT( '{"id_product":"', od.`product_id`, '","id_variant":"', od.`product_attribute_id`, '","name":"', REPLACE(COALESCE(pl.`name`, ''), '"', '\\"'), '","price":"', od.`product_price`, '","quantity":"', od.`product_quantity`, '"}' ) SEPARATOR ',' ) AS products_json FROM `ps_order_detail` od LEFT JOIN `ps_product_lang` pl ON od.`product_id` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.`id_shop` = 1 GROUP BY od.`id_order` ) product_data ON product_data.`id_order` = o.`id_order` ORDER BY o.`id_order` DESC;

Since long time ago, I has been developing ecommerces in prestashop (and other platforms) and something needs to be said: Paid themes and modules are getting low quality, higher price everyday. Its totatly normal latelly to have Paid themes that doesnt work properly, or have modules on it from 4 years ago with security bugs (but theme has been updated on last days...) . Multiple modules that by default doesnt work in prestashop 8.1 (but they are announced as they should work). Themes installed that throws deprecated php instances over php 8.1 (to be honest, prestashop should upgrade to 8.2-8.3 before the EOL) Themes inheriting from posthemes that are copycats between them: same demos, same files, diferent names. Suport that only ask for ftp and login/password to access instean ask for information (its not only a bad practice. With the poor quality of their product after paying 60-70-80€ for them and crash, they ask you to have full access to your development shop to "solve" the problem. Prestashop members and prestashop community should say "stop" . Its totatlly normal the trustness of this platform is getting lower and lower: On last 2 weeks, we started 3 projects on prestashop and none of the modules installed worked as intended, and all of them in one or other way launches errors in screen or logs..... I know this message will be filtered, but at least the prestashop moderators should think about whats happening and why people are trusting in worst platforms only because the theme creators are pure greed people with a fake/scam products. (not all of them, but a lot of them for sure) S!

We tried to modify order, as client noticed that he does not want company name on invoice. After company removed, delivery costs were removed too from the order. I wonder why this stupid rule were created by developer and how to remove it from prestashop.

Instead of Captcha try Coludflare Turnstile. It appears to be more effective in blocking spam. A free module is available on GitHub.

Hello, I completely agree with you. I bought two themes this year and received "Deprecated" alerts for both, yet no comments mention any issues. The first theme was compatible with 8.2.x and the second with 9.0.x. The themes were recently updated, but these developers do nothing unless it's a critical error. It's high time PrestaShop cleaned up all these developers who publish such poor-quality themes, bordering on fraud.

Sí, va a entrar en vigor sí, ya somos de los pocos países de europa que no tienen algo similar, y muchos del este de europa funcionan así desde hace años. El tema está en que los políticos lo tenían muy fácil... solo tenían que hacer un comunicado y decir "ok, NO vamos a sancionar durante X meses", y listo (cosa que ya se venía comentando desde hacía meses). Pero NO, tenían que elegir la peor opción de todas: la que les permitía salir en rueda de prensa a colgarse una medallita, y así penalizan a todos los que intentan hacer las cosas bien y premian a los de la dejadez y los de "dejarlo todo para el último momento y aquí no pasa nunca nada"... Millones de euros perdidos en publicidad inútil, miles y miles de horas de desarrollo apresurado y de horas sin dormir de todo el colectivo de desarrolladores de este país, millones de euros de adaptación de dispositivos de hardware de los fabricantes de cajas registradoras, básculas.... Hay pequeñas tiendas que se han gastado un dineral inmenso para cambiar todo su hardware, y empresas que han tirado a la basura sistemas informáticos personalizados al dedillo durante décadas porque era imposible adaptarlos a tiempo. Pero sobre todo: Os aseguro que hay una enorme cantidad de negocios que directamente HAN CERRADO, gente a la que les quedaban pocos años para jubilarse y han visto imposible asumir (y pagar) tanto cambio y ya decidieron no continuar, e incluso mucho autónomo, mucho más joven, que se ha visto superado por la situación y ha bajado la persiana para siempre. A todos estos ¿qué les decimos? La base para que un país funcione económicamente es dar seguridad jurídica a quienes quieran hacer negocios en él, y en eso sí somos los líderes de europa: en tener una inseguridad jurídica al nivel de la peor de las repúblicas bananeras del mundo. En lo que a nuestro sistema se refiere, a seguir mejorando hasta 2027, y periodo de pruebas gratuito prolongado hasta finales de 2026.. y a los clientes que ya han confiado en nosotros les hemos informado por email de cómo vamos a actuar y al 99% les ha parecido bien.

ok, it works👍... Thanks again for the help

Hello, Ok, this makes more sense now. In your ps_facetedsearch module's configuration, in the template used, you are most likely having Search (experimental) checked in the Pages using this template: section. The problem seems to be the fact that ps_facetedsearch does not execute the actionSearch hook. If you uncheck that option, the default search class will be used in the search page, and this class does implement the hook, so you should start seeing the search keywords inserted into that table.

Mare sure the iframe parameter is allowed

c'est normal le n° de tel est lié à l'adresse pas au compte. Vous l'aurez au moment de créer votre adresse.

Thank you for your suggestion. I will have a look and choose

Bonjour, Module installé, juste parfait, exactement ce que je recherchais, je vais gagner un temps précieux. Merci pour ce dev Juste une petite suggestion, l'ajout d'une case à cocher, qui le resterait, lorsque le produit est commandé chez le fournisseur.

La validation est en cours sur Addons, je propose déjà le module sur mon site : https://www.prestatoolbox.fr/transport-logistique/478-commandes-groupees-par-fournisseur.html

Prestashop's autoupgrade module works step by step, processing sql files that list what must be changed in the database for the next version. And at some point during that process it will cross the 1.4-1.5 border and add the root category. Those files are found in the /install/upgrade/sql directory (up to 1.7.0) and /modules/autoupgrade/upgrade/sql (after 1.7) Of course third party tools can choose to work in another way.

Pour ceux qui sont encore sous PS 1.6 (Debian 6.1, Apache 2.4, MariaDB 10.11, PHP 7.0.33) faut‑il absolument migrer vers PS 8.x ou peut‑on rester durablement sur 1.6 avec des mesures compensatoires ? Quels impacts avez‑vous constaté sur la compatibilité des modules et surtout sur le SEO ? Merci pour vos retours d’expérience.

Bonjour, Nous souhaitons mettre en place une réduction par palier d'achat dans les règles paniers. Ce qui semble facile à configurer mais nous rencontrons trois problèmes ... 1 - La règle panier n'exclu pas les produits en promotions 2 - La réduction par palier s'applique à tout le panier (s'il contient 1 produit de la catégorie) et non pas juste aux produits de la catégorie. (et même les produits d'une autre catégorie avec des promotions !) 3 - Malgré ces configurations nous avons observés 25 cas sur 580 qui ont bénéficiés de la remise cumulés -10, -15 et -20%. Comment l'expliquer ? Voici la configuration mise en place : BON DE RÉDUCTION DE 10% POUR 50€ D'ACHAT (sur une catégorie spécifique) : * Montant minimum : 50 * Non-compatibilité : bon de réduction 15% et bon de réduction 20% *Sélection de produit : nombre de produits requis dans le panier : 1 Ajout d'une règle qui concerne 1 catégorie. * Priorité : 3 * Etat : validé *Appliquer une réduction en pourcentage : 10% *Exclure les produits en promotions BON DE RÉDUCTION DE 15% POUR 100€ D'ACHAT (sur une catégorie spécifique) : : * Montant minimum : 100 * Non-compatibilité : bon de réduction 10% et bon de réduction 20% *Sélection de produit : nombre de produits requis dans le panier : 1 Ajout d'une règle qui concerne 1 catégorie. * Priorité : 2 * Etat : validé *Appliquer une réduction en pourcentage : 15% *Exclure les produits en promotions BON DE RÉDUCTION DE 20% POUR 150€ D'ACHAT (sur une catégorie spécifique) : : * Montant minimum : 150 * Non-compatibilité : bon de réduction 10% et bon de réduction 15% *Sélection de produit : nombre de produits requis dans le panier : 1 Ajout d'une règle qui concerne 1 catégorie. * Priorité : 1 * Etat : validé *Appliquer une réduction en pourcentage : 20% *Exclure les produits en promotions Avez-vous une explication à nos 3 problématiques ?

Bonjour, Je viens de passer sur votre site, il est en ligne ici.

Jeśli w tym katalogu nie masz pliku custom.css to go utwórz i tam dodaj ten kod.

it's a bit tricky, import works but you need to set attributes properly. During import prestashop will create the missing attributes or assing existing ones. it goes like that attributegroupname:type:position(ordering of the group);attributevalues:position(ordering of values) example: Size:radio:0;S:0 T-shirt color:color:0;RED:0 You can combine these to make proper variant: Size:radio:0,T-shirt color:color:1;S:0,RED:1 but you have to remember about position otherwise presta will create new value inside wrong group: if you want to export that you would need to make a query that combines tables like: attribute attribute_lang attribute_group attribute_group_lang product_attribute_combination I made similar query for product listing but it will require adjustments. It all depends on what structure you need.

$product_manufacturer.image.small.url

Panowie biorę się za pisanie, sam wysyłam fv z presty i myślę że popyt będzie. Będę wrzucał tutaj demówki, kto korzysta niech testuje i daje feedback. Jak będzie wersja 1.0 to założę nowy wątek z darmowym modułem i tutaj podlinkuję.

PrestaShop 9.0.2 is now available! This second patch version represents yet another step in making PrestaShop 9 more reliable. It focuses on fixing some reported issues to provide a more stable and seamless experience for merchants and developers.View the full article

Hola a todos, Nos gustaría poder comentar en este foro ya que se nos nombra bastante. Somos los creadores del Módulo STK Verifactu y se dice alguna cosa que no es cierta. Estaría bien que el moderador nos aprobara los comentarios para poder debatir y sumar en este foro.

Tu parles de cela : https://www.mediacom87.fr/pourquoi-je-ne-developpe-jamais-en-local/ Vous travaillez en local ou sur un serveur distant, en gros sur le serveur de votre hébergement que vous avez commandé ? Que ce soit en local ou en ligne, il n'y a pas de raison pour que vous ne puissiez pas renommer ce répoertoire.

Bonjour Ne pas travailler en local...

Hi. I like this post for free drag and drop theme and i send thank you. But how much secure is that module theme ? I want to open a new eshop.

I just disabled PS contact us form. e-mail address is left and those who wanna can contact and somehow e-mail providers are better dealing with spam...

As you don't describe how you removed this company name it is hard to say what went wrong. But if it is really a bug you can report it here: https://github.com/PrestaShop/PrestaShop/issues

Tampoco han hecho una campaña de información adecuada, ay muchos muchos muchos autónomos y pymes que no tienen aún ni idea, yo aun estoy informando a muchos, y otros han oído campanas pero no entienden nada. No es solo que haya gente que no haya empezado ha hacer cosas a ultima hora. También creo que las gestorías tienen mucha culpa por qué deberían informar bien a sus clientes dónde estos temas y no lo hacen ... En fin...

As was not having problems with WAMP maybe because my user was and administrator... For me it seems like permission problems. If you are doing this on local server just for testing, try to play with permissions. In your case, first i'll make user as admin and reinstall WAMP, try if it solves you issues, if not, make the directory, you install presta, permission settings 777 and try again.

Hello everyone, We are going to start offering our customers STL files for 3D printing. These are quite large files, around 200 MB per file, which are hosted on a Drive. The idea would be to provide the customer with a download link via email once they have made their purchase. Something like: ‘Thank you very much for your purchase, here is your download link’ Ideally, this link could also appear in the orders section of their customer profile, but this would be secondary. I don't see how to configure this in Prestashop 8.2. How could we do it? Does anyone know of a suitable module? Thank you very much for your help and best regards!

is your WAMP starting automatically when you boot your pc? Rmembering my times with WAMP I had to start it manually. After that need to check server settings it it can't see your instalation.

Imagino que dentro de un año volveremos a leernos en este post...vaya panda nos gobierna

Hello, did you rename or delete the install folder? Best regards,

@El Patron I'm not fighting here... I'm not going to apologize cause people this time getting too easy insulted even when nobody was trying to insult them. Statement you're not reading is because @gaminn writes that search result (looking by/for product number) with his product number is given from the post in prestashop forum with domain extension .com and not showing on search results from his eshop with same extention .com (and you state, that the problem is domain extension). I run through google docs for dev about search results, maybe too fast, but found nothing about domain extension influence an search results (btw @gaminn check on these docs maybe some thoughts after that)... FYI .us=USA domain name extension relevant to country. gTLD's are not country associated so my saying that .com=US (is another bullshait is correct). I said reading helps, so put these in search and check "what is gtld by country" , "domain name extensions by country" , "domain name extensions and search results" . I did not dispute your contribution to this community helping with prestashop issues, but sometimes i have doubts about who is the real author of your answers. @El Patron the saying, that someone who has nothing to do but to change what is working properly - was not about you, but if you think so - it's not my problem. Just read, not imagine (the talk was about search engine rules and data rankings, so I don't think you are making them) ...

you should then also read the information I posted, you in same boat. The original poster thought I made up .com vs .eu and how that is major problem for him...so you should pretty easily rank higher than him if you already don't. Friday, I feel a little more freedom of speech. Seldom does anyone follow advice here, they already have some answer in their head and they will focus on that until they go out of business..

@willsmith79052 is exactly the correct Google only allows review markup when the rating refers to the primary topic of the page. @AcidLava maybe say thank you for his response? if you question someone's answer, especially on this topic, you could have easily find google's recommendations and that mixing reviews on non relevant page will get you penalized.

Hello! Pulling my hair out on this one. We have a website where orders with a valid VAT number should remove the VAT. They should be created with the proper prices/taxes We tested several modules and can get the actual business logic to work, as long as Vies returns proper data. However, some member states have rate limits or maintenance periods, which means addresses can't be flagged as valid before order creation => created orders include taxes => the merchant has to jump through hoops to re-validate and trigger a new calculation of the order taxes/prices. The customers also receive the erroneous values. Has anyone found a satisfactory solution to this? Which module do you use? What's your process? I'll take any suggestions at this point. Thanks in advance!

UPDATES VERSIONS Version 1.3.0 (Major) Major Features: Saved layouts system: users can save, load, and manage custom layouts Add a Copy Paste in right click menu (copy block, copy styles, paste block, paste styles) Version 1.2.2 (Minor) Bug Fixes: Fixed wrapper detector allowing 'body' to be used as a valid wrapper.

We are thrilled to announce the release of Hummingbird v2.0.0 Beta. This milestone is the result of a monumental effort, representing more than 320 commits, 500 file changes, 50,000 additions, and 30,000 deletions. The goal is to deliver a developer-first, lightweight, and modular theme that establishes a new standard for the PrestaShop ecosystem.View the full article

I found the answer. exec() was not enabled on the server.

It is online again. I found that the problem was a bit wider. The new version - 1.36m - should solve it.

Bonjour, Je ne suis pas contre l’idée du Wall of Fame, mais alors vraiment pas en gros dans le menu général d’un backoffice de ecommerce, ça n’apporte rien pour le bizness, rien pour l’usage, ça surcharge le menu et nuis à l’UX pour rien. Et en termes de crédit pour les contributeurs, un énorme placard du genre a tendance à avoir tout l’effet inverse. Par ailleurs, je ne crois pas être le seul que ça ennuis : https://github.com/PrestaShop/ps_distributionapiclient/issues/62 Ne faites pas la bêtise de désactiver le module ps_distributionapiclient, si ça désactive le Wall of Fame, ça désactive aussi les mises à jour des modules natifs de Prestashop. Faites plutôt cette requête SQL pour le masquer : UPDATE ps_tab SET enabled = 0 WHERE class_name = 'AdminPsdistributionapiclient'; Vous pourrez toujours y accéder depuis cette url : https://votre-site.tld/adminrandom/modules/ps_distributionapiclient/top-contributors?_token=votretoken/ Et pour le réactiver : UPDATE ps_tab SET enabled = 1 WHERE class_name = 'AdminPsdistributionapiclient';

1) In the meantime, the credit card option in back office is available for merchants from Germany, Mexico and Brazil. But you always can choose the credit card payment directly in Paypal pop-up during checkout. 2) The module doesn't impact the initial Paypal fees. Regards, Daria support 202-ecommerce

Out of range value for column 'id_category' at row 1 INSERT INTO `ps_category` (`nleft`, `nright`, `level_depth`, `active`, `id_parent`, `id_shop_default`, `is_root_category`, `position`, `date_add`, `date_upd`) VALUES ('0', '0', '5', '1', '102', '1', '0', '0', '2017-10-10 21:22:19', '2017-10-10 21:22:19') When creating new category, I get that error (error reporting on). It is possible that category id is too high. How I can change categoryid autoincrement to start from ie. 1000?

That is actually really weird. I've tested it in multiple stores, and it always in the list of your screenshot. Please reinstall the module to check if that helps.

And of course, the screenshot of the validation of this post, from the moderators point of view.

Hello, Voilà c'est cadeau : Modules > Modules installés : Recherche sur "contact" : > Formulaire de contact > Configurer, puis voir les instructions.

I have VDS, so i can reach to php.ini. But what change i need to do exactlty? I have below line in php.ini, session.save_path = "/var/cpanel/php/sessions/ea-php56" do you suggest to change it to below one? session.save_path = "/tmp"