ubuntuchosen Developer Dari Czech Republic Anggota sejak Des 2018 ubuntuchosen 29 Mei 2020 01:36 Hey, we started selling in another country (Slovakia) in addition to our home country (Czechia), but we are unable to get reports grouped by country. We are currently running LC 2.1.4 (we are afraid to upgrade because of some custom changes that were done in our system in order to make it work with our czech country invoicing etc., and a different project I already tried to upgrade 2.1.4 to 2.2.1. got broken, so we'll have to stick with 2.1.4 for a while) I am not very skilled in MySQL, but I tried fooling around with the original monthly_sales.inc.php, editing only the line #55 from: "select id from ". DB_TABLE_ORDER_STATUSES ." where id=1 OR id=2 OR id=4 OR id=5 OR id=6;" to: "select id from ". DB_TABLE_ORDERS ." where customer_country_code='CZ';" This resulted in country reports for CZ country being shown - the exact same report as on monthly sales, except a lower number this month (as a part of sales from this month are from a different customer_country_code). So that seemed like it worked perfectly. I tried making a second monthly_sales duplicate with just this similar edit of line #55: "select id from ". DB_TABLE_ORDERS ." where customer_country_code='SK';" But that doesn't show anything, it loads the table header, but no table items, even though there are at least 10 sales from SK, with order ids that have is_sale=1. I tried switching customer_country_code to shipping_country_code, but that outputs the same result = blank table. After spending too much time on this, I tried looking further (since nothing about Country Reports was found in the forum) and came across this paid addon: https://www.litecart.net/en/addons/86/country-sales-report Unfortunately, seeing the addon was last updated in 2017, and it doesn't support 2.1.4, I am afraid of buying it just to find out it won't help at all. Does anyone know of a solution or similar way of geting a simple country reporting, grouped by months like in monthly_sales.inc.php? Or an addon that would solve this problem? Thanks a lot for any comments!
ubuntuchosen Developer Dari Czech Republic Anggota sejak Des 2018 ubuntuchosen 29 Mei 2020 03:44 Okay, so I eventually solved it by just buying the addon I mentioned. It seems to be working great on 2.1.4, so should be compatible even though it's an old addon. Thanks a lot for the addon Tim :)
tim Founder Dari Sweden Anggota sejak Mei 2013 tim 30 Mei 2020 02:46 The pleasure is mine :) Thanks for letting me know.