Following bacterias can be the cause food poisoning
and having the foul smelling stool and nausea
2)E. coli enteritis
Now most probable can be pin-pointed simply by the history of food you ate since the question do not has the food item listed I will be more broad in my answer
1)Campylobacter enteritis mostly seen in the meat products which are not cooked well (e.g. hamburger)
2)E. coli enteritis will be seen in Raw fish or oysters, or raw vegetables/fruits not washed properly.
3)Staphylococcus aureus is present in poultry product like eggs
4)Salmonella is seen in poultry product,
5)Shigella is seen in poor hygiene mostly water bourn
6)cholera is seen in water
based no the location / food it can change the causative agent.
NOW LET ME ANSWER YOUR QUESTION
The answer is "YES" you need to see the doctor, but if not able to go soon please keep your self hydrated with water/ lime water / any short of juice till you can see the doctor. Sooner the better to see doctor.
Here is what they will do
1) physical exam
2) ask history of food/ water intake
3) collect stool sample and blood test
for the culture
4) mean while will provide a broad spectrum antibiotic and ask you to keep hydrating yourself.
5) once the culture comes in they will check and may change the antibiotics if needed
Hope it helps.