Knowledgebase: Smart Search



After insert:





Find this code near line 47:





BEFORE add:






--------------------------------------------------------------------------------

Related Articles

•The On Sale module discounts aren't applied when using Google Checkout or Gift certificates.
•How do I add the On Sale discounts to the Related or Upselling products on my main product display page?
•I'm receiving this error on the checkout page: "There was an error loading the shipping options, please try again. (You may need to refresh your browser.)"
•I receive an "Order processing error ! Payment processor can not process your order. Data is invalid" error when submitting a $0 order with the One Page Checkout.

--------------------------------------------------------------------------------

Still Have Questions? If you are unable to find a solution in the knowledgebase please open a support ticket for a personal response from alteredCart support.

[MODIFICATION] Change the search statistics to display the search terms sorted in the order from most to least searched.
Posted by - NA - on 01 December 2010 10:12 AM
This X-Cart modification will display the search terms in the Management -> Statistics -> Search statistics section sorted in the order from most to least searched. This can give you a better idea of the most used search phrases on your store.




--------------------------------------------------------------------------------


admin/stats_search.php

Find this code near line 65:


$statistics = func_query("SELECT * FROM $sql_tbl[stats_search] as ss WHERE $date_condition ORDER BY date DESC LIMIT $first_page, $objects_per_page");


Change it to:


$statistics = func_query("SELECT *, COUNT(*) as amount FROM $sql_tbl[stats_search] as ss WHERE $date_condition GROUP BY search ORDER BY amount DESC LIMIT $first_page, $objects_per_page");



skin1/admin/main/atracking_search.tpl

Find this code near line 31:


{$lng.lbl_search_string} Count {$v.date|date_format:$config.Appearance.datetime_format} {$v.amount}

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: