This saved search is for the user who wants to show their Items' Base Price from Inventory > Sales/Pricing tab > Base Price and to see if there are promotions applied by showing the Promotion Fixed Price added on Lists > Marketing > Promotion > New > Item Fixed Price Promotion.
You can follow the steps below:
1. Lists > Search > Saved Searches > New.
2. Select Item.
3. On the Criteria tab, add "TYPE" and select "Is Inventory Item". (If you only want to pull up inventory items).
4. On the Results tab, you can
- Select Pricing fields... Choose Item.
- Select Transaction fields... Choose Coupon Code.
- Select Transaction fields... Choose Base Item Price (Custom Column). *base price
- Select Transaction fields... Choose Amount. *promotion price
5. Click Preview .or click Save and Run.