sylwekb

Hello I have a store on Prestasop version 1.7.8.9 and I noticed a very large table capacity ps_layered_filter_block of over 700 MB! What is the reason for such a large capacity. The other tables don't take up as much space. Regards ______________________________________________________ Solved follow this post https://github.com/PrestaShop/PrestaShop/issues/17318 clear cache faceted module

I thought there was such a solution that in the case when product 1 is in euros and product 2 in dollars, the basket would be divided into 2 parts and both products would be shown in 2 currencies and the transfer also in 2 currencies. However, as far as I can see, no one has come across such a solution.

Hello Has anyone sold services without shipping in Prestashop 1.7 or 8? Is it enough to disable shipments? Will everything work? Regards

That can't be the case with me. I would like to achieve such an effect that the product, for example, named 1 is in euros, and the product named 2 is in dollars. I saw something like this in a store somewhere. I just don't know if some additional module was responsible for this. These prices for e.g. product 1 in euros and product 2 in dollars must be for all customer groups. I understand that there is no possibility in Prestashop to assign a specific currency to a product so as to achieve the effect that different currencies could be used for different products?

Hello Is it with Prestashop 1.7. and 8 can be set so that the products have different currencies ? eg product 1 in euros, product 2 in dollars? Where is it possible to set 1 euro for a product and 2 dollars for a product? Regards

Dzień dobry Mam Prestashop 1.7.8.8 i Komentarze produktu w najnowszej wersji z poniższej strony, w trybie debugowania mam poniższe błędy. Co może być przyczyna i jak naprawić. Oczywiście gdy wyłączam moduł błąd znika. Link do modułu, wydaje się aktualny. https://mypresta.eu/pl/modules/advertising-marketing/ocena-i-komentarz-o-produkcie.html [PrestaShopDatabaseException] Unknown column 'pc.id_shop' in 'where clause'<br /><br /><pre> SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 64 AND pc.`id_shop` = 1 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1</pre> at line 769 in file classes/db/Db.php 764. if ($webservice_call && $errno) { 765. $dbg = debug_backtrace(); 766. WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97); 767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 768. if ($sql) { 769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>'); 770. } 771. 772. throw new PrestaShopDatabaseException($this->getMsgError()); 773. } 774. } DbCore->displayError - [line 385 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 663 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 207 - modules/myprestacomments/MyprestaComment.php] - [1 Arguments] MyprestaComment::getAverageGrade - [line 1233 - modules/myprestacomments/myprestacomments.php] - [1 Arguments] myprestacomments->hookDisplayProductListReviews - [line 1007 - classes/Hook.php] - [1 Arguments] -------------------------------------------------------------------------------------------------------- Rozwiązaniem problemu jest odinstalowanie i zainstalowanie ponowne najnowszej wersji modułu. Rzeczywiście zainstalowanie nowego modułu na już istniejącą starszą wersję powoduje takie błędy.

Hello For me, the cause was two of the old modules that was not delivered with core Prestashop. You must try to enable and disable individual modules one by one, or if you can't comment one by one on FTP in the /modules directory, for example by adding a _ sign before the module directory. For me, there were 2 marketing and shipping modules that were not delivered with Prestashop but from an external developer.

Thank you. I did via phpmyadmin. there are over 100,000 addresses. Yes it is the fastest.

Hello How to extract only all customer email addresses to csv from a Prestashop 1.7 store? How to export all? You can select up to 1000 in the panel.

Witam W sklepach powinno się generować kod produktu i Kod EAN-13? Jeśli dobrze rozumiem to kod produktu jest w polu indeks na karcie Ustawienia podstawowe? Natomiast na karcie produktu Opcje jest Kod kreskowy EAN-13 lub JAN. O ile ten pierwszy Indeks może być dowolny np od nazwy produktu to jak się generuje te numeryczne kody ponieważ nie mogą to być dowolnie wpisane cyfry ?

Hello I have official Facebook pixel for Prestashop 1.7 counts add to cart x2. Has anyone encountered such a problem and how to solve it? Regards

Thank you. Is it possible to set it so that when buying for a minimum of 200, the customer has a permanent discount, e.g. 20%. Then, as I understand it, it would assign the customer to a group with such a discount, e.g. 20%?

How to set for such a group when the condition of exceeding the amount, e.g. 200 net or gross, is met and only then the 20% discount?

Tak zrobiłem rzeczywiście to działa. Czy mozna ustawić dla takiej grupy przy spełnieniu warunku przekroczenia kwoty np 200 zł netto lub brutto i dopiero wtedy rabat 20%?

Czyli nie ma takiego rozwiązania, że zaznaczam konkretnego klienta z poziomu rabatów i przypisuję mu rabat np 10% tylko rabat jest dla całej grupy klientów przypisanych? W tej chwili robię rabat dla wszystkich ale jak ktoś więcej kupuje to chciałbym mu przypisać większy rabat.