Search the Community

Bonjour, depuis quelques jours les commandes de mes clients n'ont aucun statut je suis obligé de les mettre en paiement validé manuellement. De plus je ne reçois aucun mail de confirmation de commande en tant qu'admin, par contre en tant que client c'est ok. J'ai passé une commande pour voir le problème et effectivement lorsque je valide un paiement j'ai une page avec une erreur 500. J'ai réessayé en mode debug et ça m'a donné ce message : InvalidArgumentException ""cannot be interpreted as a number in Builder.php line 40 at Builder :: parseNumber(") in Number.php line 72 at Number -> __construct(") in Formatter.php line 149 at Formatter ->prepareNumber(null) in Formatter.php line 106 at Formatter ->format(null, object(Price)) in Locale.php line 155 at Locale -> formatPrice(null) in ps_emailalerts.php line 486 at Ps_EmailAlerts -> hookActionValidateOrder( array('cart => object(Cart), 'order' => object(Order), 'customer' => object(Customer), 'currency' => object(Currency), 'orderStatus' => object(OrderState), 'cookie' => object(Cookie), 'altern' =>2)) in Hook.php line 970 at HookCore :: coreCallHook(object(Ps_EmailAlerts), 'hookActionValidateOrder', array('cart => object(Cart), 'order' => object(Order), 'customer' => object(Customer), 'currency' => object(Currency), 'orderStatus' => object(OrderState), 'cookie' => object(Cookie), 'altern' =>2)) in Hook.php line 355 at HookCore :: callHookOn(object(Ps_EmailAlerts), 'actionValidateOrder', array('cart => object(Cart), 'order' => object(Order), 'customer' => object(Customer), 'currency' => object(Currency), 'orderStatus' => object(OrderState), 'cookie' => object(Cookie), 'altern' =>2)) in Hook.php line 907 at HookCore :: exec(object('actionValidateOrder', array('cart => object(Cart), 'order' => object(Order), 'customer' => object(Customer), 'currency' => object(Currency), 'orderStatus' => object(OrderState), 'cookie' => object(Cookie), 'altern' =>2)) in PaymentModule.php line 738 at PaymentModule -> validateOrder(29501, 1, 456.0, 'Chèque', null, array('{check_name}' =>'', '{check_adress}' => '', '{check_adress_html}' =>''), 1, false,'') in validation.php in line 86 at Ps_CheckpaymentValidationModuleFrontController ->postProcess() in Controller.php line 281 at ControllerCore ->run() in Dispatcher.php line 515 at DispatcherCore ->dispatch() in index.php line 28 Lorsque je dégreffe le module mail alert du hook actionValidateOrder, les statuts de commande se mettent automatiquement mais je ne reçois toujours pas de mail de confirmation en tant qu'admin ( ce qui est logique en soi mais c'est la seule solution que j'ai trouvée en attendant de régler le problème). Je suis sur PS 1.7.6 J'ai la version 2.2 de mail Alert je l'ai mis à jour avec la dernière version en pensant que cela réglerait le problème mais ça n'a rien changé !

I've read many posts asking this: How to show product manufacturer and reference in mail that alerts from product restock. None has been solved. Can anybody help me with this? Thanks in advance, PS. Version 1.5.5

Hi ! I have a website on Prestashop 1.7.6.9. I installed mailalert module to receive new order and low stock alerts. No problem for the new orders alerts, but the low stock emails are not sent correctly : - Both emails (new order and low stocks) must be sent to the same email A - I set A as the recipient in the mailalert module parameters. - No problem for the new order email, they are sent to A - The low stocks alerts are sent to every member of the team (anybody with an admin account, no matter the group SuperAdmin or Commercial). It is a real problem for me. Also, the email template used it the Prestashop one, not the module template. - I tried to add a second email B in the module parameters : it solves part of the problem ; the low stock email is sent only to A and B (most of the time, when the stock is 0 the email is still sent to everybody). Also to A and B the email template used is the module one. - My problem is now, B receives the new order emails too (of course), and only A must receive that email. What can I do to make sure all emails are sent to A only ? Maybe I just misconfigured something ? MailAlert has been updated. I looked for an anwsers on many forums but I couldn't find any similar problem. I have the same problem on another shop in 1.7.6. Thanks !

Bonjour, Ma boutique est en panne : page d'accueil erreur 500 Avec le mode debug, cela indique un problème avec le fichier MailAlert.php L'administration fonctionne à l'exception de Module Manager qui indique 2 problèmes avec mailalert. Le problème est que je ne vois absolument pas quoi modifier pour réparer. Quelqu'un a-t-il une solution ? Merci.

Hi, I installed the native mail alerts module. Then i enabled the notification for customers But i don't see the form to let the email on the product page in case there is no more stock. How can i do this ? Thanks

Hola, Tengo un conflicto que no consigo resolver en prestashop 1.7.5. Espero que podáis ayudarme. El caso es que tengo un conflicto con el formato de fecha... necesito que en los emails de pedidos que se envían desde mailalert se muestre la hora del pedido ... para ello, en Internacional > Localización, en el campo "Formato de fecha" asigno el formato de fecha así: d/m/Y H:i:s El caso es que si configuro el "formato de fecha" de esta forma, en los emails que envía mailalert aparece la fecha y hora correctamente pero en el registro, en el campo "Fecha nacimiento" me exige añadir la hora de nacimiento y el campo aparece como erróneo. Por lo que no permite el registro de usuario. Como podéis ver en esta imagen: Si cambio el formato de fecha por "d/m/Y" en el email de pedido enviado por mailalert no muestra la hora y es un campo que necesitamos. La solución temporal ha sido desactivar la opción "Solicitar fecha de nacimiento" en Parámetros de la tienda > Ajustes sobre clientes > Clientes. ¿Se os ocurre como puedo solucionarlo? Lo que quiero es que al registrarse un usuario no se le solicite la hora de nacimiento pero si la fecha y que aparezca la hora en los emails de pedidos que envía mailalert. Por el momento, puedo conseguir una de las dos cosas, pero no las dos... Muchas gracias de antemano!

Salve a tutti. Come da titolo, ho installato il modulo mail alerts per ricevere notifiche tramite e-mail di tutto ciò che riguarda il negozio. Registrazione nuovi utenti, ordini effettuati ecc.. Ho provato a cercare la soluzione e nel forum inglese, alcuni, hanno trovato una soluzione aggiungendo la cartella "it" nella cartella del modulo. Ho provato a fare questa manovra senza risultati. Ho bisogno del vostro aiuto perchè è di fondamentale importanza. Grazie mille per la vostra disponibilità, confido nella vostra conoscenza!🤓

Bonjour a tous, Je vous explique le problème que rencontre un ami vendeur sous prestashop 1.6. IL a un magasin physique et un sur le net. Les deux sont reliés par une passerelle et lorsqu'une vente est effectué en local, elle est directement créée sur le site en statut "Livré" sans passer par "paiement accepté". Les ventes internet se font, elles, normalement. Le soucis est que le module d'alerte email des ventes lui envoi toutes les notifications des ventes locales et ne fait aucune distinction. il se retrouve avec 50 mails dans sa boite sans pouvoir directement distinguer celles qui sont locales de celles qui ne le sont pas. Y a t'il un moyen de modifier le module d'alerte email, de manière à ce que celui ci n’envoie des emails que si la vente est au statut "Paiement accepté" ? De cette manière il ne recevrais alors que les ventes internet et plus celles locales ? Je ne suis pas assez doué en modif de module, et donc je me tourne vers vous.. Si quelqu'un pouvait lui venir en aide. ce serait super . Ensuite je ferais les modifs manuellement, ca par contre c'est pas un problème.

Tak jak w temacie - mailalerts zainstalowany, ale maile do sprzedawcy nie przychodza - tylko do klientow. Co zrobic?

Zainstalowaną mam wtyczkę mail alerts w sklepie, która odpowiada za wysyłanie powiadomienia klientowi kiedy produkt jest dostępny. Wcześniej musi on wpisać w pole tekstowe swój mail i zgłosić chęć takiego powiadomienia. Tyle że cokolwiek nie wpisze w pole tekstowe wtyczka i tak daje komunikat że jest ok. Wie ktoś jak dopisać weryfikację czy wpisany tekst jest adresem e-mail?

Hello, I'm having an issue with the mailalerts module. I have a order state (ID: 8) indicating "error on payment". In BO, the state has checked the option: "Send email to customer when an order change to this state". Then I have a payment module (realexredirect - addon payments). Everytime a customer fails on its payment, mailalerts sends 2 emails. One for the customer (this one is fine) and another to the admin, saying "New order, but with an error message". I'm trying to avoid the second email. I searched inside module (mailalerts) and it has 2 hook functions that could be sending the second email ( in fact they do call Mail::send() ): - hookActionValidateOrder($params) - hookActionOrderReturn($params) In both I added: if($order->current_state == 8) { return; } But the module is still sending the second email. I searched for any reference of "Mail::class" or "Mail::send function" but it is not in there. (inside the payment module) What else could it be? Thanks!

PS 1.6.0.8 Hi I'm trying to create an override for the mailaerts module to display the product description on the confirmation email. It doesn't seem to work. When I put the same code into the core code, it works ok. Code placed in /overrides/modules/mailalerts. The method is "hookActionValidateOrder": Possibly the issue is the placement of line: return parent::hookActionValidateOrder($params); See code below. Any help appreciated. Thanks <?php if (!defined('_CAN_LOAD_FILES_')) exit; include_once(dirname(__FILE__).'/MailAlert.php'); class MailAlertsOverride extends MailAlerts { public function hookActionValidateOrder($params) { if (!$this->merchant_order || empty($this->merchant_mails)) return; // Getting differents vars $context = Context::getContext(); $id_lang = (int)$context->language->id; $id_shop = (int)$context->shop->id; $currency = $params['currency']; $order = $params['order']; $customer = $params['customer']; $configuration = Configuration::getMultiple( array( 'PS_SHOP_EMAIL', 'PS_MAIL_METHOD', 'PS_MAIL_SERVER', 'PS_MAIL_USER', 'PS_MAIL_PASSWD', 'PS_SHOP_NAME', 'PS_MAIL_COLOR' ), $id_lang, null, $id_shop ); $delivery = new Address((int)$order->id_address_delivery); $invoice = new Address((int)$order->id_address_invoice); $order_date_text = Tools::displayDate($order->date_add); $carrier = new Carrier((int)$order->id_carrier); $message = $this->getAllMessages($order->id); if (!$message || empty($message)) $message = $this->l('No message'); $items_table = ''; $products = $params['order']->getProducts(); $customized_datas = Product::getAllCustomizedDatas((int)$params['cart']->id); Product::addCustomizationPrice($products, $customized_datas); foreach ($products as $key => $product) { $unit_price = Product::getTaxCalculationMethod($customer->id) == PS_TAX_EXC ? $product['product_price'] : $product['product_price_wt']; $customization_text = ''; if (isset($customized_datas[$product['product_id']][$product['product_attribute_id']])) { foreach ($customized_datas[$product['product_id']][$product['product_attribute_id']][$order->id_address_delivery] as $customization) { if (isset($customization['datas'][Product::CUSTOMIZE_TEXTFIELD])) foreach ($customization['datas'][Product::CUSTOMIZE_TEXTFIELD] as $text) $customization_text .= $text['name'].': '.$text['value'].'<br />'; if (isset($customization['datas'][Product::CUSTOMIZE_FILE])) $customization_text .= count($customization['datas'][Product::CUSTOMIZE_FILE]).' '.$this->l('image(s)').'<br />'; $customization_text .= '---<br />'; } if (method_exists('Tools', 'rtrimString')) $customization_text = Tools::rtrimString($customization_text, '---<br />'); else $customization_text = preg_replace('/---<br \/>$/', '', $customization_text); } // Start - Added DA 25/09/2018. Get product description for new poles codes. $results = Db::getInstance()->executeS('select `description_short` FROM `'._DB_PREFIX_.'product_lang` WHERE `id_product` = \''.pSQL($product['product_id']).'\' '); $desc_short = ''; if ($results) { $desc_short = $results[0]['description_short']; } // End -Added DA 25/09/2018. Get product description for new poles codes. $url = $context->link->getProductLink($product['product_id']); $items_table .= '<tr style="background-color:'.($key % 2 ? '#DDE2E6' : '#EBECEE').';"> <td style="padding:0.6em 0.4em;">'.$product['product_reference'].'</td> <td style="padding:0.6em 0.4em;"> <strong><a href="'.$url.'">'.$product['product_name'].'</a>' .(isset($product['attributes_small']) ? ' '.$product['attributes_small'] : '') .(!empty($customization_text) ? '<br />'.$customization_text : '') .'<br />'.$desc_short // Added by DA 25/09/2018 for 2018 pole code changes to output product description on order confirmation received by AMGS. .'</strong> </td> <td style="padding:0.6em 0.4em; text-align:right;">'.Tools::displayPrice($unit_price, $currency, false).'</td> <td style="padding:0.6em 0.4em; text-align:center;">'.(int)$product['product_quantity'].'</td> <td style="padding:0.6em 0.4em; text-align:right;">' .Tools::displayPrice(($unit_price * $product['product_quantity']), $currency, false) .'</td> </tr>'; } foreach ($params['order']->getCartRules() as $discount) { $items_table .= '<tr style="background-color:#EBECEE;"> <td colspan="4" style="padding:0.6em 0.4em; text-align:right;">'.$this->l('Voucher code:').' '.$discount['name'].'</td> <td style="padding:0.6em 0.4em; text-align:right;">-'.Tools::displayPrice($discount['value'], $currency, false).'</td> </tr>'; } if ($delivery->id_state) $delivery_state = new State((int)$delivery->id_state); if ($invoice->id_state) $invoice_state = new State((int)$invoice->id_state); if (Product::getTaxCalculationMethod($customer->id) == PS_TAX_EXC) $total_products = $order->getTotalProductsWithoutTaxes(); else $total_products = $order->getTotalProductsWithTaxes(); $order_state = $params['orderStatus']; // Filling-in vars for email $template_vars = array( '{firstname}' => $customer->firstname, '{lastname}' => $customer->lastname, '{email}' => $customer->email, '{delivery_block_txt}' => MailAlert::getFormatedAddress($delivery, "\n"), '{invoice_block_txt}' => MailAlert::getFormatedAddress($invoice, "\n"), '{delivery_block_html}' => MailAlert::getFormatedAddress( $delivery, '<br />', array( 'firstname' => '<span style="color:'.$configuration['PS_MAIL_COLOR'].'; font-weight:bold;">%s</span>', 'lastname' => '<span style="color:'.$configuration['PS_MAIL_COLOR'].'; font-weight:bold;">%s</span>' ) ), '{invoice_block_html}' => MailAlert::getFormatedAddress( $invoice, '<br />', array( 'firstname' => '<span style="color:'.$configuration['PS_MAIL_COLOR'].'; font-weight:bold;">%s</span>', 'lastname' => '<span style="color:'.$configuration['PS_MAIL_COLOR'].'; font-weight:bold;">%s</span>' ) ), '{delivery_company}' => $delivery->company, '{delivery_firstname}' => $delivery->firstname, '{delivery_lastname}' => $delivery->lastname, '{delivery_address1}' => $delivery->address1, '{delivery_address2}' => $delivery->address2, '{delivery_city}' => $delivery->city, '{delivery_postal_code}' => $delivery->postcode, '{delivery_country}' => $delivery->country, '{delivery_state}' => $delivery->id_state ? $delivery_state->name : '', '{delivery_phone}' => $delivery->phone ? $delivery->phone : $delivery->phone_mobile, '{delivery_other}' => $delivery->other, '{invoice_company}' => $invoice->company, '{invoice_firstname}' => $invoice->firstname, '{invoice_lastname}' => $invoice->lastname, '{invoice_address2}' => $invoice->address2, '{invoice_address1}' => $invoice->address1, '{invoice_city}' => $invoice->city, '{invoice_postal_code}' => $invoice->postcode, '{invoice_country}' => $invoice->country, '{invoice_state}' => $invoice->id_state ? $invoice_state->name : '', '{invoice_phone}' => $invoice->phone ? $invoice->phone : $invoice->phone_mobile, '{invoice_other}' => $invoice->other, '{order_name}' => $order->reference, '{order_status}' => $order_state->name, '{shop_name}' => $configuration['PS_SHOP_NAME'], '{date}' => $order_date_text, '{carrier}' => (($carrier->name == '0') ? $configuration['PS_SHOP_NAME'] : $carrier->name), '{payment}' => Tools::substr($order->payment, 0, 32), '{items}' => $items_table, '{total_paid}' => Tools::displayPrice($order->total_paid, $currency), '{total_products}' => Tools::displayPrice($total_products, $currency), '{total_discounts}' => Tools::displayPrice($order->total_discounts, $currency), '{total_shipping}' => Tools::displayPrice($order->total_shipping, $currency), '{total_tax_paid}' => Tools::displayPrice( ($order->total_products_wt - $order->total_products) + ($order->total_shipping_tax_incl - $order->total_shipping_tax_excl), $currency, false ), '{total_wrapping}' => Tools::displayPrice($order->total_wrapping, $currency), '{currency}' => $currency->sign, '{gift}' => (bool)$order->gift, '{gift_message}' => $order->gift_message, '{message}' => $message ); // Shop iso $iso = Language::getIsoById((int)Configuration::get('PS_LANG_DEFAULT')); // Send 1 email by merchant mail, because Mail::Send doesn't work with an array of recipients $merchant_mails = explode(self::__MA_MAIL_DELIMITOR__, $this->merchant_mails); foreach ($merchant_mails as $merchant_mail) { // Default language $mail_id_lang = $id_lang; $mail_iso = $iso; // Use the merchant lang if he exists as an employee $results = Db::getInstance()->executeS(' SELECT `id_lang` FROM `'._DB_PREFIX_.'employee` WHERE `email` = \''.pSQL($merchant_mail).'\' '); if ($results) { $user_iso = Language::getIsoById((int)$results[0]['id_lang']); if ($user_iso) { $mail_id_lang = (int)$results[0]['id_lang']; $mail_iso = $user_iso; } } $dir_mail = false; if (file_exists(dirname(__FILE__).'/mails/'.$mail_iso.'/new_order.txt') && file_exists(dirname(__FILE__).'/mails/'.$mail_iso.'/new_order.html')) $dir_mail = dirname(__FILE__).'/mails/'; if (file_exists(_PS_MAIL_DIR_.$mail_iso.'/new_order.txt') && file_exists(_PS_MAIL_DIR_.$mail_iso.'/new_order.html')) $dir_mail = _PS_MAIL_DIR_; if ($dir_mail) Mail::Send( $mail_id_lang, 'new_order', sprintf(Mail::l('New order : #%d - %s', $mail_id_lang), $order->id, $order->reference), $template_vars, $merchant_mail, null, $configuration['PS_SHOP_EMAIL'], $configuration['PS_SHOP_NAME'], null, null, $dir_mail, null, $id_shop ); } return parent::hookActionValidateOrder($params); } } ?>

Bonjour, je me retrouev avec un probleme sur le module MailAlerts, impossible de valider l'email sur la fiche produit pour être informé du retour en stokc, le message d'erreur ne m'aide pas beaucoup Page : http://www.boutiquedelajasse-montlobre.com/43-mosson-valley-river-2016.html# Le message d'erreur est depuis content.js : [ERROR] CS formClassifier Error DOMException: Failed to execute 'querySelectorAll' on 'Document': '[action="http\:\/\/www\.boutiquedelajasse-montlobre\ [type="submit"]' is not a valid selector. Quelqu'un a t'il deja eut ce genre de probleme, le module est à jour pourtant : Alertes par e-mail v3.7.0 Corrigé Le probleme en fait provient de l'impossibilité de rentrer un email dans la BDD, depuis la version 3.7 du module, cela ne fonctionne plus !!! La table reste vide ??? Merci

Hejhej, Czy ktoś z Was wie jak można prztłumaczyć tekst na stronie modułu ps_emailalerts? Sam nagłówek da się przetłumaczyć bez problemu, natomiast nigdzie w tłumaczeniach nie widzę fragmentu "You don't have any email alerts yet" (ale jak zmienię oryginalny tekst w pliku, to na angielskiej stronie też się zmienia - jedyny problem, że Presta nie widzi, że może to przetłumaczyć). Poniżej kod: {block name='page_content'} <h2>{l s='My alerts' d='Modules.Mailalerts.Shop'}</h2> {if $mailAlerts} <ul> {foreach from=$mailAlerts item=mailAlert} <li>{include 'module:ps_emailalerts/views/templates/front/mailalerts-account-line.tpl' mailAlert=$mailAlert}</li> {/foreach} </ul> {else} <p class="warning">{l s="You don't have any mail alerts yet." d='Modules.Mailalerts.Shop'}</p> {/if} {/block} Macie jakiś pomysł?

Hi, ich würde gern die Attribute eines Artikels die in der new_order Mail angezeigt werden, auf eine Zeile pro Attribut ändern. Habe schon versucht in der maialerts einfach ein <br> an unterschiedlichen Stellen ein zu bauen aber dann geht die Datei nicht mehr. Das wär mein eh schon etwas abgeänderter Code der ps_emaialerts.php Datei: if ($product['product_reference'] == 'service') { $items_table .= '<tr style="background-color:'.($key % 2 ? '#DDE2E6' : '#EBECEE').';"> <td style="padding:0.6em 0.4em; border:1px solid #D6D4D4;">'.$product['product_reference'].'</td> <td style="padding:0.6em 0.4em; border:1px solid #D6D4D4;"> <div>'.$product['product_name'].'</div>' .(isset($product['attributes_small']) ? ' '.$product['attributes_small'] : '') .(!empty($customization_text) ? '<br />'.$customization_text : '') .' </td> <td style="padding:0.6em 0.4em; text-align:center; border:1px solid #D6D4D4;">'.(int) $product['product_quantity'].'</td> </tr>';} else { $items_table .= '<tr style="background-color:'.($key % 2 ? '#DDE2E6' : '#EBECEE').';"> <td style="padding:0.6em 0.4em; border:1px solid #D6D4D4;">'.$product['product_reference'].'</td> <td style="padding:0.6em 0.4em; border:1px solid #D6D4D4;"> <div>'.$product['product_name'].'</div>' .(isset($product['attributes_small']) ? ' '.$product['attributes_small'] : '') .(!empty($customization_text) ? '<br />'.$customization_text : '') .' </td> <td style="padding:0.6em 0.4em; text-align:center; border:1px solid #D6D4D4;">'.(int) $product['product_quantity'].'</td> </tr> <tr height="30px"><td style="border-width:1px 0px 1px 1px;border-style:solid;border-color:#D6D4D4;background-color:#fbfbfb;font-family:Arial;color:#333;font-size:13px;padding:3px;font-weight: bold;">Bauteil/Material:</td><td style="border-width:1px 1px 1px 0px;border-style:solid;border-color:#D6D4D4;background-color:#fbfbfb;font-family:Arial;color:#333;font-size:13px;padding:3px;text-align:right;font-weight: bold;"><input type="text" name="material1" id="material1" style="width:180px;"> Druckbogen/Maschine:</td><td style="border:1px solid #D6D4D4;background-color:#fbfbfb;"><input type="text" name="bogen1" id="bogen1" style="width:80px;"></td></tr> <tr height="30px"><td style="border-width:1px 0px 1px 1px;border-style:solid;border-color:#D6D4D4;background-color:#fbfbfb;font-family:Arial;color:#333;font-size:13px;padding:3px;font-weight: bold;">Bauteil/Material:</td><td style="border-width:1px 1px 1px 0px;border-style:solid;border-color:#D6D4D4;background-color:#fbfbfb;font-family:Arial;color:#333;font-size:13px;padding:3px;text-align:right;font-weight: bold;"><input type="text" name="material2" id="material2" style="width:180px;"> Druckbogen/Maschine:</td><td style="border:1px solid #D6D4D4;background-color:#fbfbfb;"><input type="text" name="bogen2" id="bogen2" style="width:80px;"></td></tr> <tr height="30px"><td style="border-width:1px 0px 1px 1px;border-style:solid;border-color:#D6D4D4;background-color:#fbfbfb;font-family:Arial;color:#333;font-size:13px;padding:3px;font-weight: bold;">Bauteil/Material:</td><td style="border-width:1px 1px 1px 0px;border-style:solid;border-color:#D6D4D4;background-color:#fbfbfb;font-family:Arial;color:#333;font-size:13px;padding:3px;text-align:right;font-weight: bold;"><input type="text" name="material3" id="material3" style="width:180px;"> Druckbogen/Maschine:</td><td style="border:1px solid #D6D4D4;background-color:#fbfbfb;"><input type="text" name="bogen3" id="bogen3" style="width:80px;"></td></tr>';} } Ich denke es geht um die Zeile: .(isset($product['attributes_small']) ? ' '.$product['attributes_small'] : '') aber wo muss da das <br> rein damit jedes Attribut in einer neuen Zeile steht? Schonmal danke für jede Hilfe.

I need a help with mail alerts module. Everytime I'm trying to change order status same error appear: (in both PS 1.5.6.2 and 1.6.0.14). Any suggestions? [PrestaShopDatabaseException] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND TO_DAYS(NOW()) - TO_DAYS(sm.`date_add`) <= 7 AND s.`id_product` = 472 ' at line 14 SELECT SUM(view.quantity) as quantity_out FROM ( SELECT sm.`physical_quantity` as quantity FROM `ps_stock_mvt` sm LEFT JOIN `ps_stock` s ON (sm.`id_stock` = s.`id_stock`) LEFT JOIN `ps_product` p ON (p.`id_product` = s.`id_product`) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = p.id_shop_default) LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop IN (5, 6, 8, 7, 2, 1, 3, 4)) WHERE sm.`sign` = -1 AND sm.`id_stock_mvt_reason` != AND TO_DAYS(NOW()) - TO_DAYS(sm.`date_add`) <= 7 AND s.`id_product` = 472 AND s.`id_product_attribute` = 6330 AND s.`id_warehouse` = 1 GROUP BY sm.`id_stock_mvt` ) as view LIMIT 1 at line 646 in file classes/db/Db.php 641. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 642. } 643. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 644. { 645. if ($sql) 646. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 647. throw new PrestaShopDatabaseException($this->getMsgError()); 648. } 649. } 650. 651. /** DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 558 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 583 - classes/db/Db.php] - [2 Arguments] DbCore->getValue - [line 661 - classes/stock/StockManager.php] - [1 Arguments] StockManagerCore->getProductCoverage - [line 617 - modules/mailalerts/mailalerts.php] - [4 Arguments] MailAlerts->hookActionProductCoverage - [line 510 - classes/Hook.php] - [1 Arguments] HookCore::exec - [line 427 - classes/stock/StockManager.php] - [2 Arguments] StockManagerCore->removeProduct - [line 223 - classes/order/OrderHistory.php] - [9 Arguments] OrderHistoryCore->changeIdOrderState - [line 520 - controllers/admin/AdminOrdersController.php] - [3 Arguments] AdminOrdersControllerCore->postProcess - [line 171 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 54 - admin/index.php]

Hello everyone I have a problem, I recently installed the PrestaShop MailAlerts Module in my Store version 1.6, where an incident is happening to me, when a client registers and accesses his account and the "MY ALERTS" section shows this: When I select it, it opens a window with my command: /modules/paypal/about.php... Alguien sabe como solucionar el problema?

Hi all, I have PS 1.6.16 with Mailalerts 3.6.1 and I get the following behaviour: New order mails are sent to the merchant OK. Customer notifications (product availability, order change) are not sent. When a customer creates a product availability alert then it cannot be deleted/removed from My Account/My Alerts (the "X" doesn't work). I have tried to reinstall the module, copy it from another website in which works OK, disabling cache, etc with no success. I really appreciate your help. Manuel.

Salve a tutti, come da oggetto, ho attivato il modulo mailalerts sul mio prestashop 1.6.1.17. Tutto funziona bene, ma purtroppo, nella mail che arriva al cliente che ha appena effettuato l'ordine, non appaiono i dettagli dei prodotti acquistati. Cosa posso verificare per cercare di porre rimedio a questo strano comportamento? Grazie a tutti per le eventuali risposte

Hi I have been searching in vain on how to attach the invoice pdf to the email generated when the product is shipped. I see a lot of suggestions on Prestashop1.4, but no working suggestions on how is it possible for 1.6 I would like the invoice to be sent every time the order status is set to "shipped" at the backoffice. I understand that I can have the customer download the invoice pdf from the order history, (based on what I configure in the order status) but my requirement is to ATTACH the pdf to the mail that is generated. Thanks Uma

Hi friends, Have a lot of posts because this problem with module mail alert (prestashop official), about as show only product out of stock: Insert this code in line 450 more or less: <!-- Out of stock hook --> {if (!$allow_oosp && $product->quantity <= 0) OR !$product->available_for_order OR (isset($restricted_country_mode) AND $restricted_country_mode) OR $PS_CATALOG_MODE} <div id="oosHook"{if $product->quantity > 0} style="display: none;"{/if}> </div> {$HOOK_PRODUCT_OOS} {/if} I use prestashop 1.6.0.9

Hi, I have Prestashop 1.6.1.13 with default theme, with customized css and a few modifications in tpl files and translations. A big problem is, that order confirmation, it means between push of a confirmation button for example in bankwire and the final confirmation page, takes always around 30 seconds, sometimes more. On the browser side, most of the time is spent on virtually nothing... Just waiting. The debug profiling mode clearly shows, that the problem is in some "postProcess". It takes 19 seconds, before something else happens. Here is the debug output: Furthermore, there is a significant delay here: and here: I use google smtp for mail communication. I discovered prestashop just a month ago, so I am still learning and am clueless what more I could do to find out what the postProcess actually does and what could be the cause of the delay. Could somebody please point me the right direction? Thank you in advance

Hi, I'm a complete newbie to PrestaShop and OOP and would appreciate some help. I am trying to write a override to the mailalerts module to be able to send a notification email to either the supplier or the manufacturer of the product which is ordered. I know you can add a merchant email but the problem is that we will have many different manufacturers and suppliers from which the customer can order directly and I don't want to send everyone the email only the specific Supplier/manufacturer. So far I made overrides for MailAlerts.php and mailalerts.php in a mailalerts folder, deleted cache and it all works fine. In the MailAlert.php override I'm trying to use the product-id to first get either the supplier_id or the manufacturer_id and then use that to go to address database to get the correct email (I made a custom field for that and that all works fine) First problem is here....... how do I echo out the variables I created here to see if that it actually makes the call to the database and get the right values? I have tried : $Mail = new Mail (); $Mail->manufacturer_mails; $Mail->supplier_mails; ---- nothing -because it needs the product_id, I think? also tried echo'ing from within the class and even tried making a function but I'm not sure how to call that function so ....still... nothing. MailAlert.php Second problem: I then went and modified alerts.php and basically copied everything that was done to merchants_mails to try and get it to work here...mainly because I have very little idea of how this is supposed to be.... I did manage to echo out the variables from the __construct functions and it does give me the merchant_mails but my $manufacturer_mails and $supplier_mails are empty. mailalerts.php At the moment or before I started messing everything up the code would run but gives me a: Fatal error: Undefined class constant 'TYPE_TEXT' in /blah blah/site/classes/PaymentModule.php on line 506 which is.. if (count($product_var_tpl_list) > 0) { $product_list_txt = $this->getEmailTemplateContent('order_conf_product_list.txt', Mail::TYPE_TEXT, $product_var_tpl_list); $product_list_html = $this->getEmailTemplateContent('order_conf_product_list.tpl', Mail::TYPE_HTML, $product_var_tpl_list); } Sorry the code is very messy as I've tried about a hundred different ways to get the values...... I would greatly apprecciate any help! Thank you Ari

Hola a todos Estoy modificando un proyecto donde el cliente quiere que en el correo que recibe como correo de comerciante, aparezca en la tabla del listado de productos una columna más de descuento por producto. Por un lado, entiendo que en modules/mailalerts/mails/es/new_order.html y txt tengo que añadir una columna más para añadir el "Descuento" en productos". Luego lo que se me escapa es donde tendría que introducir el tipo de descuento del producto dentro del archivo modules/mailalerts/mailalerts.php. Llego hasta el lugar donde se encuentra la tabla, pero me faltaría que me echárais un cable con el valor de la variable, que no lo encuentro por ningún lado. $items_table .= '<tr style="background-color:'.($key % 2 ? '#DDE2E6' : '#EBECEE').';"> <td style="padding:0.6em 0.4em;">'.$product['product_reference'].'</td> <td style="padding:0.6em 0.4em;"> <strong><a href="'.$url.'">'.$product['product_name'].'</a>' .(isset($product['attributes_small']) ? ' '.$product['attributes_small'] : '') .(!empty($customization_text) ? '<br />'.$customization_text : '') .'</strong> </td> <td style="padding:0.6em 0.4em; text-align:right;">'.Tools::displayPrice($unit_price, $currency, false).'</td> <td style="padding:0.6em 0.4em; text-align:center;">'.(int)$product['product_quantity'].'</td> <td style="padding:0.6em 0.4em; text-align:right;">' .Tools::displayPrice(($unit_price * $product['product_quantity']), $currency, false) .'</td> </tr>'; Imagino que tiene que ser un $product[product_discount] o algo así, pero no me va. Lo ideal sería saber diferenciar entre de tipo porcentual o según la moneda. Gracias de antemano

Salut. Je suis maintenant sous Prestashop 1.6.1 après une niveau à niveau. Et j'ai un bug avec les Mail alerts. C'est peut etre une question idiote, mais où je peux trouver le module Mailalerts à télécharger pour remplacer celui- que j'ai est qui est tres étrange ? D'avance merci.