Product report
On this page you will learn more about the various reports in the Product Business Insights report.
Product report
To access the product report, first navigate to the products section by clicking on ‘products’ in the top menu. Then click on the ‘business insights’ button (image 1).
Image 1: Navigate to the product report by clicking on ‘Business Insights'
The resulting page (image 2) provides an overview of all the products in PCM and specific details as variant ID, name, category, descriptions, warehouse (online vs. store), prices, imagery, the product status and scope ID.
To go to one of the product pages in PCM, simply click product name and a new tab will open with the product detail page.
Image 2: Product report
Sorting data
The report can be sorted by clicking on one of the headers in the grey bar. Click e.g. on product name, to view the list on alphabetical order (image 3).
Image 3: Sorting the report
How to filter your data to fine tune your report
On the right side of the report you will find a panel with different filters (image 4). Adding a filter to your report will affect the records that appear and narrows down what data displays. This allows you to fine tune your report.
You can use multiple filters to display the data that meets your criteria. For example, you can select a certain status of a product (complete, new etc). Additionally, you can filter on image to see whether a product is already enriched with images, or you can choose to filter on warehouses.
You will notice that certain filters also allow you to select a filter type (image 5), When opening the dropdown of filter type, you can choose between basic filtering and advanced filtering:
‘Basic filtering’ shows specific values for that filter, and you will be able to select your options by ticking a checkbox.
When you are using ‘advanced filtering’, you can add specific criteria. As you enter new criteria, choosing the AND or OR to add multiple criteria. Use AND to narrow your report and find records that match all of the values you enter. Use OR to broaden your results to include matches for either the first value or the second value.
Image 4: Filter panel.
Image 5: Basic and advanced filtering options
Price details per SKU
At the top right of the report, you will notice it says ‘price details’ (image 6). Click on this link to open a list of products with price details. You can use this report to view all prices per SKU at a glance.
Image 6: Price details per SKU
Export your data
When hovering over the report, you will notice a few icons appearing at the top right. These icons provide more options to sort your data, filter your data and most importantly export your data. Simply click the three dots and select export data to download an excel file or csv file (image 7).
Image 7: Export your data
copyright wolfpack DCS b.v. 2020