Jump to content


  • Posts

  • Joined

  • Last visited

About thomaska

  • Birthday 11/08/1974

Contact Methods

Profile Information

  • Location
  • Activity

thomaska's Achievements


Newbie (1/14)



  1. Hello, Same problem here. After upgrading from to i cannot login with the same problem. Any suggestions?
  2. Hi, I have a prestashop website and suddenly, a few days ago i realize that there was a lot of abandoned carts or Not Ordered carts. That was strange and i start searching the reason. I saw that when the user press the button to "add to cart" the ajax popup appears informing that the product has been successfully added to the cart, but the products in the cart number is zero 0 and if you navigate to the cart, the cart is empty. On the otherhand, in the backoffice the shopping cart has been created and the status is Non Ordered for the guests and Abandoned for the registered customers. Any suggestions please because this is very serious and i cannot find a solution. Best Regards, Thomas
  3. Hi, I need to add extra fields in email templates. I fould the ps_emailalerts inside the modules folder as well as the mails folder in the root directory. Inside those folders are the html templates. Where is the php file that is using those files to send email to a customer, for example the order confirmation email. And also which template should i edit in order to add those extra fields? The template for the order confirmation inside the ps_emailalerts or inside the mails folder? Or should i copy the ps_emailalerts inside the override and there edit the order confirmation html template? Which is the best approach and of course where is the php that collects the data and use the appropriate html template? In older version there was an emailalerts folder inside the modules and there was the emailalerts.php file. In 1.7.4??? Best Regards Thomas
  4. Hi, I have a store v1.5.3.1 in Greek and English language. I am facing an issue with the Store Contacts. When i navigate in Preferences -> Store Contacts to add a store i would like the Name, Address and the City to be translated in both languages but unfortunately the flag icon next to the text boxes does not exist, as it does in other cases (e.g. product description). So how can i set the values for these fields in multiple languages in order to be displayed correctly depending on the UI language?
  5. Hi, Suddenly i am facing the following issue and i cannot figure out how to resolve it. For some orders the shipping cost is calculated wrong on the shipping field of the backend order details page (see the attachment) as well as on the email. The final cost is correct, with the correct amount of shipping cost, only the shipping field is wrong. This is a problem because the same think happens on the email the customer receives, so they complaint for wrong charges. I must fix this ASAP because is a production environment. I will appreciate any help. Regards Thomas
  6. Hi, I have a request to show on home page the last modified products. Even if the user shop owner change the price, or the quantity must be shown in home page. In order to do that i have made the following changes: 1. Copy the Product.php from classes in override/classes and inside the file i create a new function the following one in order to get the last modified products. ---------------------------------------------------------------------------------------------------------------------------------- /** * Get last modified products * * @param integer $id_lang Language id * @param integer $pageNumber Start from (optional) * @param integer $nbProducts Number of products to return (optional) * @return array Last modified products */ public static function getLastModifiedProducts($id_lang, $page_number = 0, $nb_products = 10, $count = false, $order_by = null, $order_way = null, Context $context = null) { if (!$context) $context = Context::getContext(); $front = true; if (!in_array($context->controller->controller_type, array('front', 'modulefront'))) $front = false; if ($page_number < 0) $page_number = 0; if ($nb_products < 1) $nb_products = 10; if (empty($order_by) || $order_by == 'position') $order_by = 'date_upd'; if (empty($order_way)) $order_way = 'DESC'; if ($order_by == 'id_product' || $order_by == 'price' || $order_by == 'date_add' || $order_by == 'date_upd') $order_by_prefix = 'p'; else if ($order_by == 'name') $order_by_prefix = 'pl'; if (!Validate::isOrderBy($order_by) || !Validate::isOrderWay($order_way)) die(Tools::displayError()); $groups = FrontController::getCurrentCustomerGroups(); $sql_groups = (count($groups) ? 'IN ('.implode(',', $groups).')' : '= 1'); if (strpos($order_by, '.') > 0) { $order_by = explode('.', $order_by); $order_by_prefix = $order_by[0]; $order_by = $order_by[1]; } if ($count) { $sql = 'SELECT COUNT(p.`id_product`) AS nb FROM `'._DB_PREFIX_.'product` p '.Shop::addSqlAssociation('product', 'p').' WHERE product_shop.`active` = 1 AND product_shop.`date_upd` > "'.date('Y-m-d', strtotime('-'.(Configuration::get('PS_NB_DAYS_NEW_PRODUCT') ? (int)Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY')).'" '.($front ? ' AND product_shop.`visibility` IN ("both", "catalog")' : '').' AND p.`id_product` IN ( SELECT cp.`id_product` FROM `'._DB_PREFIX_.'category_group` cg LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` '.$sql_groups.' )'; return (int)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql); } $sql = new DbQuery(); $sql->select( 'p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name, product_shop.`date_upd` > "'.date('Y-m-d', strtotime('-'.(Configuration::get('PS_NB_DAYS_NEW_PRODUCT') ? (int)Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY')).'" as new' ); $sql->from('product', 'p'); $sql->join(Shop::addSqlAssociation('product', 'p')); $sql->leftJoin('product_lang', 'pl', ' p.`id_product` = pl.`id_product` AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl') ); $sql->leftJoin('image', 'i', 'i.`id_product` = p.`id_product`'); $sql->join(Shop::addSqlAssociation('image', 'i', false, 'image_shop.cover=1')); $sql->leftJoin('image_lang', 'il', 'i.`id_image` = il.`id_image` AND il.`id_lang` = '.(int)$id_lang); $sql->leftJoin('manufacturer', 'm', 'm.`id_manufacturer` = p.`id_manufacturer`'); $sql->where('product_shop.`active` = 1'); if ($front) $sql->where('product_shop.`visibility` IN ("both", "catalog")'); $sql->where('product_shop.`date_upd` > "'.date('Y-m-d', strtotime('-'.(Configuration::get('PS_NB_DAYS_NEW_PRODUCT') ? (int)Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY')).'"'); $sql->where('p.`id_product` IN ( SELECT cp.`id_product` FROM `'._DB_PREFIX_.'category_group` cg LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` '.$sql_groups.' )'); $sql->groupBy('product_shop.id_product'); $sql->orderBy((isset($order_by_prefix) ? pSQL($order_by_prefix).'.' : '').'`'.pSQL($order_by).'` '.pSQL($order_way)); $sql->limit($nb_products, $page_number * $nb_products); if (Combination::isFeatureActive()) { $sql->select('MAX(product_attribute_shop.id_product_attribute) id_product_attribute'); $sql->leftOuterJoin('product_attribute', 'pa', 'p.`id_product` = pa.`id_product`'); $sql->join(Shop::addSqlAssociation('product_attribute', 'pa', false, 'product_attribute_shop.default_on = 1')); } $sql->join(Product::sqlStock('p', Combination::isFeatureActive() ? 'product_attribute_shop' : 0)); $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql); if ($order_by == 'price') Tools::orderbyPrice($result, $order_way); if (!$result) return false; $products_ids = array(); foreach ($result as $row) $products_ids[] = $row['id_product']; // Thus you can avoid one query per product, because there will be only one query for all the products of the cart Product::cacheFrontFeatures($products_ids, $id_lang); return Product::getProductsProperties((int)$id_lang, $result); } -------------------------------------------------------------------------------------------------------------------------------- 2. Copy the NewProductController.php from the ../controllers/front to ../override/controllers/front and i change in the InitContent() function the following $this->orderBy = 'date_add'; change it to $this->orderBy = 'date_upd'; 3. I had create a new module from the NewProducts Module and instead of calling the getNewProducts() function i am calling my function in section 1 above. Finally i delete the class_index.php from the ../cache folder in order to refresh the cache The result it wasn't what i was expecting to. It does give me a few newer products, i don't know how it select them, but unfortunatelly it does not show the latest modified. Before navigating on the site i had update the price of a product and i was expecting to see it in home page, but unfortunatelly it does not. Any help please??
  7. Thank you a lot. You save my day. Greaat
  8. Hi, I need a help. I have production eshop and my customer requires the telephone to be required on order submission because all the courier services requires telephone number in order to send a parcel. How can i do that?
  9. Hi, I am facing an issue with my customers data that have been migrated from virtuemart and i would like to show them a popup message after the login to inform them to update their persomal data conditional. Conditional means that if the surname field has a specific value (the id field) then the popup must appear. Is there any module to do that or can anyone help me on how to implement this? Regards Thomas
  10. Hi, I just go live a new eshop migrated from Virtuemart and I am facing the following problem with some customers who are trying to recover their password. They are getting and email with a Url to click in order to recover the password like the following one https://eshop.atmomixani.gr/en/password-recovery?token=3c5a455adbd33470ed68424760144fe9&id_customer=2007 but for some of them as soon as they click on the url they redirect on a page which informs them that "Oops something went wrong. Try to refresh this page or feel free to contact us if the problem persists." like the attached picture. Can anyone help me on that because I cannot understand where is the problem? Regards Thomas
  11. Hi, Following is the default subject of the shop owner new order notification email. Subject: [Atmomixani] New order : #8 - UUASQXUHX My customer has a request and i need help. He wants also on the subject to appear the Customer Name and Surname. Where and how can i do that? Regards Thomas
  12. Can anyone help on this? While i am pressing the button "Refund Complete Order" i am getting the following message. Refund operation result:ACK: FailureL_ERRORCODE0: 81002L_SHORTMESSAGE0: Unspecified MethodL_LONGMESSAGE0: Method Specified is not SupportedL_SEVERITYCODE0: ErrorTransaction error!
  13. Hi, Thank you for that, but this is only for paypal. How about other gateway payment methods?
  14. Hi, I need as soon as possible a module in order to add extra fees per payment module. To be more specific i need on Paypal Module to add the extra fees that paypal charge on the order total as well as on another gateway payments. On Paypal module 3.5.8 the fees exists, but the problem is that these fees appears only on the paypal redirect page and after the payment, on the order details, on the invoice e.t.c these fees does not exists. I need a module to do that as soon as possible in order to upload a site to live environment. This is the only thing that is missing. Regards Thomas
  15. I cannot understand why i does not exists a such a useful module. Also why on Paypal Module v3.5.8 the extra fees exists and does not exist after the 3.5.8 version.
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More