Thanks for the prompt reply.
One more thing I am trying to pull out the vendor_address_state to display it on the product page.
Example:
Every product is sold by a vendor, the vendor has an address, so what I am trying to do is to pull out his address on the product page, all is fine but the vendor_address_state is returning a value like the following: state_______________1234
I know the corresponding value to this is the zone_name field in #__hikashop_zone, however, I would like to know if there is a way to do it without overriding the model or controller, so when we make updates it doesn't erase our changes.
Thanks