Before you can do a query based on the field first you need to figure out why the field is being added to the DB incorrectly, and/or where the right value is being saved.
…and I don’t even know what questions to ask or where to begin to figure this out. What ecommerce plugin are you using?