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

Do oficjalnego wydania ich nowego modułu do PrestaShop 8 a znając życie może to potrwać jeszcze 2 lata nic nie zrobisz jeżeli wogóle planują wydać, dodam jeszcze że w samej 8 zależnie od szablonu lub samego serwera moduł miał często problemy. Możesz pomyśleć też o innej integracji np. furgonetka mają wtyczkę do PrestaShop 9 ogólnie ich developorzerzy prężniej działają z aktualizacją modułów po wydaniu nowej wersji praktycznie odrazu pojawia się moduł to też dobrze zapowiada kolejne wersje i przejścia do PrestaShop 10, 11, 12 nie będziesz czekał latami na moduł uprzedzę też odrazu pytanie o ceny jeżeli na apaczka masz lepsze ceny piszesz do furgonetki o tym fakcie i na twoim koncie ustawiają identyczne ceny wysyłek jak miałeś w apaczka a często ceny nawet są lepsze.

Bonjour, Merci, je vais regarder cela

Hi, Some reading material to help you secure your website. https://www.mediacom87.com/post/security/

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

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 @Audrey Tournier, je viens de vous envoyez un MP. Bonne continuation et bonne journée. Cordialement,

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

Ha oui en effet, si je clique sur position, l'icone reviens bien, merci de votre aide

Super, merci ! Il m'a suffit de désactiver la bannière paiement en 4x Paypal directement dans le module et le tour est jouer !

Przeróbka w szablonie i np. warunek dla: {$product.quantity} < X jeżeli spełniony to wyłączy np. przycisk dodawania do koszyka.

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.

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 @Surática Software, finalmente completasteis la auditoría que estabais haciendo por lo que proporcionais algún tipo de "declaración responsable" para vuestro módulo? cuando hablé con vosotros estabais con ello creo... saludos

This is genuinely helpful, especially for anyone working with older PrestaShop setups. The way you broke down the on-page essentials makes it much easier to see what actually moves the needle. At fhseohub we often see merchants struggle with the exact issues you highlighted, so having a clean, practical checklist like this is a great starting point. Thanks for sharing your experience—it adds real value to the community.

Order settings > General > Recalculate shipping costs after editing the order

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...

I have a new installation of PS9.0.1 on a new Win 11 / WAMP setup. PS9 Installs OK but then Apache refuses to serve up both the shop or the back end. The installation is: WAMP Server 2.4. Server Configuration Apache Version: 2.4.65 - Documentation Apache - Loaded Apache modules Server Software: Apache/2.4.65 (Win64) PHP/8.3.28 mod_fcgid/2.3.10-dev - Port defined for Apache: 80 PHP Version: [Apache module] 8.3.28 - Documentation PHP - Loaded PHP extensions - Use of PHP versions [FCGI] 8.0.30 - 8.1.33 - 8.2.29 - 8.3.28 - 8.4.15 - 8.5.0 - FCGI mode help MySQL Version: 8.4.7 - Port defined for MySQL: 3306 - default DBMS - Documentation MySQL MariaDB Version: 11.4.9 - Port defined for MariaDB: 3307 - Documentation MariaDB - MySQL - MariaDB Win64OpenSSL_Light-3_6_0 (1) Opening https://localhost/PS produces: Hmmm… can't reach this page localhost refused to connect. Try: Checking the connection Checking the proxy and the firewall ERR_CONNECTION_REFUSED And the back end produces: Oops! An Error Occurred The server returned a "500 Internal Server Error". I am obviously new at this. What have I missed? Please help!! Very annoying Barrie

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!

yes, install folder deleted. PS8 serves up the 'Maintenance' web page for both shop and back office. No ability to do anything. Frustrating!

Ne touchez pas aux produits. Vous pouvez vider cette table et surtout: guest, connections, connection_pages, page_viewed, page_not_found

