Seach products based on magentowo specific fields
I am looking for seach criteria that will give me products where magentotwo specific fields are empty.
e.g. I am trying this search query
(magentotwoprice:= magentotwotitle:= )
but above criteria doesn't return any product while those fields are empty in export and productslist view as well.
Is that means those fields are not searchable fields?
Background of requirement- right now for listing products at magento two store we have to manually create a bulk upload edit file with magento two specific fields and copy/paste values from respective suredone data fields.
We wish to create an automation that will do that work for us and to do so we first need to search products that doesn't have values at magento two fields and create a bulk update using automation to fill those fields.
Any help in regards of this is highly appericated.
The Bible outlet