Jump to content


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

177 profile views

Jolsvi's Achievements


Apprentice (3/14)

  • Dedicated Rare
  • First Post Rare
  • Collaborator Rare
  • Conversation Starter Rare
  • Week One Done Rare

Recent Badges



  1. Hi, I want to add extra column to display "quantity sold product" in the bakcoffice - product list page. Has anyone tried to do this in PS 1.7? Please help Thanks in advance
  2. Hi, I have tried to browse some forum about blank captcha image problem, but I haven't got solution yet. Please help, maybe someone have same issue and could share how to solve it. So I have product review module, and it has captcha feature. But captcha code is not appearing. (attached 1) When I check the inspect element, it shows (attached 2 & 3): Notice: A non well formed numeric value encountered in /home/waterfj0/public_html/modules/homecomments/library/Captcha.php on line 76 var captcha_src = "https://waterfilterforfridge.com.au/index.php?fc=module&module=homecomments&controller=captcha&homecomments_captcha&t=0.48374300+1623974623"; I follow some forum and try to edit the line 76: // Use milliseconds instead of seconds srand(microtime() * 100); <--- line 76 - change to: srand(microtime(true) * 100); // Generate CAPTCHA code if not set by user if (empty($captcha_config['code'])) { $captcha_config['code'] = ''; $length = rand($captcha_config['min_length'],$captcha_config['max_length']); $captcha_code_length = Tools::strlen($captcha_config['code']); while ($captcha_code_length < $length) { $captcha_config['code'] .= Tools::substr( $captcha_config['characters'], rand() % (Tools::strlen($captcha_config['characters'])), 1 ); $captcha_code_length = Tools::strlen($captcha_config['code']); } } After I edit the line 76, the captcha is showing without image at all (attached 3) Currently the website is running under: Prestashop PHP version 7.1 Thank you in advance
  3. Hi, I'm just wondering is there anyone had modified the Delivery Methods section like this: - Adding option to customer if they want to provide permission to leave their shipment when they are not at home. - Section will be underneath the delivery method like "Leave a message" - Once they checked the box / choose that option , form will posted the text status "Parcel to be left at premises if no one is available to accept it." in the database (ps_address). I'm still beginner in programming. Hope someone could help me with this modification, please. Thanks in advance
  4. Hi Leo, Thank you for your suggestions. I have solved the 404 issue!! I have tried the enable debug mode, and disable the override, disable the last module that I have installed but it still redirected to 'page not found'. Then I tried this: - create blank .htaccess - go to Preference -> SEO & URLs -> on the Shcema of urls I modify the 'Route to products' become {category:/}{id}-{rewrite}.html - go to Preference -> Search -> on Indexing I rebuild the entire index Now the product page shows up. I guess you are right Leo, the module that related to SEO makes some overrides files. I also think that I fill the wrong configuration on that and I might try again with the right setting. Thank you
  5. Hi, I'm using Prestashop, and I found my product page always redirected to 404 page. The other link like about us, customer care, shipping & returns are fine, they are showing the correct content. Please help to solve this issue. Thank you This is the website : buyfridgefilters.com.au
  6. Hi @Daniel Tengler it works!!! The total page views shows the same number in database. Thank you very much for your help
  7. Thank you @Daniel Tengler you are really helpful. I have tried your codes. The first one shows no more multiple records, but column page views returns 0 data. The second one shows page views with data but I think it is not the total page views (and the filter displays random sorted data). Probably because of the id_date_range in table ps_date_range connection. I compare the results by adding the query that I got from forum and put that into the SQL manager: SELECT SQL_CALC_FOUND_ROWS p.id_product, p.reference, pl.name, ( SELECT IFNULL(SUM(pv.counter), 0) FROM ps_page pa LEFT JOIN ps_page_viewed pv ON pa.id_page = pv.id_page LEFT JOIN ps_date_range dr ON pv.id_date_range = dr.id_date_range WHERE pa.id_object = p.id_product AND pa.id_page_type = 5 AND dr.time_start BETWEEN '2021-01-01 00:00:00' AND '2021-12-31 23:59:59' AND dr.time_end BETWEEN '2021-01-02 00:00:00' AND '2021-12-31 23:59:59') AS totalPageViewed FROM ps_product p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_lang = 1 AND pl.id_shop = 1) GROUP BY p.id_product ORDER BY p.id_product ASC and I don't know how to apply that in the function
  8. Hi @Daniel Tengler thank you for your answer. I tried it to add this on AdminProductController.php but it shows with multiple product id $this->_select .= ', pv.`counter` as pageview_counter'; $this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'page` pa ON (pa.`id_object` = a.`id_product` AND pa.`id_page_type`=5)'; $this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'page_viewed` pv ON (pv.`id_page` = pa.`id_page`)'; $this->fields_list['pageview_counter'] = array( 'title' => $this->l('Page View'), 'align' => 'center', 'havingFilter' => true, ); Maybe you have additional code to view total counter in one product?
  9. Hi, I want to add additional column Page Views in the Product table (backoffice). I have tried to search in the forum but mostly shows the product page views for frontoffice purpose. I know there is a stats function Best-selling Products which displays page views data from each product, but there is no filter to sort like catalog products has. Please help, if someone knows how to make it or has already applied it. Thank you in advance
  10. Hi @ndiaga, it works!!!! Now the product on pdf can open the product page. Thank you for your help, really appreciate it
  11. Hi @ndiaga This is from the file invoice.product-tab.tpl and I try this: <table width="100%"> <tr> <td width="15%"> {if isset($order_detail.image) && $order_detail.image->id} {$order_detail.image_tag} {/if} </td> <td width="5%">&nbsp;</td> <td width="80%"> <a href="'.$this->context->link->getProductLink($product['id_product']).'">{$order_detail.product_name}</a> </td> </tr> </table> But when I open the pdf file, product is not linked to product page
  12. Hi @ndiaga thank you for your answer. Can you show me how? Let say one customer order product A, how can I generate automatically the product url link (refer to product A) from order details and apply to invoice?
  13. Hi, I'm just wondering is there any way to insert product url into invoice (pdf)? So when customer open the pdf and click the product, they can be redirected to product page.
  14. Hi, I'm currently using Prestashop and having problem to display order summary in the email template for customer. In this case I want to send 'bankwire' template with order summary. At the moment I can display variable : {carrier}, {payment}, {order_name}, {total_products} etc.. But the variable {products} and {discounts} are not working. Is there anyone has solved this issue? Help me please Thanks Note: I applied the override OrderHistory.php from this link:
  15. Hi, I'm currently using Prestashop v and facing trouble with the search features. When I try to search product with "/" and "-" it takes around 2 minutes to display. The response time is just too different with the words input, always quick. The shop is selling spare parts which a lot of product name such as : - fittings 1/4", 3/8", 1/2" - part number 4396508/8212652 - replacement for RG-100 Is there any recommendation to solve this issue? Thank you
  • Create New...

Important Information

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