Lo que ha pasado es vergonzoso.. es lo que dices tú .. damos 3 meses sin sanciones..o lo que sea.. pero ya se había avisado lo suficiente como para a falta de menos de un mes hagan esto.. no me cabe en la cabeza la panda de inútiles que nos gobierna.. Antes de ayer se dio de alta un cliente en tu servicio, otro estaba apuntado, a espera de contratar el servicio, uno con 2000 facturas mensuales. Evidentemente han dicho que hasta el año que viene nada (lógico). El perjuicio económico que os han causado es inmenso... Ánimos Saludos Enrique

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.

Nada, ¿a quién pasamos la factura del tiempo y del dinero que se ha perdido en esta chorrada? Qué asco de gente, por Dios.

Hello, Since this is experimental, you would expect things to be missing. You can manually fix it for now. You can edit modules/ps_facetedsearch/src/Product/SearchProvider.php and on line 197 add the following: \Hook::exec('actionSearch', [ 'searched_query' => $query->getSearchString(), 'total' => $productsAndCount['count'], 'expr' => $query->getSearchString(), ]); If it's inserting things twice, this means the hook is called twice, although it shouldn't. Did you add it for debugging somewhere in the code and forgot to remove it?

Hi Yes install folder deleted on both PS8 and PS9 folders. I have a TEST folder with a simple HTML Hello World page. Apache serves that up to me no problems.

" localhost refused to connect" seems to be a connection issue like host definition or protocol (http / https)

Thank you very much for your contribution, and apologies for bringing this topic up again after more than a year. Is the module posted here (https://www.prestashop.com/forums/topic/1080554-visitors-online-shows-module-not-found/#comment-3460318) working for Prestashop 8.2.1? Thanks again and best regards!

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.

there is an open issue on github here you can vote it up and if you create login add your own comments. I assume the code update you made solved your issue....but seems correct to me

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';

Please share which PS versions it's compatible with. I am doing a 9.0.1 and client wants hummingbird so I don't have a lot of front office flexibility, this could do the trick!

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

Hi lorenxo! Have you tried to contact Prestashop support team with your issue? You can do it via this link: https://addons.prestashop.com/en/contact-us?id_product=46347 If the issue remains, I kindly invite you to try the Paypal Official module which also have express checkout button. If anything, we will be glad to help you. Regards, Daria support 202-ecommerce

Ciao a tutti, devo creare una promozione 3x2, ovvero acquisti 3 prodotti e il meno caro è gratis. Ho creato la regola ma non riesco a capire come fargli applicare il calcolo dal prezzo di listino e non da quello scontato. Qualcuno mi può aiutare? Grazie

Hi there, This is my first topic here. I've been working with the PS webservice in order to create a SYNC system with an external ERP, and I would like to share my experience (if somebody is interested). I've also other scripts to add products (including images), etc. If somebody interested...let me know. Before using the script: - This is a LINUX bash shellscript (will not work in windows) - You have to install the "xmlstarlet" tools (apt-get install xmlstarlet in Ubuntu) - You have to install "CURL" (apt-get install curl in Ubuntu) - You have to create a config.inc file providing your PS webservice KEY and base URL for your SITE config.inc contents: WS_KEY=XYZABCDDJ5ERJTW81231231231231 BASEURL=http://YOURSITE.COM/prestashop/api After creating the config.inc file on the SAME directory as ps_edtProduct.sh you can use it on a regular console like this: Change QUANTITY for product ID=1234: ./ps_edtProduct.sh 1234 QUANTITY=120 Change PRICE for product ID=1234: ./ps_edtProduct.sh 1234 PRICE=120 Change WHOLESALE_PRICE for product ID=1234: ./ps_edtProduct.sh 1234 WPRICE=120 I'm experiencing problems while uploading images, they upload fine, but PS refuses to use the image as "main" image until I manually edit the product. Somebody having this issue? NOTE: I've uploaded the script renamed as .txt to avoid upload restrictions, please re-rename it after downloading

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

http://www.presta-addons.com/moduly/3-pdf-rozsireni.html Možnosti úprav nekonečné. Můžeš si s podobou katalogu hrát hodiny a dny. Navíc modul umožňuje tvořit vlastní faktury, které se nemusí s každou novou verzí Presty předělávat.