cancel
Showing results for 
Search instead for 
Did you mean: 

Find products with special prices

SOLVED

Find products with special prices

Hi,

 

Is there a way to find all products for which a special price is set in the admin panel? Somehow when we migrated from M1 to M2.3 programmatically special prices for some products were set 50% lower than the actual price. Having 100s of products, I don't want to go through them one-by-one

 

Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Find products with special prices

Hello @frank95a 

 

Please follow the below stapes.

 

Go to store attributes 
then select the attribute "Special Price"

 

For Admin side:

Go to Advanced Attribute Properties 
set "Add to Column Options" and  "Use in Filter Options" as yes
you can see the special price filters in the catalog product grid

If any catalog price rule is created then you need to check the product filter condition over there.

For front end:
Go to the special price attribute " Storefront priorities"
and set "Used in Product Listing" as yes
then you can see the filter of special prices on every category page on the front side.

If you get the solution then please, "Kudos" and "Accept as Solution" for Token of Appreciation

View solution in original post

3 REPLIES 3

Re: Find products with special prices

Hello @frank95a 

 

Do you want to check those products on admin side or front side?

 

 

Re: Find products with special prices

Thanks for your response. Either / or would help but admin side would be better

Thanks

Re: Find products with special prices

Hello @frank95a 

 

Please follow the below stapes.

 

Go to store attributes 
then select the attribute "Special Price"

 

For Admin side:

Go to Advanced Attribute Properties 
set "Add to Column Options" and  "Use in Filter Options" as yes
you can see the special price filters in the catalog product grid

If any catalog price rule is created then you need to check the product filter condition over there.

For front end:
Go to the special price attribute " Storefront priorities"
and set "Used in Product Listing" as yes
then you can see the filter of special prices on every category page on the front side.

If you get the solution then please, "Kudos" and "Accept as Solution" for Token of Appreciation