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 Pre-sale Questions.
  • Page:
  • 1

TOPIC: Product Attribute Reports

Product Attribute Reports 6 years, 9 months ago #1

  • jkpcguru
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Hi
I'm thinking about buying your extension for my online store.

Would I be able to do the following:
Run a report giving me an order count of each size for each tshirt I sell so I know how many to order of each size in bulk

Example:

Tshirt 1
# of Small
# of Medium
# of Large

Tshirt 2
# of Small
# of Medium
# of Large

Thanks
John

Re: Product Attribute Reports 6 years, 9 months ago #2

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

Thank you for your interest in our products.

The point you mention can be very useful, but it has some complexity. VM stores order items information in one register in the database, and that register holds the item (product) attributes in one unique text field. That means that when you're dealing with one or more attributes, you get a property like text, for example:
size=medium
color=red

This text-based information is hard to parse and process on SQL queries, but even though, I believe we can do something about it (grouping information by this field content, we'd only need to parse it once after the query).

Let us take a deeper loop at it, and if it's doable, we'll include a new report area called Product Attributes with all the information reports, ok?

Thank you for your feedback.

Kind regards.

Re: Product Attribute Reports 6 years, 9 months ago #3

  • jkpcguru
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Sounds good to me. Let me know what you figure out.
  • Page:
  • 1
Time to create page: 0.48 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.