Filter Reports by Product Group

Overview

Sellercloud’s product group feature lets you arrange products together into one or more named groups.

When used in Sellercloud’s Financial Reporting suite, you can quickly run a report with a large number of SKUs simply by filtering the report by one (or more) product groups that are comprised of those SKUs.

Create a Product Group From the SKU Filter

You can create product groups from the Product Groups page or add products to an existing group in bulk through a file upload.

You can also create a new group from any Sellercloud report that offers the SKU filter. In the Delta user interface, the only option is the Sales Comparison Detail report.

By opening the SKU filter and either searching for SKUs or copy-pasting them into a list, you can instantly create a new product group and immediately run that report by the new group. You’ll also be able to add copied SKUs to an existing product group.

Want to see how easy this is? Take a short video tour:

To use a report’s SKU filter to create a product group:

1. Go to Reports > Open a report.
2. Click the SKU filter to open a separate Search Products window.
   
3. Follow these steps:
   
   1. Click Show/Hide textbox to paste SKU list.
   2. Paste the desired SKUs on separate lines into the box > Click Search SKUs.
   3. Select all SKUs by clicking Select all pages (for Export).
   4. Go to Select Action > From the drop-down menu choose Add to Product Group > Go.
      
4. In the next window, either enter the New Group name or click Existing Group and choose one > Save.
   

Filter a Report by Product Group

Follow these steps to filter a report by product group:

1. While viewing a report, click Add filter and select Product Group.
2. Click the Product Group filter, select a product group, and run the report.

To use the Product Group filter in the Sales Comparison Detail report:

1. In the report, click the Product Group filter and choose the group(s) from the list.
   
2. Click Run Report. In the sample report below, the total physical, reserved, and available inventory and value appears in each warehouse for the SKUs in that product group.