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: Product SKUs?!

Product SKUs?! 4 years ago #1

  • atrus80
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
  • Karma: 0
Hi to all!

Noticed that we cannot see the products by product SKU, this is so confusing for us, we cannot rely on product titles, how can we enable this?

Rgrds,
Chris

Multilingual Product Titles? 4 years ago #2

  • atrus80
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
  • Karma: 0
Hi to all,

We have multiple languages in our VM2 store; we noticed that the component lacks the functionality of using a default language for product titles. Instead,it displays the product titles in random languages!

Would appreciate your assistance!

Rgrds,
Chris

Re: Product SKUs?! 4 years ago #3

  • latitudweb
  • OFFLINE
  • Administrator
  • Posts: 182
  • Karma: 1
Hello Chris,

We have merged these two topics into one, becuase the reason for both of them is the same.

At this moment, when Sales Analytics displays reports by products, it groups data by the product identifier (ID), and then it displays the report data using the product name (as it is displayed in the order). It does not use the product SKU. So when on multi-language stores, the first product name the query finds in the database is used to display the data (as the product name on the order depends on the language, the displayed product names in the report may be in different languages).

This is useful on most stores that either are mono-language or that its product names are obvious to handle. But you are right, maybe in a multi-language store that handles many different products and that has been managed using the product SKU's, it's probably more appropiate to display the product SKU.

This is what we can do: we'll release a new version with one more setting parameter that users can set to display either the product name, the product SKU, or a combination of both.

In the mean time, I will now send you an SQL file to execute on the database, to update the appropiate queries to use the product SKU instead of the product name, ok?

Kind regards.

Re: Product SKUs?! 4 years ago #4

  • atrus80
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
  • Karma: 0
Ok, that would great, thanks for the quick reply!

Rgrds,
Chris

Re: Product SKUs?! 4 years ago #5

  • latitudweb
  • OFFLINE
  • Administrator
  • Posts: 182
  • Karma: 1
Hi Chris,

I send you an SQL file to update the Sales Analytics installation, for it to use SKU's instead of product names on the reports.

To update the installation you need to replace the text:
#__

With the table prefix you are using.

If you need further information, please let me know.

Kind regards.
Attachments:

Re: Product SKUs?! 4 years ago #6

  • atrus80
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
  • Karma: 0
Thank you for the assistance, seems to be working

Rgrds
  • Page:
  • 1
Time to create page: 0.28 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.