"Unfortunately I am getting errors" this is not helpful unless you also tell me what the error is.
any time you are reporting an error, you must include the text of the error ion order for me to have any clue what is causing the error.
I guess maybe try:
AND (siteezyecproducts.ProductLocation IS NOT NULL OR siteezyecproducts.ProductLocation != '')
in the SQL?