After insert:

Find this code near line 47:



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.



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");


Find this code near line 31:

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

Comments (0)
Post a new comment
Full Name: