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".
Updated on: 04/06/2024
Thank you!