Product search: on sale field

[dlundell]

Hi,

I'm trying to search for products that have (or don't have) the On Sale toggle set.

But it's not coming up with the right results.

I've tried: is / is not / contains for the text checked (and unchecked), which is how it's stored in the database.

(I've also tried is not blank [no text in the field]; I've tried is / is not: 1)

How do I get it to work? I need to find all of the products that don't have that checkbox set.

Thanks,

Don

[Jim]

I set one item to have a sale price of $1 and checked the box (Edit Product Layout > Check here to display this product's on sale price )
one item to have a sale price and unchecked the Edit Product Layout > Check here to display this product's on sale price box
One item to have no sale price and checked the Edit Product Layout > Check here to display this product's on sale price box.

I did a search for products On Sale and Contains with nothing in the text field. It listed the item that had both the sale price and the Display this product on Sale price box checked.

So for an item to be considered "On Sale", it must have a sale price and the box to display the checkbox must be checked.

When I search for Sale Amount contains and nothing in the text field it list all the products with the ones that have a sale amount at the top of the list with the
sale price - product name
items without a sale price display with a - product name.

[dlundell]

So for an item to be considered "On Sale", it must have a sale price and the box to display the checkbox must be checked.

Ah well.

What I need it to do is to find the checkbox independently of the sale price being filled in
(I need to find all of the not-set sale checkbox products and use that to unset another extra field I'm using for a different purpose.)

I do have a work-around in this case. Since I can see the state of the checkbox (PRODUCT.SaleOn) in the product template code,
I can do with work there. It's a hack, but it works.

Thanks,

Don