MRSware Sales and Commissions
  • New MRSware.com
  • About EYOND
  • Free Trial / Download
  • New Blogs / Docs / Training
  • Blog
  • Support
    • Training >
      • Sales Training
      • Data Entry Training
      • Training Classes - MRSweb
      • Training Classes - MRSware >
        • Lesson 1 - MRSware Home Page
        • Lesson 2 - CRM - Companies/Contacts
        • Lesson 3 - CRM - Calendar
        • Lesson 4 - CRM - Journals
        • Lesson 5 - CRM - Tasks
        • Lesson 6 - CRM - Projects
        • Lesson 7 - MREPS - Customers
    • Documentation
    • Integrations
    • Admins
    • Live Service Status
  • Web Login
  • Sales Tracking Software for Manufacturers Reps
  • Commission Tracking Software
  • Manufacturers Sales Rep Commission Rates
  • Commission Management Software for Manufacturers Reps

How to find Top Selling Products by Manufacturer, by Customer

9/24/2020

0 Comments

 
What are the best selling products for a manufacturer?  Who's buying a specific product?

This type of information can be invaluable.  Rather than go to the manufacturer and ask for the information, run a report in MRSware to find the answer.

As usual, in MRSware, there's more than one way to find out this information.
​
Here's how to run a report showing top selling products by manufacturer.
(In the example, we're looking at Toys and Games Co)

1. Click on "Report Explorer" in the Shortcuts panel 
OR
1. Click on the "Report Explorer" icon on the Shortcuts tool bar
​
Picture

Once Report Explorer opens,
​
​2. Scroll down to find the Product Reports.

Picture

3. Double-click on "Product Sales (top 20)"
​
Picture

Once the Report Prompt opens,

4. Make your selections
In the example to the right:
- we named the Report Title
- left the Dates as the default 
- chose the Manufacturer - Toys & Games
- left the Sales Rep as the default
- chose Sales (top down) as the Sort

Once all your selections have been made:

​5. Click "Ok"


​
Picture

The Report opens showing:
​
Toys and Games Co, Top Selling Products YTD, by dollar sales, by quantity, and by percentage of the total sales.
​
Picture

To look at a single product's sales, by Customer

Repeat steps 1 and 2

3. Double click on "Product Customers"
​
Picture

​
​Once the Report Prompt opens,

4. Make your selections
In the example to the right:
- we selected a catalog item number
- we selected a Starting Date of 7/1/2020 and
left the Ending Date as the default 
- chose the Manufacturer - Toys & Games
- left the Sales Rep as the default
- chose Customer Name as the Sort

Once all your selections have been made:

​5. Click "Ok"

​
Picture
Picture

Here's how to use Data Analysis to show the top selling products by manufacturer.
(In the example, we're looking at Solo Manufacturing Group)

1. Click on "Data Analysis" in the Shortcuts panel 
OR
1. Click on the "Data Analysis" icon on the Shortcuts tool bar
​
Picture

Once Data Analysis opens,

2. Double click on an Analysis Cube (in the example we've selected Sales and Commission Analysis"
​
Picture


When the Sales and Commission Parameters opens,

​3. Select your From and To Dates








​
Picture

​When the Sales and Commission opens,

4. Move the dimensions so as to appear in the order you want to view the data.

The dimensions are on the left - the default when analysis cube opens is as seen in the screenshot below:

- Customer
- Principal
​- Product
​
Picture

To move the dimensions, drag them to the location you want to view your data.

First we drag Principal above Customer.                                        Then we drag Product above Customer.
​
Picture
Picture

Next we want to filter the data.

To filter the Principal so we only see Solo Manufacturing Group's products, 
​
​1. Click on the tree to the left of Principal

2. Click on the red x under Dimension members.  This will remove the checkmarks next to all the Principals listed.

3.  Click the box next to Solo Manufacturing Group to select the Principal.

8.  Click "Ok"


Picture
Picture

Now we want to filter the Summary columns.

To filter the Summary columns, 

​1. Click on the icon above the Dimensions with the Greek E on it.

When the Summary Settings dialog opens,

2. Uncheck the boxes next to Commission, Agency Split Commission, Sales Rep Split Commission

3. Check the box next to Quantity

4. Click "Ok"
Picture



Next "Expand all nodes", to view each dimension in a column.

Right-click on the "Principal" column and select "Expand all nodes"


Then, right-click on "Products" column and select "Expand all nodes"










Picture
Finally, sort the Quantity column, Top down, by double clicking on the "E Agg. value" cell (see arrow below)

The final result shows you the most product units sold and the customers who purchased that product.

In the example below, Solo Manufacturing Group, sold 2593 each, product # 1345-216- Rubber Brush outdoor entrance mat 24 x 16, so far in 2020.  Snowfields was the customer who purchased 438 each of this mat, more than any other customer to the tune of $19,710.00.  Variety Supplies was next in line for the most sold, and so on down the list.
​  
Picture

To view a video of how this works in Data Analysis, click on Data Analysis: Product Details. 
​
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Documentation

    ​You will find technical documentation, MRSware instructions, release notes, and general content to help MRSware users through their day on this page.

    Please use the Categories below to find documentation for each area in MRSware.

    ​You may also use the Search field above to look for specific topics. To get a more precise list of articles for a particular menu option, for example, use quotation marks around the text in the Search box, e.g. "bulk assign sales rep".

    Categories

    All
    1
    Android
    Appointments
    Auto-Complete
    Batch Edit/Bulk Update
    Categories
    Contacts
    Customers
    Data Analysis
    Duplicate Removal
    Education Module
    Email
    Email/Spam
    Email Templates
    File Share
    Google
    Hidden
    IMAP
    Installation
    Journals
    Master List
    Microsoft Office
    Mobile
    (MREPS)
    MRSweb
    New MRSware Users
    Outlook
    Payments
    Projects
    Reports/data Analysis
    RSS Reader
    Sales Force Automation (SFA)
    Search / Filter / Sort
    Sync
    Tables / Listings
    Troubleshooting
    Types
    User Manuals
    Video

    Archives

    November 2022
    September 2022
    June 2022
    March 2022
    February 2022
    January 2022
    December 2021
    May 2021
    October 2020
    September 2020
    July 2020
    June 2020
    May 2020
    September 2019
    April 2019
    September 2018
    January 2018
    August 2017
    February 2017
    January 2017
    December 2016
    September 2016
    July 2016
    June 2016
    May 2016
    February 2016
    January 2016
    December 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    July 2014
    June 2014
    February 2014
    October 2013
    September 2013
    July 2013
    May 2013
    April 2013
    March 2013
    February 2013
    November 2012
    September 2012
    July 2012
    June 2012
    May 2012
    April 2012
    December 2011
    November 2011
    October 2011
    September 2011
    August 2011
    May 2011
    April 2011
    March 2011
    December 2010
    September 2010
    July 2010
    May 2010
    April 2010
    February 2010
    January 2010
    December 2009
    November 2009
    October 2009
    July 2009
    June 2009
    May 2009
    April 2009
    March 2009
    February 2009
    January 2009
    October 2008
    September 2008
    August 2008
    July 2008
    June 2008
    May 2008
    April 2007
    September 2006
    August 2006
    July 2006
    June 2006
    May 2006

    RSS Feed

Home | Sales and Commissions | CRM | Blog |​ Pricing | Training | Support | Log In | Free Trial 
[email protected]    
​(866)795-8386
Copyright (c) 2004 -2025 EYOND
Picture
Live Services Status

​MRSware is an EYOND Integrated Solution
made in Austin, TX  USA