How to search for value “null”?

  • Resolved mugwumpr

    (@mugwumpr)


    4 years ago

    Hello,

    I have a field for the Google Category number. Some products have it and some don’t. Those that don’t show “null” in that column.

    I want to find only those products that don’t already have a value in that column.

    Whenever I try a search on that column, I get no results.

    It wants to search it numerically (==, !=, <,>, etc.). I’ve tried ==0, <0, and !=2169 (the GC for Mugs), but I get an empty result set for all of them.

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author storeapps

    (@storeapps)

    Hi,

    You can simply try a search condition something like column_name == ''(pair of single quotes) and it should return all the records in which the same column has no value.

    Request you to kindly have a recheck with the same and do let me know your views.

    Thread Starter mugwumpr

    (@mugwumpr)

    Thanks for your reply.

    Sadly, it gives me the same empty set as a result.

    Plugin Author storeapps

    (@storeapps)

    Hi,

    Thank you for the update.

    As searching for empty values for the ‘Google Category number’ field using the Smart Manager plugin is not working for you, could you please try to update the value for the same field for at least one of the products using the ‘WooCommerce > Products’ menu and then simply deactivate and re-activate the Smart Manager plugin once and have a recheck and do let me know your views.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How to search for value “null”?’ is closed to new replies.