image
SALES ANALYTICS VirtueMart Reports: Sales, Products, Orders, Customers, Locations, Manufacturers, Inventory, Taxes, Shipping Costs, ... everything under control on your online shop!! Read the Full Story
image
SALES ANALYTICS for MAGENTO Magento Reports: On-site reports for Sales, Products, Categories, Orders, Customers, Locations, Taxes, Shipping,... deep insight into your Magento online shop!! Read the Full Story
image
SOCIAL ANALYTICS JomSocial 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
image
WEB ANALYTICS Joomla! Reports: You can check how your website is evolving using all the relevant information at hand, and make it grow accordingly!! Read the Full Story
* * * *
image image image image
Welcome, Guest
Username Password: Remember me
SALES ANALYTICS Installation & Configuration.
  • Page:
  • 1

TOPIC: Manufacturers Reports Problem

Manufacturers Reports Problem 1 year, 4 months ago #1

  • mihtrah
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Hello! When I'm trying to get a Manufacturers Report and when i click on every tab in manufactures section i get this mistake (see attachment). I need your extension only for this reports. Whats the problem? Thank you...Cant attach the file
Here is the mistake:

1146 Table 'a147670_2.assyrian_virtuemart_manufacturers_ru_ru.utf8' doesn't exist SQL=SELECT e.mf_name AS manufacturer, SUM(o.product_final_price*o.product_quantity) AS gross_income, SUM(o.product_item_price*o.product_quantity) AS net_income, SUM((o.product_final_price - o.product_item_price)*o.product_quantity) AS taxes, COUNT(DISTINCT(o.virtuemart_order_item_id)) AS n_orders, SUM(i.n_items) AS n_items FROM `assyrian_virtuemart_order_items` AS o LEFT JOIN `assyrian_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 `assyrian_virtuemart_order_items` AS o LEFT JOIN `assyrian_sa_order_segmentation` AS t ON o.virtuemart_order_id = t.virtuemart_order_id WHERE t.cdate>='2016-05-14' AND t.cdate<='2016-06-11 23:59:59' AND o.order_status IN ("C", "S") GROUP BY o.virtuemart_order_id) AS i ON i.virtuemart_order_id = o.virtuemart_order_id LEFT JOIN `assyrian_virtuemart_product_manufacturers` AS x ON x.virtuemart_product_id = o.virtuemart_product_id LEFT JOIN `assyrian_virtuemart_manufacturers` AS m ON m.virtuemart_manufacturer_id = x.virtuemart_manufacturer_id LEFT JOIN `assyrian_virtuemart_manufacturers_ru_ru.utf8` AS e ON e.virtuemart_manufacturer_id=m.virtuemart_manufacturer_id WHERE t.cdate>='2016-05-14' AND t.cdate<='2016-06-11 23:59:59' AND o.order_status IN ("C", "S") GROUP BY e.virtuemart_manufacturer_id ORDER BY gross_income DESC
Attachments:

Re: Manufacturers Reports Problem 1 year, 4 months ago #2

  • mihtrah
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Mistake screen
Attachments:
  • Page:
  • 1
Time to create page: 0.12 seconds

About Us

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.