SALES ANALYTICSVirtueMart Reports: Sales, Products, Orders, Customers, Locations, Manufacturers, Inventory, Taxes, Shipping Costs, ... everything under control on your online shop!! Read the Full Story
SALES ANALYTICS for MAGENTOMagento Reports: On-site reports for Sales, Products, Categories, Orders, Customers, Locations, Taxes, Shipping,... deep insight into your Magento online shop!! Read the Full Story
SOCIAL ANALYTICSJomSocial Reports: Now you can know about your user social activities in detail. Friends, groups, photos, videos, ... reports on all your user participations. Read the Full Story
I installed the Sale Analystic component but I get a lot of errors?
Can you help me?
1146 Table 'alphamep_2016.jos_virtuemart_paymentmethods_nl_nl.utf-8' doesn't exist SQL=SELECT m.payment_name AS payment_method, SUM(o.order_total) AS gross_income, SUM(o.order_subtotal + o.order_discount + o.coupon_discount) AS net_income, SUM(o.order_tax) AS taxes, COUNT(DISTINCT(o.virtuemart_order_id)) AS n_orders, SUM(i.n_items) AS n_items, -SUM(o.coupon_discount) AS coupon_discount, -SUM(o.order_discount) AS order_discount FROM `jos_virtuemart_paymentmethods` AS p LEFT JOIN `jos_virtuemart_paymentmethods_nl_nl.utf-8` AS m ON m.virtuemart_paymentmethod_id = p.virtuemart_paymentmethod_id LEFT JOIN `jos_virtuemart_orders` AS o ON o.virtuemart_paymentmethod_id=p.virtuemart_paymentmethod_id LEFT JOIN `jos_sa_order_segmentation` AS t ON o.virtuemart_order_id = t.virtuemart_order_id LEFT JOIN (SELECT o.virtuemart_order_id, SUM(o.product_quantity) AS n_items FROM `jos_virtuemart_order_items` AS o LEFT JOIN `jos_sa_order_segmentation` AS t ON o.virtuemart_order_id = t.virtuemart_order_id WHERE t.cdate>='2015-11-24' AND t.cdate<='2015-12-22 23:59:59' AND o.order_status IN ("S") GROUP BY o.virtuemart_order_id) AS i ON i.virtuemart_order_id = o.virtuemart_order_id WHERE t.cdate>='2015-11-24' AND t.cdate<='2015-12-22 23:59:59' AND o.order_status IN ("S") GROUP BY p.virtuemart_paymentmethod_id ORDER BY taxes DESC
Latitud WEB is a trademark from Business Excellence through Information Technologies S.L. (BEIT). BEIT is an Information Technology company based in Valencia (Spain). Our aim is to put the IT advantages at the service of companies and organizations of any size.