{"id":248086,"date":"2025-09-21T08:11:10","date_gmt":"2025-09-21T08:11:10","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/shopanalytics-lite-customer-sales-insights\/"},"modified":"2026-07-15T02:01:12","modified_gmt":"2026-07-15T02:01:12","slug":"shopanalytics-lite-customer-sales-insights","status":"publish","type":"plugin","link":"https:\/\/kab.wordpress.org\/plugins\/shopanalytics-lite-customer-sales-insights\/","author":8205952,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"1.5.0","stable_tag":"1.5.0","tested":"7.0.2","requires":"6.0","requires_php":"","requires_plugins":null,"header_name":"ShopAnalytics Lite - Customer & Sales Insights","header_author":"maidulcu","header_description":"Basic WooCommerce customer and sales insights plugin with Pro upgrade via Freemius.","assets_banners_color":"e9edef","last_updated":"2026-07-15 02:01:12","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"","header_author_uri":"","rating":0,"author_block_rating":0,"active_installs":0,"downloads":587,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"1.1.0":{"tag":"1.1.0","author":"maidulcu","date":"2026-07-10 19:10:44"},"1.2.0":{"tag":"1.2.0","author":"maidulcu","date":"2026-07-10 19:29:18"},"1.3.0":{"tag":"1.3.0","author":"maidulcu","date":"2026-07-14 15:29:52"},"1.4.0":{"tag":"1.4.0","author":"maidulcu","date":"2026-07-14 19:15:09"},"1.5.0":{"tag":"1.5.0","author":"maidulcu","date":"2026-07-15 02:01:12"}},"upgrade_notice":{"1.0.0":"<p>Initial release \u2014 lightweight WooCommerce sales analytics.<\/p>"},"ratings":[],"assets_icons":[],"assets_banners":{"banner-772x250.png":{"filename":"banner-772x250.png","revision":3365161,"resolution":"772x250","location":"assets","locale":"","width":772,"height":564}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.1.0","1.2.0","1.3.0","1.4.0","1.5.0"],"block_files":[],"assets_screenshots":[],"screenshots":{"1":"<code>assets\/screenshot-1.png<\/code> \u2014 Overview dashboard with key sales metrics","2":"<code>assets\/screenshot-2.png<\/code> \u2014 Customer insights and export options","3":"<code>assets\/screenshot-3.png<\/code> \u2014 Setup wizard and Pro upgrade notice"}},"plugin_section":[],"plugin_tags":[232,29488,3654,332,286],"plugin_category":[36,45],"plugin_contributors":[80683],"plugin_business_model":[],"class_list":["post-248086","plugin","type-plugin","status-publish","hentry","plugin_tags-analytics","plugin_tags-customer-insights","plugin_tags-reports","plugin_tags-sales","plugin_tags-woocommerce","plugin_category-analytics","plugin_category-ecommerce","plugin_contributors-maidulcu","plugin_committers-maidulcu"],"banners":{"banner":"https:\/\/ps.w.org\/shopanalytics-lite-customer-sales-insights\/assets\/banner-772x250.png?rev=3365161","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/shopanalytics-lite-customer-sales-insights_e9edef.svg","icon_2x":false,"generated":true},"screenshots":[],"raw_content":"<!--section=description-->\n<p><strong>ShopAnalytics Lite<\/strong> is a performance-focused analytics plugin for WooCommerce store owners. Instantly see your shop's revenue trends, top customers, repeat purchase behavior, and more \u2014 all without slowing down your site.<\/p>\n\n<p>Whether you're just getting started or managing a growing WooCommerce store, ShopAnalytics Lite gives you the insights you need to grow sales with confidence.<\/p>\n\n<p><strong>\ud83d\udd0d Why Choose ShopAnalytics Lite?<\/strong>\n- Lightweight, no performance overhead\n- Simple UI for store owners \u2014 no analytics experience needed\n- Quick setup \u2014 view reports in under a minute<\/p>\n\n<h3>Features<\/h3>\n\n<p>\ud83d\udcca <strong>Sales Trends<\/strong>\n- Visual dashboard of monthly revenue and orders\n- Dual-axis chart for comparing revenue vs. order trends\n- Supports date range filtering<\/p>\n\n<p>\ud83d\udcc8 <strong>Revenue &amp; AOV Tracking<\/strong>\n- Average Order Value (AOV) tracked per month\n- Great for understanding customer spending behavior<\/p>\n\n<p>\ud83e\uddd1\u200d\ud83e\udd1d\u200d\ud83e\uddd1 <strong>Customer Insights<\/strong>\n- View top customers by spend and order volume\n- Drill into customer lifetime value (CLV)\n- Analyze repeat vs new customers<\/p>\n\n<p>\ud83d\udce4 <strong>Export to CSV<\/strong>\n- Export top customer data\n- Export revenue metrics\n- Export order data<\/p>\n\n<p>\ud83d\udce6 <strong>Product Category Analytics<\/strong>\n- Revenue and quantity sold per category\n- Toggle between revenue view and quantity view\n- Helps you identify best-performing product categories<\/p>\n\n<p>\ud83c\udf0d <strong>Geographic Insights<\/strong>\n- View customer distribution by country\n- Simple doughnut chart for fast visual breakdown<\/p>\n\n<p>\ud83e\udde0 <strong>Customer Segmentation<\/strong>\n- Buckets by order count (e.g., 1, 2\u20133, 4\u20135, 6+)\n- Bar chart visualization to identify retention and loyalty groups<\/p>\n\n<p>\ud83e\udde9 <strong>Built for WooCommerce<\/strong>\n- Uses WooCommerce's native orders and customer tables\n- Lightweight logging table for audit trails only<\/p>\n\n<p>\u2699\ufe0f <strong>Clean &amp; Secure Code<\/strong>\n- Nonces and capability checks throughout\n- Follows WordPress coding and escaping best practices<\/p>\n\n<p>\u26a1 <strong>Performance Focused<\/strong>\n- Optional lightweight mode disables all charts for resource-limited hosts\n- Smart queries for large stores<\/p>\n\n<h3>Support<\/h3>\n\n<p>Need help or have feature requests?<br \/>\n\ud83d\udc49 Visit: <a href=\"https:\/\/dynamicweblab.com\">https:\/\/dynamicweblab.com<\/a><\/p>\n\n<!--section=installation-->\n<ol>\n<li>Upload the <code>shopanalytics-lite<\/code> folder to the <code>\/wp-content\/plugins\/<\/code> directory.<\/li>\n<li>Activate the plugin via <strong>Plugins \u2192 Installed Plugins<\/strong> in WordPress.<\/li>\n<li>Go to <strong>ShopAnalytics \u2192 Setup<\/strong> to connect with WooCommerce.<\/li>\n<li>Done! Start viewing reports from your admin dashboard.<\/li>\n<li>(Optional) For translations, add <code>.po<\/code>\/<code>.mo<\/code> files in <code>wp-content\/plugins\/shopanalytics-lite\/languages\/<\/code>.<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt id=\"is%20shopanalytics%20lite%20compatible%20with%20my%20woocommerce%20store%3F\"><h3>Is ShopAnalytics Lite compatible with my WooCommerce store?<\/h3><\/dt>\n<dd><p>Yes, absolutely. ShopAnalytics Lite works seamlessly with all WooCommerce stores using standard WooCommerce data tables.<\/p><\/dd>\n<dt id=\"will%20shopanalytics%20delete%20any%20data%20when%20uninstalled%3F\"><h3>Will ShopAnalytics delete any data when uninstalled?<\/h3><\/dt>\n<dd><p>No. Your store data is never deleted. You can optionally enable a cleanup option to remove plugin-related settings and logs.<\/p><\/dd>\n<dt id=\"can%20i%20export%20reports%20and%20data%3F\"><h3>Can I export reports and data?<\/h3><\/dt>\n<dd><p>Yes. You can export customer lists, sales trends, and other data as CSV directly from the dashboard.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>1.5.0<\/h4>\n\n<ul>\n<li>New: Coupon Analytics page \u2014 track coupon usage, discount cost, and revenue impact.<\/li>\n<li>New: Top coupons bar chart (discount vs. revenue) and monthly trend line chart.<\/li>\n<li>New: CSV export for coupon data.<\/li>\n<li>New: Coupon usage rate metric (% of orders using a coupon).<\/li>\n<\/ul>\n\n<h4>1.4.0<\/h4>\n\n<ul>\n<li>Performance: Replaced <code>wc_get_orders(limit=-1)<\/code> with direct SQL queries on Sales Trends, Order Trends, and Top Products pages \u2014 eliminates instantiating thousands of WC_Order objects on large stores.<\/li>\n<li>Performance: Sales Trends category breakdown now uses a single SQL join instead of per-item <code>wp_get_post_terms()<\/code>.<\/li>\n<li>Performance: Top Products page now queries directly from <code>woocommerce_order_items<\/code> meta tables.<\/li>\n<\/ul>\n\n<h4>1.3.0<\/h4>\n\n<ul>\n<li>New: Period-over-period comparison on dashboard metric cards \u2014 revenue, orders, AOV, and repeat rate now show percentage change vs the previous equivalent period with color-coded trend arrows.<\/li>\n<li>Improved: Dashboard subtitle now indicates the comparison context.<\/li>\n<\/ul>\n\n<h4>1.2.0<\/h4>\n\n<ul>\n<li>Performance: Replaced per-month wc_get_orders() loops with single SQL queries on dashboard.<\/li>\n<li>Performance: Eliminated N+1 query in top customers \u2014 CLV now computed in same query.<\/li>\n<li>Performance: AOV now calculated via single AVG() query instead of two separate queries.<\/li>\n<li>Performance: Batch product category lookups in sales trends (was per-order).<\/li>\n<li>Performance: Batch user lookups in customers page (was per-customer get_user_by).<\/li>\n<li>Security: Replaced esc_sql() concatenation with $wpdb-&gt;prepare() placeholders in all queries.<\/li>\n<li>Cleanup: Removed unused class-data-exporter.php, templates\/dashboard.php, unused helper functions, and dead engine methods.<\/li>\n<\/ul>\n\n<h4>1.1.0<\/h4>\n\n<ul>\n<li>Fixed: Customer Insights page now renders correctly and is accessible from the menu.<\/li>\n<li>Fixed: Removed duplicate Reports submenu registration.<\/li>\n<li>Fixed: Removed duplicate activation hook that caused double initialization.<\/li>\n<li>Fixed: Cache invalidation now works correctly (wildcard patterns replaced with specific keys).<\/li>\n<li>Fixed: Uninstall now drops the logs table, clears cron, and removes all plugin options.<\/li>\n<li>Fixed: Deactivation hook now properly clears the scheduled cron job.<\/li>\n<li>Fixed: Removed duplicate asset enqueue that caused version conflicts.<\/li>\n<li>Updated: Tested up to WordPress 7.0.<\/li>\n<\/ul>\n\n<h4>1.0.0<\/h4>\n\n<ul>\n<li>Initial release: Sales dashboard, customer insights, CSV export, Freemius integration.<\/li>\n<\/ul>","raw_excerpt":"Instant, lightweight WooCommerce reporting. Track revenue, orders, top customers, and export to CSV. Fast insights for shop owners.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/kab.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/248086","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kab.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/kab.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/kab.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=248086"}],"author":[{"embeddable":true,"href":"https:\/\/kab.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/maidulcu"}],"wp:attachment":[{"href":"https:\/\/kab.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=248086"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/kab.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=248086"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/kab.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=248086"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/kab.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=248086"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/kab.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=248086"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/kab.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=248086"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}