> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.assisty.ai/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to filter the report by product metafield

# Problem: 
* Shopify provides the product metafields to allow merchants adding custom information to product e.g supplier_sku an extra supplier info.
* And then you need to track the sales or inventory of a certain metafield. Please follow steps below.

# Step 1: Open report sales by product
* You can try the sales by product report from here: https://my.assisty.ai/reports/3/sales-performance/97
# Step 2:  Add product metafields to the report
* Click on the extra function at the top right of the report
![](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/image_15cpwgg.png)
* Choose "Add more Columns"

![](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/image_pyvy1c.png)
* Choose column "Product Meta Fields"

![](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/image_1mjhqhf.png)
* Click on the extra function at the top right of the report again
* Choose "Edit Columns"

![](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/image_1prhoxg.png)
* Check on the metafield that you want to filter by
* Click on the "Apply Changes" button


![](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/image_1oy91lt.png)
# Step 3:  Add filter
* Click on the Add filter at the left sidebar

![](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/image_1w0itu4.png)
* Select the metafield column in the filter column dropdown e.g. supplier_sku, choose the condition and then fill the values

![](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/image_1fniuk5.png)
* Click on the "Apply" button

# Step 4: Save the report with filters
* Click on the extra function at the top right of the report
* Click on the "Save as new report"

![](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/image_n0vyy5.png)
* Fill the name of the report, and then click on the Save.

![](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/image_11dg6t3.png)
* After saved the report, you can access it later in the left menu "My Reports".