Product Line Summary

Overview

In this article, you will learn about Sellercloud’s Product Line Summary report. This report summarizes item costs, revenue, and average profit for products based on orders in a specific time period.

You can see information about:

• Products – name, SKU, product type, warehouse, vendor, and brand.
• Profit and loss – last cost, site cost, item cost, profit margin, and total profit.
• Quantity – on order and on hand.

Access and Customize

To use this report:

1. Navigate to Reports > Inventory > Product Line Summary.
2. Set up the Default and Custom filters to only include what you need and have a better view of your data.
3. Click Search. Each filter you apply gets highlighted in a different color. If a filter is gray or not displayed at all, it’s not active.
   
4. To manage the columns in the report, click the three dots icon on the top right and select Customize Columns to manage what you display in the report:
   1. Reorder columns by dragging them up or down in the list;
   2. Hide columns by clicking the Trash icons;
   3. Add columns by clicking Add column.
      
5. To sort the data differently, use the Sort by menu.
6. To save your filtering and sorting options, click Save view, then type a Name and click Save.
   
7. To export the full report to a spreadsheet, click Actions and select Export to Excel. Spreadsheets include all columns, including those hidden in the report.
   

Filter and Column Definitions

Click the drop-downs below for filter and column descriptions.