* Updated for LiteCart 2.6.0.
+ Added most popular countries
- Removed most viewed products
Tags: admin, most popular, statistics, most viewed, products
[+] Version 2024-11-18 | Uploaded 18 Nov 2024 by tim
* Updated for LiteCart 2.6.0.
+ Added most popular countries
- Removed most viewed products
Compatible Versions:
LiteCart 2.6.0, LiteCart 2.6.1
The package may be compatible with more versions than listed. Contact the author for more information.
[+] Version 2024-01-12 | Uploaded 12 Jan 2024 by dodo
Added extra columns to see how many sales most popular products have and how many views most sold products have.
Compatible Versions:
LiteCart 2.5.0, LiteCart 2.5.1, LiteCart 2.5.2, LiteCart 2.5.3, LiteCart 2.5.4, LiteCart 2.5.5
The package may be compatible with more versions than listed. Contact the author for more information.
[+] Version 2024-01-11 | Uploaded 11 Jan 2024 by bosecom
This Update fixes encountered error:
Fatal error: 1525 - Incorrect TIMESTAMP value: '2023-0111 11:03:02' SELECT `shipping_city`, `shipping_zone_code`, `shipping_country_code`, COUNT(`shipping_city`) AS `most_frequent` FROM `bosecomcommerce`.`lc_orders` WHERE date_created > '2023-0111 11:03:02' AND order_status_id in ( select id from lc_order_statuses where is_sale ) GROUP BY `shipping_city` ORDER BY `most_frequent` DESC, `shipping_country_code` ASC, `shipping_zone_code` ASC, `shipping_city` ASC LIMIT 11; in ~/includes/library/lib_database.inc.php on line 177
Code in:
most_visited_products.inc.php
Line 43: Changed from
WHERE date_created > '". date('Y-md H:i:s', strtotime('-12 months')) ."'
to:
WHERE date_created > '". date('Y-m-d H:i:s', strtotime('-12 months')) ."'
Compatible Versions:
LiteCart 2.5.0, LiteCart 2.5.1, LiteCart 2.5.2, LiteCart 2.5.3, LiteCart 2.5.4, LiteCart 2.5.5
The package may be compatible with more versions than listed. Contact the author for more information.
[+] Version 2023-02-02 | Uploaded 2 Feb 2023 by tim
Updated for LiteCart 2.5.x and code cleanup
Compatible Versions:
LiteCart 2.5.0, LiteCart 2.5.1
The package may be compatible with more versions than listed. Contact the author for more information.
[+] Version 2020-12-04 | Uploaded 4 Dec 2020 by s22_tech
* added WHERE clause to show only processed orders - there's no sense in counting orders you don't actually have.
* added WHERE `p`.`purchases` > 0 to show only items that have been sold (good for new stores - prevents showing zeros)
* formatted the SQL per MySQL rules for more readable code
* changed `customer_*` info to `shipping_*` info (`customer_*` info could be just a mailing address)
* added `shipping_zone_code` to benefit countries with states or provinces
* sorted Most Popular Cities first by the # of orders, then by the shipping country, the shipping zone, and the shipping city
* used proper English capitalization in the headings
* narrowed the width of the Most Popular Cities chart since it doesn't need to be as wide as the others, and it gives more room to the others so that product names don't wrap around as much.
* removed the footers since the info wasn't that helpful, and it took up valuable space.
Compatible Versions:
LiteCart 2.2.0, LiteCart 2.2.1, Litecart 2.2.2, LiteCart 2.2.3, LiteCart 2.2.4, LiteCart 2.2.5, LiteCart 2.2.6
The package may be compatible with more versions than listed. Contact the author for more information.
[+] Version 2020-12-03 | Uploaded 3 Dec 2020 by dodo
Might be compatible with older version too.
Added a column with most popular cities.
Compatible Versions:
LiteCart 2.2.3.3, LiteCart 2.2.4, LiteCart 2.2.5, LiteCart 2.2.6
The package may be compatible with more versions than listed. Contact the author for more information.
This add-on is courtesy of Public Domain.
This add-on is being offered without any support or conditions of use. Anyone can publish new updates to it.
You are allowed to remix and redistribute this add-on without attributing the original author.
Published by dodo
| Topic | Last Post |
|---|---|
| Incorrect TIMESTAMP value in query by vladislaw |
Dec 11 2024 09:16 AM by tim |
| Sales quantity is wrong by s22_tech |
Dec 3 2020 07:52 PM by s22_tech |
| Most sold and viewed products by tomydevon |
Nov 2 2020 11:17 PM by |