Orange foundation

So I went to Edgar's Chatsworth, bought the Catrice Hydrating foundation, I do understand that yourl have better lighting than my bedroom but please train your consultants, she tried it on my neck and it looked good, lord be hold, yesterday I went for a function I decided to use the Catrice foundation for my husband to tell me I look like an orange is something, please can we have consultants that actually listen to us because I had asked her does this oxidise the reply was no, now I'm sitting with a foundation that I can not use or I need to buy a neutraliser! I have to end up spending more money